Data-Analysis-Jupyter/sentdex_data_analysis/pandas_cocantenating_appending.py

import pandas as pd

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

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

df3 = pd.DataFrame({'HPI':[80,85,88,85],
                    'Int_rate':[2, 3, 2, 2],
                    'Low_tier_HPI':[50, 52, 50, 53]},
                   index = [2001, 2002, 2003, 2004])

# df1.set_index('HPI', inplace=True)
concat = pd.concat([df1, df3])

df4 = df1.append(df3)

print(concat)
print(df4)

s = pd.Series([[80, 2, 50],[80, 54, 56], [56, 43, 23]])
print(s)