pd.merge how left EXAMPLE Example: python: left join new_df = df_1.merge(df_2, on='id', how='left', indicator=True)