Change language

Python | Compare Excel files

| |

Given the two Excel files, we want to compare the values ​​of each column row by row after sorting the values ​​and print the changed column name and row number and change the values.

  Input:  Two Excel files  Output:  Column name: ’location’ and Row Number: 0 Column name:’ ​​location’ and Row Number: 3 Column name: ’date’ and Row Number: 1 

Code: Python code to compare two Excel files

# Write Python3 code here
# pandas import


import pandas as pd

# Reading two Excel sheets


sheet1  = pd.read_excel (r ’Book1.xlsx’ )

sheet2 = pd.read_excel (r ’Book2.xlsx’ )

# Iterate the column names of both sheets

for i, j in zip (sheet1, sheet2):


  # Create empty lists to add column values ​​

a, b = [], []

 < / code> 

# Loop over column values ​​

for m, n in zip (sheet1 [i], sheet2 [j]):


  # Add values ​​to lists

a.append (m)

b.append (n)


# Sorting lists

a.sort ()

  b.sort ()


  # Iterate list values ​​and compare them

for m, n in zip ( range ( len (a)), range ( len (b))):

if a [m]! = b [n]:

print ( ’Column name:’ ​​{} ’and Row Number: {}’ . format (i, m))

Python | Compare Excel files _files: Questions

Python | Compare Excel files File handling: Questions


Best laptop for Fortnite


Best laptop for Excel


Best laptop for Solidworks


Best laptop for Roblox


Best computer for crypto mining


Best laptop for Sims 4


Best laptop for Zoom


Best laptop for Minecraft


Latest questions


psycopg2: insert multiple rows with one query

12 answers


How to convert Nonetype to int or string?

12 answers


How to specify multiple return types using type-hints

12 answers


Javascript Error: IPython is not defined in JupyterLab

12 answers



Python OpenCV | cv2.putText () method

numpy.arctan2 () in Python

Python | os.path.realpath () method

Python OpenCV | () method

Python OpenCV cv2.cvtColor () method

Python - Move item to the end of the list

time.perf_counter () function in Python

Check if one list is a subset of another in Python

Python os.path.join () method