Merging Two Columns Which Don't Overlap And Create New Columns

import pandas as pd df1 = pd.DataFrame([['2014', 'q2']], columns=('Year', 'Quarter')) df2 = pd.DataFrame([['2016', 'q1'], ['2015', 'q1']],

Solution 1:

You can use:

df1.merge(df2, on=['Year', 'Quarter'], how='outer').dropna()

to get:

YearQuarter02014      q212016      q122015      q1

You can also look into pd.concat().