compare two dataframes using a columns pandas code example

Example 1: pandas compare two columns of different dataframe

import numpy as np
df1['low_value'] = np.where(df1.value <= df2.low, 'True', 'False')

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))