Compare excel files using Python with Pandas

Simplest and most efficient way of comparing the files using Python in less than 10 lines of code. It will be very useful for scenario like comparing two different version of files.

Libraries :
Pandas
NumPy

Git Source.

[sadhikaparashar]

I had a doubt. How to compare two sheets not row wise but cell wise.. corresponding to a particular value in the cell??
Like if Row1 Column 1 corresponds to the value 'ABC' . But in sheet two, the same value corresponds to row 2 column 1. How to compare the the two rows..?

[NiranjanKumar-gdmf]

This is great input for me . It is working fine . But I am facing performance issue when I try to compare large set of xlsx files . Like 10k records in each row . Do you have any idea how to do the performance tuning ?. Thanks in advance
Regards
Niranjan

[allabakshu]

Hi Stalin, how to remove Timestamps in the validation excel file(Timestamp is added in the column) ?

[tomazbarrantes]

Super, your explanation, thanks Stalin

[AyushSingh-dshs]

Bro how do we compare two CSV which cells have multiple data in the cell. This Process does not work on that scenario.

[abinayaswaminathan]

I am getting the index value at first column in output excel file when I used the same code which you mentioned. Could you please tell me how to avoid the index value in the first column.

[prasannahonnavar]

Can we use this same codings in Jupiter notebook?

[nolimit]

would this be the same if we're using a Vertica table and a Hive table?

[danishnoman]

While comparing the values. It is throwing error: DeprecationWarning: elementwise comparison failed; this will raise an error in the future.
comparison_values = dfOld.values == dfNew.values
False

[tinacole]

Hey. Do you compare text files in the same way on BASH

[Nexatek]

Hi Stalin, thanks a lot for the video, it helped a lot. However had a question, does it work if the number of rows are different in both the columns?

[NeverGiveUp_oo]

this error is coming. rows, cols=np.where(comparison_values==False)
ValueError: not enough values to unpack (expected 2, got 1)

[cherrysonu]

Thanks for the video..
But while comparing the 2 xlsx files its throwing error as comparison failed; this will raise error in the future

Will you please help me out to resolve this issue.

Thanks

[anuroopsagar]

Please provide javascript program for two Excel sheets compares

[michele]

Thanks for sharing your knonledge, that's great! Someone can help to me to show the difference between the number instead of compare them? I'm looking to compare the real stock with the minimun safe stock...Thank you!

[skerody]

Hi Stalin, Good Morning!!!
Hope you are in good health…
Thanks for the video this is what I exactly wanted.
However my excel file is huge with 48 columns and 7K rows of data.
So the ask is to add a new column at the end saying “Match/Mismatch” (after Total column) and print if the whole column value is match or mismatch.
For E.g at H2:H5 value will be Match, and at H6 value will be MisMatch.
Can you pls help me with this…

Regards,
SK