import quandl
import pandas as pd

# Not necessary, I just do this so I do not show my API key.
api_key = "rFsSehe51RLzREtYhLfo"
fiddy_states = pd.read_html("https://simple.wikipedia.org/wiki/List_of_U.S._states")

main_df = pd.DataFrame()

for abbv in fiddy_states[0][0][1:]:
    query = "FMAC/HPI_" + str(abbv)
    df = quandl.get(query, authtoken=api_key)

    if main_df.empty:
        main_df = df
    else:
        main_df = main_df.join(df)