how to implement Excel vlookup on Python

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.

Topic dataframe python-3.x excel pandas python

Category Data Science

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

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

About

Geeks Mental is a community that publishes articles and tutorials about Web, Android, Data Science, new techniques and Linux security.