DataFrame["new_column"] = DataFrame["column1"] + DataFrame["column2"]
df_outer = pd.merge(df1, df2, on='id', how='outer') df_outer
#suppose you have two dataframes df1 and df2, and #you need to merge them along the column id df_merge_col = pd.merge(df1, df2, on='id')
df["period"] = df["Year"] + df["quarter"]
df_merge_col = pd.merge(df_row, df3, on='id') df_merge_col
bigdata = pd.concat([data1, data2], ignore_index=True, sort=False)
import pandas as pd T1 = pd.merge(T1, T2, on=T1.index, how='outer')