pandas - Vlookup/Map value from one dataframe to another dataframe in Python

Question

I want to do something similar to the vlookup in the python. Here is a dataframe I want to lookup for value 'Flow_Rate_Lupa'

And here is the dataframe I want to fill the data by looking at the same month+day to fill the missing value. Is there any one to help me to solve how to do this QAQ

question from:https://stackoverflow.com/questions/65682028/vlookup-map-value-from-one-dataframe-to-another-dataframe-in-python

Answer 1

I usually merge the two data frames and define an indicator, then filter out the values where the indicator says both meaning data is in both data frames.

import pandas as pd

mergedData= pd.merge(df1,df2, how='left' ,left_on='Key1', right_on='Key2', indicator ='Exists')
filteredData = mergedData[mergedData[Exists]='both']