Data-Analysis-Jupyter/sentdex_data_analysis/pandas_joining_merging.py

import pandas as pd

df1 = pd.DataFrame({'HPI':[80,86,88,85],
                    'Int_rate':[2, 3, 2, 2],
                    'US_GDP_Thousands':[50, 55, 65, 55],
                   'Year' : [2001, 2002, 2003, 2005]})

'''
df2 = pd.DataFrame({'HPI':[80,85,88,85],
                    'Int_rate':[5, 3, 2, 2],
                    'US_GDP_Thousands':[50, 55, 65, 55]},
                   index = [2005, 2006, 2007, 2008])
'''

df3 = pd.DataFrame({'HPI':[95, 86, 88, 90],
                    'Unemployment':[7, 8, 9, 6],
                    'Low_tier_HPI':[50, 52, 50, 53],
                   'Year' : [2000, 2002, 2003, 2004]})


# print(pd.merge(df1, df3, on=['HPI']))
# print(df1)
# print(df3)

# df1.set_index('Year', inplace=True)
# df3.set_index('Year', inplace=True)



merged = pd.merge(df1, df3, on='Year', how='outer')
print(merged)