how to merge different csv files of same index numbers with different columns in python code example
Example: combine column in csv python pandas
df['period'] = df[['Year', 'quarter', ...]].agg('-'.join, axis=1)
df['period'] = df[['Year', 'quarter', ...]].agg('-'.join, axis=1)