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

Shop

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

$499

Best laptop for Minecraft

$590

Latest questions

NUMPYNUMPY

psycopg2: insert multiple rows with one query

12 answers

NUMPYNUMPY

How to convert Nonetype to int or string?

12 answers

NUMPYNUMPY

How to specify multiple return types using type-hints

12 answers

NUMPYNUMPY

Javascript Error: IPython is not defined in JupyterLab

12 answers

News

Wiki

Python OpenCV | cv2.putText () method

numpy.arctan2 () in Python

Python | os.path.realpath () method

Python OpenCV | cv2.circle () 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