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))