how to merge columns from a csv in pandas code example

Example 1: how to merge two pandas dataframes on a column

import pandas as pd
T1 = pd.merge(T1, T2, on=T1.index, how='outer')

Example 2: combine column in csv python pandas

df['period'] = df[['Year', 'quarter', ...]].agg('-'.join, axis=1)