Wonderful video, Thank you for sharing your knowledge.

Thanks for making it as crisp

Excellent job, thank you so much.

Thanks, Comrade.

Great video sir.

Super, your explanation, thanks Stalin

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

Loved this

Awesome video

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

Great video

thank u for this video

GREAT WORK

Great!

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.

Great

Great🎉🎉🎉

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

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

3 жыл бұрын

kzread.info/dash/bejne/iWac1ZmOebDMn6g.html, this is how I compare two files, this will work irrespective of order of the records.

@pradyumnavaradpande88

2 жыл бұрын

Using .shape command you can see it

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

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

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 ?

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?

Can we use this same codings in Jupiter notebook?

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

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!

Please provide javascript program for two Excel sheets compares

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

So use full 🌝

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