Compare Two excel files | Data-Set Comparison| Compare Data Frame| Python | Pandas |DataCompy Module

Do you have something you want to badly automate? Lets Talk !

Book a call with below link. See you there :

So, here is a very quick way of just 5 lines of code and you will be able to compare data sets just seamlessly.

A python is a must-know tool for most Finance professionals since they are working day and night with the data. 80% of the time goes in Excel and yet we tend to do so many things just manually...WHY???????????

So, put an end to your manual work and start now...Start Now by just typing the code.

Learn basics of PyCharm and Python Installation:

Learn the basic syntax of Python and Pandas:

[adamsleevin]

Many thanks for your great video, is there a way to import the data in the report into excel to manag the differences easily ?

[rksmit]

How to compare multiple files data source n target folders with report

[prabhakarpavan]

Hi sir, I'm getting huge extra spaces in the part of sample data of unequal values how to remove and beautify my report

[gamehub]

सर मेरे पास 4 लाख रो के 4 शीट है मुझे चारो शीट को कम्पाइल कर के pivot table बनाना है कैसे होगा??

[alexandremaillot]

Hello, Thanks for the video, I used this method to compare two files with a lot of data, unfortunately the report shows only max unequal raws, is there a way to show the full report with all the raws that aren't equal ?

[AAS-hvgx]

Hi Sir,
I would like to know how to copy the difference report of both the excels into other excel

[iamprashantjain]

How can i compare multiple excel sheets data & make a new file with common data?

[vinayakchikkorde]

I have the source file and target file. so in that, I have to compare 140 columns and show the result if it matches or not. for example, there is a column as Country1 in source and in target as Country2. to compare that i will use True else return false. to compare 140+ columns it will take time to compare 140 columns. and in both of the file columns are not in ordered. so how can I solve this?

[TWINFLAME]

Hello Sir @EFFICIENT CORPORATES,
I have used the 1st logic which you tried for Excel Sheet Comparison.
I want to compare 2 dynamic Excel Sheets and get the differences in 3rd Excel Sheet as a output.
So when I used your logic for my Project, I am getting only 10 entries for each column in "Sample Rows with Unequal Values".
As my Excel Sheets data is huge and the Unequal values are more than 10, but in your resolution, it is taking only up to 10 unequal values for each column.
Can you please provide the resolution my this.

@Vijay Chawla