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..?
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
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
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.
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
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!
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
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..?
Thanks, Comrade.
Thanks for making it as crisp
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
Super, your explanation, thanks Stalin
Great video
Wonderful video, Thank you for sharing your knowledge.
Excellent job, thank you so much.
Great video sir.
Loved this
Bro how do we compare two CSV which cells have multiple data in the cell. This Process does not work on that scenario.
Hi, do you find the answer for your question ?
thank u for this video
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
Me to, did you find an answer?
GREAT WORK
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?
ruclips.net/video/W2hs7UIMfoE/видео.html, this is how I compare two files, this will work irrespective of order of the records.
Using .shape command you can see it
Hi Stalin, how to remove Timestamps in the validation excel file(Timestamp is added in the column) ?
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!
Great🎉🎉🎉
Hey. Do you compare text files in the same way on BASH
would this be the same if we're using a Vertica table and a Hive table?
Can we use this same codings in Jupiter notebook?
this error is coming. rows,cols=np.where(comparison_values==False)
ValueError: not enough values to unpack (expected 2, got 1)
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
Is it resolved bro? Could u pls help me I am also getting same error
Please provide javascript program for two Excel sheets compares
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!
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
Awesome video