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.