comparing two pandas dataframes code example

Example 1: comparing two dataframe columns

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

Example 2: pandas difference between two dataframes

source_df.merge(target_df,how='left',indicator=True).loc[lambda x:x['_merged']!='both']