11_idomatic_pandas.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "# Idomatic pandas\n",
    "* \"a group of words established by usage as having a meaning not deducible from those of the individual words (e.g., rain cats and dogs, see the light ).\" -- some dictionary\n",
    "* What does it mean to be idomatic with respect to a programming language?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "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",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 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",
       "\n",
       "   CENSUS2010POP  ESTIMATESBASE2010  POPESTIMATE2010  ...  RDOMESTICMIG2011  \\\n",
       "0        4779736            4780127          4785161  ...          0.002295   \n",
       "1          54571              54571            54660  ...          7.242091   \n",
       "2         182265             182265           183193  ...         14.832960   \n",
       "3          27457              27457            27341  ...         -4.728132   \n",
       "4          22915              22919            22861  ...         -5.527043   \n",
       "\n",
       "   RDOMESTICMIG2012  RDOMESTICMIG2013  RDOMESTICMIG2014  RDOMESTICMIG2015  \\\n",
       "0         -0.193196          0.381066          0.582002         -0.467369   \n",
       "1         -2.915927         -3.012349          2.265971         -2.530799   \n",
       "2         17.647293         21.845705         19.243287         17.197872   \n",
       "3         -2.500690         -7.056824         -3.904217        -10.543299   \n",
       "4         -5.068871         -6.201001         -0.177537          0.177258   \n",
       "\n",
       "   RNETMIG2011  RNETMIG2012  RNETMIG2013  RNETMIG2014  RNETMIG2015  \n",
       "0     1.030015     0.826644     1.383282     1.724718     0.712594  \n",
       "1     7.606016    -2.626146    -2.722002     2.592270    -2.187333  \n",
       "2    15.844176    18.559627    22.727626    20.317142    18.293499  \n",
       "3    -4.874741    -2.758113    -7.167664    -3.978583   -10.543299  \n",
       "4    -5.088389    -4.363636    -5.403729     0.754533     1.107861  \n",
       "\n",
       "[5 rows x 100 columns]"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "df = pd.read_csv('datasets/census.csv')\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "## Pandas Idiom 1: Method Chaining"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "slideshow": {
     "slide_type": "subslide"
    }
   },
   "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></th>\n",
       "      <th>SUMLEV</th>\n",
       "      <th>REGION</th>\n",
       "      <th>DIVISION</th>\n",
       "      <th>STATE</th>\n",
       "      <th>COUNTY</th>\n",
       "      <th>CENSUS2010POP</th>\n",
       "      <th>Estimates Base 2010</th>\n",
       "      <th>POPESTIMATE2010</th>\n",
       "      <th>POPESTIMATE2011</th>\n",
       "      <th>POPESTIMATE2012</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",
       "    <tr>\n",
       "      <th>STNAME</th>\n",
       "      <th>CTYNAME</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"30\" valign=\"top\">Alabama</th>\n",
       "      <th>Autauga County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>54571.0</td>\n",
       "      <td>54571.0</td>\n",
       "      <td>54660.0</td>\n",
       "      <td>55253.0</td>\n",
       "      <td>55175.0</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>Baldwin County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>182265.0</td>\n",
       "      <td>182265.0</td>\n",
       "      <td>183193.0</td>\n",
       "      <td>186659.0</td>\n",
       "      <td>190396.0</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>Barbour County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>27457.0</td>\n",
       "      <td>27457.0</td>\n",
       "      <td>27341.0</td>\n",
       "      <td>27226.0</td>\n",
       "      <td>27159.0</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>Bibb County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>22915.0</td>\n",
       "      <td>22919.0</td>\n",
       "      <td>22861.0</td>\n",
       "      <td>22733.0</td>\n",
       "      <td>22642.0</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>Blount County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>57322.0</td>\n",
       "      <td>57322.0</td>\n",
       "      <td>57373.0</td>\n",
       "      <td>57711.0</td>\n",
       "      <td>57776.0</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>Bullock County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>10914.0</td>\n",
       "      <td>10915.0</td>\n",
       "      <td>10887.0</td>\n",
       "      <td>10629.0</td>\n",
       "      <td>10606.0</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>Butler County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>20947.0</td>\n",
       "      <td>20946.0</td>\n",
       "      <td>20944.0</td>\n",
       "      <td>20673.0</td>\n",
       "      <td>20408.0</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>Calhoun County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>118572.0</td>\n",
       "      <td>118586.0</td>\n",
       "      <td>118437.0</td>\n",
       "      <td>117768.0</td>\n",
       "      <td>117286.0</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>Chambers County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>34215.0</td>\n",
       "      <td>34170.0</td>\n",
       "      <td>34098.0</td>\n",
       "      <td>33993.0</td>\n",
       "      <td>34075.0</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>Cherokee County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>25989.0</td>\n",
       "      <td>25986.0</td>\n",
       "      <td>25976.0</td>\n",
       "      <td>26080.0</td>\n",
       "      <td>26023.0</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>Chilton County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>43643.0</td>\n",
       "      <td>43631.0</td>\n",
       "      <td>43665.0</td>\n",
       "      <td>43739.0</td>\n",
       "      <td>43697.0</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>Choctaw County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>13859.0</td>\n",
       "      <td>13858.0</td>\n",
       "      <td>13841.0</td>\n",
       "      <td>13593.0</td>\n",
       "      <td>13543.0</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>Clarke County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>25833.0</td>\n",
       "      <td>25840.0</td>\n",
       "      <td>25767.0</td>\n",
       "      <td>25570.0</td>\n",
       "      <td>25144.0</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>Clay County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>13932.0</td>\n",
       "      <td>13932.0</td>\n",
       "      <td>13880.0</td>\n",
       "      <td>13670.0</td>\n",
       "      <td>13456.0</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>Cleburne County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>14972.0</td>\n",
       "      <td>14972.0</td>\n",
       "      <td>14973.0</td>\n",
       "      <td>14971.0</td>\n",
       "      <td>14921.0</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>Coffee County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>49948.0</td>\n",
       "      <td>49948.0</td>\n",
       "      <td>50177.0</td>\n",
       "      <td>50448.0</td>\n",
       "      <td>51173.0</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>Colbert County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>54428.0</td>\n",
       "      <td>54428.0</td>\n",
       "      <td>54514.0</td>\n",
       "      <td>54443.0</td>\n",
       "      <td>54472.0</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>Conecuh County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>13228.0</td>\n",
       "      <td>13228.0</td>\n",
       "      <td>13208.0</td>\n",
       "      <td>13121.0</td>\n",
       "      <td>12996.0</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>Coosa County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>11539.0</td>\n",
       "      <td>11758.0</td>\n",
       "      <td>11758.0</td>\n",
       "      <td>11348.0</td>\n",
       "      <td>11195.0</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>Covington County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>37765.0</td>\n",
       "      <td>37765.0</td>\n",
       "      <td>37796.0</td>\n",
       "      <td>38060.0</td>\n",
       "      <td>37818.0</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>Crenshaw County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>13906.0</td>\n",
       "      <td>13906.0</td>\n",
       "      <td>13853.0</td>\n",
       "      <td>13896.0</td>\n",
       "      <td>13951.0</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>Cullman County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>80406.0</td>\n",
       "      <td>80410.0</td>\n",
       "      <td>80473.0</td>\n",
       "      <td>80469.0</td>\n",
       "      <td>80374.0</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>Dale County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>50251.0</td>\n",
       "      <td>50251.0</td>\n",
       "      <td>50358.0</td>\n",
       "      <td>50109.0</td>\n",
       "      <td>50324.0</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>Dallas County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>43820.0</td>\n",
       "      <td>43820.0</td>\n",
       "      <td>43803.0</td>\n",
       "      <td>43178.0</td>\n",
       "      <td>42777.0</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>DeKalb County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>71109.0</td>\n",
       "      <td>71115.0</td>\n",
       "      <td>71142.0</td>\n",
       "      <td>71387.0</td>\n",
       "      <td>70942.0</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>Elmore County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>79303.0</td>\n",
       "      <td>79296.0</td>\n",
       "      <td>79465.0</td>\n",
       "      <td>80012.0</td>\n",
       "      <td>80432.0</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>Escambia County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>38319.0</td>\n",
       "      <td>38319.0</td>\n",
       "      <td>38309.0</td>\n",
       "      <td>38213.0</td>\n",
       "      <td>38034.0</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>Etowah County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>104430.0</td>\n",
       "      <td>104427.0</td>\n",
       "      <td>104442.0</td>\n",
       "      <td>104236.0</td>\n",
       "      <td>104235.0</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>Fayette County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>17241.0</td>\n",
       "      <td>17241.0</td>\n",
       "      <td>17231.0</td>\n",
       "      <td>17062.0</td>\n",
       "      <td>16960.0</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>Franklin County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>31704.0</td>\n",
       "      <td>31709.0</td>\n",
       "      <td>31734.0</td>\n",
       "      <td>31729.0</td>\n",
       "      <td>31648.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.638750</td>\n",
       "      <td>-5.459394</td>\n",
       "      <td>-8.043702</td>\n",
       "      <td>-1.267849</td>\n",
       "      <td>-2.401719</td>\n",
       "      <td>0.063029</td>\n",
       "      <td>-3.471291</td>\n",
       "      <td>-5.700261</td>\n",
       "      <td>1.553115</td>\n",
       "      <td>0.442422</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\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 rowspan=\"7\" valign=\"top\">Wisconsin</th>\n",
       "      <th>Washburn County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>129.0</td>\n",
       "      <td>15911.0</td>\n",
       "      <td>15911.0</td>\n",
       "      <td>15930.0</td>\n",
       "      <td>15784.0</td>\n",
       "      <td>15831.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-6.873936</td>\n",
       "      <td>7.338289</td>\n",
       "      <td>-6.732724</td>\n",
       "      <td>3.510452</td>\n",
       "      <td>-5.123279</td>\n",
       "      <td>-6.747809</td>\n",
       "      <td>7.464811</td>\n",
       "      <td>-6.605691</td>\n",
       "      <td>3.638104</td>\n",
       "      <td>-4.995197</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Washington County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>131.0</td>\n",
       "      <td>131887.0</td>\n",
       "      <td>131885.0</td>\n",
       "      <td>131967.0</td>\n",
       "      <td>132225.0</td>\n",
       "      <td>132649.0</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>Waukesha County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>389891.0</td>\n",
       "      <td>389938.0</td>\n",
       "      <td>390076.0</td>\n",
       "      <td>390808.0</td>\n",
       "      <td>392710.0</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>Waupaca County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>135.0</td>\n",
       "      <td>52410.0</td>\n",
       "      <td>52410.0</td>\n",
       "      <td>52422.0</td>\n",
       "      <td>52342.0</td>\n",
       "      <td>52035.0</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>Waushara County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>137.0</td>\n",
       "      <td>24496.0</td>\n",
       "      <td>24496.0</td>\n",
       "      <td>24506.0</td>\n",
       "      <td>24581.0</td>\n",
       "      <td>24484.0</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>Winnebago County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>139.0</td>\n",
       "      <td>166994.0</td>\n",
       "      <td>166994.0</td>\n",
       "      <td>167059.0</td>\n",
       "      <td>167630.0</td>\n",
       "      <td>168717.0</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>Wood County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>141.0</td>\n",
       "      <td>74749.0</td>\n",
       "      <td>74749.0</td>\n",
       "      <td>74807.0</td>\n",
       "      <td>74647.0</td>\n",
       "      <td>74384.0</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 rowspan=\"23\" valign=\"top\">Wyoming</th>\n",
       "      <th>Albany County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>36299.0</td>\n",
       "      <td>36299.0</td>\n",
       "      <td>36428.0</td>\n",
       "      <td>36908.0</td>\n",
       "      <td>37396.0</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>Big Horn County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>11668.0</td>\n",
       "      <td>11668.0</td>\n",
       "      <td>11672.0</td>\n",
       "      <td>11745.0</td>\n",
       "      <td>11785.0</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>Campbell County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>46133.0</td>\n",
       "      <td>46133.0</td>\n",
       "      <td>46244.0</td>\n",
       "      <td>46600.0</td>\n",
       "      <td>47881.0</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>Carbon County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>15885.0</td>\n",
       "      <td>15885.0</td>\n",
       "      <td>15837.0</td>\n",
       "      <td>15817.0</td>\n",
       "      <td>15678.0</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>Converse County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>13833.0</td>\n",
       "      <td>13833.0</td>\n",
       "      <td>13826.0</td>\n",
       "      <td>13728.0</td>\n",
       "      <td>14025.0</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>Crook County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>7083.0</td>\n",
       "      <td>7083.0</td>\n",
       "      <td>7114.0</td>\n",
       "      <td>7129.0</td>\n",
       "      <td>7148.0</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>Fremont County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>40123.0</td>\n",
       "      <td>40123.0</td>\n",
       "      <td>40222.0</td>\n",
       "      <td>40591.0</td>\n",
       "      <td>41129.0</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>Goshen County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>13249.0</td>\n",
       "      <td>13247.0</td>\n",
       "      <td>13408.0</td>\n",
       "      <td>13597.0</td>\n",
       "      <td>13666.0</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>Hot Springs County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>4812.0</td>\n",
       "      <td>4812.0</td>\n",
       "      <td>4813.0</td>\n",
       "      <td>4818.0</td>\n",
       "      <td>4846.0</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>Johnson County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>8569.0</td>\n",
       "      <td>8569.0</td>\n",
       "      <td>8581.0</td>\n",
       "      <td>8636.0</td>\n",
       "      <td>8610.0</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>Laramie County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>91738.0</td>\n",
       "      <td>91881.0</td>\n",
       "      <td>92271.0</td>\n",
       "      <td>92663.0</td>\n",
       "      <td>94894.0</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>Lincoln County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>18106.0</td>\n",
       "      <td>18106.0</td>\n",
       "      <td>18091.0</td>\n",
       "      <td>18022.0</td>\n",
       "      <td>17943.0</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>Natrona County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>75450.0</td>\n",
       "      <td>75450.0</td>\n",
       "      <td>75472.0</td>\n",
       "      <td>76420.0</td>\n",
       "      <td>78699.0</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>Niobrara County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>2484.0</td>\n",
       "      <td>2484.0</td>\n",
       "      <td>2492.0</td>\n",
       "      <td>2485.0</td>\n",
       "      <td>2475.0</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>Park County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>28205.0</td>\n",
       "      <td>28205.0</td>\n",
       "      <td>28259.0</td>\n",
       "      <td>28473.0</td>\n",
       "      <td>28863.0</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>Platte County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>8667.0</td>\n",
       "      <td>8667.0</td>\n",
       "      <td>8678.0</td>\n",
       "      <td>8701.0</td>\n",
       "      <td>8732.0</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>Sheridan County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>29116.0</td>\n",
       "      <td>29116.0</td>\n",
       "      <td>29146.0</td>\n",
       "      <td>29275.0</td>\n",
       "      <td>29594.0</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>Sublette County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>10247.0</td>\n",
       "      <td>10247.0</td>\n",
       "      <td>10244.0</td>\n",
       "      <td>10142.0</td>\n",
       "      <td>10418.0</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>Sweetwater County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>43806.0</td>\n",
       "      <td>43806.0</td>\n",
       "      <td>43593.0</td>\n",
       "      <td>44041.0</td>\n",
       "      <td>45104.0</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>Teton County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>21294.0</td>\n",
       "      <td>21294.0</td>\n",
       "      <td>21297.0</td>\n",
       "      <td>21482.0</td>\n",
       "      <td>21697.0</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>Uinta County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>21118.0</td>\n",
       "      <td>21118.0</td>\n",
       "      <td>21102.0</td>\n",
       "      <td>20912.0</td>\n",
       "      <td>20989.0</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>Washakie County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>8533.0</td>\n",
       "      <td>8533.0</td>\n",
       "      <td>8545.0</td>\n",
       "      <td>8469.0</td>\n",
       "      <td>8443.0</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>Weston County</th>\n",
       "      <td>50.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>7208.0</td>\n",
       "      <td>7208.0</td>\n",
       "      <td>7181.0</td>\n",
       "      <td>7114.0</td>\n",
       "      <td>7065.0</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>3142 rows × 98 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                           SUMLEV  REGION  DIVISION  STATE  COUNTY  \\\n",
       "STNAME  CTYNAME                                                      \n",
       "Alabama Autauga County       50.0     3.0       6.0    1.0     1.0   \n",
       "        Baldwin County       50.0     3.0       6.0    1.0     3.0   \n",
       "        Barbour County       50.0     3.0       6.0    1.0     5.0   \n",
       "        Bibb County          50.0     3.0       6.0    1.0     7.0   \n",
       "        Blount County        50.0     3.0       6.0    1.0     9.0   \n",
       "...                           ...     ...       ...    ...     ...   \n",
       "Wyoming Sweetwater County    50.0     4.0       8.0   56.0    37.0   \n",
       "        Teton County         50.0     4.0       8.0   56.0    39.0   \n",
       "        Uinta County         50.0     4.0       8.0   56.0    41.0   \n",
       "        Washakie County      50.0     4.0       8.0   56.0    43.0   \n",
       "        Weston County        50.0     4.0       8.0   56.0    45.0   \n",
       "\n",
       "                           CENSUS2010POP  Estimates Base 2010  \\\n",
       "STNAME  CTYNAME                                                 \n",
       "Alabama Autauga County           54571.0              54571.0   \n",
       "        Baldwin County          182265.0             182265.0   \n",
       "        Barbour County           27457.0              27457.0   \n",
       "        Bibb County              22915.0              22919.0   \n",
       "        Blount County            57322.0              57322.0   \n",
       "...                                  ...                  ...   \n",
       "Wyoming Sweetwater County        43806.0              43806.0   \n",
       "        Teton County             21294.0              21294.0   \n",
       "        Uinta County             21118.0              21118.0   \n",
       "        Washakie County           8533.0               8533.0   \n",
       "        Weston County             7208.0               7208.0   \n",
       "\n",
       "                           POPESTIMATE2010  POPESTIMATE2011  POPESTIMATE2012  \\\n",
       "STNAME  CTYNAME                                                                \n",
       "Alabama Autauga County             54660.0          55253.0          55175.0   \n",
       "        Baldwin County            183193.0         186659.0         190396.0   \n",
       "        Barbour County             27341.0          27226.0          27159.0   \n",
       "        Bibb County                22861.0          22733.0          22642.0   \n",
       "        Blount County              57373.0          57711.0          57776.0   \n",
       "...                                    ...              ...              ...   \n",
       "Wyoming Sweetwater County          43593.0          44041.0          45104.0   \n",
       "        Teton County               21297.0          21482.0          21697.0   \n",
       "        Uinta County               21102.0          20912.0          20989.0   \n",
       "        Washakie County             8545.0           8469.0           8443.0   \n",
       "        Weston County               7181.0           7114.0           7065.0   \n",
       "\n",
       "                           ...  RDOMESTICMIG2011  RDOMESTICMIG2012  \\\n",
       "STNAME  CTYNAME            ...                                       \n",
       "Alabama Autauga County     ...          7.242091         -2.915927   \n",
       "        Baldwin County     ...         14.832960         17.647293   \n",
       "        Barbour County     ...         -4.728132         -2.500690   \n",
       "        Bibb County        ...         -5.527043         -5.068871   \n",
       "        Blount County      ...          1.807375         -1.177622   \n",
       "...                        ...               ...               ...   \n",
       "Wyoming Sweetwater County  ...          1.072643         16.243199   \n",
       "        Teton County       ...         -1.589565          0.972695   \n",
       "        Uinta County       ...        -17.755986         -4.916350   \n",
       "        Washakie County    ...        -11.637475         -0.827815   \n",
       "        Weston County      ...        -11.752361         -8.040059   \n",
       "\n",
       "                           RDOMESTICMIG2013  RDOMESTICMIG2014  \\\n",
       "STNAME  CTYNAME                                                 \n",
       "Alabama Autauga County            -3.012349          2.265971   \n",
       "        Baldwin County            21.845705         19.243287   \n",
       "        Barbour County            -7.056824         -3.904217   \n",
       "        Bibb County               -6.201001         -0.177537   \n",
       "        Blount County             -1.748766         -2.062535   \n",
       "...                                     ...               ...   \n",
       "Wyoming Sweetwater County         -5.339774        -14.252889   \n",
       "        Teton County              19.525929         14.143021   \n",
       "        Uinta County              -6.902954        -14.215862   \n",
       "        Washakie County           -2.013502        -17.781491   \n",
       "        Weston County             12.372583          1.533635   \n",
       "\n",
       "                           RDOMESTICMIG2015  RNETMIG2011  RNETMIG2012  \\\n",
       "STNAME  CTYNAME                                                         \n",
       "Alabama Autauga County            -2.530799     7.606016    -2.626146   \n",
       "        Baldwin County            17.197872    15.844176    18.559627   \n",
       "        Barbour County           -10.543299    -4.874741    -2.758113   \n",
       "        Bibb County                0.177258    -5.088389    -4.363636   \n",
       "        Blount County             -1.369970     1.859511    -0.848580   \n",
       "...                                     ...          ...          ...   \n",
       "Wyoming Sweetwater County        -14.248864     1.255221    16.243199   \n",
       "        Teton County              -0.564849     0.654527     2.408578   \n",
       "        Uinta County             -12.127022   -18.136812    -5.536861   \n",
       "        Washakie County            1.682288   -11.990126    -1.182592   \n",
       "        Weston County              6.935294   -12.032179    -8.040059   \n",
       "\n",
       "                           RNETMIG2013  RNETMIG2014  RNETMIG2015  \n",
       "STNAME  CTYNAME                                                   \n",
       "Alabama Autauga County       -2.722002     2.592270    -2.187333  \n",
       "        Baldwin County       22.727626    20.317142    18.293499  \n",
       "        Barbour County       -7.167664    -3.978583   -10.543299  \n",
       "        Bibb County          -5.403729     0.754533     1.107861  \n",
       "        Blount County        -1.402476    -1.577232    -0.884411  \n",
       "...                                ...          ...          ...  \n",
       "Wyoming Sweetwater County    -5.295460   -14.075283   -14.070195  \n",
       "        Teton County         21.160658    16.308671     1.520747  \n",
       "        Uinta County         -7.521840   -14.740608   -12.606351  \n",
       "        Washakie County      -2.250385   -18.020168     1.441961  \n",
       "        Weston County        12.372583     1.533635     6.935294  \n",
       "\n",
       "[3142 rows x 98 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(df.where(df['SUMLEV']==50)\n",
    "    .dropna()\n",
    "    .set_index(['STNAME','CTYNAME'])\n",
    "    .rename(columns={'ESTIMATESBASE2010': 'Estimates Base 2010'}))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "# Pandas Idiom 2: Functional Programing\n",
    "* We've talked about this at length! Broadcasting! Vectorization!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "slideshow": {
     "slide_type": "subslide"
    }
   },
   "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>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",
       "      <th>abs</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.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",
       "      <td>73818</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>-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",
       "      <td>687</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>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",
       "      <td>20516</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>-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",
       "      <td>852</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.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",
       "      <td>349</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 101 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",
       "\n",
       "   CENSUS2010POP  ESTIMATESBASE2010  POPESTIMATE2010  ...  RDOMESTICMIG2012  \\\n",
       "0        4779736            4780127          4785161  ...         -0.193196   \n",
       "1          54571              54571            54660  ...         -2.915927   \n",
       "2         182265             182265           183193  ...         17.647293   \n",
       "3          27457              27457            27341  ...         -2.500690   \n",
       "4          22915              22919            22861  ...         -5.068871   \n",
       "\n",
       "   RDOMESTICMIG2013  RDOMESTICMIG2014  RDOMESTICMIG2015  RNETMIG2011  \\\n",
       "0          0.381066          0.582002         -0.467369     1.030015   \n",
       "1         -3.012349          2.265971         -2.530799     7.606016   \n",
       "2         21.845705         19.243287         17.197872    15.844176   \n",
       "3         -7.056824         -3.904217        -10.543299    -4.874741   \n",
       "4         -6.201001         -0.177537          0.177258    -5.088389   \n",
       "\n",
       "   RNETMIG2012  RNETMIG2013  RNETMIG2014  RNETMIG2015    abs  \n",
       "0     0.826644     1.383282     1.724718     0.712594  73818  \n",
       "1    -2.626146    -2.722002     2.592270    -2.187333    687  \n",
       "2    18.559627    22.727626    20.317142    18.293499  20516  \n",
       "3    -2.758113    -7.167664    -3.978583   -10.543299    852  \n",
       "4    -4.363636    -5.403729     0.754533     1.107861    349  \n",
       "\n",
       "[5 rows x 101 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rows = ['POPESTIMATE2010', 'POPESTIMATE2011', 'POPESTIMATE2012', 'POPESTIMATE2013','POPESTIMATE2014', \n",
    "        'POPESTIMATE2015']\n",
    "df[\"abs\"]=df.apply(lambda x: np.max(x[rows])-np.min(x[rows]), axis=1)\n",
    "df.head()"
   ]
  }
 ],
 "metadata": {
  "celltoolbar": "Slideshow",
  "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}