how to compare only three columns between two dataframes code example
Example 1: pandas compare two columns of different dataframe
df3 = [(df2.type.isin(df1.type)) & (df1.value.between(df2.low,df2.high,inclusive=True))]
df1.join(df3)
Example 2: pandas compare two columns of different dataframe
df1['enh2'] = pd.Series((df2.type.isin(df1.type)) & (df1.value != df2.low) | (df1.value + 1 == df2.high))