how to merge dataframes on column code example Example: merge two df bigdata = pd.concat([data1, data2], ignore_index=True, sort=False)