concat df based 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')

Example 3: combine df columns python

df["period"] = df["Year"] + df["quarter"]