Compare excel files using Python with Pandas

[@anku_dreams_nature]

Thanks, Comrade.

[@sadhikaparashar839]

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..?

[@ThangaduraiSekar]

Thanks for making it as crisp

[@tomazbarrantes]

Super, your explanation, thanks Stalin

[@NiranjanKumar-gd7mf]

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

[@AyushSingh-ds2hs]

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

[@aniruddhaotari4082]

Hi, do you find the answer for your question ?

[@sadhikaparashar839]

Great video sir.

[@gsv202000]

Excellent job, thank you so much.

[@gabrielapatat6806]

Great🎉🎉🎉

[@user-xc2yc3vz5e]

Great

[@prasannahonnavar8994]

Can we use this same codings in Jupiter notebook?

[@sanket8873]

Loved this

[@tarukhanna6681]

thank u for this video

[@allabakshu654]

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

[@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?

[@gulshankumar17]

ua-cam.com/video/W2hs7UIMfoE/v-deo.html, this is how I compare two files, this will work irrespective of order of the records.

[@pradyumnavaradpande88]

Using .shape command you can see it

[@serageibraheem2386]

GREAT WORK

[@CoopmanGreg]

Great!

[@danishnoman2042]

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

[@cesasoft]

Me to, did you find an answer?

[@tinacole1450]

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

[@abinayaswaminathan4188]

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.

[@aniruddhss2257]

Awesome video

[@ishikamittall8461]

Nhi hua csv file value error dera h😢

[@nolimit4906]

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

[@anuroopsagar1095]

Please provide javascript program for two Excel sheets compares

[@NeverGiveUp_oo7]

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

[@cherrysonu9158]

Thanks for the video..
But while comparing the 2 xlsx files its throwing error as DepreciationWarning:elementwise comparison failed; this will raise error in the future
Will you please help me out to resolve this issue.
Thanks

[@nikhilkhanna6471]

Is it resolved bro? Could u pls help me I am also getting same error

[@niteeshkumarnitesh8969]

So use full 🌝

[@michele6124]

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

[@computerauditor]

Great video