Python | Excel File Comparison

0 0 1 minute read

Given Two Excel Files, We want to compare the values of each column row-wise after sorting the values and print the changed column name and row number and values change.

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 for comparing two excel files

# Write Python3 code here 
# importing Pandas 
  
import pandas as pd 
  
#Reading two Excel Sheets 
  
sheet1 = pd.read_excel(r'Book1.xlsx') 
sheet2 = pd.read_excel(r'Book2.xlsx') 
  
# Iterating the Columns Names of both Sheets 
for i,j in zip(sheet1,sheet2): 
     
    # Creating empty lists to append the columns values     
    a,b =[],[] 
  
    # Iterating the columns values 
    for m, n in zip(sheet1[i],sheet2[j]): 
  
        # Appending values in lists 
        a.append(m) 
        b.append(n) 
  
    # Sorting the lists 
    a.sort() 
    b.sort() 
  
    # Iterating the list's values and comparing 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)) 