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)