How To Compare CSV Files For Differences in Python

Do you have a need to understand how to compare two CSV files for differences? In this video tutorial, we look at comparing CSV files with Python pandas. When you want to compare CSV files for differences, there can be a number of options and we show three different ways to approach this.

⏲⏲⏲TIMESTAMPS⏲⏲⏲
00:00 Beginning
00:21 Problem overview
01:23 Reviewing output
03:10 An important thing to note
03:36 Code review

################ Lets be Social! ##################

#CSV #comparefiles #dataanalyticsireland #dataanalytics #moresubscribers2021

[Ricled]

Great video! I am new to python and really enjoyed you taking the time to explain your code and how it works! Looking forward to more videos

[sarvansps]

Since we know the difference is in year column.. we have checked only for that column! What if we have 100 columns in those two csv files and how to compare the column values ?

[CMondi]

May I know what would be the best approach to find the differences between two Excel or CSV file if they contain duplicate ids in each files. For instance, Excel 'A' has 123 as an Id but it is repeated 5 times with different column value in Excel A, where as Excel B with 123 id has 7 rows with different column values.
I'm really searching to find the difference for this scenarios.
Thanks.

[findthetruth]

Can you please find the percentage of discrepancy/mismatch between the two databases? for example, I can say 30% of the data1(csv1) is different than data2(csv2). Is it possible to do that?

[yeturuvenkataarunkumarredd]

How do we configure both the csv files which are located in two different unix paths..

[Indrailk]

Giving Key Error with method 3
in get_loc
raise KeyError(key) from err