![\"Open](\"https://colab.research.google.com/assets/colab-badge.svg\"){kind=icon}
"
]
},
{
"cell_type": "markdown",
"source": [
"#Using the FRED API to get and display key macro series\n",
"FRED, a database maintained by the Federal Reserve Bank of St. Louis, is a realiable source of macroecononomic and financial data. The first step is to install the FRED API. https://fred.stlouisfed.org/docs/api/fred/"
],
"metadata": {
"id": "w3KtULyNxMTj"
}
},
{
"cell_type": "code",
"source": [
"pip install fredapi "
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/"
},
"id": "D5xCDRIew5qi",
"outputId": "0bbc8c57-f383-4016-a718-af2656388916"
},
"execution_count": null,
"outputs": [
{
"output_type": "stream",
"name": "stdout",
"text": [
"Looking in indexes: https://pypi.org/simple, https://us-python.pkg.dev/colab-wheels/public/simple/\n",
"Requirement already satisfied: fredapi in /usr/local/lib/python3.7/dist-packages (0.5.0)\n",
"Requirement already satisfied: pandas in /usr/local/lib/python3.7/dist-packages (from fredapi) (1.3.5)\n",
"Requirement already satisfied: python-dateutil>=2.7.3 in /usr/local/lib/python3.7/dist-packages (from pandas->fredapi) (2.8.2)\n",
"Requirement already satisfied: numpy>=1.17.3 in /usr/local/lib/python3.7/dist-packages (from pandas->fredapi) (1.21.6)\n",
"Requirement already satisfied: pytz>=2017.3 in /usr/local/lib/python3.7/dist-packages (from pandas->fredapi) (2022.1)\n",
"Requirement already satisfied: six>=1.5 in /usr/local/lib/python3.7/dist-packages (from python-dateutil>=2.7.3->pandas->fredapi) (1.15.0)\n"
]
}
]
},
{
"cell_type": "code",
"source": [
"from fredapi import Fred "
],
"metadata": {
"id": "DAmdMgssw5nK"
},
"execution_count": null,
"outputs": []
},
{
"cell_type": "markdown",
"source": [
"Next we will download the FRED API, ask the FED for an ID (go here https://research.stlouisfed.org/useraccount/apikeys), and enter it."
],
"metadata": {
"id": "h5nj0YCexQI0"
}
},
{
"cell_type": "code",
"source": [
"############## please get your own API KEY instead of using mine ####################\n",
"fred = Fred(api_key='52b55ac11946f5749148befd9094e6bf') # this key won't work. get your own key please."
],
"metadata": {
"id": "0B0MVtSOw5kv"
},
"execution_count": null,
"outputs": []
},
{
"cell_type": "code",
"source": [
"import numpy as np\n",
"import pandas as pd\n",
"import statsmodels.formula.api as smf \n",
"import matplotlib.pyplot as plt \n",
"%matplotlib inline "
],
"metadata": {
"id": "czhiWug3xGZn"
},
"execution_count": null,
"outputs": []
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"id": "cVlyJG6GwkmB"
},
"outputs": [],
"source": [
"gdp = fred.get_series('GDPC1', observation_start='1995-1-1') # Seasonally adjusted real GDP # seasonally ajusted non-fram employment in thousands\n",
"empl = fred.get_series('PAYEMS', observation_start='1995-1-1') # seasonally ajusted non-farm employment in thousands \n",
"unemp =fred.get_series('UNRATE', observation_start='1995-1-1') # seasonally ajusted unemployment rate in percent\n",
"SP500=fred.get_series('SP500', observation_start='1995-1-1') # only starts in 2010 at Fred for some reason\n",
"consumer_confidence=fred.get_series('UMCSENT', observation_start='1995-1-1') \n",
"dollar_euro=fred.get_series('DEXUSEU', observation_start='1995-1-1') \n",
"civilian_labor_force=fred.get_series('CLF16OV', observation_start='1995-1-1') \n",
"PPI = fred.get_series('PPIACO', observation_start='1995-1-1') \n",
"CO2_emission = fred.get_series('EMISSCO2TOTVTTTOUSA', observation_start='1995-1-1') "
]
},
{
"cell_type": "code",
"source": [
"fig, axs = plt.subplots(3, 3,figsize=(20, 15))\n",
"fig.suptitle('US Economy since January 1995')\n",
"\n",
"# plt.subplot(221)\n",
"\n",
"axs[0][0].plot(gdp.index,gdp.values)\n",
"axs[0][0].set_title(\"Real GDP, SA\")\n",
"axs[0,0].set_ylabel(\"2012 $bn\")\n",
"\n",
"axs[0][1].plot(empl.index,empl.values)\n",
"axs[0][1].set_title(\"Non-farm employment, SA\")\n",
"axs[0,1].set_ylabel(\"thousands\")\n",
"\n",
"axs[0][2].plot(unemp.index,unemp.values)\n",
"axs[0][2].set_title(\"Unemployment, SA\")\n",
"axs[0,2].set_ylabel(\"%\")\n",
"\n",
"axs[1][0].plot(SP500.index,SP500.values)\n",
"axs[1][0].set_title(\"S&P500\")\n",
"\n",
"axs[1][1].plot(consumer_confidence.index,consumer_confidence.values)\n",
"axs[1][1].set_title(\"Consumer Sentiment, SA\")\n",
"\n",
"axs[1][2].plot(dollar_euro.index,dollar_euro.values)\n",
"axs[1][2].set_title(\"Dollar to Euro Spot Exchange Rate, NSA\")\n",
"\n",
"axs[2][0].plot(civilian_labor_force.index, civilian_labor_force.values)\n",
"axs[2][0].set_title(\"Civilian Labor Force, NSA\")\n",
"\n",
"axs[2][1].plot(PPI.index,PPI.values)\n",
"axs[2][1].set_title(\"PPI, SA\")\n",
"\n",
"axs[2][2].plot(CO2_emission.index,CO2_emission.values)\n",
"axs[2][2].set_title(\"CO2_emission, NSA\")\n",
"\n",
"\n",
"plt.show()"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 902
},
"id": "ktVrfkUjXRsv",
"outputId": "20ea3255-db7f-4a64-ff23-40ad9b5fbacf"
},
"execution_count": null,
"outputs": [
{
"output_type": "display_data",
"data": {
"text/plain": [
"| \n", " | xrate | \n", "friday | \n", "
|---|---|---|
| 0 | \n", "0.125333 | \n", "0.0 | \n", "
| 1 | \n", "0.028874 | \n", "0.0 | \n", "
| 2 | \n", "0.063462 | \n", "0.0 | \n", "
| 3 | \n", "0.226719 | \n", "1.0 | \n", "
| 4 | \n", "-0.214267 | \n", "0.0 | \n", "
| ... | \n", "... | \n", "... | \n", "
| 1969 | \n", "-0.408540 | \n", "1.0 | \n", "
| 1970 | \n", "-0.030468 | \n", "1.0 | \n", "
| 1971 | \n", "-0.117546 | \n", "1.0 | \n", "
| 1972 | \n", "-0.231271 | \n", "0.0 | \n", "
| 1973 | \n", "0.528047 | \n", "1.0 | \n", "
1974 rows × 2 columns
\n", "| \n", " | id | \n", "realtime_start | \n", "realtime_end | \n", "title | \n", "observation_start | \n", "observation_end | \n", "frequency | \n", "frequency_short | \n", "units | \n", "units_short | \n", "seasonal_adjustment | \n", "seasonal_adjustment_short | \n", "last_updated | \n", "popularity | \n", "notes | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| series id | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
| UMCSENT | \n", "UMCSENT | \n", "2022-04-07 | \n", "2022-04-07 | \n", "University of Michigan: Consumer Sentiment | \n", "1952-11-01 | \n", "2022-02-01 | \n", "Monthly | \n", "M | \n", "Index 1966:Q1=100 | \n", "Index 1966:Q1=100 | \n", "Not Seasonally Adjusted | \n", "NSA | \n", "2022-03-25 10:01:02-05:00 | \n", "78 | \n", "At the request of the source, the data is dela... | \n", "
| MICH | \n", "MICH | \n", "2022-04-07 | \n", "2022-04-07 | \n", "University of Michigan: Inflation Expectation | \n", "1978-01-01 | \n", "2022-02-01 | \n", "Monthly | \n", "M | \n", "Percent | \n", "% | \n", "Not Seasonally Adjusted | \n", "NSA | \n", "2022-03-25 10:01:12-05:00 | \n", "70 | \n", "Median expected price change next 12 months, S... | \n", "
| CSCICP03USM665S | \n", "CSCICP03USM665S | \n", "2022-04-07 | \n", "2022-04-07 | \n", "Consumer Opinion Surveys: Confidence Indicator... | \n", "1960-01-01 | \n", "2022-02-01 | \n", "Monthly | \n", "M | \n", "Normalised (Normal=100) | \n", "Normalised (Normal = 100) | \n", "Seasonally Adjusted | \n", "SA | \n", "2022-03-10 10:39:06-06:00 | \n", "49 | \n", "OECD descriptor ID: CSCICP03 OECD unit ID: IXN... | \n", "
| CSCICP03EZM665S | \n", "CSCICP03EZM665S | \n", "2022-04-07 | \n", "2022-04-07 | \n", "Consumer Opinion Surveys: Confidence Indicator... | \n", "1973-01-01 | \n", "2022-02-01 | \n", "Monthly | \n", "M | \n", "Normalised (Normal=100) | \n", "Normalised (Normal = 100) | \n", "Seasonally Adjusted | \n", "SA | \n", "2022-03-10 10:47:08-06:00 | \n", "22 | \n", "OECD descriptor ID: CSCICP03 OECD unit ID: IXN... | \n", "
| UMCSENT1 | \n", "UMCSENT1 | \n", "2022-04-07 | \n", "2022-04-07 | \n", "University of Michigan: Consumer Sentiment (DI... | \n", "1952-11-01 | \n", "1977-11-01 | \n", "Not Applicable | \n", "NA | \n", "Index 1966:Q1=100 | \n", "Index 1966:Q1=100 | \n", "Not Seasonally Adjusted | \n", "NSA | \n", "2004-01-12 12:08:18-06:00 | \n", "22 | \n", "Please see FRED data series UMCSENT for monthl... | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| CCDIOA17460Q156N | \n", "CCDIOA17460Q156N | \n", "2022-04-07 | \n", "2022-04-07 | \n", "CredAbility Consumer Distress Index for Clevel... | \n", "2005-01-01 | \n", "2013-01-01 | \n", "Quarterly | \n", "Q | \n", "Percent | \n", "% | \n", "Not Seasonally Adjusted | \n", "NSA | \n", "2013-05-17 14:01:30-05:00 | \n", "1 | \n", "Overview of the Index The Index is a quarterly... | \n", "
| CCDIOA26420Q156N | \n", "CCDIOA26420Q156N | \n", "2022-04-07 | \n", "2022-04-07 | \n", "CredAbility Consumer Distress Index for Housto... | \n", "2005-01-01 | \n", "2013-01-01 | \n", "Quarterly | \n", "Q | \n", "Percent | \n", "% | \n", "Not Seasonally Adjusted | \n", "NSA | \n", "2013-05-17 14:01:32-05:00 | \n", "1 | \n", "Overview of the Index The Index is a quarterly... | \n", "
| CCDIOA37100Q156N | \n", "CCDIOA37100Q156N | \n", "2022-04-07 | \n", "2022-04-07 | \n", "CredAbility Consumer Distress Index for Oxnard... | \n", "2005-01-01 | \n", "2013-01-01 | \n", "Quarterly | \n", "Q | \n", "Percent | \n", "% | \n", "Not Seasonally Adjusted | \n", "NSA | \n", "2013-05-17 14:01:50-05:00 | \n", "1 | \n", "Overview of the Index The Index is a quarterly... | \n", "
| CCDIOA40140Q156N | \n", "CCDIOA40140Q156N | \n", "2022-04-07 | \n", "2022-04-07 | \n", "CredAbility Consumer Distress Index for Rivers... | \n", "2005-01-01 | \n", "2013-01-01 | \n", "Quarterly | \n", "Q | \n", "Percent | \n", "% | \n", "Not Seasonally Adjusted | \n", "NSA | \n", "2013-05-17 14:01:19-05:00 | \n", "1 | \n", "Overview of the Index The Index is a quarterly... | \n", "
| CCDIOA35300Q156N | \n", "CCDIOA35300Q156N | \n", "2022-04-07 | \n", "2022-04-07 | \n", "CredAbility Consumer Distress Index for New Ha... | \n", "2005-01-01 | \n", "2013-01-01 | \n", "Quarterly | \n", "Q | \n", "Percent | \n", "% | \n", "Not Seasonally Adjusted | \n", "NSA | \n", "2013-05-17 14:01:42-05:00 | \n", "1 | \n", "Overview of the Index The Index is a quarterly... | \n", "
297 rows × 15 columns
\n", "