how to implement Excel vlookup on Python
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)