match 2 dataframes pandas code example

Example 1: comparing two dataframe columns

comparison_column = np.where(df["col1"] == df["col2"], True, False)

Example 2: combine column in csv python pandas

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