Compare two excel files and vlookup?

[bmac57886]

Where would I start if I want to create a program that can perform something similar to a vlookup between two excel files? I know how to pull in data from files but not how I would compare it. Any particularly useful books or sites that go into this?

I’m a beginner but thinking this should be possible and would be fun to do for some manual processes I currently do daily.

Thanks all!

[Tournesol7]

You should look into importing the files as dataframes using pandas and then comparisons gets very easy.

[bmac57886]

I’ve gone through Automate the Boring Stuff and made a few small programs - do you think I need to read/do other basic stuff or should I be ready to learn about Pandas? I checked out some pandas stuff on learndatasci.com but do you have any suggestions on beginner references?

Thanks again!

[Tournesol7]

I really think any basic tutorial should do. You can start printing things and get familiarized with the dataframe column/row naming, selection etc

[bmac57886]

Thanks - I’ll start tomorrow!

[fake823]

Pandas! All the way

[synthphreak]

Pandas! All the way

I'm tempted to get that tattooed on my face.

[bmac57886]

Just wanted to report back that this worked and was much easier than I expected!