Forum Discussion
Using FRED Data
Hi, FRED (Federal Reserve Econcomic Data) is a great website that offers all kinds of economic series data free to the public, and I'm wondering if anyone can recommend a good connector to import th...
API can be tough. Basically, it's like getting from a web source. Check out these instructions: https://blogs.msdn.microsoft.com/charles_sterling/2016/05/25/how-to-call-rest-apis-and-parse-json-with-power-bi/
You can pull FRED data in with a Python script without an API if you have Python installed or you're comfortable installing it. Get Data/Python script then paste in code per this model:
import pandas_datareader.data as web
import datetime
# Choose start and end dates for the data series
start = datetime.datetime(2015, 1, 1)
end = datetime.datetime(2019, 10, 9)
# Read the data: US Housing Starts HOUST FRED data set
houst = web.DataReader('HOUST', 'fred', start, end)
# Move the dates, which are row labels, to their own column
houst.index.name = 'date'
houst.reset_index(inplace=True)This worked perfect for me. Thanks for your help
