types of joins pandas code example

Example 1: merge two dataframes based on column

df_outer = pd.merge(df1, df2, on='id', how='outer')

df_outer

Example 2: python: left join

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