dataframes merge python on columns with different names code example

Example: python: left join

new_df = df_1.merge(df_2, on='id', how='left', indicator=True)