Census_Bureau_Analysis.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Let's say you want to analyze data from [United States Census Bureau](https://www.census.gov/).\n",
    "\n",
    "First we load numpy and pandas:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Then, we load the csv file:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "census_df = pd.read_csv('census.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This file does not need cleaning. It is already clean and ready to be analyzed.\n",
    "\n",
    "This is the file:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "scrolled": false
   },
   "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>SUMLEV</th>\n",
       "      <th>REGION</th>\n",
       "      <th>DIVISION</th>\n",
       "      <th>STATE</th>\n",
       "      <th>COUNTY</th>\n",
       "      <th>STNAME</th>\n",
       "      <th>CTYNAME</th>\n",
       "      <th>CENSUS2010POP</th>\n",
       "      <th>ESTIMATESBASE2010</th>\n",
       "      <th>POPESTIMATE2010</th>\n",
       "      <th>...</th>\n",
       "      <th>RDOMESTICMIG2011</th>\n",
       "      <th>RDOMESTICMIG2012</th>\n",
       "      <th>RDOMESTICMIG2013</th>\n",
       "      <th>RDOMESTICMIG2014</th>\n",
       "      <th>RDOMESTICMIG2015</th>\n",
       "      <th>RNETMIG2011</th>\n",
       "      <th>RNETMIG2012</th>\n",
       "      <th>RNETMIG2013</th>\n",
       "      <th>RNETMIG2014</th>\n",
       "      <th>RNETMIG2015</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>4779736</td>\n",
       "      <td>4780127</td>\n",
       "      <td>4785161</td>\n",
       "      <td>...</td>\n",
       "      <td>0.002295</td>\n",
       "      <td>-0.193196</td>\n",
       "      <td>0.381066</td>\n",
       "      <td>0.582002</td>\n",
       "      <td>-0.467369</td>\n",
       "      <td>1.030015</td>\n",
       "      <td>0.826644</td>\n",
       "      <td>1.383282</td>\n",
       "      <td>1.724718</td>\n",
       "      <td>0.712594</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Autauga County</td>\n",
       "      <td>54571</td>\n",
       "      <td>54571</td>\n",
       "      <td>54660</td>\n",
       "      <td>...</td>\n",
       "      <td>7.242091</td>\n",
       "      <td>-2.915927</td>\n",
       "      <td>-3.012349</td>\n",
       "      <td>2.265971</td>\n",
       "      <td>-2.530799</td>\n",
       "      <td>7.606016</td>\n",
       "      <td>-2.626146</td>\n",
       "      <td>-2.722002</td>\n",
       "      <td>2.592270</td>\n",
       "      <td>-2.187333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Baldwin County</td>\n",
       "      <td>182265</td>\n",
       "      <td>182265</td>\n",
       "      <td>183193</td>\n",
       "      <td>...</td>\n",
       "      <td>14.832960</td>\n",
       "      <td>17.647293</td>\n",
       "      <td>21.845705</td>\n",
       "      <td>19.243287</td>\n",
       "      <td>17.197872</td>\n",
       "      <td>15.844176</td>\n",
       "      <td>18.559627</td>\n",
       "      <td>22.727626</td>\n",
       "      <td>20.317142</td>\n",
       "      <td>18.293499</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Barbour County</td>\n",
       "      <td>27457</td>\n",
       "      <td>27457</td>\n",
       "      <td>27341</td>\n",
       "      <td>...</td>\n",
       "      <td>-4.728132</td>\n",
       "      <td>-2.500690</td>\n",
       "      <td>-7.056824</td>\n",
       "      <td>-3.904217</td>\n",
       "      <td>-10.543299</td>\n",
       "      <td>-4.874741</td>\n",
       "      <td>-2.758113</td>\n",
       "      <td>-7.167664</td>\n",
       "      <td>-3.978583</td>\n",
       "      <td>-10.543299</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Bibb County</td>\n",
       "      <td>22915</td>\n",
       "      <td>22919</td>\n",
       "      <td>22861</td>\n",
       "      <td>...</td>\n",
       "      <td>-5.527043</td>\n",
       "      <td>-5.068871</td>\n",
       "      <td>-6.201001</td>\n",
       "      <td>-0.177537</td>\n",
       "      <td>0.177258</td>\n",
       "      <td>-5.088389</td>\n",
       "      <td>-4.363636</td>\n",
       "      <td>-5.403729</td>\n",
       "      <td>0.754533</td>\n",
       "      <td>1.107861</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Blount County</td>\n",
       "      <td>57322</td>\n",
       "      <td>57322</td>\n",
       "      <td>57373</td>\n",
       "      <td>...</td>\n",
       "      <td>1.807375</td>\n",
       "      <td>-1.177622</td>\n",
       "      <td>-1.748766</td>\n",
       "      <td>-2.062535</td>\n",
       "      <td>-1.369970</td>\n",
       "      <td>1.859511</td>\n",
       "      <td>-0.848580</td>\n",
       "      <td>-1.402476</td>\n",
       "      <td>-1.577232</td>\n",
       "      <td>-0.884411</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Bullock County</td>\n",
       "      <td>10914</td>\n",
       "      <td>10915</td>\n",
       "      <td>10887</td>\n",
       "      <td>...</td>\n",
       "      <td>-30.953709</td>\n",
       "      <td>-5.180127</td>\n",
       "      <td>-1.130263</td>\n",
       "      <td>14.354290</td>\n",
       "      <td>-16.167247</td>\n",
       "      <td>-29.001673</td>\n",
       "      <td>-2.825524</td>\n",
       "      <td>1.507017</td>\n",
       "      <td>17.243790</td>\n",
       "      <td>-13.193961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Butler County</td>\n",
       "      <td>20947</td>\n",
       "      <td>20946</td>\n",
       "      <td>20944</td>\n",
       "      <td>...</td>\n",
       "      <td>-14.032727</td>\n",
       "      <td>-11.684234</td>\n",
       "      <td>-5.655413</td>\n",
       "      <td>1.085428</td>\n",
       "      <td>-6.529805</td>\n",
       "      <td>-13.936612</td>\n",
       "      <td>-11.586865</td>\n",
       "      <td>-5.557058</td>\n",
       "      <td>1.184103</td>\n",
       "      <td>-6.430868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Calhoun County</td>\n",
       "      <td>118572</td>\n",
       "      <td>118586</td>\n",
       "      <td>118437</td>\n",
       "      <td>...</td>\n",
       "      <td>-6.155670</td>\n",
       "      <td>-4.611706</td>\n",
       "      <td>-5.524649</td>\n",
       "      <td>-4.463211</td>\n",
       "      <td>-3.376322</td>\n",
       "      <td>-5.791579</td>\n",
       "      <td>-4.092677</td>\n",
       "      <td>-5.062836</td>\n",
       "      <td>-3.912834</td>\n",
       "      <td>-2.806406</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Chambers County</td>\n",
       "      <td>34215</td>\n",
       "      <td>34170</td>\n",
       "      <td>34098</td>\n",
       "      <td>...</td>\n",
       "      <td>-2.731639</td>\n",
       "      <td>3.849092</td>\n",
       "      <td>2.872721</td>\n",
       "      <td>-2.287222</td>\n",
       "      <td>1.349468</td>\n",
       "      <td>-1.821092</td>\n",
       "      <td>4.701181</td>\n",
       "      <td>3.781439</td>\n",
       "      <td>-1.290228</td>\n",
       "      <td>2.346901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Cherokee County</td>\n",
       "      <td>25989</td>\n",
       "      <td>25986</td>\n",
       "      <td>25976</td>\n",
       "      <td>...</td>\n",
       "      <td>6.339327</td>\n",
       "      <td>1.113180</td>\n",
       "      <td>5.488706</td>\n",
       "      <td>-0.076806</td>\n",
       "      <td>-3.239866</td>\n",
       "      <td>6.416167</td>\n",
       "      <td>1.420264</td>\n",
       "      <td>5.757384</td>\n",
       "      <td>0.230419</td>\n",
       "      <td>-2.931307</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Chilton County</td>\n",
       "      <td>43643</td>\n",
       "      <td>43631</td>\n",
       "      <td>43665</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.372935</td>\n",
       "      <td>-2.653369</td>\n",
       "      <td>0.480044</td>\n",
       "      <td>0.456017</td>\n",
       "      <td>-2.253483</td>\n",
       "      <td>-0.823761</td>\n",
       "      <td>-2.447504</td>\n",
       "      <td>0.868651</td>\n",
       "      <td>0.957636</td>\n",
       "      <td>-1.752709</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>23</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Choctaw County</td>\n",
       "      <td>13859</td>\n",
       "      <td>13858</td>\n",
       "      <td>13841</td>\n",
       "      <td>...</td>\n",
       "      <td>-15.455274</td>\n",
       "      <td>-0.737028</td>\n",
       "      <td>-8.766391</td>\n",
       "      <td>-1.274984</td>\n",
       "      <td>-5.291205</td>\n",
       "      <td>-15.528177</td>\n",
       "      <td>-0.737028</td>\n",
       "      <td>-8.766391</td>\n",
       "      <td>-1.274984</td>\n",
       "      <td>-5.291205</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>25</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Clarke County</td>\n",
       "      <td>25833</td>\n",
       "      <td>25840</td>\n",
       "      <td>25767</td>\n",
       "      <td>...</td>\n",
       "      <td>-6.194363</td>\n",
       "      <td>-17.667705</td>\n",
       "      <td>-0.318345</td>\n",
       "      <td>-8.686428</td>\n",
       "      <td>-5.613667</td>\n",
       "      <td>-6.077488</td>\n",
       "      <td>-17.509958</td>\n",
       "      <td>-0.159172</td>\n",
       "      <td>-8.486280</td>\n",
       "      <td>-5.411736</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Clay County</td>\n",
       "      <td>13932</td>\n",
       "      <td>13932</td>\n",
       "      <td>13880</td>\n",
       "      <td>...</td>\n",
       "      <td>-10.744102</td>\n",
       "      <td>-13.345130</td>\n",
       "      <td>4.902871</td>\n",
       "      <td>5.702648</td>\n",
       "      <td>3.912450</td>\n",
       "      <td>-10.816697</td>\n",
       "      <td>-13.345130</td>\n",
       "      <td>4.977157</td>\n",
       "      <td>5.776708</td>\n",
       "      <td>3.986270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>29</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Cleburne County</td>\n",
       "      <td>14972</td>\n",
       "      <td>14972</td>\n",
       "      <td>14973</td>\n",
       "      <td>...</td>\n",
       "      <td>-3.673524</td>\n",
       "      <td>-5.151880</td>\n",
       "      <td>7.345821</td>\n",
       "      <td>3.654485</td>\n",
       "      <td>-3.123961</td>\n",
       "      <td>-3.673524</td>\n",
       "      <td>-5.151880</td>\n",
       "      <td>7.345821</td>\n",
       "      <td>3.654485</td>\n",
       "      <td>-3.123961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>31</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Coffee County</td>\n",
       "      <td>49948</td>\n",
       "      <td>49948</td>\n",
       "      <td>50177</td>\n",
       "      <td>...</td>\n",
       "      <td>0.377640</td>\n",
       "      <td>7.675579</td>\n",
       "      <td>-13.146535</td>\n",
       "      <td>-3.602859</td>\n",
       "      <td>2.214774</td>\n",
       "      <td>2.166460</td>\n",
       "      <td>11.513368</td>\n",
       "      <td>-10.438741</td>\n",
       "      <td>-0.767822</td>\n",
       "      <td>5.350738</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>33</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Colbert County</td>\n",
       "      <td>54428</td>\n",
       "      <td>54428</td>\n",
       "      <td>54514</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.073423</td>\n",
       "      <td>1.065051</td>\n",
       "      <td>1.762390</td>\n",
       "      <td>1.835688</td>\n",
       "      <td>-0.110260</td>\n",
       "      <td>0.513964</td>\n",
       "      <td>1.469035</td>\n",
       "      <td>2.276420</td>\n",
       "      <td>2.533249</td>\n",
       "      <td>0.588052</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>35</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Conecuh County</td>\n",
       "      <td>13228</td>\n",
       "      <td>13228</td>\n",
       "      <td>13208</td>\n",
       "      <td>...</td>\n",
       "      <td>-4.861559</td>\n",
       "      <td>-7.504690</td>\n",
       "      <td>-6.107224</td>\n",
       "      <td>-14.645416</td>\n",
       "      <td>2.684140</td>\n",
       "      <td>-4.861559</td>\n",
       "      <td>-7.504690</td>\n",
       "      <td>-6.107224</td>\n",
       "      <td>-14.645416</td>\n",
       "      <td>2.684140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>37</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Coosa County</td>\n",
       "      <td>11539</td>\n",
       "      <td>11758</td>\n",
       "      <td>11758</td>\n",
       "      <td>...</td>\n",
       "      <td>-33.930581</td>\n",
       "      <td>-10.291443</td>\n",
       "      <td>-4.313831</td>\n",
       "      <td>-22.958017</td>\n",
       "      <td>-5.387581</td>\n",
       "      <td>-34.017138</td>\n",
       "      <td>-10.380162</td>\n",
       "      <td>-4.403703</td>\n",
       "      <td>-23.049483</td>\n",
       "      <td>-5.387581</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>39</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Covington County</td>\n",
       "      <td>37765</td>\n",
       "      <td>37765</td>\n",
       "      <td>37796</td>\n",
       "      <td>...</td>\n",
       "      <td>6.696899</td>\n",
       "      <td>-4.612668</td>\n",
       "      <td>0.740271</td>\n",
       "      <td>3.697932</td>\n",
       "      <td>-0.316945</td>\n",
       "      <td>6.881460</td>\n",
       "      <td>-4.559952</td>\n",
       "      <td>0.793147</td>\n",
       "      <td>3.750759</td>\n",
       "      <td>-0.264121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>41</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Crenshaw County</td>\n",
       "      <td>13906</td>\n",
       "      <td>13906</td>\n",
       "      <td>13853</td>\n",
       "      <td>...</td>\n",
       "      <td>1.729792</td>\n",
       "      <td>3.950156</td>\n",
       "      <td>-1.864936</td>\n",
       "      <td>3.084648</td>\n",
       "      <td>3.439504</td>\n",
       "      <td>2.666763</td>\n",
       "      <td>5.099293</td>\n",
       "      <td>-0.502098</td>\n",
       "      <td>4.734577</td>\n",
       "      <td>5.087600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>43</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Cullman County</td>\n",
       "      <td>80406</td>\n",
       "      <td>80410</td>\n",
       "      <td>80473</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.404233</td>\n",
       "      <td>-1.019628</td>\n",
       "      <td>4.071247</td>\n",
       "      <td>5.087142</td>\n",
       "      <td>7.915406</td>\n",
       "      <td>-1.031427</td>\n",
       "      <td>-0.634159</td>\n",
       "      <td>4.542916</td>\n",
       "      <td>5.593387</td>\n",
       "      <td>8.417777</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>45</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Dale County</td>\n",
       "      <td>50251</td>\n",
       "      <td>50251</td>\n",
       "      <td>50358</td>\n",
       "      <td>...</td>\n",
       "      <td>-10.749798</td>\n",
       "      <td>-5.277150</td>\n",
       "      <td>-15.236079</td>\n",
       "      <td>-11.979785</td>\n",
       "      <td>-5.107706</td>\n",
       "      <td>-9.575283</td>\n",
       "      <td>-0.776637</td>\n",
       "      <td>-12.640155</td>\n",
       "      <td>-9.503292</td>\n",
       "      <td>-1.998668</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>47</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Dallas County</td>\n",
       "      <td>43820</td>\n",
       "      <td>43820</td>\n",
       "      <td>43803</td>\n",
       "      <td>...</td>\n",
       "      <td>-15.635599</td>\n",
       "      <td>-11.308243</td>\n",
       "      <td>-16.745678</td>\n",
       "      <td>-9.344789</td>\n",
       "      <td>-14.687232</td>\n",
       "      <td>-15.727573</td>\n",
       "      <td>-11.378047</td>\n",
       "      <td>-16.792849</td>\n",
       "      <td>-9.368689</td>\n",
       "      <td>-14.711389</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>49</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>DeKalb County</td>\n",
       "      <td>71109</td>\n",
       "      <td>71115</td>\n",
       "      <td>71142</td>\n",
       "      <td>...</td>\n",
       "      <td>0.294677</td>\n",
       "      <td>-9.302391</td>\n",
       "      <td>-1.748807</td>\n",
       "      <td>0.267830</td>\n",
       "      <td>0.028141</td>\n",
       "      <td>1.375159</td>\n",
       "      <td>-8.656001</td>\n",
       "      <td>-1.029539</td>\n",
       "      <td>1.198187</td>\n",
       "      <td>0.956790</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>51</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Elmore County</td>\n",
       "      <td>79303</td>\n",
       "      <td>79296</td>\n",
       "      <td>79465</td>\n",
       "      <td>...</td>\n",
       "      <td>3.235576</td>\n",
       "      <td>0.822717</td>\n",
       "      <td>1.760531</td>\n",
       "      <td>-1.507057</td>\n",
       "      <td>2.067820</td>\n",
       "      <td>3.674511</td>\n",
       "      <td>1.558176</td>\n",
       "      <td>2.306047</td>\n",
       "      <td>-0.951175</td>\n",
       "      <td>2.757093</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>53</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Escambia County</td>\n",
       "      <td>38319</td>\n",
       "      <td>38319</td>\n",
       "      <td>38309</td>\n",
       "      <td>...</td>\n",
       "      <td>-3.449988</td>\n",
       "      <td>-3.855889</td>\n",
       "      <td>-4.822706</td>\n",
       "      <td>-1.189831</td>\n",
       "      <td>1.190902</td>\n",
       "      <td>-3.397716</td>\n",
       "      <td>-3.803428</td>\n",
       "      <td>-4.769999</td>\n",
       "      <td>-1.136950</td>\n",
       "      <td>1.243830</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>55</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Etowah County</td>\n",
       "      <td>104430</td>\n",
       "      <td>104427</td>\n",
       "      <td>104442</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.015919</td>\n",
       "      <td>2.062637</td>\n",
       "      <td>-1.931884</td>\n",
       "      <td>-1.726932</td>\n",
       "      <td>-2.082234</td>\n",
       "      <td>-0.632554</td>\n",
       "      <td>2.446383</td>\n",
       "      <td>-1.518596</td>\n",
       "      <td>-1.234901</td>\n",
       "      <td>-1.588308</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>57</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Fayette County</td>\n",
       "      <td>17241</td>\n",
       "      <td>17241</td>\n",
       "      <td>17231</td>\n",
       "      <td>...</td>\n",
       "      <td>-5.015601</td>\n",
       "      <td>-0.646640</td>\n",
       "      <td>-3.725937</td>\n",
       "      <td>0.296745</td>\n",
       "      <td>-2.797536</td>\n",
       "      <td>-5.132243</td>\n",
       "      <td>-0.705426</td>\n",
       "      <td>-3.785079</td>\n",
       "      <td>0.237396</td>\n",
       "      <td>-2.857058</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",
       "      <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>3163</th>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>55</td>\n",
       "      <td>131</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Washington County</td>\n",
       "      <td>131887</td>\n",
       "      <td>131885</td>\n",
       "      <td>131967</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.794876</td>\n",
       "      <td>0.785279</td>\n",
       "      <td>-2.215465</td>\n",
       "      <td>1.601149</td>\n",
       "      <td>-0.434498</td>\n",
       "      <td>-0.431504</td>\n",
       "      <td>1.162817</td>\n",
       "      <td>-1.763330</td>\n",
       "      <td>2.104796</td>\n",
       "      <td>0.059931</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3164</th>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>55</td>\n",
       "      <td>133</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Waukesha County</td>\n",
       "      <td>389891</td>\n",
       "      <td>389938</td>\n",
       "      <td>390076</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.765799</td>\n",
       "      <td>2.128860</td>\n",
       "      <td>0.038132</td>\n",
       "      <td>0.760109</td>\n",
       "      <td>-0.719858</td>\n",
       "      <td>0.102448</td>\n",
       "      <td>3.180527</td>\n",
       "      <td>1.189727</td>\n",
       "      <td>2.077633</td>\n",
       "      <td>0.593567</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3165</th>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>55</td>\n",
       "      <td>135</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Waupaca County</td>\n",
       "      <td>52410</td>\n",
       "      <td>52410</td>\n",
       "      <td>52422</td>\n",
       "      <td>...</td>\n",
       "      <td>3.111756</td>\n",
       "      <td>-2.241873</td>\n",
       "      <td>6.292687</td>\n",
       "      <td>-0.441031</td>\n",
       "      <td>-0.480617</td>\n",
       "      <td>3.359933</td>\n",
       "      <td>-2.011937</td>\n",
       "      <td>6.561277</td>\n",
       "      <td>-0.134227</td>\n",
       "      <td>-0.173022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3166</th>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>55</td>\n",
       "      <td>137</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Waushara County</td>\n",
       "      <td>24496</td>\n",
       "      <td>24496</td>\n",
       "      <td>24506</td>\n",
       "      <td>...</td>\n",
       "      <td>4.930022</td>\n",
       "      <td>-2.404973</td>\n",
       "      <td>-4.097017</td>\n",
       "      <td>-4.906711</td>\n",
       "      <td>-4.397793</td>\n",
       "      <td>5.174486</td>\n",
       "      <td>-2.160399</td>\n",
       "      <td>-3.810226</td>\n",
       "      <td>-4.535615</td>\n",
       "      <td>-4.024395</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3167</th>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>55</td>\n",
       "      <td>139</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Winnebago County</td>\n",
       "      <td>166994</td>\n",
       "      <td>166994</td>\n",
       "      <td>167059</td>\n",
       "      <td>...</td>\n",
       "      <td>0.316712</td>\n",
       "      <td>2.889873</td>\n",
       "      <td>0.833819</td>\n",
       "      <td>-2.406192</td>\n",
       "      <td>-4.557985</td>\n",
       "      <td>0.842573</td>\n",
       "      <td>3.502335</td>\n",
       "      <td>1.531624</td>\n",
       "      <td>-1.545153</td>\n",
       "      <td>-3.685304</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3168</th>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>55</td>\n",
       "      <td>141</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Wood County</td>\n",
       "      <td>74749</td>\n",
       "      <td>74749</td>\n",
       "      <td>74807</td>\n",
       "      <td>...</td>\n",
       "      <td>-4.081523</td>\n",
       "      <td>-5.019090</td>\n",
       "      <td>-6.901200</td>\n",
       "      <td>-5.596471</td>\n",
       "      <td>-3.958322</td>\n",
       "      <td>-3.733590</td>\n",
       "      <td>-4.562809</td>\n",
       "      <td>-6.442917</td>\n",
       "      <td>-5.040889</td>\n",
       "      <td>-3.414223</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3169</th>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>0</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>563626</td>\n",
       "      <td>563767</td>\n",
       "      <td>564516</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.381530</td>\n",
       "      <td>9.636214</td>\n",
       "      <td>4.487115</td>\n",
       "      <td>-4.788275</td>\n",
       "      <td>-3.221091</td>\n",
       "      <td>0.289680</td>\n",
       "      <td>10.694870</td>\n",
       "      <td>5.440390</td>\n",
       "      <td>-3.727831</td>\n",
       "      <td>-2.091573</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3170</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>1</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Albany County</td>\n",
       "      <td>36299</td>\n",
       "      <td>36299</td>\n",
       "      <td>36428</td>\n",
       "      <td>...</td>\n",
       "      <td>3.708956</td>\n",
       "      <td>2.637812</td>\n",
       "      <td>-3.544634</td>\n",
       "      <td>-3.334877</td>\n",
       "      <td>-9.911169</td>\n",
       "      <td>6.736119</td>\n",
       "      <td>6.433032</td>\n",
       "      <td>0.719587</td>\n",
       "      <td>1.429233</td>\n",
       "      <td>-5.166460</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3171</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>3</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Big Horn County</td>\n",
       "      <td>11668</td>\n",
       "      <td>11668</td>\n",
       "      <td>11672</td>\n",
       "      <td>...</td>\n",
       "      <td>4.868258</td>\n",
       "      <td>2.804930</td>\n",
       "      <td>16.815908</td>\n",
       "      <td>-8.026420</td>\n",
       "      <td>5.095861</td>\n",
       "      <td>4.868258</td>\n",
       "      <td>3.144921</td>\n",
       "      <td>17.236306</td>\n",
       "      <td>-7.608378</td>\n",
       "      <td>5.513554</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3172</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>5</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Campbell County</td>\n",
       "      <td>46133</td>\n",
       "      <td>46133</td>\n",
       "      <td>46244</td>\n",
       "      <td>...</td>\n",
       "      <td>-2.843479</td>\n",
       "      <td>15.601020</td>\n",
       "      <td>-5.895711</td>\n",
       "      <td>-8.550911</td>\n",
       "      <td>10.916963</td>\n",
       "      <td>-2.649606</td>\n",
       "      <td>15.558684</td>\n",
       "      <td>-5.916543</td>\n",
       "      <td>-8.509402</td>\n",
       "      <td>10.978525</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3173</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>7</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Carbon County</td>\n",
       "      <td>15885</td>\n",
       "      <td>15885</td>\n",
       "      <td>15837</td>\n",
       "      <td>...</td>\n",
       "      <td>-7.581980</td>\n",
       "      <td>-13.081441</td>\n",
       "      <td>3.178134</td>\n",
       "      <td>-2.970641</td>\n",
       "      <td>-23.300971</td>\n",
       "      <td>-7.392431</td>\n",
       "      <td>-12.636926</td>\n",
       "      <td>3.623073</td>\n",
       "      <td>-2.338590</td>\n",
       "      <td>-22.600668</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3174</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>9</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Converse County</td>\n",
       "      <td>13833</td>\n",
       "      <td>13833</td>\n",
       "      <td>13826</td>\n",
       "      <td>...</td>\n",
       "      <td>-12.847499</td>\n",
       "      <td>15.493820</td>\n",
       "      <td>19.035533</td>\n",
       "      <td>-20.550587</td>\n",
       "      <td>-0.070403</td>\n",
       "      <td>-12.774915</td>\n",
       "      <td>16.502720</td>\n",
       "      <td>20.093063</td>\n",
       "      <td>-19.358233</td>\n",
       "      <td>1.126443</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3175</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>11</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Crook County</td>\n",
       "      <td>7083</td>\n",
       "      <td>7083</td>\n",
       "      <td>7114</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.544618</td>\n",
       "      <td>-4.202564</td>\n",
       "      <td>1.397819</td>\n",
       "      <td>6.378258</td>\n",
       "      <td>18.629317</td>\n",
       "      <td>-0.982939</td>\n",
       "      <td>-3.642222</td>\n",
       "      <td>2.096729</td>\n",
       "      <td>7.071547</td>\n",
       "      <td>19.309219</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3176</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>13</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Fremont County</td>\n",
       "      <td>40123</td>\n",
       "      <td>40123</td>\n",
       "      <td>40222</td>\n",
       "      <td>...</td>\n",
       "      <td>2.747083</td>\n",
       "      <td>7.782673</td>\n",
       "      <td>-4.990688</td>\n",
       "      <td>-12.331633</td>\n",
       "      <td>-13.673610</td>\n",
       "      <td>3.093562</td>\n",
       "      <td>8.027411</td>\n",
       "      <td>-4.747240</td>\n",
       "      <td>-12.013555</td>\n",
       "      <td>-13.352750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3177</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>15</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Goshen County</td>\n",
       "      <td>13249</td>\n",
       "      <td>13247</td>\n",
       "      <td>13408</td>\n",
       "      <td>...</td>\n",
       "      <td>14.293649</td>\n",
       "      <td>3.961413</td>\n",
       "      <td>-8.079028</td>\n",
       "      <td>-7.017803</td>\n",
       "      <td>-11.899450</td>\n",
       "      <td>14.886132</td>\n",
       "      <td>4.841727</td>\n",
       "      <td>-6.903896</td>\n",
       "      <td>-5.761986</td>\n",
       "      <td>-10.635133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3178</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>17</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Hot Springs County</td>\n",
       "      <td>4812</td>\n",
       "      <td>4812</td>\n",
       "      <td>4813</td>\n",
       "      <td>...</td>\n",
       "      <td>3.322604</td>\n",
       "      <td>6.208609</td>\n",
       "      <td>3.095336</td>\n",
       "      <td>-6.017222</td>\n",
       "      <td>-5.454164</td>\n",
       "      <td>5.191569</td>\n",
       "      <td>6.001656</td>\n",
       "      <td>2.888981</td>\n",
       "      <td>-6.224712</td>\n",
       "      <td>-5.663940</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3179</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>19</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Johnson County</td>\n",
       "      <td>8569</td>\n",
       "      <td>8569</td>\n",
       "      <td>8581</td>\n",
       "      <td>...</td>\n",
       "      <td>4.995063</td>\n",
       "      <td>-4.058912</td>\n",
       "      <td>-0.812583</td>\n",
       "      <td>-10.715742</td>\n",
       "      <td>0.933652</td>\n",
       "      <td>5.227392</td>\n",
       "      <td>-4.058912</td>\n",
       "      <td>-0.812583</td>\n",
       "      <td>-10.715742</td>\n",
       "      <td>0.933652</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3180</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>21</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Laramie County</td>\n",
       "      <td>91738</td>\n",
       "      <td>91881</td>\n",
       "      <td>92271</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.200428</td>\n",
       "      <td>15.547274</td>\n",
       "      <td>4.787847</td>\n",
       "      <td>-1.226133</td>\n",
       "      <td>0.278940</td>\n",
       "      <td>-0.973320</td>\n",
       "      <td>17.914554</td>\n",
       "      <td>6.003143</td>\n",
       "      <td>-0.207819</td>\n",
       "      <td>1.673640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3181</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>23</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Lincoln County</td>\n",
       "      <td>18106</td>\n",
       "      <td>18106</td>\n",
       "      <td>18091</td>\n",
       "      <td>...</td>\n",
       "      <td>-9.802564</td>\n",
       "      <td>-11.566801</td>\n",
       "      <td>13.564556</td>\n",
       "      <td>6.125989</td>\n",
       "      <td>1.555544</td>\n",
       "      <td>-9.691801</td>\n",
       "      <td>-11.566801</td>\n",
       "      <td>13.619696</td>\n",
       "      <td>6.234414</td>\n",
       "      <td>1.662823</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3182</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>25</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Natrona County</td>\n",
       "      <td>75450</td>\n",
       "      <td>75450</td>\n",
       "      <td>75472</td>\n",
       "      <td>...</td>\n",
       "      <td>7.189319</td>\n",
       "      <td>23.066162</td>\n",
       "      <td>24.322042</td>\n",
       "      <td>-0.958472</td>\n",
       "      <td>-0.061057</td>\n",
       "      <td>7.689674</td>\n",
       "      <td>23.749508</td>\n",
       "      <td>25.085233</td>\n",
       "      <td>-0.110593</td>\n",
       "      <td>0.793743</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3183</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>27</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Niobrara County</td>\n",
       "      <td>2484</td>\n",
       "      <td>2484</td>\n",
       "      <td>2492</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.401849</td>\n",
       "      <td>0.806452</td>\n",
       "      <td>29.066295</td>\n",
       "      <td>-12.603387</td>\n",
       "      <td>7.492114</td>\n",
       "      <td>-0.401849</td>\n",
       "      <td>0.806452</td>\n",
       "      <td>29.066295</td>\n",
       "      <td>-12.603387</td>\n",
       "      <td>7.492114</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3184</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>29</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Park County</td>\n",
       "      <td>28205</td>\n",
       "      <td>28205</td>\n",
       "      <td>28259</td>\n",
       "      <td>...</td>\n",
       "      <td>4.582951</td>\n",
       "      <td>8.057765</td>\n",
       "      <td>7.641997</td>\n",
       "      <td>-9.252437</td>\n",
       "      <td>-2.878980</td>\n",
       "      <td>6.486639</td>\n",
       "      <td>11.127389</td>\n",
       "      <td>10.877797</td>\n",
       "      <td>-5.585731</td>\n",
       "      <td>0.856839</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3185</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>31</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Platte County</td>\n",
       "      <td>8667</td>\n",
       "      <td>8667</td>\n",
       "      <td>8678</td>\n",
       "      <td>...</td>\n",
       "      <td>4.373094</td>\n",
       "      <td>5.392073</td>\n",
       "      <td>2.634593</td>\n",
       "      <td>6.055759</td>\n",
       "      <td>4.662270</td>\n",
       "      <td>4.373094</td>\n",
       "      <td>4.933173</td>\n",
       "      <td>2.176403</td>\n",
       "      <td>5.598720</td>\n",
       "      <td>4.207414</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3186</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>33</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Sheridan County</td>\n",
       "      <td>29116</td>\n",
       "      <td>29116</td>\n",
       "      <td>29146</td>\n",
       "      <td>...</td>\n",
       "      <td>0.958559</td>\n",
       "      <td>8.425487</td>\n",
       "      <td>4.546373</td>\n",
       "      <td>3.678069</td>\n",
       "      <td>-3.298406</td>\n",
       "      <td>2.122524</td>\n",
       "      <td>9.342778</td>\n",
       "      <td>5.523001</td>\n",
       "      <td>4.781489</td>\n",
       "      <td>-2.198937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3187</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>35</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Sublette County</td>\n",
       "      <td>10247</td>\n",
       "      <td>10247</td>\n",
       "      <td>10244</td>\n",
       "      <td>...</td>\n",
       "      <td>-23.741784</td>\n",
       "      <td>15.272374</td>\n",
       "      <td>-40.870074</td>\n",
       "      <td>-16.596273</td>\n",
       "      <td>-22.870900</td>\n",
       "      <td>-21.092907</td>\n",
       "      <td>16.828794</td>\n",
       "      <td>-39.211861</td>\n",
       "      <td>-14.409938</td>\n",
       "      <td>-20.664059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3188</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>37</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Sweetwater County</td>\n",
       "      <td>43806</td>\n",
       "      <td>43806</td>\n",
       "      <td>43593</td>\n",
       "      <td>...</td>\n",
       "      <td>1.072643</td>\n",
       "      <td>16.243199</td>\n",
       "      <td>-5.339774</td>\n",
       "      <td>-14.252889</td>\n",
       "      <td>-14.248864</td>\n",
       "      <td>1.255221</td>\n",
       "      <td>16.243199</td>\n",
       "      <td>-5.295460</td>\n",
       "      <td>-14.075283</td>\n",
       "      <td>-14.070195</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3189</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>39</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Teton County</td>\n",
       "      <td>21294</td>\n",
       "      <td>21294</td>\n",
       "      <td>21297</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.589565</td>\n",
       "      <td>0.972695</td>\n",
       "      <td>19.525929</td>\n",
       "      <td>14.143021</td>\n",
       "      <td>-0.564849</td>\n",
       "      <td>0.654527</td>\n",
       "      <td>2.408578</td>\n",
       "      <td>21.160658</td>\n",
       "      <td>16.308671</td>\n",
       "      <td>1.520747</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3190</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>41</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Uinta County</td>\n",
       "      <td>21118</td>\n",
       "      <td>21118</td>\n",
       "      <td>21102</td>\n",
       "      <td>...</td>\n",
       "      <td>-17.755986</td>\n",
       "      <td>-4.916350</td>\n",
       "      <td>-6.902954</td>\n",
       "      <td>-14.215862</td>\n",
       "      <td>-12.127022</td>\n",
       "      <td>-18.136812</td>\n",
       "      <td>-5.536861</td>\n",
       "      <td>-7.521840</td>\n",
       "      <td>-14.740608</td>\n",
       "      <td>-12.606351</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3191</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>43</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Washakie County</td>\n",
       "      <td>8533</td>\n",
       "      <td>8533</td>\n",
       "      <td>8545</td>\n",
       "      <td>...</td>\n",
       "      <td>-11.637475</td>\n",
       "      <td>-0.827815</td>\n",
       "      <td>-2.013502</td>\n",
       "      <td>-17.781491</td>\n",
       "      <td>1.682288</td>\n",
       "      <td>-11.990126</td>\n",
       "      <td>-1.182592</td>\n",
       "      <td>-2.250385</td>\n",
       "      <td>-18.020168</td>\n",
       "      <td>1.441961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3192</th>\n",
       "      <td>50</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>56</td>\n",
       "      <td>45</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Weston County</td>\n",
       "      <td>7208</td>\n",
       "      <td>7208</td>\n",
       "      <td>7181</td>\n",
       "      <td>...</td>\n",
       "      <td>-11.752361</td>\n",
       "      <td>-8.040059</td>\n",
       "      <td>12.372583</td>\n",
       "      <td>1.533635</td>\n",
       "      <td>6.935294</td>\n",
       "      <td>-12.032179</td>\n",
       "      <td>-8.040059</td>\n",
       "      <td>12.372583</td>\n",
       "      <td>1.533635</td>\n",
       "      <td>6.935294</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3193 rows × 100 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      SUMLEV  REGION  DIVISION  STATE  COUNTY     STNAME             CTYNAME  \\\n",
       "0         40       3         6      1       0    Alabama             Alabama   \n",
       "1         50       3         6      1       1    Alabama      Autauga County   \n",
       "2         50       3         6      1       3    Alabama      Baldwin County   \n",
       "3         50       3         6      1       5    Alabama      Barbour County   \n",
       "4         50       3         6      1       7    Alabama         Bibb County   \n",
       "5         50       3         6      1       9    Alabama       Blount County   \n",
       "6         50       3         6      1      11    Alabama      Bullock County   \n",
       "7         50       3         6      1      13    Alabama       Butler County   \n",
       "8         50       3         6      1      15    Alabama      Calhoun County   \n",
       "9         50       3         6      1      17    Alabama     Chambers County   \n",
       "10        50       3         6      1      19    Alabama     Cherokee County   \n",
       "11        50       3         6      1      21    Alabama      Chilton County   \n",
       "12        50       3         6      1      23    Alabama      Choctaw County   \n",
       "13        50       3         6      1      25    Alabama       Clarke County   \n",
       "14        50       3         6      1      27    Alabama         Clay County   \n",
       "15        50       3         6      1      29    Alabama     Cleburne County   \n",
       "16        50       3         6      1      31    Alabama       Coffee County   \n",
       "17        50       3         6      1      33    Alabama      Colbert County   \n",
       "18        50       3         6      1      35    Alabama      Conecuh County   \n",
       "19        50       3         6      1      37    Alabama        Coosa County   \n",
       "20        50       3         6      1      39    Alabama    Covington County   \n",
       "21        50       3         6      1      41    Alabama     Crenshaw County   \n",
       "22        50       3         6      1      43    Alabama      Cullman County   \n",
       "23        50       3         6      1      45    Alabama         Dale County   \n",
       "24        50       3         6      1      47    Alabama       Dallas County   \n",
       "25        50       3         6      1      49    Alabama       DeKalb County   \n",
       "26        50       3         6      1      51    Alabama       Elmore County   \n",
       "27        50       3         6      1      53    Alabama     Escambia County   \n",
       "28        50       3         6      1      55    Alabama       Etowah County   \n",
       "29        50       3         6      1      57    Alabama      Fayette County   \n",
       "...      ...     ...       ...    ...     ...        ...                 ...   \n",
       "3163      50       2         3     55     131  Wisconsin   Washington County   \n",
       "3164      50       2         3     55     133  Wisconsin     Waukesha County   \n",
       "3165      50       2         3     55     135  Wisconsin      Waupaca County   \n",
       "3166      50       2         3     55     137  Wisconsin     Waushara County   \n",
       "3167      50       2         3     55     139  Wisconsin    Winnebago County   \n",
       "3168      50       2         3     55     141  Wisconsin         Wood County   \n",
       "3169      40       4         8     56       0    Wyoming             Wyoming   \n",
       "3170      50       4         8     56       1    Wyoming       Albany County   \n",
       "3171      50       4         8     56       3    Wyoming     Big Horn County   \n",
       "3172      50       4         8     56       5    Wyoming     Campbell County   \n",
       "3173      50       4         8     56       7    Wyoming       Carbon County   \n",
       "3174      50       4         8     56       9    Wyoming     Converse County   \n",
       "3175      50       4         8     56      11    Wyoming        Crook County   \n",
       "3176      50       4         8     56      13    Wyoming      Fremont County   \n",
       "3177      50       4         8     56      15    Wyoming       Goshen County   \n",
       "3178      50       4         8     56      17    Wyoming  Hot Springs County   \n",
       "3179      50       4         8     56      19    Wyoming      Johnson County   \n",
       "3180      50       4         8     56      21    Wyoming      Laramie County   \n",
       "3181      50       4         8     56      23    Wyoming      Lincoln County   \n",
       "3182      50       4         8     56      25    Wyoming      Natrona County   \n",
       "3183      50       4         8     56      27    Wyoming     Niobrara County   \n",
       "3184      50       4         8     56      29    Wyoming         Park County   \n",
       "3185      50       4         8     56      31    Wyoming       Platte County   \n",
       "3186      50       4         8     56      33    Wyoming     Sheridan County   \n",
       "3187      50       4         8     56      35    Wyoming     Sublette County   \n",
       "3188      50       4         8     56      37    Wyoming   Sweetwater County   \n",
       "3189      50       4         8     56      39    Wyoming        Teton County   \n",
       "3190      50       4         8     56      41    Wyoming        Uinta County   \n",
       "3191      50       4         8     56      43    Wyoming     Washakie County   \n",
       "3192      50       4         8     56      45    Wyoming       Weston County   \n",
       "\n",
       "      CENSUS2010POP  ESTIMATESBASE2010  POPESTIMATE2010     ...       \\\n",
       "0           4779736            4780127          4785161     ...        \n",
       "1             54571              54571            54660     ...        \n",
       "2            182265             182265           183193     ...        \n",
       "3             27457              27457            27341     ...        \n",
       "4             22915              22919            22861     ...        \n",
       "5             57322              57322            57373     ...        \n",
       "6             10914              10915            10887     ...        \n",
       "7             20947              20946            20944     ...        \n",
       "8            118572             118586           118437     ...        \n",
       "9             34215              34170            34098     ...        \n",
       "10            25989              25986            25976     ...        \n",
       "11            43643              43631            43665     ...        \n",
       "12            13859              13858            13841     ...        \n",
       "13            25833              25840            25767     ...        \n",
       "14            13932              13932            13880     ...        \n",
       "15            14972              14972            14973     ...        \n",
       "16            49948              49948            50177     ...        \n",
       "17            54428              54428            54514     ...        \n",
       "18            13228              13228            13208     ...        \n",
       "19            11539              11758            11758     ...        \n",
       "20            37765              37765            37796     ...        \n",
       "21            13906              13906            13853     ...        \n",
       "22            80406              80410            80473     ...        \n",
       "23            50251              50251            50358     ...        \n",
       "24            43820              43820            43803     ...        \n",
       "25            71109              71115            71142     ...        \n",
       "26            79303              79296            79465     ...        \n",
       "27            38319              38319            38309     ...        \n",
       "28           104430             104427           104442     ...        \n",
       "29            17241              17241            17231     ...        \n",
       "...             ...                ...              ...     ...        \n",
       "3163         131887             131885           131967     ...        \n",
       "3164         389891             389938           390076     ...        \n",
       "3165          52410              52410            52422     ...        \n",
       "3166          24496              24496            24506     ...        \n",
       "3167         166994             166994           167059     ...        \n",
       "3168          74749              74749            74807     ...        \n",
       "3169         563626             563767           564516     ...        \n",
       "3170          36299              36299            36428     ...        \n",
       "3171          11668              11668            11672     ...        \n",
       "3172          46133              46133            46244     ...        \n",
       "3173          15885              15885            15837     ...        \n",
       "3174          13833              13833            13826     ...        \n",
       "3175           7083               7083             7114     ...        \n",
       "3176          40123              40123            40222     ...        \n",
       "3177          13249              13247            13408     ...        \n",
       "3178           4812               4812             4813     ...        \n",
       "3179           8569               8569             8581     ...        \n",
       "3180          91738              91881            92271     ...        \n",
       "3181          18106              18106            18091     ...        \n",
       "3182          75450              75450            75472     ...        \n",
       "3183           2484               2484             2492     ...        \n",
       "3184          28205              28205            28259     ...        \n",
       "3185           8667               8667             8678     ...        \n",
       "3186          29116              29116            29146     ...        \n",
       "3187          10247              10247            10244     ...        \n",
       "3188          43806              43806            43593     ...        \n",
       "3189          21294              21294            21297     ...        \n",
       "3190          21118              21118            21102     ...        \n",
       "3191           8533               8533             8545     ...        \n",
       "3192           7208               7208             7181     ...        \n",
       "\n",
       "      RDOMESTICMIG2011  RDOMESTICMIG2012  RDOMESTICMIG2013  RDOMESTICMIG2014  \\\n",
       "0             0.002295         -0.193196          0.381066          0.582002   \n",
       "1             7.242091         -2.915927         -3.012349          2.265971   \n",
       "2            14.832960         17.647293         21.845705         19.243287   \n",
       "3            -4.728132         -2.500690         -7.056824         -3.904217   \n",
       "4            -5.527043         -5.068871         -6.201001         -0.177537   \n",
       "5             1.807375         -1.177622         -1.748766         -2.062535   \n",
       "6           -30.953709         -5.180127         -1.130263         14.354290   \n",
       "7           -14.032727        -11.684234         -5.655413          1.085428   \n",
       "8            -6.155670         -4.611706         -5.524649         -4.463211   \n",
       "9            -2.731639          3.849092          2.872721         -2.287222   \n",
       "10            6.339327          1.113180          5.488706         -0.076806   \n",
       "11           -1.372935         -2.653369          0.480044          0.456017   \n",
       "12          -15.455274         -0.737028         -8.766391         -1.274984   \n",
       "13           -6.194363        -17.667705         -0.318345         -8.686428   \n",
       "14          -10.744102        -13.345130          4.902871          5.702648   \n",
       "15           -3.673524         -5.151880          7.345821          3.654485   \n",
       "16            0.377640          7.675579        -13.146535         -3.602859   \n",
       "17           -0.073423          1.065051          1.762390          1.835688   \n",
       "18           -4.861559         -7.504690         -6.107224        -14.645416   \n",
       "19          -33.930581        -10.291443         -4.313831        -22.958017   \n",
       "20            6.696899         -4.612668          0.740271          3.697932   \n",
       "21            1.729792          3.950156         -1.864936          3.084648   \n",
       "22           -1.404233         -1.019628          4.071247          5.087142   \n",
       "23          -10.749798         -5.277150        -15.236079        -11.979785   \n",
       "24          -15.635599        -11.308243        -16.745678         -9.344789   \n",
       "25            0.294677         -9.302391         -1.748807          0.267830   \n",
       "26            3.235576          0.822717          1.760531         -1.507057   \n",
       "27           -3.449988         -3.855889         -4.822706         -1.189831   \n",
       "28           -1.015919          2.062637         -1.931884         -1.726932   \n",
       "29           -5.015601         -0.646640         -3.725937          0.296745   \n",
       "...                ...               ...               ...               ...   \n",
       "3163         -0.794876          0.785279         -2.215465          1.601149   \n",
       "3164         -0.765799          2.128860          0.038132          0.760109   \n",
       "3165          3.111756         -2.241873          6.292687         -0.441031   \n",
       "3166          4.930022         -2.404973         -4.097017         -4.906711   \n",
       "3167          0.316712          2.889873          0.833819         -2.406192   \n",
       "3168         -4.081523         -5.019090         -6.901200         -5.596471   \n",
       "3169         -0.381530          9.636214          4.487115         -4.788275   \n",
       "3170          3.708956          2.637812         -3.544634         -3.334877   \n",
       "3171          4.868258          2.804930         16.815908         -8.026420   \n",
       "3172         -2.843479         15.601020         -5.895711         -8.550911   \n",
       "3173         -7.581980        -13.081441          3.178134         -2.970641   \n",
       "3174        -12.847499         15.493820         19.035533        -20.550587   \n",
       "3175         -1.544618         -4.202564          1.397819          6.378258   \n",
       "3176          2.747083          7.782673         -4.990688        -12.331633   \n",
       "3177         14.293649          3.961413         -8.079028         -7.017803   \n",
       "3178          3.322604          6.208609          3.095336         -6.017222   \n",
       "3179          4.995063         -4.058912         -0.812583        -10.715742   \n",
       "3180         -1.200428         15.547274          4.787847         -1.226133   \n",
       "3181         -9.802564        -11.566801         13.564556          6.125989   \n",
       "3182          7.189319         23.066162         24.322042         -0.958472   \n",
       "3183         -0.401849          0.806452         29.066295        -12.603387   \n",
       "3184          4.582951          8.057765          7.641997         -9.252437   \n",
       "3185          4.373094          5.392073          2.634593          6.055759   \n",
       "3186          0.958559          8.425487          4.546373          3.678069   \n",
       "3187        -23.741784         15.272374        -40.870074        -16.596273   \n",
       "3188          1.072643         16.243199         -5.339774        -14.252889   \n",
       "3189         -1.589565          0.972695         19.525929         14.143021   \n",
       "3190        -17.755986         -4.916350         -6.902954        -14.215862   \n",
       "3191        -11.637475         -0.827815         -2.013502        -17.781491   \n",
       "3192        -11.752361         -8.040059         12.372583          1.533635   \n",
       "\n",
       "      RDOMESTICMIG2015  RNETMIG2011  RNETMIG2012  RNETMIG2013  RNETMIG2014  \\\n",
       "0            -0.467369     1.030015     0.826644     1.383282     1.724718   \n",
       "1            -2.530799     7.606016    -2.626146    -2.722002     2.592270   \n",
       "2            17.197872    15.844176    18.559627    22.727626    20.317142   \n",
       "3           -10.543299    -4.874741    -2.758113    -7.167664    -3.978583   \n",
       "4             0.177258    -5.088389    -4.363636    -5.403729     0.754533   \n",
       "5            -1.369970     1.859511    -0.848580    -1.402476    -1.577232   \n",
       "6           -16.167247   -29.001673    -2.825524     1.507017    17.243790   \n",
       "7            -6.529805   -13.936612   -11.586865    -5.557058     1.184103   \n",
       "8            -3.376322    -5.791579    -4.092677    -5.062836    -3.912834   \n",
       "9             1.349468    -1.821092     4.701181     3.781439    -1.290228   \n",
       "10           -3.239866     6.416167     1.420264     5.757384     0.230419   \n",
       "11           -2.253483    -0.823761    -2.447504     0.868651     0.957636   \n",
       "12           -5.291205   -15.528177    -0.737028    -8.766391    -1.274984   \n",
       "13           -5.613667    -6.077488   -17.509958    -0.159172    -8.486280   \n",
       "14            3.912450   -10.816697   -13.345130     4.977157     5.776708   \n",
       "15           -3.123961    -3.673524    -5.151880     7.345821     3.654485   \n",
       "16            2.214774     2.166460    11.513368   -10.438741    -0.767822   \n",
       "17           -0.110260     0.513964     1.469035     2.276420     2.533249   \n",
       "18            2.684140    -4.861559    -7.504690    -6.107224   -14.645416   \n",
       "19           -5.387581   -34.017138   -10.380162    -4.403703   -23.049483   \n",
       "20           -0.316945     6.881460    -4.559952     0.793147     3.750759   \n",
       "21            3.439504     2.666763     5.099293    -0.502098     4.734577   \n",
       "22            7.915406    -1.031427    -0.634159     4.542916     5.593387   \n",
       "23           -5.107706    -9.575283    -0.776637   -12.640155    -9.503292   \n",
       "24          -14.687232   -15.727573   -11.378047   -16.792849    -9.368689   \n",
       "25            0.028141     1.375159    -8.656001    -1.029539     1.198187   \n",
       "26            2.067820     3.674511     1.558176     2.306047    -0.951175   \n",
       "27            1.190902    -3.397716    -3.803428    -4.769999    -1.136950   \n",
       "28           -2.082234    -0.632554     2.446383    -1.518596    -1.234901   \n",
       "29           -2.797536    -5.132243    -0.705426    -3.785079     0.237396   \n",
       "...                ...          ...          ...          ...          ...   \n",
       "3163         -0.434498    -0.431504     1.162817    -1.763330     2.104796   \n",
       "3164         -0.719858     0.102448     3.180527     1.189727     2.077633   \n",
       "3165         -0.480617     3.359933    -2.011937     6.561277    -0.134227   \n",
       "3166         -4.397793     5.174486    -2.160399    -3.810226    -4.535615   \n",
       "3167         -4.557985     0.842573     3.502335     1.531624    -1.545153   \n",
       "3168         -3.958322    -3.733590    -4.562809    -6.442917    -5.040889   \n",
       "3169         -3.221091     0.289680    10.694870     5.440390    -3.727831   \n",
       "3170         -9.911169     6.736119     6.433032     0.719587     1.429233   \n",
       "3171          5.095861     4.868258     3.144921    17.236306    -7.608378   \n",
       "3172         10.916963    -2.649606    15.558684    -5.916543    -8.509402   \n",
       "3173        -23.300971    -7.392431   -12.636926     3.623073    -2.338590   \n",
       "3174         -0.070403   -12.774915    16.502720    20.093063   -19.358233   \n",
       "3175         18.629317    -0.982939    -3.642222     2.096729     7.071547   \n",
       "3176        -13.673610     3.093562     8.027411    -4.747240   -12.013555   \n",
       "3177        -11.899450    14.886132     4.841727    -6.903896    -5.761986   \n",
       "3178         -5.454164     5.191569     6.001656     2.888981    -6.224712   \n",
       "3179          0.933652     5.227392    -4.058912    -0.812583   -10.715742   \n",
       "3180          0.278940    -0.973320    17.914554     6.003143    -0.207819   \n",
       "3181          1.555544    -9.691801   -11.566801    13.619696     6.234414   \n",
       "3182         -0.061057     7.689674    23.749508    25.085233    -0.110593   \n",
       "3183          7.492114    -0.401849     0.806452    29.066295   -12.603387   \n",
       "3184         -2.878980     6.486639    11.127389    10.877797    -5.585731   \n",
       "3185          4.662270     4.373094     4.933173     2.176403     5.598720   \n",
       "3186         -3.298406     2.122524     9.342778     5.523001     4.781489   \n",
       "3187        -22.870900   -21.092907    16.828794   -39.211861   -14.409938   \n",
       "3188        -14.248864     1.255221    16.243199    -5.295460   -14.075283   \n",
       "3189         -0.564849     0.654527     2.408578    21.160658    16.308671   \n",
       "3190        -12.127022   -18.136812    -5.536861    -7.521840   -14.740608   \n",
       "3191          1.682288   -11.990126    -1.182592    -2.250385   -18.020168   \n",
       "3192          6.935294   -12.032179    -8.040059    12.372583     1.533635   \n",
       "\n",
       "      RNETMIG2015  \n",
       "0        0.712594  \n",
       "1       -2.187333  \n",
       "2       18.293499  \n",
       "3      -10.543299  \n",
       "4        1.107861  \n",
       "5       -0.884411  \n",
       "6      -13.193961  \n",
       "7       -6.430868  \n",
       "8       -2.806406  \n",
       "9        2.346901  \n",
       "10      -2.931307  \n",
       "11      -1.752709  \n",
       "12      -5.291205  \n",
       "13      -5.411736  \n",
       "14       3.986270  \n",
       "15      -3.123961  \n",
       "16       5.350738  \n",
       "17       0.588052  \n",
       "18       2.684140  \n",
       "19      -5.387581  \n",
       "20      -0.264121  \n",
       "21       5.087600  \n",
       "22       8.417777  \n",
       "23      -1.998668  \n",
       "24     -14.711389  \n",
       "25       0.956790  \n",
       "26       2.757093  \n",
       "27       1.243830  \n",
       "28      -1.588308  \n",
       "29      -2.857058  \n",
       "...           ...  \n",
       "3163     0.059931  \n",
       "3164     0.593567  \n",
       "3165    -0.173022  \n",
       "3166    -4.024395  \n",
       "3167    -3.685304  \n",
       "3168    -3.414223  \n",
       "3169    -2.091573  \n",
       "3170    -5.166460  \n",
       "3171     5.513554  \n",
       "3172    10.978525  \n",
       "3173   -22.600668  \n",
       "3174     1.126443  \n",
       "3175    19.309219  \n",
       "3176   -13.352750  \n",
       "3177   -10.635133  \n",
       "3178    -5.663940  \n",
       "3179     0.933652  \n",
       "3180     1.673640  \n",
       "3181     1.662823  \n",
       "3182     0.793743  \n",
       "3183     7.492114  \n",
       "3184     0.856839  \n",
       "3185     4.207414  \n",
       "3186    -2.198937  \n",
       "3187   -20.664059  \n",
       "3188   -14.070195  \n",
       "3189     1.520747  \n",
       "3190   -12.606351  \n",
       "3191     1.441961  \n",
       "3192     6.935294  \n",
       "\n",
       "[3193 rows x 100 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "census_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This is a description of the columns names: [Columns names description](https://www2.census.gov/programs-surveys/popest/technical-documentation/file-layouts/2010-2015/co-est2015-alldata.pdf) \n",
    "\n",
    "Now, it is time for analysis.\n",
    "\n",
    "Let's say we want to figure out which state has the most counties in it:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Texas'"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "census_df[census_df['SUMLEV']==50]\\\n",
    ".groupby('STNAME')['CTYNAME'].count().idxmax()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Let's say we want to get the three largest states in terms of population (when we consider only 3 largest counties in terms of population, for each state):"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['California', 'Texas', 'Illinois']"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "census_df[census_df['SUMLEV']==50]\\\n",
    ".sort_values(by=['STNAME', 'CENSUS2010POP'],ascending=False)\\\n",
    ".groupby('STNAME')['CENSUS2010POP'].nlargest(3).sum(level=0)\\\n",
    ".nlargest(3).index.values.tolist()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Let's say we want to get the country with the largest absolute change in population in the years 2010-2015:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Harris County'"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "census_df.loc[(census_df.loc[census_df['SUMLEV']==50,['POPESTIMATE2010', 'POPESTIMATE2011','POPESTIMATE2012', 'POPESTIMATE2013','POPESTIMATE2014', 'POPESTIMATE2015']].max(axis=1) - census_df.loc[census_df['SUMLEV']==50,['POPESTIMATE2010', 'POPESTIMATE2011','POPESTIMATE2012', 'POPESTIMATE2013','POPESTIMATE2014', 'POPESTIMATE2015']].min(axis=1)).idxmax(), 'CTYNAME']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Let's say we want to find counties that are part of regions 1 or 2, whose names starts with the word 'Washington', and whose Total Population Estimate in 2015 was greater than their Total Population Estimate in 2014."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>STNAME</th>\n",
       "      <th>CTYNAME</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>896</th>\n",
       "      <td>Iowa</td>\n",
       "      <td>Washington County</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1419</th>\n",
       "      <td>Minnesota</td>\n",
       "      <td>Washington County</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345</th>\n",
       "      <td>Pennsylvania</td>\n",
       "      <td>Washington County</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2355</th>\n",
       "      <td>Rhode Island</td>\n",
       "      <td>Washington County</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3163</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Washington County</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            STNAME            CTYNAME\n",
       "896           Iowa  Washington County\n",
       "1419     Minnesota  Washington County\n",
       "2345  Pennsylvania  Washington County\n",
       "2355  Rhode Island  Washington County\n",
       "3163     Wisconsin  Washington County"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "census_df.loc[((census_df['REGION']==1) | (census_df['REGION']==2)) & (census_df['POPESTIMATE2015'] > census_df['POPESTIMATE2014']) & (census_df['CTYNAME'].str.startswith('Washington')),['STNAME', 'CTYNAME']]"
   ]
  },
  {
   "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.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}