merging two dataframes on the basis of a function code example

Example 1: merge two dataframes with common columns

import pandas as pd
pd.merge(df1, df2, on="movie_title")

Example 2: combine column in csv python pandas

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