Skip to content

Instantly share code, notes, and snippets.

@jflam

jflam/1_Historical_Federal_Revenues_And_Outlays.ipynb

Created October 9, 2017 21:25
Show Gist options
  • Save jflam/e532496be70f4603a9632f2d58d55961 to your computer and use it in GitHub Desktop.
Save jflam/e532496be70f4603a9632f2d58d55961 to your computer and use it in GitHub Desktop.
Download ZIP
Historical Federal Revenues and Outlays
Display the source blob
Display the rendered blob
Raw
1_Historical_Federal_Revenues_And_Outlays.ipynb
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# US Federal Revenues and Outlays\n",
"\n",
"This first blog post will investigate how revenues and spending have happened historically in the United States. In this series of blog posts, I will investigate where the revenue of the US comes from and where it is spent. The idea here is really to educate myself (and others) about where their tax dollars go by going directly to the source and interpreting and visualizing the data myself using Jupyter notebooks."
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Historical Data\n",
"\n",
"The [Office of Management and Budget](https://www.whitehouse.gov/omb) has data from 1940 to current of Federal Receipts. The data in this blog is from their published [Excel Workbook](https://www.whitehouse.gov/sites/whitehouse.gov/files/omb/budget/fy2018/hist01z3.xls). For other sources of data, see their [Historical Tables](https://www.whitehouse.gov/omb/budget/Historicals) site."
]
},
{
"cell_type": "code",
"execution_count": 33,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"import pandas as pd"
]
},
{
"cell_type": "code",
"execution_count": 34,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style>\n",
" .dataframe thead tr:only-child th {\n",
" text-align: right;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Table 1.3—SUMMARY OF RECEIPTS, OUTLAYS, AND SURPLUSES OR DEFICITS (–) IN CURRENT DOLLARS, CONSTANT (FY 2009) DOLLARS, AND AS PERCENTAGES OF GDP: 1940–2022</th>\n",
" <th>Unnamed: 1</th>\n",
" <th>Unnamed: 2</th>\n",
" <th>Unnamed: 3</th>\n",
" <th>Unnamed: 4</th>\n",
" <th>Unnamed: 5</th>\n",
" <th>Unnamed: 6</th>\n",
" <th>Unnamed: 7</th>\n",
" <th>Unnamed: 8</th>\n",
" <th>Unnamed: 9</th>\n",
" <th>Unnamed: 10</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>(dollar amounts in billions)</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>Fiscal Year</td>\n",
" <td>In Current Dollars</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>In Constant (FY 2009) Dollars</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Addendum: Composite Deflator</td>\n",
" <td>As Percentages of GDP</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>NaN</td>\n",
" <td>Receipts</td>\n",
" <td>Outlays</td>\n",
" <td>Surplus or Deficit (–)</td>\n",
" <td>Receipts</td>\n",
" <td>Outlays</td>\n",
" <td>Surplus or Deficit (–)</td>\n",
" <td>NaN</td>\n",
" <td>Receipts</td>\n",
" <td>Outlays</td>\n",
" <td>Surplus or Deficit (–)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>1940</td>\n",
" <td>6.5</td>\n",
" <td>9.5</td>\n",
" <td>-2.9</td>\n",
" <td>94</td>\n",
" <td>135.8</td>\n",
" <td>-41.9</td>\n",
" <td>0.0697</td>\n",
" <td>6.7</td>\n",
" <td>9.6</td>\n",
" <td>-3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>1941</td>\n",
" <td>8.7</td>\n",
" <td>13.7</td>\n",
" <td>-4.9</td>\n",
" <td>113.3</td>\n",
" <td>177.5</td>\n",
" <td>-64.3</td>\n",
" <td>0.0769</td>\n",
" <td>7.5</td>\n",
" <td>11.7</td>\n",
" <td>-4.3</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" Table 1.3—SUMMARY OF RECEIPTS, OUTLAYS, AND SURPLUSES OR DEFICITS (–) IN CURRENT DOLLARS, CONSTANT (FY 2009) DOLLARS, AND AS PERCENTAGES OF GDP: 1940–2022 \\\n",
"0 (dollar amounts in billions) \n",
"1 Fiscal Year \n",
"2 NaN \n",
"3 1940 \n",
"4 1941 \n",
"\n",
" Unnamed: 1 Unnamed: 2 Unnamed: 3 \\\n",
"0 NaN NaN NaN \n",
"1 In Current Dollars NaN NaN \n",
"2 Receipts Outlays Surplus or Deficit (–) \n",
"3 6.5 9.5 -2.9 \n",
"4 8.7 13.7 -4.9 \n",
"\n",
" Unnamed: 4 Unnamed: 5 Unnamed: 6 \\\n",
"0 NaN NaN NaN \n",
"1 In Constant (FY 2009) Dollars NaN NaN \n",
"2 Receipts Outlays Surplus or Deficit (–) \n",
"3 94 135.8 -41.9 \n",
"4 113.3 177.5 -64.3 \n",
"\n",
" Unnamed: 7 Unnamed: 8 Unnamed: 9 \\\n",
"0 NaN NaN NaN \n",
"1 Addendum: Composite Deflator As Percentages of GDP NaN \n",
"2 NaN Receipts Outlays \n",
"3 0.0697 6.7 9.6 \n",
"4 0.0769 7.5 11.7 \n",
"\n",
" Unnamed: 10 \n",
"0 NaN \n",
"1 NaN \n",
"2 Surplus or Deficit (–) \n",
"3 -3 \n",
"4 -4.3 "
]
},
"execution_count": 34,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df = pd.read_excel('https://www.whitehouse.gov/sites/whitehouse.gov/files/omb/budget/fy2018/hist01z3.xls')\n",
"df.head()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Cleaning the data\n",
"\n",
"The XLS is formatted to be human-readable, but it's not great as a source of data for further computations."
]
},
{
"cell_type": "code",
"execution_count": 35,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"Index(['Table 1.3—SUMMARY OF RECEIPTS, OUTLAYS, AND SURPLUSES OR DEFICITS (–) IN CURRENT DOLLARS, CONSTANT (FY 2009) DOLLARS, AND AS PERCENTAGES OF GDP: 1940–2022',\n",
" 'Unnamed: 1', 'Unnamed: 2', 'Unnamed: 3', 'Unnamed: 4', 'Unnamed: 5',\n",
" 'Unnamed: 6', 'Unnamed: 7', 'Unnamed: 8', 'Unnamed: 9', 'Unnamed: 10'],\n",
" dtype='object')"
]
},
"execution_count": 35,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.columns"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Let's give the dataframe readable column names. In this case CD means Constant FY2009 dollars, and GDP means expressed as a percentage of the GDP for that Fiscal Year."
]
},
{
"cell_type": "code",
"execution_count": 36,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"df.columns = [\n",
" 'Fiscal Year', \n",
" 'Receipts', \n",
" 'Outlays', \n",
" 'Surplus or Deficit', \n",
" 'CD Receipts', \n",
" 'CD Outlays', \n",
" 'CD Surplus or Deficit', \n",
" 'Composite Deflator', \n",
" 'GDP Receipts', \n",
" 'GDP Outlays', \n",
" 'GDP Surplus or Deficit']"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Next, let's examine the dataframe and look at the rows that we want to keep. Let's construct a new dataframe called `tax` that contains just the data from FY1940-2016. You can see here that we want to keep row indexes 3 through 80 inclusive."
]
},
{
"cell_type": "code",
"execution_count": 37,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style>\n",
" .dataframe thead tr:only-child th {\n",
" text-align: right;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Fiscal Year</th>\n",
" <th>Receipts</th>\n",
" <th>Outlays</th>\n",
" <th>Surplus or Deficit</th>\n",
" <th>CD Receipts</th>\n",
" <th>CD Outlays</th>\n",
" <th>CD Surplus or Deficit</th>\n",
" <th>Composite Deflator</th>\n",
" <th>GDP Receipts</th>\n",
" <th>GDP Outlays</th>\n",
" <th>GDP Surplus or Deficit</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>(dollar amounts in billions)</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>Fiscal Year</td>\n",
" <td>In Current Dollars</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>In Constant (FY 2009) Dollars</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Addendum: Composite Deflator</td>\n",
" <td>As Percentages of GDP</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>NaN</td>\n",
" <td>Receipts</td>\n",
" <td>Outlays</td>\n",
" <td>Surplus or Deficit (–)</td>\n",
" <td>Receipts</td>\n",
" <td>Outlays</td>\n",
" <td>Surplus or Deficit (–)</td>\n",
" <td>NaN</td>\n",
" <td>Receipts</td>\n",
" <td>Outlays</td>\n",
" <td>Surplus or Deficit (–)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>1940</td>\n",
" <td>6.5</td>\n",
" <td>9.5</td>\n",
" <td>-2.9</td>\n",
" <td>94</td>\n",
" <td>135.8</td>\n",
" <td>-41.9</td>\n",
" <td>0.0697</td>\n",
" <td>6.7</td>\n",
" <td>9.6</td>\n",
" <td>-3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>1941</td>\n",
" <td>8.7</td>\n",
" <td>13.7</td>\n",
" <td>-4.9</td>\n",
" <td>113.3</td>\n",
" <td>177.5</td>\n",
" <td>-64.3</td>\n",
" <td>0.0769</td>\n",
" <td>7.5</td>\n",
" <td>11.7</td>\n",
" <td>-4.3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>1942</td>\n",
" <td>14.6</td>\n",
" <td>35.1</td>\n",
" <td>-20.5</td>\n",
" <td>167.8</td>\n",
" <td>402.9</td>\n",
" <td>-235.1</td>\n",
" <td>0.0872</td>\n",
" <td>9.9</td>\n",
" <td>23.8</td>\n",
" <td>-13.9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>1943</td>\n",
" <td>24</td>\n",
" <td>78.6</td>\n",
" <td>-54.6</td>\n",
" <td>249</td>\n",
" <td>814.9</td>\n",
" <td>-565.9</td>\n",
" <td>0.0964</td>\n",
" <td>13</td>\n",
" <td>42.6</td>\n",
" <td>-29.6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>1944</td>\n",
" <td>43.7</td>\n",
" <td>91.3</td>\n",
" <td>-47.6</td>\n",
" <td>493.2</td>\n",
" <td>1029.4</td>\n",
" <td>-536.2</td>\n",
" <td>0.0887</td>\n",
" <td>20.5</td>\n",
" <td>42.7</td>\n",
" <td>-22.2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>1945</td>\n",
" <td>45.2</td>\n",
" <td>92.7</td>\n",
" <td>-47.6</td>\n",
" <td>541.5</td>\n",
" <td>1111.7</td>\n",
" <td>-570.2</td>\n",
" <td>0.0834</td>\n",
" <td>19.9</td>\n",
" <td>41</td>\n",
" <td>-21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>1946</td>\n",
" <td>39.3</td>\n",
" <td>55.2</td>\n",
" <td>-15.9</td>\n",
" <td>466.7</td>\n",
" <td>656</td>\n",
" <td>-189.3</td>\n",
" <td>0.0842</td>\n",
" <td>17.2</td>\n",
" <td>24.2</td>\n",
" <td>-7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>1947</td>\n",
" <td>38.5</td>\n",
" <td>34.5</td>\n",
" <td>4</td>\n",
" <td>402.9</td>\n",
" <td>360.8</td>\n",
" <td>42</td>\n",
" <td>0.0956</td>\n",
" <td>16.1</td>\n",
" <td>14.4</td>\n",
" <td>1.7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>1948</td>\n",
" <td>41.6</td>\n",
" <td>29.8</td>\n",
" <td>11.8</td>\n",
" <td>418.1</td>\n",
" <td>299.4</td>\n",
" <td>118.7</td>\n",
" <td>0.0994</td>\n",
" <td>15.8</td>\n",
" <td>11.3</td>\n",
" <td>4.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>1949</td>\n",
" <td>39.4</td>\n",
" <td>38.8</td>\n",
" <td>0.6</td>\n",
" <td>411.4</td>\n",
" <td>405.4</td>\n",
" <td>6.1</td>\n",
" <td>0.0958</td>\n",
" <td>14.2</td>\n",
" <td>14</td>\n",
" <td>0.2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>1950</td>\n",
" <td>39.4</td>\n",
" <td>42.6</td>\n",
" <td>-3.1</td>\n",
" <td>392.5</td>\n",
" <td>423.5</td>\n",
" <td>-31</td>\n",
" <td>0.1005</td>\n",
" <td>14.1</td>\n",
" <td>15.3</td>\n",
" <td>-1.1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>1951</td>\n",
" <td>51.6</td>\n",
" <td>45.5</td>\n",
" <td>6.1</td>\n",
" <td>511.6</td>\n",
" <td>451.1</td>\n",
" <td>60.5</td>\n",
" <td>0.1009</td>\n",
" <td>15.8</td>\n",
" <td>13.9</td>\n",
" <td>1.9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>1952</td>\n",
" <td>66.2</td>\n",
" <td>67.7</td>\n",
" <td>-1.5</td>\n",
" <td>657.7</td>\n",
" <td>672.8</td>\n",
" <td>-15.1</td>\n",
" <td>0.1006</td>\n",
" <td>18.5</td>\n",
" <td>18.9</td>\n",
" <td>-0.4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>1953</td>\n",
" <td>69.6</td>\n",
" <td>76.1</td>\n",
" <td>-6.5</td>\n",
" <td>644.5</td>\n",
" <td>704.6</td>\n",
" <td>-60.1</td>\n",
" <td>0.108</td>\n",
" <td>18.2</td>\n",
" <td>19.9</td>\n",
" <td>-1.7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>1954</td>\n",
" <td>69.7</td>\n",
" <td>70.9</td>\n",
" <td>-1.2</td>\n",
" <td>626.8</td>\n",
" <td>637.2</td>\n",
" <td>-10.4</td>\n",
" <td>0.1112</td>\n",
" <td>18</td>\n",
" <td>18.3</td>\n",
" <td>-0.3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>1955</td>\n",
" <td>65.5</td>\n",
" <td>68.4</td>\n",
" <td>-3</td>\n",
" <td>568.6</td>\n",
" <td>594.6</td>\n",
" <td>-26</td>\n",
" <td>0.1151</td>\n",
" <td>16.1</td>\n",
" <td>16.8</td>\n",
" <td>-0.7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>1956</td>\n",
" <td>74.6</td>\n",
" <td>70.6</td>\n",
" <td>3.9</td>\n",
" <td>620.5</td>\n",
" <td>587.7</td>\n",
" <td>32.8</td>\n",
" <td>0.1202</td>\n",
" <td>17</td>\n",
" <td>16.1</td>\n",
" <td>0.9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>1957</td>\n",
" <td>80</td>\n",
" <td>76.6</td>\n",
" <td>3.4</td>\n",
" <td>634.3</td>\n",
" <td>607.3</td>\n",
" <td>27.1</td>\n",
" <td>0.1261</td>\n",
" <td>17.2</td>\n",
" <td>16.5</td>\n",
" <td>0.7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>1958</td>\n",
" <td>79.6</td>\n",
" <td>82.4</td>\n",
" <td>-2.8</td>\n",
" <td>596.5</td>\n",
" <td>617.3</td>\n",
" <td>-20.7</td>\n",
" <td>0.1335</td>\n",
" <td>16.8</td>\n",
" <td>17.4</td>\n",
" <td>-0.6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>1959</td>\n",
" <td>79.2</td>\n",
" <td>92.1</td>\n",
" <td>-12.8</td>\n",
" <td>569.7</td>\n",
" <td>662.1</td>\n",
" <td>-92.4</td>\n",
" <td>0.1391</td>\n",
" <td>15.7</td>\n",
" <td>18.2</td>\n",
" <td>-2.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>1960</td>\n",
" <td>92.5</td>\n",
" <td>92.2</td>\n",
" <td>0.3</td>\n",
" <td>655.5</td>\n",
" <td>653.4</td>\n",
" <td>2.1</td>\n",
" <td>0.1411</td>\n",
" <td>17.3</td>\n",
" <td>17.2</td>\n",
" <td>0.1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>1961</td>\n",
" <td>94.4</td>\n",
" <td>97.7</td>\n",
" <td>-3.3</td>\n",
" <td>654.1</td>\n",
" <td>677.2</td>\n",
" <td>-23.1</td>\n",
" <td>0.1443</td>\n",
" <td>17.2</td>\n",
" <td>17.8</td>\n",
" <td>-0.6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>1962</td>\n",
" <td>99.7</td>\n",
" <td>106.8</td>\n",
" <td>-7.1</td>\n",
" <td>689.8</td>\n",
" <td>739.2</td>\n",
" <td>-49.5</td>\n",
" <td>0.1445</td>\n",
" <td>17</td>\n",
" <td>18.2</td>\n",
" <td>-1.2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>1963</td>\n",
" <td>106.6</td>\n",
" <td>111.3</td>\n",
" <td>-4.8</td>\n",
" <td>707.1</td>\n",
" <td>738.7</td>\n",
" <td>-31.6</td>\n",
" <td>0.1507</td>\n",
" <td>17.2</td>\n",
" <td>18</td>\n",
" <td>-0.8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>1964</td>\n",
" <td>112.6</td>\n",
" <td>118.5</td>\n",
" <td>-5.9</td>\n",
" <td>735.6</td>\n",
" <td>774.2</td>\n",
" <td>-38.6</td>\n",
" <td>0.1531</td>\n",
" <td>17</td>\n",
" <td>17.9</td>\n",
" <td>-0.9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>1965</td>\n",
" <td>116.8</td>\n",
" <td>118.2</td>\n",
" <td>-1.4</td>\n",
" <td>752.2</td>\n",
" <td>761.3</td>\n",
" <td>-9.1</td>\n",
" <td>0.1553</td>\n",
" <td>16.4</td>\n",
" <td>16.6</td>\n",
" <td>-0.2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>1966</td>\n",
" <td>130.8</td>\n",
" <td>134.5</td>\n",
" <td>-3.7</td>\n",
" <td>819.8</td>\n",
" <td>842.9</td>\n",
" <td>-23.2</td>\n",
" <td>0.1596</td>\n",
" <td>16.7</td>\n",
" <td>17.2</td>\n",
" <td>-0.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>57</th>\n",
" <td>1993</td>\n",
" <td>1154.3</td>\n",
" <td>1409.4</td>\n",
" <td>-255.1</td>\n",
" <td>1655.7</td>\n",
" <td>2021.5</td>\n",
" <td>-365.8</td>\n",
" <td>0.6972</td>\n",
" <td>17</td>\n",
" <td>20.7</td>\n",
" <td>-3.8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>58</th>\n",
" <td>1994</td>\n",
" <td>1258.6</td>\n",
" <td>1461.8</td>\n",
" <td>-203.2</td>\n",
" <td>1772.6</td>\n",
" <td>2058.8</td>\n",
" <td>-286.2</td>\n",
" <td>0.71</td>\n",
" <td>17.5</td>\n",
" <td>20.3</td>\n",
" <td>-2.8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>59</th>\n",
" <td>1995</td>\n",
" <td>1351.8</td>\n",
" <td>1515.7</td>\n",
" <td>-164</td>\n",
" <td>1850.2</td>\n",
" <td>2074.7</td>\n",
" <td>-224.4</td>\n",
" <td>0.7306</td>\n",
" <td>17.8</td>\n",
" <td>20</td>\n",
" <td>-2.2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>60</th>\n",
" <td>1996</td>\n",
" <td>1453.1</td>\n",
" <td>1560.5</td>\n",
" <td>-107.4</td>\n",
" <td>1948.1</td>\n",
" <td>2092.1</td>\n",
" <td>-144</td>\n",
" <td>0.7459</td>\n",
" <td>18.2</td>\n",
" <td>19.6</td>\n",
" <td>-1.3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>61</th>\n",
" <td>1997</td>\n",
" <td>1579.2</td>\n",
" <td>1601.1</td>\n",
" <td>-21.9</td>\n",
" <td>2074.7</td>\n",
" <td>2103.4</td>\n",
" <td>-28.7</td>\n",
" <td>0.7612</td>\n",
" <td>18.6</td>\n",
" <td>18.9</td>\n",
" <td>-0.3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>62</th>\n",
" <td>1998</td>\n",
" <td>1721.7</td>\n",
" <td>1652.5</td>\n",
" <td>69.3</td>\n",
" <td>2242.1</td>\n",
" <td>2151.9</td>\n",
" <td>90.2</td>\n",
" <td>0.7679</td>\n",
" <td>19.2</td>\n",
" <td>18.5</td>\n",
" <td>0.8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>63</th>\n",
" <td>1999</td>\n",
" <td>1827.5</td>\n",
" <td>1701.8</td>\n",
" <td>125.6</td>\n",
" <td>2349.8</td>\n",
" <td>2188.3</td>\n",
" <td>161.5</td>\n",
" <td>0.7777</td>\n",
" <td>19.2</td>\n",
" <td>17.9</td>\n",
" <td>1.3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>64</th>\n",
" <td>2000</td>\n",
" <td>2025.2</td>\n",
" <td>1789</td>\n",
" <td>236.2</td>\n",
" <td>2541</td>\n",
" <td>2244.6</td>\n",
" <td>296.4</td>\n",
" <td>0.797</td>\n",
" <td>20</td>\n",
" <td>17.6</td>\n",
" <td>2.3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>65</th>\n",
" <td>2001</td>\n",
" <td>1991.1</td>\n",
" <td>1862.8</td>\n",
" <td>128.2</td>\n",
" <td>2433.2</td>\n",
" <td>2276.5</td>\n",
" <td>156.7</td>\n",
" <td>0.8183</td>\n",
" <td>18.8</td>\n",
" <td>17.6</td>\n",
" <td>1.2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>66</th>\n",
" <td>2002</td>\n",
" <td>1853.1</td>\n",
" <td>2010.9</td>\n",
" <td>-157.8</td>\n",
" <td>2227.6</td>\n",
" <td>2417.2</td>\n",
" <td>-189.6</td>\n",
" <td>0.8319</td>\n",
" <td>17</td>\n",
" <td>18.5</td>\n",
" <td>-1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>67</th>\n",
" <td>2003</td>\n",
" <td>1782.3</td>\n",
" <td>2159.9</td>\n",
" <td>-377.6</td>\n",
" <td>2083.6</td>\n",
" <td>2525</td>\n",
" <td>-441.4</td>\n",
" <td>0.8554</td>\n",
" <td>15.7</td>\n",
" <td>19.1</td>\n",
" <td>-3.3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>68</th>\n",
" <td>2004</td>\n",
" <td>1880.1</td>\n",
" <td>2292.8</td>\n",
" <td>-412.7</td>\n",
" <td>2141.8</td>\n",
" <td>2612</td>\n",
" <td>-470.2</td>\n",
" <td>0.8778</td>\n",
" <td>15.6</td>\n",
" <td>19</td>\n",
" <td>-3.4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>69</th>\n",
" <td>2005</td>\n",
" <td>2153.6</td>\n",
" <td>2472</td>\n",
" <td>-318.3</td>\n",
" <td>2371.6</td>\n",
" <td>2722.1</td>\n",
" <td>-350.6</td>\n",
" <td>0.9081</td>\n",
" <td>16.7</td>\n",
" <td>19.2</td>\n",
" <td>-2.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>70</th>\n",
" <td>2006</td>\n",
" <td>2406.9</td>\n",
" <td>2655</td>\n",
" <td>-248.2</td>\n",
" <td>2561.9</td>\n",
" <td>2826</td>\n",
" <td>-264.2</td>\n",
" <td>0.9395</td>\n",
" <td>17.6</td>\n",
" <td>19.4</td>\n",
" <td>-1.8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>71</th>\n",
" <td>2007</td>\n",
" <td>2568</td>\n",
" <td>2728.7</td>\n",
" <td>-160.7</td>\n",
" <td>2663.1</td>\n",
" <td>2829.7</td>\n",
" <td>-166.7</td>\n",
" <td>0.9643</td>\n",
" <td>17.9</td>\n",
" <td>19.1</td>\n",
" <td>-1.1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>72</th>\n",
" <td>2008</td>\n",
" <td>2524</td>\n",
" <td>2982.5</td>\n",
" <td>-458.6</td>\n",
" <td>2529</td>\n",
" <td>2988.5</td>\n",
" <td>-459.5</td>\n",
" <td>0.998</td>\n",
" <td>17.1</td>\n",
" <td>20.2</td>\n",
" <td>-3.1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>73</th>\n",
" <td>2009</td>\n",
" <td>2105</td>\n",
" <td>3517.7</td>\n",
" <td>-1412.7</td>\n",
" <td>2105</td>\n",
" <td>3517.7</td>\n",
" <td>-1412.7</td>\n",
" <td>1</td>\n",
" <td>14.6</td>\n",
" <td>24.4</td>\n",
" <td>-9.8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>74</th>\n",
" <td>2010</td>\n",
" <td>2162.7</td>\n",
" <td>3457.1</td>\n",
" <td>-1294.4</td>\n",
" <td>2129.3</td>\n",
" <td>3403.6</td>\n",
" <td>-1274.4</td>\n",
" <td>1.0157</td>\n",
" <td>14.6</td>\n",
" <td>23.4</td>\n",
" <td>-8.7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>75</th>\n",
" <td>2011</td>\n",
" <td>2303.5</td>\n",
" <td>3603.1</td>\n",
" <td>-1299.6</td>\n",
" <td>2215.9</td>\n",
" <td>3466.2</td>\n",
" <td>-1250.2</td>\n",
" <td>1.0395</td>\n",
" <td>15</td>\n",
" <td>23.4</td>\n",
" <td>-8.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>76</th>\n",
" <td>2012</td>\n",
" <td>2450</td>\n",
" <td>3536.9</td>\n",
" <td>-1087</td>\n",
" <td>2310.7</td>\n",
" <td>3335.8</td>\n",
" <td>-1025.1</td>\n",
" <td>1.0603</td>\n",
" <td>15.3</td>\n",
" <td>22.1</td>\n",
" <td>-6.8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>77</th>\n",
" <td>2013</td>\n",
" <td>2775.1</td>\n",
" <td>3454.6</td>\n",
" <td>-679.5</td>\n",
" <td>2583.9</td>\n",
" <td>3216.6</td>\n",
" <td>-632.7</td>\n",
" <td>1.074</td>\n",
" <td>16.8</td>\n",
" <td>20.9</td>\n",
" <td>-4.1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>78</th>\n",
" <td>2014</td>\n",
" <td>3021.5</td>\n",
" <td>3506.1</td>\n",
" <td>-484.6</td>\n",
" <td>2770.5</td>\n",
" <td>3214.8</td>\n",
" <td>-444.3</td>\n",
" <td>1.0906</td>\n",
" <td>17.5</td>\n",
" <td>20.4</td>\n",
" <td>-2.8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>79</th>\n",
" <td>2015</td>\n",
" <td>3249.9</td>\n",
" <td>3688.4</td>\n",
" <td>-438.5</td>\n",
" <td>2960.9</td>\n",
" <td>3360.4</td>\n",
" <td>-399.5</td>\n",
" <td>1.0976</td>\n",
" <td>18.2</td>\n",
" <td>20.6</td>\n",
" <td>-2.4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>80</th>\n",
" <td>2016</td>\n",
" <td>3268</td>\n",
" <td>3852.6</td>\n",
" <td>-584.7</td>\n",
" <td>2953.2</td>\n",
" <td>3481.5</td>\n",
" <td>-528.3</td>\n",
" <td>1.1066</td>\n",
" <td>17.8</td>\n",
" <td>20.9</td>\n",
" <td>-3.2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>81</th>\n",
" <td>2017 estimate</td>\n",
" <td>3459.7</td>\n",
" <td>4062.2</td>\n",
" <td>-602.5</td>\n",
" <td>3056</td>\n",
" <td>3588.2</td>\n",
" <td>-532.2</td>\n",
" <td>1.1321</td>\n",
" <td>18.1</td>\n",
" <td>21.2</td>\n",
" <td>-3.1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>82</th>\n",
" <td>2018 estimate</td>\n",
" <td>3654.3</td>\n",
" <td>4094.4</td>\n",
" <td>-440.2</td>\n",
" <td>3159.2</td>\n",
" <td>3539.8</td>\n",
" <td>-380.5</td>\n",
" <td>1.1567</td>\n",
" <td>18.3</td>\n",
" <td>20.5</td>\n",
" <td>-2.2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>83</th>\n",
" <td>2019 estimate</td>\n",
" <td>3813.7</td>\n",
" <td>4339.6</td>\n",
" <td>-525.9</td>\n",
" <td>3224.3</td>\n",
" <td>3668.9</td>\n",
" <td>-444.6</td>\n",
" <td>1.1828</td>\n",
" <td>18.2</td>\n",
" <td>20.7</td>\n",
" <td>-2.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>84</th>\n",
" <td>2020 estimate</td>\n",
" <td>3982.1</td>\n",
" <td>4470.1</td>\n",
" <td>-488</td>\n",
" <td>3292.4</td>\n",
" <td>3695.8</td>\n",
" <td>-403.4</td>\n",
" <td>1.2095</td>\n",
" <td>18.1</td>\n",
" <td>20.3</td>\n",
" <td>-2.2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>85</th>\n",
" <td>2021 estimate</td>\n",
" <td>4160.9</td>\n",
" <td>4616.7</td>\n",
" <td>-455.8</td>\n",
" <td>3364</td>\n",
" <td>3732.5</td>\n",
" <td>-368.5</td>\n",
" <td>1.2369</td>\n",
" <td>18</td>\n",
" <td>20</td>\n",
" <td>-2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>86</th>\n",
" <td>2022 estimate</td>\n",
" <td>4390.1</td>\n",
" <td>4831.7</td>\n",
" <td>-441.7</td>\n",
" <td>3471.2</td>\n",
" <td>3820.5</td>\n",
" <td>-349.2</td>\n",
" <td>1.2647</td>\n",
" <td>18.1</td>\n",
" <td>19.9</td>\n",
" <td>-1.8</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>87 rows × 11 columns</p>\n",
"</div>"
],
"text/plain": [
" Fiscal Year Receipts Outlays \\\n",
"0 (dollar amounts in billions) NaN NaN \n",
"1 Fiscal Year In Current Dollars NaN \n",
"2 NaN Receipts Outlays \n",
"3 1940 6.5 9.5 \n",
"4 1941 8.7 13.7 \n",
"5 1942 14.6 35.1 \n",
"6 1943 24 78.6 \n",
"7 1944 43.7 91.3 \n",
"8 1945 45.2 92.7 \n",
"9 1946 39.3 55.2 \n",
"10 1947 38.5 34.5 \n",
"11 1948 41.6 29.8 \n",
"12 1949 39.4 38.8 \n",
"13 1950 39.4 42.6 \n",
"14 1951 51.6 45.5 \n",
"15 1952 66.2 67.7 \n",
"16 1953 69.6 76.1 \n",
"17 1954 69.7 70.9 \n",
"18 1955 65.5 68.4 \n",
"19 1956 74.6 70.6 \n",
"20 1957 80 76.6 \n",
"21 1958 79.6 82.4 \n",
"22 1959 79.2 92.1 \n",
"23 1960 92.5 92.2 \n",
"24 1961 94.4 97.7 \n",
"25 1962 99.7 106.8 \n",
"26 1963 106.6 111.3 \n",
"27 1964 112.6 118.5 \n",
"28 1965 116.8 118.2 \n",
"29 1966 130.8 134.5 \n",
".. ... ... ... \n",
"57 1993 1154.3 1409.4 \n",
"58 1994 1258.6 1461.8 \n",
"59 1995 1351.8 1515.7 \n",
"60 1996 1453.1 1560.5 \n",
"61 1997 1579.2 1601.1 \n",
"62 1998 1721.7 1652.5 \n",
"63 1999 1827.5 1701.8 \n",
"64 2000 2025.2 1789 \n",
"65 2001 1991.1 1862.8 \n",
"66 2002 1853.1 2010.9 \n",
"67 2003 1782.3 2159.9 \n",
"68 2004 1880.1 2292.8 \n",
"69 2005 2153.6 2472 \n",
"70 2006 2406.9 2655 \n",
"71 2007 2568 2728.7 \n",
"72 2008 2524 2982.5 \n",
"73 2009 2105 3517.7 \n",
"74 2010 2162.7 3457.1 \n",
"75 2011 2303.5 3603.1 \n",
"76 2012 2450 3536.9 \n",
"77 2013 2775.1 3454.6 \n",
"78 2014 3021.5 3506.1 \n",
"79 2015 3249.9 3688.4 \n",
"80 2016 3268 3852.6 \n",
"81 2017 estimate 3459.7 4062.2 \n",
"82 2018 estimate 3654.3 4094.4 \n",
"83 2019 estimate 3813.7 4339.6 \n",
"84 2020 estimate 3982.1 4470.1 \n",
"85 2021 estimate 4160.9 4616.7 \n",
"86 2022 estimate 4390.1 4831.7 \n",
"\n",
" Surplus or Deficit CD Receipts CD Outlays \\\n",
"0 NaN NaN NaN \n",
"1 NaN In Constant (FY 2009) Dollars NaN \n",
"2 Surplus or Deficit (–) Receipts Outlays \n",
"3 -2.9 94 135.8 \n",
"4 -4.9 113.3 177.5 \n",
"5 -20.5 167.8 402.9 \n",
"6 -54.6 249 814.9 \n",
"7 -47.6 493.2 1029.4 \n",
"8 -47.6 541.5 1111.7 \n",
"9 -15.9 466.7 656 \n",
"10 4 402.9 360.8 \n",
"11 11.8 418.1 299.4 \n",
"12 0.6 411.4 405.4 \n",
"13 -3.1 392.5 423.5 \n",
"14 6.1 511.6 451.1 \n",
"15 -1.5 657.7 672.8 \n",
"16 -6.5 644.5 704.6 \n",
"17 -1.2 626.8 637.2 \n",
"18 -3 568.6 594.6 \n",
"19 3.9 620.5 587.7 \n",
"20 3.4 634.3 607.3 \n",
"21 -2.8 596.5 617.3 \n",
"22 -12.8 569.7 662.1 \n",
"23 0.3 655.5 653.4 \n",
"24 -3.3 654.1 677.2 \n",
"25 -7.1 689.8 739.2 \n",
"26 -4.8 707.1 738.7 \n",
"27 -5.9 735.6 774.2 \n",
"28 -1.4 752.2 761.3 \n",
"29 -3.7 819.8 842.9 \n",
".. ... ... ... \n",
"57 -255.1 1655.7 2021.5 \n",
"58 -203.2 1772.6 2058.8 \n",
"59 -164 1850.2 2074.7 \n",
"60 -107.4 1948.1 2092.1 \n",
"61 -21.9 2074.7 2103.4 \n",
"62 69.3 2242.1 2151.9 \n",
"63 125.6 2349.8 2188.3 \n",
"64 236.2 2541 2244.6 \n",
"65 128.2 2433.2 2276.5 \n",
"66 -157.8 2227.6 2417.2 \n",
"67 -377.6 2083.6 2525 \n",
"68 -412.7 2141.8 2612 \n",
"69 -318.3 2371.6 2722.1 \n",
"70 -248.2 2561.9 2826 \n",
"71 -160.7 2663.1 2829.7 \n",
"72 -458.6 2529 2988.5 \n",
"73 -1412.7 2105 3517.7 \n",
"74 -1294.4 2129.3 3403.6 \n",
"75 -1299.6 2215.9 3466.2 \n",
"76 -1087 2310.7 3335.8 \n",
"77 -679.5 2583.9 3216.6 \n",
"78 -484.6 2770.5 3214.8 \n",
"79 -438.5 2960.9 3360.4 \n",
"80 -584.7 2953.2 3481.5 \n",
"81 -602.5 3056 3588.2 \n",
"82 -440.2 3159.2 3539.8 \n",
"83 -525.9 3224.3 3668.9 \n",
"84 -488 3292.4 3695.8 \n",
"85 -455.8 3364 3732.5 \n",
"86 -441.7 3471.2 3820.5 \n",
"\n",
" CD Surplus or Deficit Composite Deflator \\\n",
"0 NaN NaN \n",
"1 NaN Addendum: Composite Deflator \n",
"2 Surplus or Deficit (–) NaN \n",
"3 -41.9 0.0697 \n",
"4 -64.3 0.0769 \n",
"5 -235.1 0.0872 \n",
"6 -565.9 0.0964 \n",
"7 -536.2 0.0887 \n",
"8 -570.2 0.0834 \n",
"9 -189.3 0.0842 \n",
"10 42 0.0956 \n",
"11 118.7 0.0994 \n",
"12 6.1 0.0958 \n",
"13 -31 0.1005 \n",
"14 60.5 0.1009 \n",
"15 -15.1 0.1006 \n",
"16 -60.1 0.108 \n",
"17 -10.4 0.1112 \n",
"18 -26 0.1151 \n",
"19 32.8 0.1202 \n",
"20 27.1 0.1261 \n",
"21 -20.7 0.1335 \n",
"22 -92.4 0.1391 \n",
"23 2.1 0.1411 \n",
"24 -23.1 0.1443 \n",
"25 -49.5 0.1445 \n",
"26 -31.6 0.1507 \n",
"27 -38.6 0.1531 \n",
"28 -9.1 0.1553 \n",
"29 -23.2 0.1596 \n",
".. ... ... \n",
"57 -365.8 0.6972 \n",
"58 -286.2 0.71 \n",
"59 -224.4 0.7306 \n",
"60 -144 0.7459 \n",
"61 -28.7 0.7612 \n",
"62 90.2 0.7679 \n",
"63 161.5 0.7777 \n",
"64 296.4 0.797 \n",
"65 156.7 0.8183 \n",
"66 -189.6 0.8319 \n",
"67 -441.4 0.8554 \n",
"68 -470.2 0.8778 \n",
"69 -350.6 0.9081 \n",
"70 -264.2 0.9395 \n",
"71 -166.7 0.9643 \n",
"72 -459.5 0.998 \n",
"73 -1412.7 1 \n",
"74 -1274.4 1.0157 \n",
"75 -1250.2 1.0395 \n",
"76 -1025.1 1.0603 \n",
"77 -632.7 1.074 \n",
"78 -444.3 1.0906 \n",
"79 -399.5 1.0976 \n",
"80 -528.3 1.1066 \n",
"81 -532.2 1.1321 \n",
"82 -380.5 1.1567 \n",
"83 -444.6 1.1828 \n",
"84 -403.4 1.2095 \n",
"85 -368.5 1.2369 \n",
"86 -349.2 1.2647 \n",
"\n",
" GDP Receipts GDP Outlays GDP Surplus or Deficit \n",
"0 NaN NaN NaN \n",
"1 As Percentages of GDP NaN NaN \n",
"2 Receipts Outlays Surplus or Deficit (–) \n",
"3 6.7 9.6 -3 \n",
"4 7.5 11.7 -4.3 \n",
"5 9.9 23.8 -13.9 \n",
"6 13 42.6 -29.6 \n",
"7 20.5 42.7 -22.2 \n",
"8 19.9 41 -21 \n",
"9 17.2 24.2 -7 \n",
"10 16.1 14.4 1.7 \n",
"11 15.8 11.3 4.5 \n",
"12 14.2 14 0.2 \n",
"13 14.1 15.3 -1.1 \n",
"14 15.8 13.9 1.9 \n",
"15 18.5 18.9 -0.4 \n",
"16 18.2 19.9 -1.7 \n",
"17 18 18.3 -0.3 \n",
"18 16.1 16.8 -0.7 \n",
"19 17 16.1 0.9 \n",
"20 17.2 16.5 0.7 \n",
"21 16.8 17.4 -0.6 \n",
"22 15.7 18.2 -2.5 \n",
"23 17.3 17.2 0.1 \n",
"24 17.2 17.8 -0.6 \n",
"25 17 18.2 -1.2 \n",
"26 17.2 18 -0.8 \n",
"27 17 17.9 -0.9 \n",
"28 16.4 16.6 -0.2 \n",
"29 16.7 17.2 -0.5 \n",
".. ... ... ... \n",
"57 17 20.7 -3.8 \n",
"58 17.5 20.3 -2.8 \n",
"59 17.8 20 -2.2 \n",
"60 18.2 19.6 -1.3 \n",
"61 18.6 18.9 -0.3 \n",
"62 19.2 18.5 0.8 \n",
"63 19.2 17.9 1.3 \n",
"64 20 17.6 2.3 \n",
"65 18.8 17.6 1.2 \n",
"66 17 18.5 -1.5 \n",
"67 15.7 19.1 -3.3 \n",
"68 15.6 19 -3.4 \n",
"69 16.7 19.2 -2.5 \n",
"70 17.6 19.4 -1.8 \n",
"71 17.9 19.1 -1.1 \n",
"72 17.1 20.2 -3.1 \n",
"73 14.6 24.4 -9.8 \n",
"74 14.6 23.4 -8.7 \n",
"75 15 23.4 -8.5 \n",
"76 15.3 22.1 -6.8 \n",
"77 16.8 20.9 -4.1 \n",
"78 17.5 20.4 -2.8 \n",
"79 18.2 20.6 -2.4 \n",
"80 17.8 20.9 -3.2 \n",
"81 18.1 21.2 -3.1 \n",
"82 18.3 20.5 -2.2 \n",
"83 18.2 20.7 -2.5 \n",
"84 18.1 20.3 -2.2 \n",
"85 18 20 -2 \n",
"86 18.1 19.9 -1.8 \n",
"\n",
"[87 rows x 11 columns]"
]
},
"execution_count": 37,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df"
]
},
{
"cell_type": "code",
"execution_count": 38,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style>\n",
" .dataframe thead tr:only-child th {\n",
" text-align: right;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Fiscal Year</th>\n",
" <th>Receipts</th>\n",
" <th>Outlays</th>\n",
" <th>Surplus or Deficit</th>\n",
" <th>CD Receipts</th>\n",
" <th>CD Outlays</th>\n",
" <th>CD Surplus or Deficit</th>\n",
" <th>Composite Deflator</th>\n",
" <th>GDP Receipts</th>\n",
" <th>GDP Outlays</th>\n",
" <th>GDP Surplus or Deficit</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>1940</td>\n",
" <td>6.5</td>\n",
" <td>9.5</td>\n",
" <td>-2.9</td>\n",
" <td>94</td>\n",
" <td>135.8</td>\n",
" <td>-41.9</td>\n",
" <td>0.0697</td>\n",
" <td>6.7</td>\n",
" <td>9.6</td>\n",
" <td>-3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>1941</td>\n",
" <td>8.7</td>\n",
" <td>13.7</td>\n",
" <td>-4.9</td>\n",
" <td>113.3</td>\n",
" <td>177.5</td>\n",
" <td>-64.3</td>\n",
" <td>0.0769</td>\n",
" <td>7.5</td>\n",
" <td>11.7</td>\n",
" <td>-4.3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>1942</td>\n",
" <td>14.6</td>\n",
" <td>35.1</td>\n",
" <td>-20.5</td>\n",
" <td>167.8</td>\n",
" <td>402.9</td>\n",
" <td>-235.1</td>\n",
" <td>0.0872</td>\n",
" <td>9.9</td>\n",
" <td>23.8</td>\n",
" <td>-13.9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>1943</td>\n",
" <td>24</td>\n",
" <td>78.6</td>\n",
" <td>-54.6</td>\n",
" <td>249</td>\n",
" <td>814.9</td>\n",
" <td>-565.9</td>\n",
" <td>0.0964</td>\n",
" <td>13</td>\n",
" <td>42.6</td>\n",
" <td>-29.6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>1944</td>\n",
" <td>43.7</td>\n",
" <td>91.3</td>\n",
" <td>-47.6</td>\n",
" <td>493.2</td>\n",
" <td>1029.4</td>\n",
" <td>-536.2</td>\n",
" <td>0.0887</td>\n",
" <td>20.5</td>\n",
" <td>42.7</td>\n",
" <td>-22.2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>1945</td>\n",
" <td>45.2</td>\n",
" <td>92.7</td>\n",
" <td>-47.6</td>\n",
" <td>541.5</td>\n",
" <td>1111.7</td>\n",
" <td>-570.2</td>\n",
" <td>0.0834</td>\n",
" <td>19.9</td>\n",
" <td>41</td>\n",
" <td>-21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>1946</td>\n",
" <td>39.3</td>\n",
" <td>55.2</td>\n",
" <td>-15.9</td>\n",
" <td>466.7</td>\n",
" <td>656</td>\n",
" <td>-189.3</td>\n",
" <td>0.0842</td>\n",
" <td>17.2</td>\n",
" <td>24.2</td>\n",
" <td>-7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>1947</td>\n",
" <td>38.5</td>\n",
" <td>34.5</td>\n",
" <td>4</td>\n",
" <td>402.9</td>\n",
" <td>360.8</td>\n",
" <td>42</td>\n",
" <td>0.0956</td>\n",
" <td>16.1</td>\n",
" <td>14.4</td>\n",
" <td>1.7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>1948</td>\n",
" <td>41.6</td>\n",
" <td>29.8</td>\n",
" <td>11.8</td>\n",
" <td>418.1</td>\n",
" <td>299.4</td>\n",
" <td>118.7</td>\n",
" <td>0.0994</td>\n",
" <td>15.8</td>\n",
" <td>11.3</td>\n",
" <td>4.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>1949</td>\n",
" <td>39.4</td>\n",
" <td>38.8</td>\n",
" <td>0.6</td>\n",
" <td>411.4</td>\n",
" <td>405.4</td>\n",
" <td>6.1</td>\n",
" <td>0.0958</td>\n",
" <td>14.2</td>\n",
" <td>14</td>\n",
" <td>0.2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>1950</td>\n",
" <td>39.4</td>\n",
" <td>42.6</td>\n",
" <td>-3.1</td>\n",
" <td>392.5</td>\n",
" <td>423.5</td>\n",
" <td>-31</td>\n",
" <td>0.1005</td>\n",
" <td>14.1</td>\n",
" <td>15.3</td>\n",
" <td>-1.1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>1951</td>\n",
" <td>51.6</td>\n",
" <td>45.5</td>\n",
" <td>6.1</td>\n",
" <td>511.6</td>\n",
" <td>451.1</td>\n",
" <td>60.5</td>\n",
" <td>0.1009</td>\n",
" <td>15.8</td>\n",
" <td>13.9</td>\n",
" <td>1.9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>1952</td>\n",
" <td>66.2</td>\n",
" <td>67.7</td>\n",
" <td>-1.5</td>\n",
" <td>657.7</td>\n",
" <td>672.8</td>\n",
" <td>-15.1</td>\n",
" <td>0.1006</td>\n",
" <td>18.5</td>\n",
" <td>18.9</td>\n",
" <td>-0.4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>1953</td>\n",
" <td>69.6</td>\n",
" <td>76.1</td>\n",
" <td>-6.5</td>\n",
" <td>644.5</td>\n",
" <td>704.6</td>\n",
" <td>-60.1</td>\n",
" <td>0.108</td>\n",
" <td>18.2</td>\n",
" <td>19.9</td>\n",
" <td>-1.7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>1954</td>\n",
" <td>69.7</td>\n",
" <td>70.9</td>\n",
" <td>-1.2</td>\n",
" <td>626.8</td>\n",
" <td>637.2</td>\n",
" <td>-10.4</td>\n",
" <td>0.1112</td>\n",
" <td>18</td>\n",
" <td>18.3</td>\n",
" <td>-0.3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>1955</td>\n",
" <td>65.5</td>\n",
" <td>68.4</td>\n",
" <td>-3</td>\n",
" <td>568.6</td>\n",
" <td>594.6</td>\n",
" <td>-26</td>\n",
" <td>0.1151</td>\n",
" <td>16.1</td>\n",
" <td>16.8</td>\n",
" <td>-0.7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>1956</td>\n",
" <td>74.6</td>\n",
" <td>70.6</td>\n",
" <td>3.9</td>\n",
" <td>620.5</td>\n",
" <td>587.7</td>\n",
" <td>32.8</td>\n",
" <td>0.1202</td>\n",
" <td>17</td>\n",
" <td>16.1</td>\n",
" <td>0.9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>1957</td>\n",
" <td>80</td>\n",
" <td>76.6</td>\n",
" <td>3.4</td>\n",
" <td>634.3</td>\n",
" <td>607.3</td>\n",
" <td>27.1</td>\n",
" <td>0.1261</td>\n",
" <td>17.2</td>\n",
" <td>16.5</td>\n",
" <td>0.7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>1958</td>\n",
" <td>79.6</td>\n",
" <td>82.4</td>\n",
" <td>-2.8</td>\n",
" <td>596.5</td>\n",
" <td>617.3</td>\n",
" <td>-20.7</td>\n",
" <td>0.1335</td>\n",
" <td>16.8</td>\n",
" <td>17.4</td>\n",
" <td>-0.6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>1959</td>\n",
" <td>79.2</td>\n",
" <td>92.1</td>\n",
" <td>-12.8</td>\n",
" <td>569.7</td>\n",
" <td>662.1</td>\n",
" <td>-92.4</td>\n",
" <td>0.1391</td>\n",
" <td>15.7</td>\n",
" <td>18.2</td>\n",
" <td>-2.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>1960</td>\n",
" <td>92.5</td>\n",
" <td>92.2</td>\n",
" <td>0.3</td>\n",
" <td>655.5</td>\n",
" <td>653.4</td>\n",
" <td>2.1</td>\n",
" <td>0.1411</td>\n",
" <td>17.3</td>\n",
" <td>17.2</td>\n",
" <td>0.1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>1961</td>\n",
" <td>94.4</td>\n",
" <td>97.7</td>\n",
" <td>-3.3</td>\n",
" <td>654.1</td>\n",
" <td>677.2</td>\n",
" <td>-23.1</td>\n",
" <td>0.1443</td>\n",
" <td>17.2</td>\n",
" <td>17.8</td>\n",
" <td>-0.6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>1962</td>\n",
" <td>99.7</td>\n",
" <td>106.8</td>\n",
" <td>-7.1</td>\n",
" <td>689.8</td>\n",
" <td>739.2</td>\n",
" <td>-49.5</td>\n",
" <td>0.1445</td>\n",
" <td>17</td>\n",
" <td>18.2</td>\n",
" <td>-1.2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>1963</td>\n",
" <td>106.6</td>\n",
" <td>111.3</td>\n",
" <td>-4.8</td>\n",
" <td>707.1</td>\n",
" <td>738.7</td>\n",
" <td>-31.6</td>\n",
" <td>0.1507</td>\n",
" <td>17.2</td>\n",
" <td>18</td>\n",
" <td>-0.8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>1964</td>\n",
" <td>112.6</td>\n",
" <td>118.5</td>\n",
" <td>-5.9</td>\n",
" <td>735.6</td>\n",
" <td>774.2</td>\n",
" <td>-38.6</td>\n",
" <td>0.1531</td>\n",
" <td>17</td>\n",
" <td>17.9</td>\n",
" <td>-0.9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>1965</td>\n",
" <td>116.8</td>\n",
" <td>118.2</td>\n",
" <td>-1.4</td>\n",
" <td>752.2</td>\n",
" <td>761.3</td>\n",
" <td>-9.1</td>\n",
" <td>0.1553</td>\n",
" <td>16.4</td>\n",
" <td>16.6</td>\n",
" <td>-0.2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>1966</td>\n",
" <td>130.8</td>\n",
" <td>134.5</td>\n",
" <td>-3.7</td>\n",
" <td>819.8</td>\n",
" <td>842.9</td>\n",
" <td>-23.2</td>\n",
" <td>0.1596</td>\n",
" <td>16.7</td>\n",
" <td>17.2</td>\n",
" <td>-0.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td>1967</td>\n",
" <td>148.8</td>\n",
" <td>157.5</td>\n",
" <td>-8.6</td>\n",
" <td>911.9</td>\n",
" <td>964.9</td>\n",
" <td>-53</td>\n",
" <td>0.1632</td>\n",
" <td>17.8</td>\n",
" <td>18.8</td>\n",
" <td>-1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td>1968</td>\n",
" <td>153</td>\n",
" <td>178.1</td>\n",
" <td>-25.2</td>\n",
" <td>904.6</td>\n",
" <td>1053.4</td>\n",
" <td>-148.8</td>\n",
" <td>0.1691</td>\n",
" <td>17</td>\n",
" <td>19.8</td>\n",
" <td>-2.8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td>1969</td>\n",
" <td>186.9</td>\n",
" <td>183.6</td>\n",
" <td>3.2</td>\n",
" <td>1039.4</td>\n",
" <td>1021.4</td>\n",
" <td>18</td>\n",
" <td>0.1798</td>\n",
" <td>19</td>\n",
" <td>18.7</td>\n",
" <td>0.3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>51</th>\n",
" <td>1987</td>\n",
" <td>854.3</td>\n",
" <td>1004</td>\n",
" <td>-149.7</td>\n",
" <td>1513.9</td>\n",
" <td>1779.2</td>\n",
" <td>-265.3</td>\n",
" <td>0.5643</td>\n",
" <td>17.9</td>\n",
" <td>21</td>\n",
" <td>-3.1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>52</th>\n",
" <td>1988</td>\n",
" <td>909.2</td>\n",
" <td>1064.4</td>\n",
" <td>-155.2</td>\n",
" <td>1558.2</td>\n",
" <td>1824.2</td>\n",
" <td>-265.9</td>\n",
" <td>0.5835</td>\n",
" <td>17.6</td>\n",
" <td>20.6</td>\n",
" <td>-3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>53</th>\n",
" <td>1989</td>\n",
" <td>991.1</td>\n",
" <td>1143.7</td>\n",
" <td>-152.6</td>\n",
" <td>1636</td>\n",
" <td>1888</td>\n",
" <td>-252</td>\n",
" <td>0.6058</td>\n",
" <td>17.8</td>\n",
" <td>20.5</td>\n",
" <td>-2.7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>54</th>\n",
" <td>1990</td>\n",
" <td>1032</td>\n",
" <td>1253</td>\n",
" <td>-221</td>\n",
" <td>1654.6</td>\n",
" <td>2009</td>\n",
" <td>-354.4</td>\n",
" <td>0.6237</td>\n",
" <td>17.4</td>\n",
" <td>21.2</td>\n",
" <td>-3.7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>55</th>\n",
" <td>1991</td>\n",
" <td>1055</td>\n",
" <td>1324.2</td>\n",
" <td>-269.2</td>\n",
" <td>1616.6</td>\n",
" <td>2029.2</td>\n",
" <td>-412.6</td>\n",
" <td>0.6526</td>\n",
" <td>17.3</td>\n",
" <td>21.7</td>\n",
" <td>-4.4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>56</th>\n",
" <td>1992</td>\n",
" <td>1091.2</td>\n",
" <td>1381.5</td>\n",
" <td>-290.3</td>\n",
" <td>1611.6</td>\n",
" <td>2040.4</td>\n",
" <td>-428.8</td>\n",
" <td>0.6771</td>\n",
" <td>17</td>\n",
" <td>21.5</td>\n",
" <td>-4.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>57</th>\n",
" <td>1993</td>\n",
" <td>1154.3</td>\n",
" <td>1409.4</td>\n",
" <td>-255.1</td>\n",
" <td>1655.7</td>\n",
" <td>2021.5</td>\n",
" <td>-365.8</td>\n",
" <td>0.6972</td>\n",
" <td>17</td>\n",
" <td>20.7</td>\n",
" <td>-3.8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>58</th>\n",
" <td>1994</td>\n",
" <td>1258.6</td>\n",
" <td>1461.8</td>\n",
" <td>-203.2</td>\n",
" <td>1772.6</td>\n",
" <td>2058.8</td>\n",
" <td>-286.2</td>\n",
" <td>0.71</td>\n",
" <td>17.5</td>\n",
" <td>20.3</td>\n",
" <td>-2.8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>59</th>\n",
" <td>1995</td>\n",
" <td>1351.8</td>\n",
" <td>1515.7</td>\n",
" <td>-164</td>\n",
" <td>1850.2</td>\n",
" <td>2074.7</td>\n",
" <td>-224.4</td>\n",
" <td>0.7306</td>\n",
" <td>17.8</td>\n",
" <td>20</td>\n",
" <td>-2.2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>60</th>\n",
" <td>1996</td>\n",
" <td>1453.1</td>\n",
" <td>1560.5</td>\n",
" <td>-107.4</td>\n",
" <td>1948.1</td>\n",
" <td>2092.1</td>\n",
" <td>-144</td>\n",
" <td>0.7459</td>\n",
" <td>18.2</td>\n",
" <td>19.6</td>\n",
" <td>-1.3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>61</th>\n",
" <td>1997</td>\n",
" <td>1579.2</td>\n",
" <td>1601.1</td>\n",
" <td>-21.9</td>\n",
" <td>2074.7</td>\n",
" <td>2103.4</td>\n",
" <td>-28.7</td>\n",
" <td>0.7612</td>\n",
" <td>18.6</td>\n",
" <td>18.9</td>\n",
" <td>-0.3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>62</th>\n",
" <td>1998</td>\n",
" <td>1721.7</td>\n",
" <td>1652.5</td>\n",
" <td>69.3</td>\n",
" <td>2242.1</td>\n",
" <td>2151.9</td>\n",
" <td>90.2</td>\n",
" <td>0.7679</td>\n",
" <td>19.2</td>\n",
" <td>18.5</td>\n",
" <td>0.8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>63</th>\n",
" <td>1999</td>\n",
" <td>1827.5</td>\n",
" <td>1701.8</td>\n",
" <td>125.6</td>\n",
" <td>2349.8</td>\n",
" <td>2188.3</td>\n",
" <td>161.5</td>\n",
" <td>0.7777</td>\n",
" <td>19.2</td>\n",
" <td>17.9</td>\n",
" <td>1.3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>64</th>\n",
" <td>2000</td>\n",
" <td>2025.2</td>\n",
" <td>1789</td>\n",
" <td>236.2</td>\n",
" <td>2541</td>\n",
" <td>2244.6</td>\n",
" <td>296.4</td>\n",
" <td>0.797</td>\n",
" <td>20</td>\n",
" <td>17.6</td>\n",
" <td>2.3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>65</th>\n",
" <td>2001</td>\n",
" <td>1991.1</td>\n",
" <td>1862.8</td>\n",
" <td>128.2</td>\n",
" <td>2433.2</td>\n",
" <td>2276.5</td>\n",
" <td>156.7</td>\n",
" <td>0.8183</td>\n",
" <td>18.8</td>\n",
" <td>17.6</td>\n",
" <td>1.2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>66</th>\n",
" <td>2002</td>\n",
" <td>1853.1</td>\n",
" <td>2010.9</td>\n",
" <td>-157.8</td>\n",
" <td>2227.6</td>\n",
" <td>2417.2</td>\n",
" <td>-189.6</td>\n",
" <td>0.8319</td>\n",
" <td>17</td>\n",
" <td>18.5</td>\n",
" <td>-1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>67</th>\n",
" <td>2003</td>\n",
" <td>1782.3</td>\n",
" <td>2159.9</td>\n",
" <td>-377.6</td>\n",
" <td>2083.6</td>\n",
" <td>2525</td>\n",
" <td>-441.4</td>\n",
" <td>0.8554</td>\n",
" <td>15.7</td>\n",
" <td>19.1</td>\n",
" <td>-3.3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>68</th>\n",
" <td>2004</td>\n",
" <td>1880.1</td>\n",
" <td>2292.8</td>\n",
" <td>-412.7</td>\n",
" <td>2141.8</td>\n",
" <td>2612</td>\n",
" <td>-470.2</td>\n",
" <td>0.8778</td>\n",
" <td>15.6</td>\n",
" <td>19</td>\n",
" <td>-3.4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>69</th>\n",
" <td>2005</td>\n",
" <td>2153.6</td>\n",
" <td>2472</td>\n",
" <td>-318.3</td>\n",
" <td>2371.6</td>\n",
" <td>2722.1</td>\n",
" <td>-350.6</td>\n",
" <td>0.9081</td>\n",
" <td>16.7</td>\n",
" <td>19.2</td>\n",
" <td>-2.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>70</th>\n",
" <td>2006</td>\n",
" <td>2406.9</td>\n",
" <td>2655</td>\n",
" <td>-248.2</td>\n",
" <td>2561.9</td>\n",
" <td>2826</td>\n",
" <td>-264.2</td>\n",
" <td>0.9395</td>\n",
" <td>17.6</td>\n",
" <td>19.4</td>\n",
" <td>-1.8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>71</th>\n",
" <td>2007</td>\n",
" <td>2568</td>\n",
" <td>2728.7</td>\n",
" <td>-160.7</td>\n",
" <td>2663.1</td>\n",
" <td>2829.7</td>\n",
" <td>-166.7</td>\n",
" <td>0.9643</td>\n",
" <td>17.9</td>\n",
" <td>19.1</td>\n",
" <td>-1.1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>72</th>\n",
" <td>2008</td>\n",
" <td>2524</td>\n",
" <td>2982.5</td>\n",
" <td>-458.6</td>\n",
" <td>2529</td>\n",
" <td>2988.5</td>\n",
" <td>-459.5</td>\n",
" <td>0.998</td>\n",
" <td>17.1</td>\n",
" <td>20.2</td>\n",
" <td>-3.1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>73</th>\n",
" <td>2009</td>\n",
" <td>2105</td>\n",
" <td>3517.7</td>\n",
" <td>-1412.7</td>\n",
" <td>2105</td>\n",
" <td>3517.7</td>\n",
" <td>-1412.7</td>\n",
" <td>1</td>\n",
" <td>14.6</td>\n",
" <td>24.4</td>\n",
" <td>-9.8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>74</th>\n",
" <td>2010</td>\n",
" <td>2162.7</td>\n",
" <td>3457.1</td>\n",
" <td>-1294.4</td>\n",
" <td>2129.3</td>\n",
" <td>3403.6</td>\n",
" <td>-1274.4</td>\n",
" <td>1.0157</td>\n",
" <td>14.6</td>\n",
" <td>23.4</td>\n",
" <td>-8.7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>75</th>\n",
" <td>2011</td>\n",
" <td>2303.5</td>\n",
" <td>3603.1</td>\n",
" <td>-1299.6</td>\n",
" <td>2215.9</td>\n",
" <td>3466.2</td>\n",
" <td>-1250.2</td>\n",
" <td>1.0395</td>\n",
" <td>15</td>\n",
" <td>23.4</td>\n",
" <td>-8.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>76</th>\n",
" <td>2012</td>\n",
" <td>2450</td>\n",
" <td>3536.9</td>\n",
" <td>-1087</td>\n",
" <td>2310.7</td>\n",
" <td>3335.8</td>\n",
" <td>-1025.1</td>\n",
" <td>1.0603</td>\n",
" <td>15.3</td>\n",
" <td>22.1</td>\n",
" <td>-6.8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>77</th>\n",
" <td>2013</td>\n",
" <td>2775.1</td>\n",
" <td>3454.6</td>\n",
" <td>-679.5</td>\n",
" <td>2583.9</td>\n",
" <td>3216.6</td>\n",
" <td>-632.7</td>\n",
" <td>1.074</td>\n",
" <td>16.8</td>\n",
" <td>20.9</td>\n",
" <td>-4.1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>78</th>\n",
" <td>2014</td>\n",
" <td>3021.5</td>\n",
" <td>3506.1</td>\n",
" <td>-484.6</td>\n",
" <td>2770.5</td>\n",
" <td>3214.8</td>\n",
" <td>-444.3</td>\n",
" <td>1.0906</td>\n",
" <td>17.5</td>\n",
" <td>20.4</td>\n",
" <td>-2.8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>79</th>\n",
" <td>2015</td>\n",
" <td>3249.9</td>\n",
" <td>3688.4</td>\n",
" <td>-438.5</td>\n",
" <td>2960.9</td>\n",
" <td>3360.4</td>\n",
" <td>-399.5</td>\n",
" <td>1.0976</td>\n",
" <td>18.2</td>\n",
" <td>20.6</td>\n",
" <td>-2.4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>80</th>\n",
" <td>2016</td>\n",
" <td>3268</td>\n",
" <td>3852.6</td>\n",
" <td>-584.7</td>\n",
" <td>2953.2</td>\n",
" <td>3481.5</td>\n",
" <td>-528.3</td>\n",
" <td>1.1066</td>\n",
" <td>17.8</td>\n",
" <td>20.9</td>\n",
" <td>-3.2</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>78 rows × 11 columns</p>\n",
"</div>"
],
"text/plain": [
" Fiscal Year Receipts Outlays Surplus or Deficit CD Receipts CD Outlays \\\n",
"3 1940 6.5 9.5 -2.9 94 135.8 \n",
"4 1941 8.7 13.7 -4.9 113.3 177.5 \n",
"5 1942 14.6 35.1 -20.5 167.8 402.9 \n",
"6 1943 24 78.6 -54.6 249 814.9 \n",
"7 1944 43.7 91.3 -47.6 493.2 1029.4 \n",
"8 1945 45.2 92.7 -47.6 541.5 1111.7 \n",
"9 1946 39.3 55.2 -15.9 466.7 656 \n",
"10 1947 38.5 34.5 4 402.9 360.8 \n",
"11 1948 41.6 29.8 11.8 418.1 299.4 \n",
"12 1949 39.4 38.8 0.6 411.4 405.4 \n",
"13 1950 39.4 42.6 -3.1 392.5 423.5 \n",
"14 1951 51.6 45.5 6.1 511.6 451.1 \n",
"15 1952 66.2 67.7 -1.5 657.7 672.8 \n",
"16 1953 69.6 76.1 -6.5 644.5 704.6 \n",
"17 1954 69.7 70.9 -1.2 626.8 637.2 \n",
"18 1955 65.5 68.4 -3 568.6 594.6 \n",
"19 1956 74.6 70.6 3.9 620.5 587.7 \n",
"20 1957 80 76.6 3.4 634.3 607.3 \n",
"21 1958 79.6 82.4 -2.8 596.5 617.3 \n",
"22 1959 79.2 92.1 -12.8 569.7 662.1 \n",
"23 1960 92.5 92.2 0.3 655.5 653.4 \n",
"24 1961 94.4 97.7 -3.3 654.1 677.2 \n",
"25 1962 99.7 106.8 -7.1 689.8 739.2 \n",
"26 1963 106.6 111.3 -4.8 707.1 738.7 \n",
"27 1964 112.6 118.5 -5.9 735.6 774.2 \n",
"28 1965 116.8 118.2 -1.4 752.2 761.3 \n",
"29 1966 130.8 134.5 -3.7 819.8 842.9 \n",
"30 1967 148.8 157.5 -8.6 911.9 964.9 \n",
"31 1968 153 178.1 -25.2 904.6 1053.4 \n",
"32 1969 186.9 183.6 3.2 1039.4 1021.4 \n",
".. ... ... ... ... ... ... \n",
"51 1987 854.3 1004 -149.7 1513.9 1779.2 \n",
"52 1988 909.2 1064.4 -155.2 1558.2 1824.2 \n",
"53 1989 991.1 1143.7 -152.6 1636 1888 \n",
"54 1990 1032 1253 -221 1654.6 2009 \n",
"55 1991 1055 1324.2 -269.2 1616.6 2029.2 \n",
"56 1992 1091.2 1381.5 -290.3 1611.6 2040.4 \n",
"57 1993 1154.3 1409.4 -255.1 1655.7 2021.5 \n",
"58 1994 1258.6 1461.8 -203.2 1772.6 2058.8 \n",
"59 1995 1351.8 1515.7 -164 1850.2 2074.7 \n",
"60 1996 1453.1 1560.5 -107.4 1948.1 2092.1 \n",
"61 1997 1579.2 1601.1 -21.9 2074.7 2103.4 \n",
"62 1998 1721.7 1652.5 69.3 2242.1 2151.9 \n",
"63 1999 1827.5 1701.8 125.6 2349.8 2188.3 \n",
"64 2000 2025.2 1789 236.2 2541 2244.6 \n",
"65 2001 1991.1 1862.8 128.2 2433.2 2276.5 \n",
"66 2002 1853.1 2010.9 -157.8 2227.6 2417.2 \n",
"67 2003 1782.3 2159.9 -377.6 2083.6 2525 \n",
"68 2004 1880.1 2292.8 -412.7 2141.8 2612 \n",
"69 2005 2153.6 2472 -318.3 2371.6 2722.1 \n",
"70 2006 2406.9 2655 -248.2 2561.9 2826 \n",
"71 2007 2568 2728.7 -160.7 2663.1 2829.7 \n",
"72 2008 2524 2982.5 -458.6 2529 2988.5 \n",
"73 2009 2105 3517.7 -1412.7 2105 3517.7 \n",
"74 2010 2162.7 3457.1 -1294.4 2129.3 3403.6 \n",
"75 2011 2303.5 3603.1 -1299.6 2215.9 3466.2 \n",
"76 2012 2450 3536.9 -1087 2310.7 3335.8 \n",
"77 2013 2775.1 3454.6 -679.5 2583.9 3216.6 \n",
"78 2014 3021.5 3506.1 -484.6 2770.5 3214.8 \n",
"79 2015 3249.9 3688.4 -438.5 2960.9 3360.4 \n",
"80 2016 3268 3852.6 -584.7 2953.2 3481.5 \n",
"\n",
" CD Surplus or Deficit Composite Deflator GDP Receipts GDP Outlays \\\n",
"3 -41.9 0.0697 6.7 9.6 \n",
"4 -64.3 0.0769 7.5 11.7 \n",
"5 -235.1 0.0872 9.9 23.8 \n",
"6 -565.9 0.0964 13 42.6 \n",
"7 -536.2 0.0887 20.5 42.7 \n",
"8 -570.2 0.0834 19.9 41 \n",
"9 -189.3 0.0842 17.2 24.2 \n",
"10 42 0.0956 16.1 14.4 \n",
"11 118.7 0.0994 15.8 11.3 \n",
"12 6.1 0.0958 14.2 14 \n",
"13 -31 0.1005 14.1 15.3 \n",
"14 60.5 0.1009 15.8 13.9 \n",
"15 -15.1 0.1006 18.5 18.9 \n",
"16 -60.1 0.108 18.2 19.9 \n",
"17 -10.4 0.1112 18 18.3 \n",
"18 -26 0.1151 16.1 16.8 \n",
"19 32.8 0.1202 17 16.1 \n",
"20 27.1 0.1261 17.2 16.5 \n",
"21 -20.7 0.1335 16.8 17.4 \n",
"22 -92.4 0.1391 15.7 18.2 \n",
"23 2.1 0.1411 17.3 17.2 \n",
"24 -23.1 0.1443 17.2 17.8 \n",
"25 -49.5 0.1445 17 18.2 \n",
"26 -31.6 0.1507 17.2 18 \n",
"27 -38.6 0.1531 17 17.9 \n",
"28 -9.1 0.1553 16.4 16.6 \n",
"29 -23.2 0.1596 16.7 17.2 \n",
"30 -53 0.1632 17.8 18.8 \n",
"31 -148.8 0.1691 17 19.8 \n",
"32 18 0.1798 19 18.7 \n",
".. ... ... ... ... \n",
"51 -265.3 0.5643 17.9 21 \n",
"52 -265.9 0.5835 17.6 20.6 \n",
"53 -252 0.6058 17.8 20.5 \n",
"54 -354.4 0.6237 17.4 21.2 \n",
"55 -412.6 0.6526 17.3 21.7 \n",
"56 -428.8 0.6771 17 21.5 \n",
"57 -365.8 0.6972 17 20.7 \n",
"58 -286.2 0.71 17.5 20.3 \n",
"59 -224.4 0.7306 17.8 20 \n",
"60 -144 0.7459 18.2 19.6 \n",
"61 -28.7 0.7612 18.6 18.9 \n",
"62 90.2 0.7679 19.2 18.5 \n",
"63 161.5 0.7777 19.2 17.9 \n",
"64 296.4 0.797 20 17.6 \n",
"65 156.7 0.8183 18.8 17.6 \n",
"66 -189.6 0.8319 17 18.5 \n",
"67 -441.4 0.8554 15.7 19.1 \n",
"68 -470.2 0.8778 15.6 19 \n",
"69 -350.6 0.9081 16.7 19.2 \n",
"70 -264.2 0.9395 17.6 19.4 \n",
"71 -166.7 0.9643 17.9 19.1 \n",
"72 -459.5 0.998 17.1 20.2 \n",
"73 -1412.7 1 14.6 24.4 \n",
"74 -1274.4 1.0157 14.6 23.4 \n",
"75 -1250.2 1.0395 15 23.4 \n",
"76 -1025.1 1.0603 15.3 22.1 \n",
"77 -632.7 1.074 16.8 20.9 \n",
"78 -444.3 1.0906 17.5 20.4 \n",
"79 -399.5 1.0976 18.2 20.6 \n",
"80 -528.3 1.1066 17.8 20.9 \n",
"\n",
" GDP Surplus or Deficit \n",
"3 -3 \n",
"4 -4.3 \n",
"5 -13.9 \n",
"6 -29.6 \n",
"7 -22.2 \n",
"8 -21 \n",
"9 -7 \n",
"10 1.7 \n",
"11 4.5 \n",
"12 0.2 \n",
"13 -1.1 \n",
"14 1.9 \n",
"15 -0.4 \n",
"16 -1.7 \n",
"17 -0.3 \n",
"18 -0.7 \n",
"19 0.9 \n",
"20 0.7 \n",
"21 -0.6 \n",
"22 -2.5 \n",
"23 0.1 \n",
"24 -0.6 \n",
"25 -1.2 \n",
"26 -0.8 \n",
"27 -0.9 \n",
"28 -0.2 \n",
"29 -0.5 \n",
"30 -1 \n",
"31 -2.8 \n",
"32 0.3 \n",
".. ... \n",
"51 -3.1 \n",
"52 -3 \n",
"53 -2.7 \n",
"54 -3.7 \n",
"55 -4.4 \n",
"56 -4.5 \n",
"57 -3.8 \n",
"58 -2.8 \n",
"59 -2.2 \n",
"60 -1.3 \n",
"61 -0.3 \n",
"62 0.8 \n",
"63 1.3 \n",
"64 2.3 \n",
"65 1.2 \n",
"66 -1.5 \n",
"67 -3.3 \n",
"68 -3.4 \n",
"69 -2.5 \n",
"70 -1.8 \n",
"71 -1.1 \n",
"72 -3.1 \n",
"73 -9.8 \n",
"74 -8.7 \n",
"75 -8.5 \n",
"76 -6.8 \n",
"77 -4.1 \n",
"78 -2.8 \n",
"79 -2.4 \n",
"80 -3.2 \n",
"\n",
"[78 rows x 11 columns]"
]
},
"execution_count": 38,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"tax = df[3:81]\n",
"tax"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"There is also a row where the Fiscal Year == 'TQ'. I don't understand what this is, so I'm going to omit it for now."
]
},
{
"cell_type": "code",
"execution_count": 39,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style>\n",
" .dataframe thead tr:only-child th {\n",
" text-align: right;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Fiscal Year</th>\n",
" <th>Receipts</th>\n",
" <th>Outlays</th>\n",
" <th>Surplus or Deficit</th>\n",
" <th>CD Receipts</th>\n",
" <th>CD Outlays</th>\n",
" <th>CD Surplus or Deficit</th>\n",
" <th>Composite Deflator</th>\n",
" <th>GDP Receipts</th>\n",
" <th>GDP Outlays</th>\n",
" <th>GDP Surplus or Deficit</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>40</th>\n",
" <td>TQ</td>\n",
" <td>81.2</td>\n",
" <td>96</td>\n",
" <td>-14.7</td>\n",
" <td>274.3</td>\n",
" <td>324.1</td>\n",
" <td>-49.8</td>\n",
" <td>0.2961</td>\n",
" <td>17.2</td>\n",
" <td>20.3</td>\n",
" <td>-3.1</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" Fiscal Year Receipts Outlays Surplus or Deficit CD Receipts CD Outlays \\\n",
"40 TQ 81.2 96 -14.7 274.3 324.1 \n",
"\n",
" CD Surplus or Deficit Composite Deflator GDP Receipts GDP Outlays \\\n",
"40 -49.8 0.2961 17.2 20.3 \n",
"\n",
" GDP Surplus or Deficit \n",
"40 -3.1 "
]
},
"execution_count": 39,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"tax[tax['Fiscal Year'] == 'TQ']"
]
},
{
"cell_type": "code",
"execution_count": 40,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"tax2 = tax.drop(tax[tax['Fiscal Year'] == 'TQ'].index)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Next, let's look at the data types. We need to coerce these to numbers from their current object type so that we can perform numerical computations on them."
]
},
{
"cell_type": "code",
"execution_count": 41,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"Fiscal Year object\n",
"Receipts object\n",
"Outlays object\n",
"Surplus or Deficit object\n",
"CD Receipts object\n",
"CD Outlays object\n",
"CD Surplus or Deficit object\n",
"Composite Deflator object\n",
"GDP Receipts object\n",
"GDP Outlays object\n",
"GDP Surplus or Deficit object\n",
"dtype: object"
]
},
"execution_count": 41,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"tax2.dtypes"
]
},
{
"cell_type": "code",
"execution_count": 42,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"for col in tax2.columns:\n",
" tax2[col] = pd.to_numeric(tax2[col])"
]
},
{
"cell_type": "code",
"execution_count": 43,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"Fiscal Year int64\n",
"Receipts float64\n",
"Outlays float64\n",
"Surplus or Deficit float64\n",
"CD Receipts float64\n",
"CD Outlays float64\n",
"CD Surplus or Deficit float64\n",
"Composite Deflator float64\n",
"GDP Receipts float64\n",
"GDP Outlays float64\n",
"GDP Surplus or Deficit float64\n",
"dtype: object"
]
},
"execution_count": 43,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"tax2.dtypes"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Plotting the data\n",
"\n",
"Now that we have the data in a form where we can directly visualize it, let's spend some time using the [Bokeh](http://bokeh.pydata.org/en/latest/) plotting library in Python to visualize the time series data. Here is a [good cheat sheet for Bokeh](https://s3.amazonaws.com/assets.datacamp.com/blog_assets/Python_Bokeh_Cheat_Sheet.pdf)."
]
},
{
"cell_type": "code",
"execution_count": 58,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <div class=\"bk-root\">\n",
" <a href=\"https://bokeh.pydata.org\" target=\"_blank\" class=\"bk-logo bk-logo-small bk-logo-notebook\"></a>\n",
" <span id=\"79f2fdb4-d047-4afc-a231-cef909e2255d\">Loading BokehJS ...</span>\n",
" </div>"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"application/javascript": [
"\n",
"(function(root) {\n",
" function now() {\n",
" return new Date();\n",
" }\n",
"\n",
" var force = true;\n",
"\n",
" if (typeof (root._bokeh_onload_callbacks) === \"undefined\" || force === true) {\n",
" root._bokeh_onload_callbacks = [];\n",
" root._bokeh_is_loading = undefined;\n",
" }\n",
"\n",
"\n",
" \n",
" if (typeof (root._bokeh_timeout) === \"undefined\" || force === true) {\n",
" root._bokeh_timeout = Date.now() + 5000;\n",
" root._bokeh_failed_load = false;\n",
" }\n",
"\n",
" var NB_LOAD_WARNING = {'data': {'text/html':\n",
" \"<div style='background-color: #fdd'>\\n\"+\n",
" \"<p>\\n\"+\n",
" \"BokehJS does not appear to have successfully loaded. If loading BokehJS from CDN, this \\n\"+\n",
" \"may be due to a slow or bad network connection. Possible fixes:\\n\"+\n",
" \"</p>\\n\"+\n",
" \"<ul>\\n\"+\n",
" \"<li>re-rerun `output_notebook()` to attempt to load from CDN again, or</li>\\n\"+\n",
" \"<li>use INLINE resources instead, as so:</li>\\n\"+\n",
" \"</ul>\\n\"+\n",
" \"<code>\\n\"+\n",
" \"from bokeh.resources import INLINE\\n\"+\n",
" \"output_notebook(resources=INLINE)\\n\"+\n",
" \"</code>\\n\"+\n",
" \"</div>\"}};\n",
"\n",
" function display_loaded() {\n",
" if (root.Bokeh !== undefined) {\n",
" var el = document.getElementById(\"79f2fdb4-d047-4afc-a231-cef909e2255d\");\n",
" if (el != null) {\n",
" el.textContent = \"BokehJS \" + Bokeh.version + \" successfully loaded.\";\n",
" }\n",
" } else if (Date.now() < root._bokeh_timeout) {\n",
" setTimeout(display_loaded, 100)\n",
" }\n",
" }\n",
"\n",
"\n",
" function run_callbacks() {\n",
" try {\n",
" root._bokeh_onload_callbacks.forEach(function(callback) { callback() });\n",
" }\n",
" finally {\n",
" delete root._bokeh_onload_callbacks\n",
" }\n",
" console.info(\"Bokeh: all callbacks have finished\");\n",
" }\n",
"\n",
" function load_libs(js_urls, callback) {\n",
" root._bokeh_onload_callbacks.push(callback);\n",
" if (root._bokeh_is_loading > 0) {\n",
" console.log(\"Bokeh: BokehJS is being loaded, scheduling callback at\", now());\n",
" return null;\n",
" }\n",
" if (js_urls == null || js_urls.length === 0) {\n",
" run_callbacks();\n",
" return null;\n",
" }\n",
" console.log(\"Bokeh: BokehJS not loaded, scheduling load and callback at\", now());\n",
" root._bokeh_is_loading = js_urls.length;\n",
" for (var i = 0; i < js_urls.length; i++) {\n",
" var url = js_urls[i];\n",
" var s = document.createElement('script');\n",
" s.src = url;\n",
" s.async = false;\n",
" s.onreadystatechange = s.onload = function() {\n",
" root._bokeh_is_loading--;\n",
" if (root._bokeh_is_loading === 0) {\n",
" console.log(\"Bokeh: all BokehJS libraries loaded\");\n",
" run_callbacks()\n",
" }\n",
" };\n",
" s.onerror = function() {\n",
" console.warn(\"failed to load library \" + url);\n",
" };\n",
" console.log(\"Bokeh: injecting script tag for BokehJS library: \", url);\n",
" document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
" }\n",
" };var element = document.getElementById(\"79f2fdb4-d047-4afc-a231-cef909e2255d\");\n",
" if (element == null) {\n",
" console.log(\"Bokeh: ERROR: autoload.js configured with elementid '79f2fdb4-d047-4afc-a231-cef909e2255d' but no matching script tag was found. \")\n",
" return false;\n",
" }\n",
"\n",
" var js_urls = [\"https://cdn.pydata.org/bokeh/release/bokeh-0.12.7.min.js\", \"https://cdn.pydata.org/bokeh/release/bokeh-widgets-0.12.7.min.js\", \"https://cdn.pydata.org/bokeh/release/bokeh-tables-0.12.7.min.js\", \"https://cdn.pydata.org/bokeh/release/bokeh-gl-0.12.7.min.js\"];\n",
"\n",
" var inline_js = [\n",
" function(Bokeh) {\n",
" Bokeh.set_log_level(\"info\");\n",
" },\n",
" \n",
" function(Bokeh) {\n",
" \n",
" },\n",
" \n",
" function(Bokeh) {\n",
" \n",
" document.getElementById(\"79f2fdb4-d047-4afc-a231-cef909e2255d\").textContent = \"BokehJS is loading...\";\n",
" },\n",
" function(Bokeh) {\n",
" console.log(\"Bokeh: injecting CSS: https://cdn.pydata.org/bokeh/release/bokeh-0.12.7.min.css\");\n",
" Bokeh.embed.inject_css(\"https://cdn.pydata.org/bokeh/release/bokeh-0.12.7.min.css\");\n",
" console.log(\"Bokeh: injecting CSS: https://cdn.pydata.org/bokeh/release/bokeh-widgets-0.12.7.min.css\");\n",
" Bokeh.embed.inject_css(\"https://cdn.pydata.org/bokeh/release/bokeh-widgets-0.12.7.min.css\");\n",
" console.log(\"Bokeh: injecting CSS: https://cdn.pydata.org/bokeh/release/bokeh-tables-0.12.7.min.css\");\n",
" Bokeh.embed.inject_css(\"https://cdn.pydata.org/bokeh/release/bokeh-tables-0.12.7.min.css\");\n",
" }\n",
" ];\n",
"\n",
" function run_inline_js() {\n",
" \n",
" if ((root.Bokeh !== undefined) || (force === true)) {\n",
" for (var i = 0; i < inline_js.length; i++) {\n",
" inline_js[i].call(root, root.Bokeh);\n",
" }if (force === true) {\n",
" display_loaded();\n",
" }} else if (Date.now() < root._bokeh_timeout) {\n",
" setTimeout(run_inline_js, 100);\n",
" } else if (!root._bokeh_failed_load) {\n",
" console.log(\"Bokeh: BokehJS failed to load within specified timeout.\");\n",
" root._bokeh_failed_load = true;\n",
" } else if (force !== true) {\n",
" var cell = $(document.getElementById(\"79f2fdb4-d047-4afc-a231-cef909e2255d\")).parents('.cell').data().cell;\n",
" cell.output_area.append_execute_result(NB_LOAD_WARNING)\n",
" }\n",
"\n",
" }\n",
"\n",
" if (root._bokeh_is_loading === 0) {\n",
" console.log(\"Bokeh: BokehJS loaded, going straight to plotting\");\n",
" run_inline_js();\n",
" } else {\n",
" load_libs(js_urls, function() {\n",
" console.log(\"Bokeh: BokehJS plotting callback run at\", now());\n",
" run_inline_js();\n",
" });\n",
" }\n",
"}(window));"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"from bokeh.plotting import figure, show\n",
"from bokeh.models import Legend\n",
"from bokeh.io import output_notebook\n",
"output_notebook()"
]
},
{
"cell_type": "code",
"execution_count": 72,
"metadata": {},
"outputs": [],
"source": [
"fig = figure(\n",
" x_axis_label=\"Fiscal Year\", \n",
" y_axis_label=\"Constant FY2009 Dollars (Billions)\", \n",
" title=\"Historical US Federal Government Receipts, Outlays and Surplus or Deficit\",\n",
" plot_width = 800,\n",
" toolbar_location = None)\n"
]
},
{
"cell_type": "code",
"execution_count": 74,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
" <div class=\"bk-root\">\n",
" <div class=\"bk-plotdiv\" id=\"a08d4626-e6d6-4811-b703-e81e0c6dc463\"></div>\n",
" </div>\n",
"<script type=\"text/javascript\">\n",
" \n",
" (function(root) {\n",
" function now() {\n",
" return new Date();\n",
" }\n",
" \n",
" var force = false;\n",
" \n",
" if (typeof (root._bokeh_onload_callbacks) === \"undefined\" || force === true) {\n",
" root._bokeh_onload_callbacks = [];\n",
" root._bokeh_is_loading = undefined;\n",
" }\n",
" \n",
" \n",
" \n",
" if (typeof (root._bokeh_timeout) === \"undefined\" || force === true) {\n",
" root._bokeh_timeout = Date.now() + 0;\n",
" root._bokeh_failed_load = false;\n",
" }\n",
" \n",
" var NB_LOAD_WARNING = {'data': {'text/html':\n",
" \"<div style='background-color: #fdd'>\\n\"+\n",
" \"<p>\\n\"+\n",
" \"BokehJS does not appear to have successfully loaded. If loading BokehJS from CDN, this \\n\"+\n",
" \"may be due to a slow or bad network connection. Possible fixes:\\n\"+\n",
" \"</p>\\n\"+\n",
" \"<ul>\\n\"+\n",
" \"<li>re-rerun `output_notebook()` to attempt to load from CDN again, or</li>\\n\"+\n",
" \"<li>use INLINE resources instead, as so:</li>\\n\"+\n",
" \"</ul>\\n\"+\n",
" \"<code>\\n\"+\n",
" \"from bokeh.resources import INLINE\\n\"+\n",
" \"output_notebook(resources=INLINE)\\n\"+\n",
" \"</code>\\n\"+\n",
" \"</div>\"}};\n",
" \n",
" function display_loaded() {\n",
" if (root.Bokeh !== undefined) {\n",
" var el = document.getElementById(\"a08d4626-e6d6-4811-b703-e81e0c6dc463\");\n",
" if (el != null) {\n",
" el.textContent = \"BokehJS \" + Bokeh.version + \" successfully loaded.\";\n",
" }\n",
" } else if (Date.now() < root._bokeh_timeout) {\n",
" setTimeout(display_loaded, 100)\n",
" }\n",
" }\n",
" \n",
" \n",
" function run_callbacks() {\n",
" try {\n",
" root._bokeh_onload_callbacks.forEach(function(callback) { callback() });\n",
" }\n",
" finally {\n",
" delete root._bokeh_onload_callbacks\n",
" }\n",
" console.info(\"Bokeh: all callbacks have finished\");\n",
" }\n",
" \n",
" function load_libs(js_urls, callback) {\n",
" root._bokeh_onload_callbacks.push(callback);\n",
" if (root._bokeh_is_loading > 0) {\n",
" console.log(\"Bokeh: BokehJS is being loaded, scheduling callback at\", now());\n",
" return null;\n",
" }\n",
" if (js_urls == null || js_urls.length === 0) {\n",
" run_callbacks();\n",
" return null;\n",
" }\n",
" console.log(\"Bokeh: BokehJS not loaded, scheduling load and callback at\", now());\n",
" root._bokeh_is_loading = js_urls.length;\n",
" for (var i = 0; i < js_urls.length; i++) {\n",
" var url = js_urls[i];\n",
" var s = document.createElement('script');\n",
" s.src = url;\n",
" s.async = false;\n",
" s.onreadystatechange = s.onload = function() {\n",
" root._bokeh_is_loading--;\n",
" if (root._bokeh_is_loading === 0) {\n",
" console.log(\"Bokeh: all BokehJS libraries loaded\");\n",
" run_callbacks()\n",
" }\n",
" };\n",
" s.onerror = function() {\n",
" console.warn(\"failed to load library \" + url);\n",
" };\n",
" console.log(\"Bokeh: injecting script tag for BokehJS library: \", url);\n",
" document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
" }\n",
" };var element = document.getElementById(\"a08d4626-e6d6-4811-b703-e81e0c6dc463\");\n",
" if (element == null) {\n",
" console.log(\"Bokeh: ERROR: autoload.js configured with elementid 'a08d4626-e6d6-4811-b703-e81e0c6dc463' but no matching script tag was found. \")\n",
" return false;\n",
" }\n",
" \n",
" var js_urls = [];\n",
" \n",
" var inline_js = [\n",
" function(Bokeh) {\n",
" (function() {\n",
" var fn = function() {\n",
" var docs_json = {\"5f458e6e-d2f5-4e49-bd4d-7a849004cdb5\":{\"roots\":{\"references\":[{\"attributes\":{\"callback\":null,\"column_names\":[\"x\",\"y\"],\"data\":{\"x\":[1940,1941,1942,1943,1944,1945,1946,1947,1948,1949,1950,1951,1952,1953,1954,1955,1956,1957,1958,1959,1960,1961,1962,1963,1964,1965,1966,1967,1968,1969,1970,1971,1972,1973,1974,1975,1976,1977,1978,1979,1980,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016],\"y\":{\"__ndarray__\":\"AAAAAACAV0AzMzMzM1NcQJqZmZmZ+WRAAAAAAAAgb0AzMzMzM9N+QAAAAAAA7IBAMzMzMzMrfUBmZmZmZi55QJqZmZmZIXpAZmZmZma2eUAAAAAAAIh4QJqZmZmZ+X9AmpmZmZmNhEAAAAAAACSEQGZmZmZmloNAzczMzMzEgUAAAAAAAGSDQGZmZmZm0oNAAAAAAACkgkCamZmZmc2BQAAAAAAAfIRAzczMzMxwhEBmZmZmZo6FQM3MzMzMGIZAzczMzMz8hkCamZmZmYGHQGZmZmZmnolAMzMzMzN/jEDNzMzMzESMQJqZmZmZPZBAZmZmZma6j0AzMzMzM8+MQAAAAAAA7I1AAAAAAADUj0BmZmZmZsKQQGZmZmZmLpBAZmZmZmYgkEDNzMzMzO6RQM3MzMzM9pJAZmZmZmY+lEAzMzMzM3OUQDMzMzMzU5VAAAAAAABylEAAAAAAAO6SQGZmZmZmFpRAmpmZmZlZlUAAAAAAAOiVQJqZmZmZp5dAzczMzMxYmEAAAAAAAJCZQGZmZmZm2plAZmZmZmZCmUBmZmZmZi6ZQM3MzMzM3plAZmZmZmaym0DNzMzMzOicQGZmZmZmcJ5AZmZmZmY1oEAzMzMzM4ShQJqZmZmZW6JAAAAAAADao0BmZmZmZgKjQDMzMzMzZ6FAMzMzMzNHoECamZmZmbugQDMzMzMzh6JAzczMzMwDpEAzMzMzM86kQAAAAAAAwqNAAAAAAAByoECamZmZmaKgQM3MzMzMT6FAZmZmZmYNokDNzMzMzC+kQAAAAAAApaVAzczMzMwhp0BmZmZmZhKnQA==\",\"dtype\":\"float64\",\"shape\":[77]}}},\"id\":\"7157799c-3caf-4bd2-a635-cf9a29be93cf\",\"type\":\"ColumnDataSource\"},{\"attributes\":{\"source\":{\"id\":\"1f883965-4124-4eff-87a0-1cb8360f0323\",\"type\":\"ColumnDataSource\"}},\"id\":\"8f882343-9350-4ab5-a821-2544f51dca8c\",\"type\":\"CDSView\"},{\"attributes\":{\"callback\":null,\"column_names\":[\"x\",\"y\"],\"data\":{\"x\":[1940,1941,1942,1943,1944,1945,1946,1947,1948,1949,1950,1951,1952,1953,1954,1955,1956,1957,1958,1959,1960,1961,1962,1963,1964,1965,1966,1967,1968,1969,1970,1971,1972,1973,1974,1975,1976,1977,1978,1979,1980,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016],\"y\":{\"__ndarray__\":\"mpmZmZn5YEAAAAAAADBmQGZmZmZmLnlAMzMzMzN3iUCamZmZmRWQQM3MzMzMXpFAAAAAAACAhEDNzMzMzIx2QGZmZmZmtnJAZmZmZmZWeUAAAAAAAHh6QJqZmZmZMXxAZmZmZmYGhUDNzMzMzASGQJqZmZmZ6YNAzczMzMyUgkCamZmZmV2CQGZmZmZm+oJAZmZmZmZKg0DNzMzMzLCEQDMzMzMza4RAmpmZmZkphUCamZmZmRmHQJqZmZmZFYdAmpmZmZkxiEBmZmZmZsqHQDMzMzMzV4pAMzMzMzMnjkCamZmZmXWQQDMzMzMz649AMzMzMzMZkEAzMzMzMy2QQAAAAAAAppBAMzMzMzPxkEBmZmZmZiaRQGZmZmZmRJNAmpmZmZkdlECamZmZmaOUQAAAAAAAxpVAAAAAAAAGlkDNzMzMzF6XQGZmZmZmIphAZmZmZmaumEAzMzMzM3uZQGZmZmZmrJlAZmZmZmaGm0AzMzMzMzWcQM3MzMzMzJtAzczMzMyAnEAAAAAAAICdQAAAAAAAZJ9AzczMzMy0n0CamZmZmeGfQAAAAAAAlp9AmpmZmZkVoEBmZmZmZjWgQDMzMzMzWKBAzczMzMxuoEDNzMzMzM+gQJqZmZmZGKFAMzMzMzOJoUAAAAAAAMmhQGZmZmZm4qJAAAAAAAC6o0AAAAAAAGikQDMzMzMzRKVAAAAAAAAUpkBmZmZmZhumQAAAAAAAWadAZmZmZmZ7q0AzMzMzM5eqQGZmZmZmFKtAmpmZmZkPqkAzMzMzMyGpQJqZmZmZHalAzczMzMxAqkAAAAAAADOrQA==\",\"dtype\":\"float64\",\"shape\":[77]}}},\"id\":\"82387aca-9209-4381-b566-d0f317f0c416\",\"type\":\"ColumnDataSource\"},{\"attributes\":{\"line_alpha\":{\"value\":0.1},\"line_color\":{\"value\":\"#1f77b4\"},\"x\":{\"field\":\"x\"},\"y\":{\"field\":\"y\"}},\"id\":\"e381cfaa-05ef-4758-a9c8-c68ac689149c\",\"type\":\"Line\"},{\"attributes\":{},\"id\":\"3e711ba8-3a9e-4e9a-96b7-65ebe7afbbfd\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{\"line_color\":{\"value\":\"Red\"},\"x\":{\"field\":\"x\"},\"y\":{\"field\":\"y\"}},\"id\":\"f2155893-0161-4fcd-9872-319c50309601\",\"type\":\"Line\"},{\"attributes\":{\"bottom_units\":\"screen\",\"fill_alpha\":{\"value\":0.5},\"fill_color\":{\"value\":\"lightgrey\"},\"left_units\":\"screen\",\"level\":\"overlay\",\"line_alpha\":{\"value\":1.0},\"line_color\":{\"value\":\"black\"},\"line_dash\":[4,4],\"line_width\":{\"value\":2},\"plot\":null,\"render_mode\":\"css\",\"right_units\":\"screen\",\"top_units\":\"screen\"},\"id\":\"37edf68b-83d6-4d4c-930d-4f48f68cb728\",\"type\":\"BoxAnnotation\"},{\"attributes\":{\"line_color\":{\"value\":\"Green\"},\"x\":{\"field\":\"x\"},\"y\":{\"field\":\"y\"}},\"id\":\"5f094f8d-5c87-4faf-ac58-d562d08b6530\",\"type\":\"Line\"},{\"attributes\":{\"line_color\":{\"value\":\"Green\"},\"x\":{\"field\":\"x\"},\"y\":{\"field\":\"y\"}},\"id\":\"0acc0de2-f6c6-44e5-ab73-1667524d07bb\",\"type\":\"Line\"},{\"attributes\":{\"line_alpha\":{\"value\":0.1},\"line_color\":{\"value\":\"#1f77b4\"},\"x\":{\"field\":\"x\"},\"y\":{\"field\":\"y\"}},\"id\":\"24cace50-8cfc-42fb-abfd-f8091e175d63\",\"type\":\"Line\"},{\"attributes\":{},\"id\":\"1c4f46cf-8083-4805-a08f-5ea3e2d8958a\",\"type\":\"PanTool\"},{\"attributes\":{\"line_alpha\":{\"value\":0.1},\"line_color\":{\"value\":\"#1f77b4\"},\"x\":{\"field\":\"x\"},\"y\":{\"field\":\"y\"}},\"id\":\"fe95878b-79ef-4f19-a0f0-c9d3c9535b87\",\"type\":\"Line\"},{\"attributes\":{\"data_source\":{\"id\":\"aaa11924-4066-4b5d-a0bd-098096c5e608\",\"type\":\"ColumnDataSource\"},\"glyph\":{\"id\":\"0acc0de2-f6c6-44e5-ab73-1667524d07bb\",\"type\":\"Line\"},\"hover_glyph\":null,\"muted_glyph\":null,\"nonselection_glyph\":{\"id\":\"24cace50-8cfc-42fb-abfd-f8091e175d63\",\"type\":\"Line\"},\"selection_glyph\":null,\"view\":{\"id\":\"aa849e71-e0ad-4ce2-8b61-c413d7ef0ccf\",\"type\":\"CDSView\"}},\"id\":\"fe71beef-273b-4401-9bd5-8c4e87944d40\",\"type\":\"GlyphRenderer\"},{\"attributes\":{\"data_source\":{\"id\":\"7157799c-3caf-4bd2-a635-cf9a29be93cf\",\"type\":\"ColumnDataSource\"},\"glyph\":{\"id\":\"5f094f8d-5c87-4faf-ac58-d562d08b6530\",\"type\":\"Line\"},\"hover_glyph\":null,\"muted_glyph\":null,\"nonselection_glyph\":{\"id\":\"fe95878b-79ef-4f19-a0f0-c9d3c9535b87\",\"type\":\"Line\"},\"selection_glyph\":null,\"view\":{\"id\":\"6222cd76-9a51-4459-92a0-de42d485b03e\",\"type\":\"CDSView\"}},\"id\":\"bf1efee2-65d5-4432-b72e-42720d98e2b2\",\"type\":\"GlyphRenderer\"},{\"attributes\":{\"source\":{\"id\":\"aaa11924-4066-4b5d-a0bd-098096c5e608\",\"type\":\"ColumnDataSource\"}},\"id\":\"aa849e71-e0ad-4ce2-8b61-c413d7ef0ccf\",\"type\":\"CDSView\"},{\"attributes\":{},\"id\":\"63166b60-0e53-4295-865d-c38a526ab487\",\"type\":\"WheelZoomTool\"},{\"attributes\":{\"source\":{\"id\":\"7157799c-3caf-4bd2-a635-cf9a29be93cf\",\"type\":\"ColumnDataSource\"}},\"id\":\"6222cd76-9a51-4459-92a0-de42d485b03e\",\"type\":\"CDSView\"},{\"attributes\":{\"line_alpha\":{\"value\":0.1},\"line_color\":{\"value\":\"#1f77b4\"},\"x\":{\"field\":\"x\"},\"y\":{\"field\":\"y\"}},\"id\":\"909dc845-d10a-4ad4-9843-8599adc22a5d\",\"type\":\"Line\"},{\"attributes\":{\"data_source\":{\"id\":\"1f883965-4124-4eff-87a0-1cb8360f0323\",\"type\":\"ColumnDataSource\"},\"glyph\":{\"id\":\"042fd9c6-18bb-4136-81a8-d2b27fb162f2\",\"type\":\"Line\"},\"hover_glyph\":null,\"muted_glyph\":null,\"nonselection_glyph\":{\"id\":\"83dcc98e-140f-465a-b06c-3647dbfe3f27\",\"type\":\"Line\"},\"selection_glyph\":null,\"view\":{\"id\":\"8f882343-9350-4ab5-a821-2544f51dca8c\",\"type\":\"CDSView\"}},\"id\":\"e59a1788-f99c-414f-a220-088cbbeb343e\",\"type\":\"GlyphRenderer\"},{\"attributes\":{\"overlay\":{\"id\":\"37edf68b-83d6-4d4c-930d-4f48f68cb728\",\"type\":\"BoxAnnotation\"}},\"id\":\"fb41f431-4497-4dab-a581-69a32ed7a8ef\",\"type\":\"BoxZoomTool\"},{\"attributes\":{},\"id\":\"6850f547-d9a5-496f-9bf4-7df0625b083e\",\"type\":\"SaveTool\"},{\"attributes\":{},\"id\":\"ca64521d-c4d8-433a-a552-5438aa0c0ad8\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{},\"id\":\"60bac286-6c48-4de2-b70a-3a50ca17703e\",\"type\":\"ResetTool\"},{\"attributes\":{\"callback\":null,\"column_names\":[\"x\",\"y\"],\"data\":{\"x\":[1940,1941,1942,1943,1944,1945,1946,1947,1948,1949,1950,1951,1952,1953,1954,1955,1956,1957,1958,1959,1960,1961,1962,1963,1964,1965,1966,1967,1968,1969,1970,1971,1972,1973,1974,1975,1976,1977,1978,1979,1980,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016],\"y\":{\"__ndarray__\":\"MzMzMzPzRMAzMzMzMxNQwDMzMzMzY23AMzMzMzOvgcCamZmZmcGAwJqZmZmZ0YHAmpmZmZmpZ8AAAAAAAABFQM3MzMzMrF1AZmZmZmZmGEAAAAAAAAA/wAAAAAAAQE5AMzMzMzMzLsDNzMzMzAxOwM3MzMzMzCTAAAAAAAAAOsBmZmZmZmZAQJqZmZmZGTtAMzMzMzOzNMCamZmZmRlXwM3MzMzMzABAmpmZmZkZN8AAAAAAAMBIwJqZmZmZmT/AzczMzMxMQ8AzMzMzMzMiwDMzMzMzMzfAAAAAAACASsCamZmZmZliwAAAAAAAADJAAAAAAAAALsAAAAAAAGBcwAAAAAAAAFvAMzMzMzNzUMAAAAAAAAA5wDMzMzMzs2jAmpmZmZnpb8BmZmZmZqZlwJqZmZmZeWbAmpmZmZl5XMDNzMzMzFxnwJqZmZmZeWbAmpmZmZnxcMAzMzMzMzN6wJqZmZmZWXbAMzMzMzOzeMDNzMzMzDR5wM3MzMzMlHDAZmZmZmaecMAAAAAAAIBvwGZmZmZmJnbAmpmZmZnJecDNzMzMzMx6wM3MzMzM3HbAMzMzMzPjccDNzMzMzAxswAAAAAAAAGLAMzMzMzOzPMDNzMzMzIxWQAAAAAAAMGRAZmZmZmaGckBmZmZmZpZjQDMzMzMzs2fAZmZmZmaWe8AzMzMzM2N9wJqZmZmZ6XXAMzMzMzODcMBmZmZmZtZkwAAAAAAAuHzAzczMzMwSlsCamZmZmemTwM3MzMzMiJPAZmZmZmYEkMCamZmZmcWDwM3MzMzMxHvAAAAAAAD4eMBmZmZmZoKAwA==\",\"dtype\":\"float64\",\"shape\":[77]}}},\"id\":\"1f883965-4124-4eff-87a0-1cb8360f0323\",\"type\":\"ColumnDataSource\"},{\"attributes\":{},\"id\":\"c332193a-1896-4c65-8c07-e053e5b1843c\",\"type\":\"HelpTool\"},{\"attributes\":{\"line_color\":{\"value\":\"Black\"},\"x\":{\"field\":\"x\"},\"y\":{\"field\":\"y\"}},\"id\":\"15cdc2dc-0e59-4f0f-89a5-bc707d5f562d\",\"type\":\"Line\"},{\"attributes\":{\"line_color\":{\"value\":\"Black\"},\"x\":{\"field\":\"x\"},\"y\":{\"field\":\"y\"}},\"id\":\"042fd9c6-18bb-4136-81a8-d2b27fb162f2\",\"type\":\"Line\"},{\"attributes\":{\"line_color\":{\"value\":\"Red\"},\"x\":{\"field\":\"x\"},\"y\":{\"field\":\"y\"}},\"id\":\"538626e3-c428-49e5-be9c-7f25a5c8b0ea\",\"type\":\"Line\"},{\"attributes\":{\"axis_label\":\"Fiscal Year\",\"formatter\":{\"id\":\"ca64521d-c4d8-433a-a552-5438aa0c0ad8\",\"type\":\"BasicTickFormatter\"},\"plot\":{\"id\":\"0b084532-3463-449c-bb9e-7343886f1937\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"ticker\":{\"id\":\"e791d0c3-5725-45ad-ae92-1e7396fe4f4c\",\"type\":\"BasicTicker\"}},\"id\":\"f2f87c8c-6587-4930-b1a1-73b97c3601f5\",\"type\":\"LinearAxis\"},{\"attributes\":{\"plot\":{\"id\":\"0b084532-3463-449c-bb9e-7343886f1937\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"ticker\":{\"id\":\"e791d0c3-5725-45ad-ae92-1e7396fe4f4c\",\"type\":\"BasicTicker\"}},\"id\":\"7b0fa212-13c7-4a3c-97f0-182047635b2a\",\"type\":\"Grid\"},{\"attributes\":{\"data_source\":{\"id\":\"3910575a-1909-4e2c-ae25-3898ddb7b354\",\"type\":\"ColumnDataSource\"},\"glyph\":{\"id\":\"15cdc2dc-0e59-4f0f-89a5-bc707d5f562d\",\"type\":\"Line\"},\"hover_glyph\":null,\"muted_glyph\":null,\"nonselection_glyph\":{\"id\":\"e381cfaa-05ef-4758-a9c8-c68ac689149c\",\"type\":\"Line\"},\"selection_glyph\":null,\"view\":{\"id\":\"cebd8ffa-3e04-4446-8505-0963190c5939\",\"type\":\"CDSView\"}},\"id\":\"17be84b7-2fb1-4f7d-996f-6444fa054a09\",\"type\":\"GlyphRenderer\"},{\"attributes\":{\"data_source\":{\"id\":\"82387aca-9209-4381-b566-d0f317f0c416\",\"type\":\"ColumnDataSource\"},\"glyph\":{\"id\":\"f2155893-0161-4fcd-9872-319c50309601\",\"type\":\"Line\"},\"hover_glyph\":null,\"muted_glyph\":null,\"nonselection_glyph\":{\"id\":\"a4f631e7-2b04-4d31-8e44-f8d954f6c07b\",\"type\":\"Line\"},\"selection_glyph\":null,\"view\":{\"id\":\"0778f582-c0be-4667-942c-eb6cdf4cc10c\",\"type\":\"CDSView\"}},\"id\":\"8e57c3f2-11b4-4957-bc65-c3730ab0aca6\",\"type\":\"GlyphRenderer\"},{\"attributes\":{},\"id\":\"4b89254b-930b-43bf-9315-f2d8eb0777b0\",\"type\":\"LinearScale\"},{\"attributes\":{\"data_source\":{\"id\":\"4f37478b-ceac-420f-8be5-ea7aeeb69399\",\"type\":\"ColumnDataSource\"},\"glyph\":{\"id\":\"538626e3-c428-49e5-be9c-7f25a5c8b0ea\",\"type\":\"Line\"},\"hover_glyph\":null,\"muted_glyph\":null,\"nonselection_glyph\":{\"id\":\"909dc845-d10a-4ad4-9843-8599adc22a5d\",\"type\":\"Line\"},\"selection_glyph\":null,\"view\":{\"id\":\"182b0912-58d5-4da6-a1f1-0f54e53927fc\",\"type\":\"CDSView\"}},\"id\":\"24e50d35-e5cb-4e18-9a87-579d92874d78\",\"type\":\"GlyphRenderer\"},{\"attributes\":{\"callback\":null,\"column_names\":[\"x\",\"y\"],\"data\":{\"x\":[1940,1941,1942,1943,1944,1945,1946,1947,1948,1949,1950,1951,1952,1953,1954,1955,1956,1957,1958,1959,1960,1961,1962,1963,1964,1965,1966,1967,1968,1969,1970,1971,1972,1973,1974,1975,1976,1977,1978,1979,1980,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016],\"y\":{\"__ndarray__\":\"mpmZmZn5YEAAAAAAADBmQGZmZmZmLnlAMzMzMzN3iUCamZmZmRWQQM3MzMzMXpFAAAAAAACAhEDNzMzMzIx2QGZmZmZmtnJAZmZmZmZWeUAAAAAAAHh6QJqZmZmZMXxAZmZmZmYGhUDNzMzMzASGQJqZmZmZ6YNAzczMzMyUgkCamZmZmV2CQGZmZmZm+oJAZmZmZmZKg0DNzMzMzLCEQDMzMzMza4RAmpmZmZkphUCamZmZmRmHQJqZmZmZFYdAmpmZmZkxiEBmZmZmZsqHQDMzMzMzV4pAMzMzMzMnjkCamZmZmXWQQDMzMzMz649AMzMzMzMZkEAzMzMzMy2QQAAAAAAAppBAMzMzMzPxkEBmZmZmZiaRQGZmZmZmRJNAmpmZmZkdlECamZmZmaOUQAAAAAAAxpVAAAAAAAAGlkDNzMzMzF6XQGZmZmZmIphAZmZmZmaumEAzMzMzM3uZQGZmZmZmrJlAZmZmZmaGm0AzMzMzMzWcQM3MzMzMzJtAzczMzMyAnEAAAAAAAICdQAAAAAAAZJ9AzczMzMy0n0CamZmZmeGfQAAAAAAAlp9AmpmZmZkVoEBmZmZmZjWgQDMzMzMzWKBAzczMzMxuoEDNzMzMzM+gQJqZmZmZGKFAMzMzMzOJoUAAAAAAAMmhQGZmZmZm4qJAAAAAAAC6o0AAAAAAAGikQDMzMzMzRKVAAAAAAAAUpkBmZmZmZhumQAAAAAAAWadAZmZmZmZ7q0AzMzMzM5eqQGZmZmZmFKtAmpmZmZkPqkAzMzMzMyGpQJqZmZmZHalAzczMzMxAqkAAAAAAADOrQA==\",\"dtype\":\"float64\",\"shape\":[77]}}},\"id\":\"4f37478b-ceac-420f-8be5-ea7aeeb69399\",\"type\":\"ColumnDataSource\"},{\"attributes\":{\"items\":[{\"id\":\"2ab28216-cc92-4cec-8e64-cbb4e4a27bb5\",\"type\":\"LegendItem\"},{\"id\":\"2c4e5251-60cc-4fea-a4d6-0511377e18a0\",\"type\":\"LegendItem\"},{\"id\":\"7cb1c3d1-a284-4ab2-809c-74acaef4a040\",\"type\":\"LegendItem\"}],\"plot\":{\"id\":\"0b084532-3463-449c-bb9e-7343886f1937\",\"subtype\":\"Figure\",\"type\":\"Plot\"}},\"id\":\"cccb1263-e756-4f66-b00b-c1b74e24f862\",\"type\":\"Legend\"},{\"attributes\":{\"source\":{\"id\":\"4f37478b-ceac-420f-8be5-ea7aeeb69399\",\"type\":\"ColumnDataSource\"}},\"id\":\"182b0912-58d5-4da6-a1f1-0f54e53927fc\",\"type\":\"CDSView\"},{\"attributes\":{\"source\":{\"id\":\"82387aca-9209-4381-b566-d0f317f0c416\",\"type\":\"ColumnDataSource\"}},\"id\":\"0778f582-c0be-4667-942c-eb6cdf4cc10c\",\"type\":\"CDSView\"},{\"attributes\":{\"source\":{\"id\":\"3910575a-1909-4e2c-ae25-3898ddb7b354\",\"type\":\"ColumnDataSource\"}},\"id\":\"cebd8ffa-3e04-4446-8505-0963190c5939\",\"type\":\"CDSView\"},{\"attributes\":{\"callback\":null,\"column_names\":[\"x\",\"y\"],\"data\":{\"x\":[1940,1941,1942,1943,1944,1945,1946,1947,1948,1949,1950,1951,1952,1953,1954,1955,1956,1957,1958,1959,1960,1961,1962,1963,1964,1965,1966,1967,1968,1969,1970,1971,1972,1973,1974,1975,1976,1977,1978,1979,1980,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016],\"y\":{\"__ndarray__\":\"AAAAAACAV0AzMzMzM1NcQJqZmZmZ+WRAAAAAAAAgb0AzMzMzM9N+QAAAAAAA7IBAMzMzMzMrfUBmZmZmZi55QJqZmZmZIXpAZmZmZma2eUAAAAAAAIh4QJqZmZmZ+X9AmpmZmZmNhEAAAAAAACSEQGZmZmZmloNAzczMzMzEgUAAAAAAAGSDQGZmZmZm0oNAAAAAAACkgkCamZmZmc2BQAAAAAAAfIRAzczMzMxwhEBmZmZmZo6FQM3MzMzMGIZAzczMzMz8hkCamZmZmYGHQGZmZmZmnolAMzMzMzN/jEDNzMzMzESMQJqZmZmZPZBAZmZmZma6j0AzMzMzM8+MQAAAAAAA7I1AAAAAAADUj0BmZmZmZsKQQGZmZmZmLpBAZmZmZmYgkEDNzMzMzO6RQM3MzMzM9pJAZmZmZmY+lEAzMzMzM3OUQDMzMzMzU5VAAAAAAABylEAAAAAAAO6SQGZmZmZmFpRAmpmZmZlZlUAAAAAAAOiVQJqZmZmZp5dAzczMzMxYmEAAAAAAAJCZQGZmZmZm2plAZmZmZmZCmUBmZmZmZi6ZQM3MzMzM3plAZmZmZmaym0DNzMzMzOicQGZmZmZmcJ5AZmZmZmY1oEAzMzMzM4ShQJqZmZmZW6JAAAAAAADao0BmZmZmZgKjQDMzMzMzZ6FAMzMzMzNHoECamZmZmbugQDMzMzMzh6JAzczMzMwDpEAzMzMzM86kQAAAAAAAwqNAAAAAAAByoECamZmZmaKgQM3MzMzMT6FAZmZmZmYNokDNzMzMzC+kQAAAAAAApaVAzczMzMwhp0BmZmZmZhKnQA==\",\"dtype\":\"float64\",\"shape\":[77]}}},\"id\":\"aaa11924-4066-4b5d-a0bd-098096c5e608\",\"type\":\"ColumnDataSource\"},{\"attributes\":{\"callback\":null,\"column_names\":[\"x\",\"y\"],\"data\":{\"x\":[1940,1941,1942,1943,1944,1945,1946,1947,1948,1949,1950,1951,1952,1953,1954,1955,1956,1957,1958,1959,1960,1961,1962,1963,1964,1965,1966,1967,1968,1969,1970,1971,1972,1973,1974,1975,1976,1977,1978,1979,1980,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016],\"y\":{\"__ndarray__\":\"MzMzMzPzRMAzMzMzMxNQwDMzMzMzY23AMzMzMzOvgcCamZmZmcGAwJqZmZmZ0YHAmpmZmZmpZ8AAAAAAAABFQM3MzMzMrF1AZmZmZmZmGEAAAAAAAAA/wAAAAAAAQE5AMzMzMzMzLsDNzMzMzAxOwM3MzMzMzCTAAAAAAAAAOsBmZmZmZmZAQJqZmZmZGTtAMzMzMzOzNMCamZmZmRlXwM3MzMzMzABAmpmZmZkZN8AAAAAAAMBIwJqZmZmZmT/AzczMzMxMQ8AzMzMzMzMiwDMzMzMzMzfAAAAAAACASsCamZmZmZliwAAAAAAAADJAAAAAAAAALsAAAAAAAGBcwAAAAAAAAFvAMzMzMzNzUMAAAAAAAAA5wDMzMzMzs2jAmpmZmZnpb8BmZmZmZqZlwJqZmZmZeWbAmpmZmZl5XMDNzMzMzFxnwJqZmZmZeWbAmpmZmZnxcMAzMzMzMzN6wJqZmZmZWXbAMzMzMzOzeMDNzMzMzDR5wM3MzMzMlHDAZmZmZmaecMAAAAAAAIBvwGZmZmZmJnbAmpmZmZnJecDNzMzMzMx6wM3MzMzM3HbAMzMzMzPjccDNzMzMzAxswAAAAAAAAGLAMzMzMzOzPMDNzMzMzIxWQAAAAAAAMGRAZmZmZmaGckBmZmZmZpZjQDMzMzMzs2fAZmZmZmaWe8AzMzMzM2N9wJqZmZmZ6XXAMzMzMzODcMBmZmZmZtZkwAAAAAAAuHzAzczMzMwSlsCamZmZmemTwM3MzMzMiJPAZmZmZmYEkMCamZmZmcWDwM3MzMzMxHvAAAAAAAD4eMBmZmZmZoKAwA==\",\"dtype\":\"float64\",\"shape\":[77]}}},\"id\":\"3910575a-1909-4e2c-ae25-3898ddb7b354\",\"type\":\"ColumnDataSource\"},{\"attributes\":{\"label\":{\"value\":\"CD Outlays\"},\"renderers\":[{\"id\":\"24e50d35-e5cb-4e18-9a87-579d92874d78\",\"type\":\"GlyphRenderer\"}]},\"id\":\"2c4e5251-60cc-4fea-a4d6-0511377e18a0\",\"type\":\"LegendItem\"},{\"attributes\":{\"axis_label\":\"Constant FY2009 Dollars (Billions)\",\"formatter\":{\"id\":\"3e711ba8-3a9e-4e9a-96b7-65ebe7afbbfd\",\"type\":\"BasicTickFormatter\"},\"plot\":{\"id\":\"0b084532-3463-449c-bb9e-7343886f1937\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"ticker\":{\"id\":\"845a8be9-4c00-4efb-a86e-ecb48aff39f7\",\"type\":\"BasicTicker\"}},\"id\":\"e3db9e40-92e3-4231-b618-b5396f488afe\",\"type\":\"LinearAxis\"},{\"attributes\":{\"below\":[{\"id\":\"f2f87c8c-6587-4930-b1a1-73b97c3601f5\",\"type\":\"LinearAxis\"}],\"left\":[{\"id\":\"e3db9e40-92e3-4231-b618-b5396f488afe\",\"type\":\"LinearAxis\"}],\"plot_width\":800,\"renderers\":[{\"id\":\"f2f87c8c-6587-4930-b1a1-73b97c3601f5\",\"type\":\"LinearAxis\"},{\"id\":\"7b0fa212-13c7-4a3c-97f0-182047635b2a\",\"type\":\"Grid\"},{\"id\":\"e3db9e40-92e3-4231-b618-b5396f488afe\",\"type\":\"LinearAxis\"},{\"id\":\"441e1354-8966-4157-b1b0-1bd7bfba216a\",\"type\":\"Grid\"},{\"id\":\"37edf68b-83d6-4d4c-930d-4f48f68cb728\",\"type\":\"BoxAnnotation\"},{\"id\":\"bf1efee2-65d5-4432-b72e-42720d98e2b2\",\"type\":\"GlyphRenderer\"},{\"id\":\"8e57c3f2-11b4-4957-bc65-c3730ab0aca6\",\"type\":\"GlyphRenderer\"},{\"id\":\"e59a1788-f99c-414f-a220-088cbbeb343e\",\"type\":\"GlyphRenderer\"},{\"id\":\"fe71beef-273b-4401-9bd5-8c4e87944d40\",\"type\":\"GlyphRenderer\"},{\"id\":\"24e50d35-e5cb-4e18-9a87-579d92874d78\",\"type\":\"GlyphRenderer\"},{\"id\":\"17be84b7-2fb1-4f7d-996f-6444fa054a09\",\"type\":\"GlyphRenderer\"},{\"id\":\"cccb1263-e756-4f66-b00b-c1b74e24f862\",\"type\":\"Legend\"}],\"right\":[{\"id\":\"cccb1263-e756-4f66-b00b-c1b74e24f862\",\"type\":\"Legend\"}],\"title\":{\"id\":\"226fbc14-e972-4f77-b130-6c34cffeadb4\",\"type\":\"Title\"},\"toolbar\":{\"id\":\"4dcdd716-e2e7-4dd3-9811-50360143bcc5\",\"type\":\"Toolbar\"},\"toolbar_location\":null,\"x_range\":{\"id\":\"a0dddc71-d05d-4768-8db4-2ed5ab5fa97f\",\"type\":\"DataRange1d\"},\"x_scale\":{\"id\":\"cfd089c2-b59e-43c6-bae4-e1987c7b2f85\",\"type\":\"LinearScale\"},\"y_range\":{\"id\":\"bb43c182-6f09-44bc-912a-160de9161776\",\"type\":\"DataRange1d\"},\"y_scale\":{\"id\":\"4b89254b-930b-43bf-9315-f2d8eb0777b0\",\"type\":\"LinearScale\"}},\"id\":\"0b084532-3463-449c-bb9e-7343886f1937\",\"subtype\":\"Figure\",\"type\":\"Plot\"},{\"attributes\":{\"label\":{\"value\":\"CD Receipts\"},\"renderers\":[{\"id\":\"fe71beef-273b-4401-9bd5-8c4e87944d40\",\"type\":\"GlyphRenderer\"}]},\"id\":\"2ab28216-cc92-4cec-8e64-cbb4e4a27bb5\",\"type\":\"LegendItem\"},{\"attributes\":{\"line_alpha\":{\"value\":0.1},\"line_color\":{\"value\":\"#1f77b4\"},\"x\":{\"field\":\"x\"},\"y\":{\"field\":\"y\"}},\"id\":\"83dcc98e-140f-465a-b06c-3647dbfe3f27\",\"type\":\"Line\"},{\"attributes\":{\"label\":{\"value\":\"CD Surplus or Deficit\"},\"renderers\":[{\"id\":\"17be84b7-2fb1-4f7d-996f-6444fa054a09\",\"type\":\"GlyphRenderer\"}]},\"id\":\"7cb1c3d1-a284-4ab2-809c-74acaef4a040\",\"type\":\"LegendItem\"},{\"attributes\":{\"line_alpha\":{\"value\":0.1},\"line_color\":{\"value\":\"#1f77b4\"},\"x\":{\"field\":\"x\"},\"y\":{\"field\":\"y\"}},\"id\":\"a4f631e7-2b04-4d31-8e44-f8d954f6c07b\",\"type\":\"Line\"},{\"attributes\":{\"dimension\":1,\"plot\":{\"id\":\"0b084532-3463-449c-bb9e-7343886f1937\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"ticker\":{\"id\":\"845a8be9-4c00-4efb-a86e-ecb48aff39f7\",\"type\":\"BasicTicker\"}},\"id\":\"441e1354-8966-4157-b1b0-1bd7bfba216a\",\"type\":\"Grid\"},{\"attributes\":{},\"id\":\"cfd089c2-b59e-43c6-bae4-e1987c7b2f85\",\"type\":\"LinearScale\"},{\"attributes\":{},\"id\":\"e791d0c3-5725-45ad-ae92-1e7396fe4f4c\",\"type\":\"BasicTicker\"},{\"attributes\":{\"active_drag\":\"auto\",\"active_inspect\":\"auto\",\"active_scroll\":\"auto\",\"active_tap\":\"auto\",\"tools\":[{\"id\":\"1c4f46cf-8083-4805-a08f-5ea3e2d8958a\",\"type\":\"PanTool\"},{\"id\":\"63166b60-0e53-4295-865d-c38a526ab487\",\"type\":\"WheelZoomTool\"},{\"id\":\"fb41f431-4497-4dab-a581-69a32ed7a8ef\",\"type\":\"BoxZoomTool\"},{\"id\":\"6850f547-d9a5-496f-9bf4-7df0625b083e\",\"type\":\"SaveTool\"},{\"id\":\"60bac286-6c48-4de2-b70a-3a50ca17703e\",\"type\":\"ResetTool\"},{\"id\":\"c332193a-1896-4c65-8c07-e053e5b1843c\",\"type\":\"HelpTool\"}]},\"id\":\"4dcdd716-e2e7-4dd3-9811-50360143bcc5\",\"type\":\"Toolbar\"},{\"attributes\":{\"plot\":null,\"text\":\"Historical US Federal Government Receipts, Outlays and Surplus or Deficit\"},\"id\":\"226fbc14-e972-4f77-b130-6c34cffeadb4\",\"type\":\"Title\"},{\"attributes\":{\"callback\":null},\"id\":\"a0dddc71-d05d-4768-8db4-2ed5ab5fa97f\",\"type\":\"DataRange1d\"},{\"attributes\":{},\"id\":\"845a8be9-4c00-4efb-a86e-ecb48aff39f7\",\"type\":\"BasicTicker\"},{\"attributes\":{\"callback\":null},\"id\":\"bb43c182-6f09-44bc-912a-160de9161776\",\"type\":\"DataRange1d\"}],\"root_ids\":[\"0b084532-3463-449c-bb9e-7343886f1937\"]},\"title\":\"Bokeh Application\",\"version\":\"0.12.7\"}};\n",
" var render_items = [{\"docid\":\"5f458e6e-d2f5-4e49-bd4d-7a849004cdb5\",\"elementid\":\"a08d4626-e6d6-4811-b703-e81e0c6dc463\",\"modelid\":\"0b084532-3463-449c-bb9e-7343886f1937\"}];\n",
" \n",
" Bokeh.embed.embed_items(docs_json, render_items);\n",
" };\n",
" if (document.readyState != \"loading\") fn();\n",
" else document.addEventListener(\"DOMContentLoaded\", fn);\n",
" })();\n",
" },\n",
" function(Bokeh) {\n",
" }\n",
" ];\n",
" \n",
" function run_inline_js() {\n",
" \n",
" if ((root.Bokeh !== undefined) || (force === true)) {\n",
" for (var i = 0; i < inline_js.length; i++) {\n",
" inline_js[i].call(root, root.Bokeh);\n",
" }if (force === true) {\n",
" display_loaded();\n",
" }} else if (Date.now() < root._bokeh_timeout) {\n",
" setTimeout(run_inline_js, 100);\n",
" } else if (!root._bokeh_failed_load) {\n",
" console.log(\"Bokeh: BokehJS failed to load within specified timeout.\");\n",
" root._bokeh_failed_load = true;\n",
" } else if (force !== true) {\n",
" var cell = $(document.getElementById(\"a08d4626-e6d6-4811-b703-e81e0c6dc463\")).parents('.cell').data().cell;\n",
" cell.output_area.append_execute_result(NB_LOAD_WARNING)\n",
" }\n",
" \n",
" }\n",
" \n",
" if (root._bokeh_is_loading === 0) {\n",
" console.log(\"Bokeh: BokehJS loaded, going straight to plotting\");\n",
" run_inline_js();\n",
" } else {\n",
" load_libs(js_urls, function() {\n",
" console.log(\"Bokeh: BokehJS plotting callback run at\", now());\n",
" run_inline_js();\n",
" });\n",
" }\n",
" }(window));\n",
"</script>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"l1 = fig.line(\n",
" x = tax2[\"Fiscal Year\"], \n",
" y = tax2[\"CD Receipts\"],\n",
" color = 'Green')\n",
"l2 = fig.line(\n",
" x = tax2[\"Fiscal Year\"], \n",
" y = tax2[\"CD Outlays\"],\n",
" color = 'Red')\n",
"l3 = fig.line(\n",
" x = tax2[\"Fiscal Year\"], \n",
" y = tax2[\"CD Surplus or Deficit\"],\n",
" color = 'Black')\n",
"legend = Legend(items=[\n",
" (\"CD Receipts\", [l1]),\n",
" (\"CD Outlays\", [l2]),\n",
" (\"CD Surplus or Deficit\", [l3])\n",
"])\n",
"fig.add_layout(legend, 'right')\n",
"show(fig)"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.6.2"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment