Skip to content

Instantly share code, notes, and snippets.

@elbertwang3

elbertwang3/epmg.ipynb

Last active March 8, 2019 21:11
Show Gist options
  • Save elbertwang3/bba02c281342cee4870093a063537588 to your computer and use it in GitHub Desktop.
Save elbertwang3/bba02c281342cee4870093a063537588 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
epmg.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Populating the interactive namespace from numpy and matplotlib\n"
]
}
],
"source": [
"%pylab inline\n",
"import pandas as pd\n",
"import numpy as np\n",
"import matplotlib.pyplot as plt\n",
"pd.set_option('display.max_columns', 500)"
]
},
{
"cell_type": "code",
"execution_count": 31,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>reportingPeriod</th>\n",
" <th>state</th>\n",
" <th>legalAgencyName</th>\n",
" <th>projectType</th>\n",
" <th>projectStartDate</th>\n",
" <th>projectEndDate</th>\n",
" <th>empgTotalFunding</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2014 BSIR (December 15)</td>\n",
" <td>Alabama</td>\n",
" <td>Alabama Emergency Management Agency</td>\n",
" <td>Develop/enhance plans, procedures, and protocols</td>\n",
" <td>2014-10-01T00:00:00+00:00</td>\n",
" <td>2016-10-01T00:00:00+00:00</td>\n",
" <td>5795991.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2014 BSIR (December 15)</td>\n",
" <td>Alaska</td>\n",
" <td>City of Dillingham</td>\n",
" <td>Establish/Enhance emergency plans and procedur...</td>\n",
" <td>2014-07-01T00:00:00+00:00</td>\n",
" <td>2015-06-01T00:00:00+00:00</td>\n",
" <td>2672.65</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>2014 BSIR (December 15)</td>\n",
" <td>Alaska</td>\n",
" <td>City of Ketchikan</td>\n",
" <td>Establish/Enhance emergency plans and procedur...</td>\n",
" <td>2014-07-01T00:00:00+00:00</td>\n",
" <td>2015-06-01T00:00:00+00:00</td>\n",
" <td>25206.29</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>2014 BSIR (December 15)</td>\n",
" <td>Alaska</td>\n",
" <td>City of Whittier</td>\n",
" <td>Establish/Enhance emergency plans and procedur...</td>\n",
" <td>2014-07-01T00:00:00+00:00</td>\n",
" <td>2015-06-01T00:00:00+00:00</td>\n",
" <td>3359.39</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>2014 BSIR (December 15)</td>\n",
" <td>Alaska</td>\n",
" <td>Division of Homeland Security and Emergency Ma...</td>\n",
" <td>Establish/Enhance emergency plans and procedur...</td>\n",
" <td>2013-10-01T00:00:00+00:00</td>\n",
" <td>2015-09-01T00:00:00+00:00</td>\n",
" <td>2425109.67</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" reportingPeriod state \\\n",
"0 2014 BSIR (December 15) Alabama \n",
"1 2014 BSIR (December 15) Alaska \n",
"2 2014 BSIR (December 15) Alaska \n",
"3 2014 BSIR (December 15) Alaska \n",
"4 2014 BSIR (December 15) Alaska \n",
"\n",
" legalAgencyName \\\n",
"0 Alabama Emergency Management Agency \n",
"1 City of Dillingham \n",
"2 City of Ketchikan \n",
"3 City of Whittier \n",
"4 Division of Homeland Security and Emergency Ma... \n",
"\n",
" projectType \\\n",
"0 Develop/enhance plans, procedures, and protocols \n",
"1 Establish/Enhance emergency plans and procedur... \n",
"2 Establish/Enhance emergency plans and procedur... \n",
"3 Establish/Enhance emergency plans and procedur... \n",
"4 Establish/Enhance emergency plans and procedur... \n",
"\n",
" projectStartDate projectEndDate empgTotalFunding \n",
"0 2014-10-01T00:00:00+00:00 2016-10-01T00:00:00+00:00 5795991.00 \n",
"1 2014-07-01T00:00:00+00:00 2015-06-01T00:00:00+00:00 2672.65 \n",
"2 2014-07-01T00:00:00+00:00 2015-06-01T00:00:00+00:00 25206.29 \n",
"3 2014-07-01T00:00:00+00:00 2015-06-01T00:00:00+00:00 3359.39 \n",
"4 2013-10-01T00:00:00+00:00 2015-09-01T00:00:00+00:00 2425109.67 "
]
},
"execution_count": 31,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"grants = pd.read_csv('../data/EmergencyManagementPerformanceGrants.csv')\n",
"pop = pd.read_csv('../data/popbystate.csv')\n",
"grants.head()"
]
},
{
"cell_type": "code",
"execution_count": 47,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"array(['Alabama Emergency Management Agency', 'City of Dillingham',\n",
" 'City of Ketchikan', ..., 'Renton, City of', 'Skagit, County of',\n",
" 'Whitman, County of'], dtype=object)"
]
},
"execution_count": 47,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"grants.legalAgencyName.unique()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Emergency Management Performance Grant By State"
]
},
{
"cell_type": "code",
"execution_count": 48,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>empgTotalFunding</th>\n",
" </tr>\n",
" <tr>\n",
" <th>state</th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>California</th>\n",
" <td>83539746.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Texas</th>\n",
" <td>60498530.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Florida</th>\n",
" <td>46732318.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>New York</th>\n",
" <td>46394114.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Illinois</th>\n",
" <td>33008796.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Pennsylvania</th>\n",
" <td>32839862.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Ohio</th>\n",
" <td>30506777.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Georgia</th>\n",
" <td>27594376.75</td>\n",
" </tr>\n",
" <tr>\n",
" <th>North Carolina</th>\n",
" <td>27288964.27</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Michigan</th>\n",
" <td>27215146.37</td>\n",
" </tr>\n",
" <tr>\n",
" <th>New Jersey</th>\n",
" <td>25311851.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Virginia</th>\n",
" <td>24123357.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington</th>\n",
" <td>21653524.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Massachusetts</th>\n",
" <td>21040847.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Arizona</th>\n",
" <td>21010081.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Indiana</th>\n",
" <td>20751396.90</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Tennessee</th>\n",
" <td>20658827.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Missouri</th>\n",
" <td>19712848.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Maryland</th>\n",
" <td>19530563.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Wisconsin</th>\n",
" <td>19112997.23</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Minnesota</th>\n",
" <td>18525542.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Colorado</th>\n",
" <td>18338590.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Alabama</th>\n",
" <td>17338109.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>South Carolina</th>\n",
" <td>17312485.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Louisiana</th>\n",
" <td>16950022.92</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Kentucky</th>\n",
" <td>16486752.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Oregon</th>\n",
" <td>15637453.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Oklahoma</th>\n",
" <td>15449373.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Connecticut</th>\n",
" <td>14892469.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Puerto Rico</th>\n",
" <td>14798179.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Iowa</th>\n",
" <td>13940743.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Mississippi</th>\n",
" <td>13717169.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Arkansas</th>\n",
" <td>13669134.60</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Utah</th>\n",
" <td>13626927.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Kansas</th>\n",
" <td>13542682.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Nevada</th>\n",
" <td>13418908.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Nebraska</th>\n",
" <td>11549120.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>West Virginia</th>\n",
" <td>11485900.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Idaho</th>\n",
" <td>11064416.67</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Hawaii</th>\n",
" <td>10643935.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Maine</th>\n",
" <td>10469997.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>New Hampshire</th>\n",
" <td>10465516.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Rhode Island</th>\n",
" <td>9933282.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Montana</th>\n",
" <td>9814194.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Delaware</th>\n",
" <td>9701741.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>South Dakota</th>\n",
" <td>9538582.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>North Dakota</th>\n",
" <td>9319359.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Alaska</th>\n",
" <td>9313330.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>District of Columbia</th>\n",
" <td>9161768.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Vermont</th>\n",
" <td>9095922.72</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Wyoming</th>\n",
" <td>9015419.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>New Mexico</th>\n",
" <td>3971203.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Guam</th>\n",
" <td>2939411.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Virgin Islands</th>\n",
" <td>2828352.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>American Samoa</th>\n",
" <td>2731450.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Northern Mariana Islands</th>\n",
" <td>2725858.00</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" empgTotalFunding\n",
"state \n",
"California 83539746.00\n",
"Texas 60498530.00\n",
"Florida 46732318.00\n",
"New York 46394114.00\n",
"Illinois 33008796.00\n",
"Pennsylvania 32839862.00\n",
"Ohio 30506777.00\n",
"Georgia 27594376.75\n",
"North Carolina 27288964.27\n",
"Michigan 27215146.37\n",
"New Jersey 25311851.00\n",
"Virginia 24123357.00\n",
"Washington 21653524.00\n",
"Massachusetts 21040847.00\n",
"Arizona 21010081.00\n",
"Indiana 20751396.90\n",
"Tennessee 20658827.00\n",
"Missouri 19712848.00\n",
"Maryland 19530563.00\n",
"Wisconsin 19112997.23\n",
"Minnesota 18525542.00\n",
"Colorado 18338590.00\n",
"Alabama 17338109.00\n",
"South Carolina 17312485.00\n",
"Louisiana 16950022.92\n",
"Kentucky 16486752.00\n",
"Oregon 15637453.00\n",
"Oklahoma 15449373.00\n",
"Connecticut 14892469.00\n",
"Puerto Rico 14798179.00\n",
"Iowa 13940743.00\n",
"Mississippi 13717169.00\n",
"Arkansas 13669134.60\n",
"Utah 13626927.00\n",
"Kansas 13542682.00\n",
"Nevada 13418908.00\n",
"Nebraska 11549120.00\n",
"West Virginia 11485900.00\n",
"Idaho 11064416.67\n",
"Hawaii 10643935.00\n",
"Maine 10469997.00\n",
"New Hampshire 10465516.00\n",
"Rhode Island 9933282.00\n",
"Montana 9814194.00\n",
"Delaware 9701741.00\n",
"South Dakota 9538582.00\n",
"North Dakota 9319359.00\n",
"Alaska 9313330.00\n",
"District of Columbia 9161768.00\n",
"Vermont 9095922.72\n",
"Wyoming 9015419.00\n",
"New Mexico 3971203.00\n",
"Guam 2939411.00\n",
"Virgin Islands 2828352.00\n",
"American Samoa 2731450.00\n",
"Northern Mariana Islands 2725858.00"
]
},
"execution_count": 48,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"bystate = pd.DataFrame(grants.groupby(['state'])['empgTotalFunding'].sum().sort_values(ascending=False))\n",
"bystate"
]
},
{
"cell_type": "code",
"execution_count": 34,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"reportingPeriod\n",
"2014 BSIR (December 15) 3.460054e+08\n",
"2015 BSIR (December 15) 3.459480e+08\n",
"2016 BSIR (December 16) 3.499848e+08\n",
"Name: empgTotalFunding, dtype: float64"
]
},
"execution_count": 34,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"grants.groupby(['reportingPeriod'])['empgTotalFunding'].sum()"
]
},
{
"cell_type": "code",
"execution_count": 35,
"metadata": {},
"outputs": [],
"source": [
"pop['Population estimate, July 1, 2018[4]'] = pop['Population estimate, July 1, 2018[4]'].str.replace(\",\", \"\").astype(int)"
]
},
{
"cell_type": "code",
"execution_count": 36,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Rank in the fifty states, 2018</th>\n",
" <th>Rank in States &amp; Territories</th>\n",
" <th>Name</th>\n",
" <th>Population estimate, July 1, 2018[4]</th>\n",
" <th>Census population, April 1, 2010</th>\n",
" <th>Percent increase from 2010-2018[note 1]</th>\n",
" <th>Total seats in the U.S. House of Representatives, 2013–2023</th>\n",
" <th>Estimated population per electoral vote, 2018[note 2]</th>\n",
" <th>Estimated population per House seat, 2018</th>\n",
" <th>Census population per House seat, 2010</th>\n",
" <th>Percent of the total U.S. population, 2018[note 3]</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>California</td>\n",
" <td>39557045</td>\n",
" <td>37,252,895</td>\n",
" <td>6.19%</td>\n",
" <td>53</td>\n",
" <td>719,219</td>\n",
" <td>746,359</td>\n",
" <td>702,885</td>\n",
" <td>11.96%</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>Texas</td>\n",
" <td>28701845</td>\n",
" <td>25,146,105</td>\n",
" <td>14.14%</td>\n",
" <td>36</td>\n",
" <td>755,312</td>\n",
" <td>797,273</td>\n",
" <td>698,503</td>\n",
" <td>8.68%</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>Florida</td>\n",
" <td>21299325</td>\n",
" <td>18,804,623</td>\n",
" <td>13.27%</td>\n",
" <td>27</td>\n",
" <td>734,459</td>\n",
" <td>788,864</td>\n",
" <td>696,468</td>\n",
" <td>6.44%</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>4</td>\n",
" <td>4</td>\n",
" <td>New York</td>\n",
" <td>19542209</td>\n",
" <td>19,378,087</td>\n",
" <td>0.85%</td>\n",
" <td>27</td>\n",
" <td>673,869</td>\n",
" <td>723,786</td>\n",
" <td>717,707</td>\n",
" <td>5.91%</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>5</td>\n",
" <td>5</td>\n",
" <td>Pennsylvania</td>\n",
" <td>12807060</td>\n",
" <td>12,702,887</td>\n",
" <td>0.82%</td>\n",
" <td>18</td>\n",
" <td>640,353</td>\n",
" <td>711,503</td>\n",
" <td>705,715</td>\n",
" <td>3.87%</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" Rank in the fifty states, 2018 Rank in States & Territories Name \\\n",
"0 1 1 California \n",
"1 2 2 Texas \n",
"2 3 3 Florida \n",
"3 4 4 New York \n",
"4 5 5 Pennsylvania \n",
"\n",
" Population estimate, July 1, 2018[4] Census population, April 1, 2010 \\\n",
"0 39557045 37,252,895 \n",
"1 28701845 25,146,105 \n",
"2 21299325 18,804,623 \n",
"3 19542209 19,378,087 \n",
"4 12807060 12,702,887 \n",
"\n",
" Percent increase from 2010-2018[note 1] \\\n",
"0 6.19% \n",
"1 14.14% \n",
"2 13.27% \n",
"3 0.85% \n",
"4 0.82% \n",
"\n",
" Total seats in the U.S. House of Representatives, 2013–2023 \\\n",
"0 53 \n",
"1 36 \n",
"2 27 \n",
"3 27 \n",
"4 18 \n",
"\n",
" Estimated population per electoral vote, 2018[note 2] \\\n",
"0 719,219 \n",
"1 755,312 \n",
"2 734,459 \n",
"3 673,869 \n",
"4 640,353 \n",
"\n",
" Estimated population per House seat, 2018 \\\n",
"0 746,359 \n",
"1 797,273 \n",
"2 788,864 \n",
"3 723,786 \n",
"4 711,503 \n",
"\n",
" Census population per House seat, 2010 \\\n",
"0 702,885 \n",
"1 698,503 \n",
"2 696,468 \n",
"3 717,707 \n",
"4 705,715 \n",
"\n",
" Percent of the total U.S. population, 2018[note 3] \n",
"0 11.96% \n",
"1 8.68% \n",
"2 6.44% \n",
"3 5.91% \n",
"4 3.87% "
]
},
"execution_count": 36,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pop.head()"
]
},
{
"cell_type": "code",
"execution_count": 43,
"metadata": {},
"outputs": [],
"source": [
"merged = pd.merge(bystate, pop[['Name', 'Population estimate, July 1, 2018[4]']], left_on='state', right_on='Name', how='inner')"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Emergency Management Performance Grant By State, Per Capita"
]
},
{
"cell_type": "code",
"execution_count": 46,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>empgTotalFunding</th>\n",
" <th>Name</th>\n",
" <th>Population estimate, July 1, 2018[4]</th>\n",
" <th>percapita</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>54</th>\n",
" <td>2725858.00</td>\n",
" <td>Northern Mariana Islands</td>\n",
" <td>55194</td>\n",
" <td>49.386854</td>\n",
" </tr>\n",
" <tr>\n",
" <th>53</th>\n",
" <td>2731450.00</td>\n",
" <td>American Samoa</td>\n",
" <td>55641</td>\n",
" <td>49.090599</td>\n",
" </tr>\n",
" <tr>\n",
" <th>52</th>\n",
" <td>2939411.00</td>\n",
" <td>Guam</td>\n",
" <td>165718</td>\n",
" <td>17.737427</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50</th>\n",
" <td>9015419.00</td>\n",
" <td>Wyoming</td>\n",
" <td>577737</td>\n",
" <td>15.604711</td>\n",
" </tr>\n",
" <tr>\n",
" <th>49</th>\n",
" <td>9095922.72</td>\n",
" <td>Vermont</td>\n",
" <td>626299</td>\n",
" <td>14.523291</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td>9161768.00</td>\n",
" <td>District of Columbia</td>\n",
" <td>702455</td>\n",
" <td>13.042498</td>\n",
" </tr>\n",
" <tr>\n",
" <th>47</th>\n",
" <td>9313330.00</td>\n",
" <td>Alaska</td>\n",
" <td>737438</td>\n",
" <td>12.629306</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46</th>\n",
" <td>9319359.00</td>\n",
" <td>North Dakota</td>\n",
" <td>760077</td>\n",
" <td>12.261072</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45</th>\n",
" <td>9538582.00</td>\n",
" <td>South Dakota</td>\n",
" <td>882235</td>\n",
" <td>10.811838</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44</th>\n",
" <td>9701741.00</td>\n",
" <td>Delaware</td>\n",
" <td>967171</td>\n",
" <td>10.031050</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td>9933282.00</td>\n",
" <td>Rhode Island</td>\n",
" <td>1057315</td>\n",
" <td>9.394818</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43</th>\n",
" <td>9814194.00</td>\n",
" <td>Montana</td>\n",
" <td>1062305</td>\n",
" <td>9.238584</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40</th>\n",
" <td>10469997.00</td>\n",
" <td>Maine</td>\n",
" <td>1338404</td>\n",
" <td>7.822748</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41</th>\n",
" <td>10465516.00</td>\n",
" <td>New Hampshire</td>\n",
" <td>1356458</td>\n",
" <td>7.715326</td>\n",
" </tr>\n",
" <tr>\n",
" <th>39</th>\n",
" <td>10643935.00</td>\n",
" <td>Hawaii</td>\n",
" <td>1420491</td>\n",
" <td>7.493138</td>\n",
" </tr>\n",
" <tr>\n",
" <th>37</th>\n",
" <td>11485900.00</td>\n",
" <td>West Virginia</td>\n",
" <td>1805832</td>\n",
" <td>6.360448</td>\n",
" </tr>\n",
" <tr>\n",
" <th>38</th>\n",
" <td>11064416.67</td>\n",
" <td>Idaho</td>\n",
" <td>1754208</td>\n",
" <td>6.307357</td>\n",
" </tr>\n",
" <tr>\n",
" <th>36</th>\n",
" <td>11549120.00</td>\n",
" <td>Nebraska</td>\n",
" <td>1929268</td>\n",
" <td>5.986270</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td>13542682.00</td>\n",
" <td>Kansas</td>\n",
" <td>2911505</td>\n",
" <td>4.651437</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>14798179.00</td>\n",
" <td>Puerto Rico</td>\n",
" <td>3195153</td>\n",
" <td>4.631446</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td>13717169.00</td>\n",
" <td>Mississippi</td>\n",
" <td>2986530</td>\n",
" <td>4.593012</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td>13669134.60</td>\n",
" <td>Arkansas</td>\n",
" <td>3013825</td>\n",
" <td>4.535477</td>\n",
" </tr>\n",
" <tr>\n",
" <th>35</th>\n",
" <td>13418908.00</td>\n",
" <td>Nevada</td>\n",
" <td>3034392</td>\n",
" <td>4.422272</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td>13940743.00</td>\n",
" <td>Iowa</td>\n",
" <td>3156145</td>\n",
" <td>4.417016</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td>13626927.00</td>\n",
" <td>Utah</td>\n",
" <td>3161105</td>\n",
" <td>4.310811</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>14892469.00</td>\n",
" <td>Connecticut</td>\n",
" <td>3572665</td>\n",
" <td>4.168448</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>15449373.00</td>\n",
" <td>Oklahoma</td>\n",
" <td>3943079</td>\n",
" <td>3.918099</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>15637453.00</td>\n",
" <td>Oregon</td>\n",
" <td>4190713</td>\n",
" <td>3.731454</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>16486752.00</td>\n",
" <td>Kentucky</td>\n",
" <td>4468402</td>\n",
" <td>3.689630</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>16950022.92</td>\n",
" <td>Louisiana</td>\n",
" <td>4659978</td>\n",
" <td>3.637361</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>17338109.00</td>\n",
" <td>Alabama</td>\n",
" <td>4887871</td>\n",
" <td>3.547170</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>17312485.00</td>\n",
" <td>South Carolina</td>\n",
" <td>5084127</td>\n",
" <td>3.405203</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>18525542.00</td>\n",
" <td>Minnesota</td>\n",
" <td>5611179</td>\n",
" <td>3.301542</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>19112997.23</td>\n",
" <td>Wisconsin</td>\n",
" <td>5813568</td>\n",
" <td>3.287654</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>19530563.00</td>\n",
" <td>Maryland</td>\n",
" <td>6042718</td>\n",
" <td>3.232082</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>18338590.00</td>\n",
" <td>Colorado</td>\n",
" <td>5695564</td>\n",
" <td>3.219802</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>19712848.00</td>\n",
" <td>Missouri</td>\n",
" <td>6126452</td>\n",
" <td>3.217661</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>20751396.90</td>\n",
" <td>Indiana</td>\n",
" <td>6691878</td>\n",
" <td>3.100983</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>20658827.00</td>\n",
" <td>Tennessee</td>\n",
" <td>6770010</td>\n",
" <td>3.051521</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>21040847.00</td>\n",
" <td>Massachusetts</td>\n",
" <td>6902149</td>\n",
" <td>3.048449</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>21010081.00</td>\n",
" <td>Arizona</td>\n",
" <td>7171646</td>\n",
" <td>2.929604</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>21653524.00</td>\n",
" <td>Washington</td>\n",
" <td>7535591</td>\n",
" <td>2.873500</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>24123357.00</td>\n",
" <td>Virginia</td>\n",
" <td>8517685</td>\n",
" <td>2.832149</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>25311851.00</td>\n",
" <td>New Jersey</td>\n",
" <td>9032873</td>\n",
" <td>2.802193</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>27215146.37</td>\n",
" <td>Michigan</td>\n",
" <td>9998915</td>\n",
" <td>2.721810</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>27288964.27</td>\n",
" <td>North Carolina</td>\n",
" <td>10383620</td>\n",
" <td>2.628078</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>27594376.75</td>\n",
" <td>Georgia</td>\n",
" <td>10519475</td>\n",
" <td>2.623171</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>30506777.00</td>\n",
" <td>Ohio</td>\n",
" <td>11689442</td>\n",
" <td>2.609772</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>33008796.00</td>\n",
" <td>Illinois</td>\n",
" <td>12741080</td>\n",
" <td>2.590738</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>32839862.00</td>\n",
" <td>Pennsylvania</td>\n",
" <td>12807060</td>\n",
" <td>2.564200</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>46394114.00</td>\n",
" <td>New York</td>\n",
" <td>19542209</td>\n",
" <td>2.374047</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>46732318.00</td>\n",
" <td>Florida</td>\n",
" <td>21299325</td>\n",
" <td>2.194075</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>83539746.00</td>\n",
" <td>California</td>\n",
" <td>39557045</td>\n",
" <td>2.111880</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>60498530.00</td>\n",
" <td>Texas</td>\n",
" <td>28701845</td>\n",
" <td>2.107827</td>\n",
" </tr>\n",
" <tr>\n",
" <th>51</th>\n",
" <td>3971203.00</td>\n",
" <td>New Mexico</td>\n",
" <td>2095428</td>\n",
" <td>1.895175</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" empgTotalFunding Name \\\n",
"54 2725858.00 Northern Mariana Islands \n",
"53 2731450.00 American Samoa \n",
"52 2939411.00 Guam \n",
"50 9015419.00 Wyoming \n",
"49 9095922.72 Vermont \n",
"48 9161768.00 District of Columbia \n",
"47 9313330.00 Alaska \n",
"46 9319359.00 North Dakota \n",
"45 9538582.00 South Dakota \n",
"44 9701741.00 Delaware \n",
"42 9933282.00 Rhode Island \n",
"43 9814194.00 Montana \n",
"40 10469997.00 Maine \n",
"41 10465516.00 New Hampshire \n",
"39 10643935.00 Hawaii \n",
"37 11485900.00 West Virginia \n",
"38 11064416.67 Idaho \n",
"36 11549120.00 Nebraska \n",
"34 13542682.00 Kansas \n",
"29 14798179.00 Puerto Rico \n",
"31 13717169.00 Mississippi \n",
"32 13669134.60 Arkansas \n",
"35 13418908.00 Nevada \n",
"30 13940743.00 Iowa \n",
"33 13626927.00 Utah \n",
"28 14892469.00 Connecticut \n",
"27 15449373.00 Oklahoma \n",
"26 15637453.00 Oregon \n",
"25 16486752.00 Kentucky \n",
"24 16950022.92 Louisiana \n",
"22 17338109.00 Alabama \n",
"23 17312485.00 South Carolina \n",
"20 18525542.00 Minnesota \n",
"19 19112997.23 Wisconsin \n",
"18 19530563.00 Maryland \n",
"21 18338590.00 Colorado \n",
"17 19712848.00 Missouri \n",
"15 20751396.90 Indiana \n",
"16 20658827.00 Tennessee \n",
"13 21040847.00 Massachusetts \n",
"14 21010081.00 Arizona \n",
"12 21653524.00 Washington \n",
"11 24123357.00 Virginia \n",
"10 25311851.00 New Jersey \n",
"9 27215146.37 Michigan \n",
"8 27288964.27 North Carolina \n",
"7 27594376.75 Georgia \n",
"6 30506777.00 Ohio \n",
"4 33008796.00 Illinois \n",
"5 32839862.00 Pennsylvania \n",
"3 46394114.00 New York \n",
"2 46732318.00 Florida \n",
"0 83539746.00 California \n",
"1 60498530.00 Texas \n",
"51 3971203.00 New Mexico \n",
"\n",
" Population estimate, July 1, 2018[4] percapita \n",
"54 55194 49.386854 \n",
"53 55641 49.090599 \n",
"52 165718 17.737427 \n",
"50 577737 15.604711 \n",
"49 626299 14.523291 \n",
"48 702455 13.042498 \n",
"47 737438 12.629306 \n",
"46 760077 12.261072 \n",
"45 882235 10.811838 \n",
"44 967171 10.031050 \n",
"42 1057315 9.394818 \n",
"43 1062305 9.238584 \n",
"40 1338404 7.822748 \n",
"41 1356458 7.715326 \n",
"39 1420491 7.493138 \n",
"37 1805832 6.360448 \n",
"38 1754208 6.307357 \n",
"36 1929268 5.986270 \n",
"34 2911505 4.651437 \n",
"29 3195153 4.631446 \n",
"31 2986530 4.593012 \n",
"32 3013825 4.535477 \n",
"35 3034392 4.422272 \n",
"30 3156145 4.417016 \n",
"33 3161105 4.310811 \n",
"28 3572665 4.168448 \n",
"27 3943079 3.918099 \n",
"26 4190713 3.731454 \n",
"25 4468402 3.689630 \n",
"24 4659978 3.637361 \n",
"22 4887871 3.547170 \n",
"23 5084127 3.405203 \n",
"20 5611179 3.301542 \n",
"19 5813568 3.287654 \n",
"18 6042718 3.232082 \n",
"21 5695564 3.219802 \n",
"17 6126452 3.217661 \n",
"15 6691878 3.100983 \n",
"16 6770010 3.051521 \n",
"13 6902149 3.048449 \n",
"14 7171646 2.929604 \n",
"12 7535591 2.873500 \n",
"11 8517685 2.832149 \n",
"10 9032873 2.802193 \n",
"9 9998915 2.721810 \n",
"8 10383620 2.628078 \n",
"7 10519475 2.623171 \n",
"6 11689442 2.609772 \n",
"4 12741080 2.590738 \n",
"5 12807060 2.564200 \n",
"3 19542209 2.374047 \n",
"2 21299325 2.194075 \n",
"0 39557045 2.111880 \n",
"1 28701845 2.107827 \n",
"51 2095428 1.895175 "
]
},
"execution_count": 46,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"merged['percapita'] = merged['empgTotalFunding']/merged['Population estimate, July 1, 2018[4]']\n",
"merged.sort_values(['percapita'], ascending=False)"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
}
],
"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.7.2"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Display the source blob
Display the rendered blob
Raw
fema.ipynb
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Display the source blob
Display the rendered blob
Raw
public-assistance.ipynb
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Display the source blob
Display the rendered blob
Raw
still-open.ipynb
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment