how to merge different csv file with different columns of same index in python code example

Example: combine column in csv python pandas

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