how to implement Excel vlookup on Python

Question

I have a dataset A and dataset B, both data has a column in common which is the ID, i want to check if dataset A ID values can be found in dataset B ID values. Also get the records of dataset B that have the same value with dataset A. I can do this on excel using vlookup, but I want to automate the process using python.

NOTE:
1. dataset B has 10020 rows while dataset A has 2039 rows.
2. The ID column is numeric.

Thanks.

dataframe excel pandas python python 3.x

NOTE:
1. dataset B has 10020 rows while dataset A has 2039 rows.
2. The ID column is numeric.

Thanks.

S van Balen · Answer

You will want to load your data in two pandas data frames (if you haven't already)
Next you will need to use dataframe.join():

Note: You might want to think about the mode (inner, outer, left or right)

how to implement Excel vlookup on Python

One Answer

Add your own answers!

Ask a Question