| 123456789101112131415161718 |
- 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)
|
