Compare Two Excel Sheets with Different Number of Rows and Find Differences using Python 

Great to hear & thanks for watching the video!

Glad I could help! Cheers, Sven ✌️

Thank you very much. Happy to hear that you liked the video!

Highlighting the entire row that was not in the initial file has been covered in the video (09:28 min). You could take that example as a starting point to check further (column by column) if the change is only in one column to use a different colour. I hope you understand that I am missing the time to code out an example for you. Happy Coding!

You could also replicate it with Excel formulas, but adding (automatically) comments to cells would only be possible using VBA.

Thank you for watching the video & your suggestion.

Thanks for watching. I haven't tried that, but I guess the xlwings method shown in the video should work . Happy coding!

Thanks for the positive feedback! Appreciate you taking the time to leave a comment.

Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!

Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video! Cheers, Sven ✌️

Thanks for watching and for your question. Hard to tell from a distance why the cells do not get a color. Sorry that I cannot help.

Happy to hear that it was useful. Thanks for watching! 👍

Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!

It's a good question but difficult to answer because it depends on many factors. Before comparing the data, you would probably need to check the shape of the data range and/or the column header (names). That said, I do not have the time to code an example.

Thanks for watching and for your question. By merging the dataframes - similar to what I have demonstrated at 7:04 min. Happy Coding! :)

Hard to tell from a distance. Not sure what might be causing the issue.

Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help.

Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!

Thank you for watching. You can always find the relevant links from my videos in the video description. Here you go: github.com/Sven-Bo/compare-two-excel-sheets-python. Happy coding and testing! Cheers, Sven ✌️

Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!

Thanks for watching. When using pandas, the column headers need to be identical. However, you could also rename the column headers before using the compare method. Here is how you do it: stackoverflow.com/a/11354850 I hope it helps! Happy learning & coding! :)

An absolute pleasure, Yasser Khalil! Thanks for the kind comments! 👍

Thanks for watching and your video suggestion! Cheers, Sven 👍

Thanks for watching. Not sure. You might just want to give it a try to find out.

Thanks for watching. I am not sure to which method you are referring to. In the video, showed different methods and also the use cases (and limitations) for each of those methods.

@@CodingIsFun I think he means what if the updated version of the excel file has missing rows. Is it possible to add these missing rows into the updated excel in a different font colour?

@@clairelee9056 That sounds possible but of course, would require some additional coding.

Thanks for watching the video. Unfortunately, I do not have the time to code out an example tailored to your specific use case. I hope you can understand. Thank you!

@@CodingIsFun I know you very busy. But you can do as a video it self ☺️ it will help me like people's i hope you understand the issue.thank you

And I thank YOU, Alberto Montero. It appreciate your support. 🙏

You're very welcome! Thank you for watching and for the comment!

Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!

Thanks for watching. Yes, you can using the result_names parameter as written in the pandas docs: pandas.pydata.org/docs/reference/api/pandas.DataFrame.compare.html

Thanks for watching. Here a couply of ways to convert the Notebook to a Python file: mljar.com/blog/convert-jupyter-notebook-python/ I hope it helps! Happy Coding!

@@CodingIsFun I am using jetbrain, not sure if that is the same as a jupyter? I tried to import the ipynb file that I I downloaded from you, but don't see any of those commands in the link you showed me. And other help would be greatly appreciated. Also, did you ever write a version where you had the a final file that would show the original AND the revised content of any changed cells?

06:32 min

Probably because you are using 'used_range' on a workbook and not on a worksheet object.

Thanks for watching. I recommend downloading the Jupyter Notebook and 'playing' around with the figures. Happy Coding!

@@CodingIsFun I got it as I was practicing... do you think that we can highlight values only not yhe whole row as you did in the first part of the video?

@@CodingIsFun I got it as I was practicing... do you think that we can highlight values only not yhe whole row as you did in the first part of the video?

@@serageibraheem2386 It might be possible, but I do not know how to implement that right off the bat.

@@CodingIsFun I will try and let u know.... thank uuuu so much 👏👏

Thanks for watching. What exactly do you mean by unique identifiers? In the xlwnigs example, the header names do not matter. The script will compare cell to cell, e.g. A1 (WB1) to A1 (WB2). When using pandas compare, you want to use the same column headers.

@@CodingIsFun By unique identifier i meant to say that one field that distinguishes my row from the rest of the rows and which stays same throughout any point of time. Anyway I will try to replicate this logic in Excel and see if it helps. Thanks for the video though.... :)

That should be possible, but I have not tired it yet.

Glad you think so! Thanks for watching & your comment! :)

Thanks for watching. Link is in the description. Here you are: github.com/Sven-Bo/compare-two-excel-sheets-python Cheers, Sven ✌️

capitalize Path from pathlib import Path

@@CodingIsFun that worked!! thank you . You earned a subscriber!!

can you help me with the code that actually compares two excel files and copies the data only between corresponding cells which has a common name in the first column.

@@howard_roark1210 What have you tried so far?

Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!

@@CodingIsFun Okay! Thanks for the reply!

What does the error say?

@@CodingIsFun Traceback(most recent call last): file "",line 1 in Files "C\users\sharma\appdata\local\program\python\python310\lib\site-packages\xlwings\main.py", line 903 , in save with self.app.properties(display_alerts_false): Files "C\users\sharma\appdata\local\program\python\python310\lib\site-packages\xlwings\main.py", line 867 , in app return(app(impl=self.impl.app) Files "C\users\sharma\appdata\local\program\python\python310\lib\site-packages\xlwings\_xlwindows.py", line 551 , in app return App(xl=self.xl.application) Files "C\users\sharma\appdata\local\program\python\python310\lib\site-packages\xlwings\_xlwindows.py", line 135 , in __getattr__ v= getattr(self._inner, item) Files "C\users\sharma\appdata\local\program\python\python310\lib\site-packages\wincom\client\__init.py__", line 645 , in __getattr__ return getattr(d, attr) Files "C\users\sharma\appdata\local\program\python\python310\lib\site-packages\wincom\client\__init.py__", line 548, in __getattr__ return self.ApplyTypes(*agrs) Files "C\users\sharma\appdata\local\program\python\python310\lib\site-packages\wincom\client\__init.py__", line 572, in _ApplyTypes_ self.oleobj_InvokeTypes(dispid, 0, wflags, retType, argTypes, *args), pywintypes.com_errror:(-2147023170, 'The remote procedure call failed.', None, None)

I really apprecaite if you can help me in resolving the error. I used the word to word code of yours and everything is working perfectly fine but i don't know why its giving error on save function. i tried several ways but nothing worked out for me. I hope if you can trace the error in it. Thanks for your help.

@@saurabhsharma-bd1xf Please paste the error trace log here: pastebin.com/ Once done, share your paste bin ID (NOT THE FULL URL [links will be deleted by YT]), an example of pastebin ID: *MsEChyJw* ( www.screencast.com/t/7Q8W3zE8Rc )

@@CodingIsFun aaJDTjyV

ok my bad. needed to update xlwings==0.25.3

@@kevindandrade5307 is there another way to fix this error with xlwings version 0.16.0 ?

Because I am looking for any additions or deletions between the two datasets (df_initial and df_update)

@@CodingIsFun Ohk , but Inner join also gives the difference between two csv tables , so my doubt is how to identify if many rows deleted and added in df_update how to extract that particular rows

@@amitkhandelwal8030 why not simply trying it out. Feel free to share your solution here

Glad you liked it. Thanks for watching and taking the time to leave a comment! 👍👍