import pandas as pd

def main():
    # The Housing Data
    df_house = pd.read_excel('House_price.xls', index_col=0).dropna(how='all').fillna(0)
    print(df_house.head())

    # The MBS Data
    df_mbs = pd.read_excel('MBS_data.xlsx', index_col=0)
    df_mbs.rename(index={'observation_date': 'Date'},
                  inplace=True)
    print(df_mbs.head())

    # 30 year fixed interest rate data
    df_interest = pd.read_excel('interest_rate.xlsx', index_col=0)
    df_interest.rename(index={'observation_date': 'Date'},
                       inplace=True)

    # Joining MBS and Interest Rate datasets on their index column
    df_mbs_ir = pd.merge(df_mbs, df_interest, left_index=True,
                         right_index=True)
    print(df_mbs_ir.head())

    # Joined both tables on their index column
    df_join = pd.merge(df_house, df_mbs_ir, left_index=True, right_index=True)
    print(df_join.columns)

main()