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

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
In this video, I will show you how to use Python to compare two Excel sheets with different numbers of rows and find the differences between them.

🌍 𝗟𝗜𝗡𝗞𝗦:

⭐ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
00:00 – Introduction
00:25 – Install & load dependencies
01:07 – Data with the same shape using pandas
04:31 – Data with the same shape using xlwings
06:32 – Data with different shape using pandas
09:28 – Highlight the difference using xlwings
10:13 – Outro

𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here:

[xilllllix]

this has plenty of day-to-day uses, thanks!

[ghoshasish]

Fabulous video! Excellent explanation and perfect solutioning..

[ankitait]

exactly what I was looking for. good job and thank you

[KhalilYasser]

Thank you very much for these incredible tutorials.

[DeepakKumar-cxtr]

Thank you, i was looking for something like this

[SanS-oohy]

Great content. Thanks for the code. !!

[CODUlTiMaTeBaWsS]

Hi!

Thank you for this great video! It has helped me out a lot!
I just had one question though, I used the code from the second part of the video however when i execute my code, the rows on my worksheet don't get colors.

[VoltaireParis]

awsome in all ways : big thanks and big kudos for your clear & clever explanations !

[bc]

Thank you! I run into this type of task pretty regularly. Excel doesn't have a built-in formula / tool for this, right? It would take a bunch of LOOKUPs and stuff?

[yogeetjain]

Hey, this is a great video, my task was majorly done, but xlwings does not run when we use the highlight code for very large datasets.
Moreover if you could provide a video where we can compare files having different number of columns it would be very helpful.

[sagarkadam]

if there is only column difference can you highlight with different color and if the entire row is not present in any of the file can you highlight with different color? This will give you an idea if there is only one column that is different or the entire row is not present in any of the file

[kingofthesummer]

Hi, I have a question… in the data with different shapes sections, what if the difference in the shape of the excel file was that additional columns were added or both columns and rows changed, how would you handle that?

[tseringdolmagangsudora]

thanks for the video. If you could also make a video on how to compare two JSON files with different actions and find differences using Python. Thank you

[wbdxpmb]

If I have a template workbook with 20+ shape-protected sheets, can I still use your code to find the diff between two ver? Or, what else should I do?

[sureshakkavarapu]

thanks for the video & explanation, if possible can you pls share the gitrepo or sample utility to test locally ???

[akshaybhat]

for each row in source1.csv, find all matching values from source2, csv how its done please help me to solve this. thank you

[mohithasharma]

After getting the data, which exists in right_only sheet, (8:41) I am getting all the index as NaN and I am not able to convert that to python list. It still remains NaN. How can I proceed?

[alexk]

Hello, what is your take on comparing XLSXs that have cells with multiline string values (ie, 7 lines of text). Pandas seems to be strangling with those.

[freakfun]

Hey awesome video. You have put a lot of effort here. Thanks for that. Just a query how to compare 2 Excel with some common and some different columns details

[sahraouikhaoula]

in my code, i want to compare two elements if they are in the same column, how could i achieve that? thank you