pandas compare 2 dataframe columns code example

Example 1: comparing two dataframe columns

comparison_column = np.where(df["col1"] == df["col2"], True, False)

Example 2: pandas compare two columns of different dataframe

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