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