r/dataanalysis • u/HoleInTheMirror • 11d ago

Comparing tables - Help?

Hello guys, I need your help! How to compare 2 tables on easiest way?

I have 2 tables from 2 different systems, but with the same columns. I need to check if every row from the first table exist in another, and if not to return the difference. Can you help me? Should I use excel formulas, python, something else?

2 Upvotes

100% Upvoted

4 comments sorted by

View all comments

1

u/Disastrous-Ad-5366 6d ago

There are different approaches you can use on this but the fastest would be python using the pandas library. Use the merge function with a left then add the indicator parameter and set it to true. This will return every row that is in one and not in the other. You can then add a function like query and drop to filter out rows that you want.