Pandas Datareader

Aus MattWiki

Example code for importing data into Pandas with Pandas Datareader.

import pandas as pd

# Import Pandas Datareader data library for use with St. Louis FED / FRED API
import pandas_datareader.data as web

# Import World Bank sub module from Pandas Datareader
import pandas_datareader.wb as wb
from datetime import datetime

import numpy as np

start = datetime(1999, 1, 1)
end = datetime(2019, 1, 1)

# Get NASDAQ100 Data from FRED
nasdaq_data = web.DataReader('NASDAQ100', 'fred', start, end)
print(nasdaq_data)

sap_data = web.DataReader('SP500', 'fred', start, end)
print(sap_data)

# Get GDP data from World Bank API
gdp_data = wb.download(indicator='NY.GDP.MKTP.CD', country=['US'], start=start, end=end)
print(gdp_data)

export_data = wb.download(indicator='NE.EXP.GNFS.CN', country=['US'], start=start, end=end)
print(export_data)