pandas join tables on column code example

Example 1: merge two df

bigdata = pd.concat([data1, data2], ignore_index=True, sort=False)

Example 2: python dataframe left join

>>> left.merge(right, on='user_id', how='left')