Hi Stalin, how to remove Timestamps in the validation excel file(Timestamp is added in the column) ?
@bevedel Жыл бұрын
Really helped. Thank you.
@computerauditor Жыл бұрын
Great video
@serageibraheem2386 Жыл бұрын
GREAT WORK
@NeverGiveUp_oo72 жыл бұрын
this error is coming. rows,cols=np.where(comparison_values==False) ValueError: not enough values to unpack (expected 2, got 1)
@benjamimjr22 жыл бұрын
Thanks from Brazil!!
@niteeshkumarnitesh89692 жыл бұрын
So use full 🌝
@thepmgzzz2 жыл бұрын
Thanks!
@cherrysonu91582 жыл бұрын
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
@CoopmanGreg2 жыл бұрын
Great!
@gsv2020002 жыл бұрын
Excellent job, thank you so much.
@skerody2 жыл бұрын
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
@danishnoman20422 жыл бұрын
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?
@markhooker85202 жыл бұрын
Wonderful video, Thank you for sharing your knowledge.
@raosatishgmail2 жыл бұрын
Why was the FileSystemWatcher created in the loop. Can we not create a Singleton so a file system watcher does not get created in each interation.
@nicojmb2 жыл бұрын
Same question here, why the code is insde the loop?
@CreativPret2 жыл бұрын
You are correct. It does not need to be in the loop. (The guys who write code like this would never pass first round of interview where I work ) :)
@b000ta2 жыл бұрын
when i run it, it logs multiple console messages for a single event.
@alez94562 жыл бұрын
Hi! Do you resolve it?
@tinacole14502 жыл бұрын
Hey. Do you compare text files in the same way on BASH
@kalpeshgohil15942 жыл бұрын
You are too good... Nice Explanation... I have one question. How you manage the event. I am doing the same thing which you showing but when i copy file to the watcher folder in multiple time event is invoked. It will not fire event single time. In your demo it is single time. So how you do that?
@anuroopsagar10952 жыл бұрын
Please provide javascript program for two Excel sheets compares
@ThangaduraiSekar2 жыл бұрын
Thanks for making it as crisp
@AyushSingh-ds2hs2 жыл бұрын
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 ?
@akhtarzaman73883 жыл бұрын
Will it run on docker windows container?
@tomazbarrantes3 жыл бұрын
Super, your explanation, thanks Stalin
@NiranjanKumar-gd7mf3 жыл бұрын
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
@nolimit49063 жыл бұрын
would this be the same if we're using a Vertica table and a Hive table?
@michele61243 жыл бұрын
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!
@aniruddhss22573 жыл бұрын
Awesome video
@user-xc2yc3vz5e3 жыл бұрын
Great
@abinayaswaminathan41883 жыл бұрын
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.
@anku_dreams_photography3 жыл бұрын
Thanks, Comrade.
@tarukhanna66813 жыл бұрын
thank u for this video
@rrrrr16able3 жыл бұрын
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?
@gulshankumar173 жыл бұрын
kzread.info/dash/bejne/iWac1ZmOebDMn6g.html, this is how I compare two files, this will work irrespective of order of the records.
@pradyumnavaradpande882 жыл бұрын
Using .shape command you can see it
@sadhikaparashar8393 жыл бұрын
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
Great🎉🎉🎉
Can we use this same codings in Jupiter notebook?
Hi Stalin, how to remove Timestamps in the validation excel file(Timestamp is added in the column) ?
Really helped. Thank you.
Great video
GREAT WORK
this error is coming. rows,cols=np.where(comparison_values==False) ValueError: not enough values to unpack (expected 2, got 1)
Thanks from Brazil!!
So use full 🌝
Thanks!
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
Great!
Excellent job, thank you so much.
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
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?
Wonderful video, Thank you for sharing your knowledge.
Why was the FileSystemWatcher created in the loop. Can we not create a Singleton so a file system watcher does not get created in each interation.
Same question here, why the code is insde the loop?
You are correct. It does not need to be in the loop. (The guys who write code like this would never pass first round of interview where I work ) :)
when i run it, it logs multiple console messages for a single event.
Hi! Do you resolve it?
Hey. Do you compare text files in the same way on BASH
You are too good... Nice Explanation... I have one question. How you manage the event. I am doing the same thing which you showing but when i copy file to the watcher folder in multiple time event is invoked. It will not fire event single time. In your demo it is single time. So how you do that?
Please provide javascript program for two Excel sheets compares
Thanks for making it as crisp
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 ?
Will it run on docker windows container?
Super, your explanation, thanks Stalin
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
would this be the same if we're using a Vertica table and a Hive table?
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!
Awesome video
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.
Thanks, Comrade.
thank u for this video
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?
kzread.info/dash/bejne/iWac1ZmOebDMn6g.html, this is how I compare two files, this will work irrespective of order of the records.
Using .shape command you can see it
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..?
Great video sir.