detect different columns dataframes code example
Example 1: pandas difference between two dataframes
source_df.merge(target_df,how='left',indicator=True).loc[lambda x:x['_merged']!='both']
Example 2: pandas compare two columns of different dataframe
df1['priceDiff?'] = np.where(df1['Price1'] == df2['Price2'], 0, df1['Price1'] - df2['Price2'])
Example 3: 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')
Example 4: 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))