pandas two dataframes find similar items in a special column and return rows code example

Example 1: python - show repeted values in a column

df = df[df.duplicated(subset=['val1','val2'], keep=False)]

Example 2: pandas difference between two dataframes

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