outer_join = df1.merge(df2, left_on='id_col1', right_on='id_col2', indicator=True, how='outer') outer_join[outer_join['_merge'] == 'right_only']