Assignment+2.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---\n",
    "\n",
    "_You are currently looking at **version 1.2** of this notebook. To download notebooks and datafiles, as well as get help on Jupyter notebooks in the Coursera platform, visit the [Jupyter Notebook FAQ](https://www.coursera.org/learn/python-data-analysis/resources/0dhYG) course resource._\n",
    "\n",
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Assignment 2 - Pandas Introduction\n",
    "All questions are weighted the same in this assignment.\n",
    "## Part 1\n",
    "The following code loads the olympics dataset (olympics.csv), which was derrived from the Wikipedia entry on [All Time Olympic Games Medals](https://en.wikipedia.org/wiki/All-time_Olympic_Games_medal_table), and does some basic data cleaning. \n",
    "\n",
    "The columns are organized as # of Summer games, Summer medals, # of Winter games, Winter medals, total # number of games, total # of medals. Use this dataset to answer the questions below."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "nbgrader": {
     "grade": false,
     "grade_id": "1",
     "locked": false,
     "solution": false
    },
    "scrolled": false,
    "umich_question": "prolog-000"
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th># Summer</th>\n",
       "      <th>Gold</th>\n",
       "      <th>Silver</th>\n",
       "      <th>Bronze</th>\n",
       "      <th>Total</th>\n",
       "      <th># Winter</th>\n",
       "      <th>Gold.1</th>\n",
       "      <th>Silver.1</th>\n",
       "      <th>Bronze.1</th>\n",
       "      <th>Total.1</th>\n",
       "      <th># Games</th>\n",
       "      <th>Gold.2</th>\n",
       "      <th>Silver.2</th>\n",
       "      <th>Bronze.2</th>\n",
       "      <th>Combined total</th>\n",
       "      <th>ID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Afghanistan</th>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>AFG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Algeria</th>\n",
       "      <td>12</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>15</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>15</td>\n",
       "      <td>ALG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Argentina</th>\n",
       "      <td>23</td>\n",
       "      <td>18</td>\n",
       "      <td>24</td>\n",
       "      <td>28</td>\n",
       "      <td>70</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>41</td>\n",
       "      <td>18</td>\n",
       "      <td>24</td>\n",
       "      <td>28</td>\n",
       "      <td>70</td>\n",
       "      <td>ARG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Armenia</th>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>12</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>12</td>\n",
       "      <td>ARM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Australasia</th>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>ANZ</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             # Summer  Gold  Silver  Bronze  Total  # Winter  Gold.1  \\\n",
       "Afghanistan        13     0       0       2      2         0       0   \n",
       "Algeria            12     5       2       8     15         3       0   \n",
       "Argentina          23    18      24      28     70        18       0   \n",
       "Armenia             5     1       2       9     12         6       0   \n",
       "Australasia         2     3       4       5     12         0       0   \n",
       "\n",
       "             Silver.1  Bronze.1  Total.1  # Games  Gold.2  Silver.2  Bronze.2  \\\n",
       "Afghanistan         0         0        0       13       0         0         2   \n",
       "Algeria             0         0        0       15       5         2         8   \n",
       "Argentina           0         0        0       41      18        24        28   \n",
       "Armenia             0         0        0       11       1         2         9   \n",
       "Australasia         0         0        0        2       3         4         5   \n",
       "\n",
       "             Combined total   ID  \n",
       "Afghanistan               2  AFG  \n",
       "Algeria                  15  ALG  \n",
       "Argentina                70  ARG  \n",
       "Armenia                  12  ARM  \n",
       "Australasia              12  ANZ  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "df = pd.read_csv('olympics.csv', index_col=0, skiprows=1)\n",
    "\n",
    "for col in df.columns:\n",
    "    if col[:2]=='01':\n",
    "        df.rename(columns={col:'Gold'+col[4:]}, inplace=True)\n",
    "    if col[:2]=='02':\n",
    "        df.rename(columns={col:'Silver'+col[4:]}, inplace=True)\n",
    "    if col[:2]=='03':\n",
    "        df.rename(columns={col:'Bronze'+col[4:]}, inplace=True)\n",
    "    if col[:1]=='№':\n",
    "        df.rename(columns={col:'#'+col[1:]}, inplace=True)\n",
    "\n",
    "names_ids = df.index.str.split('\\s\\(') # split the index by '('\n",
    "\n",
    "df.index = names_ids.str[0] # the [0] element is the country name (new index) \n",
    "df['ID'] = names_ids.str[1].str[:3] # the [1] element is the abbreviation or ID (take first 3 characters from that)\n",
    "\n",
    "df = df.drop('Totals')\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Question 0 (Example)\n",
    "\n",
    "What is the first country in df?\n",
    "\n",
    "*This function should return a Series.*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "umich_question": "000"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "# Summer           13\n",
       "Gold                0\n",
       "Silver              0\n",
       "Bronze              2\n",
       "Total               2\n",
       "# Winter            0\n",
       "Gold.1              0\n",
       "Silver.1            0\n",
       "Bronze.1            0\n",
       "Total.1             0\n",
       "# Games            13\n",
       "Gold.2              0\n",
       "Silver.2            0\n",
       "Bronze.2            2\n",
       "Combined total      2\n",
       "ID                AFG\n",
       "Name: Afghanistan, dtype: object"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# You should write your whole answer within the function provided. The autograder will call\n",
    "# this function and compare the return value against the correct solution value\n",
    "def answer_zero():\n",
    "    # This function returns the row for Afghanistan, which is a Series object. The assignment\n",
    "    # question description will tell you the general format the autograder is expecting\n",
    "    return df.iloc[0]\n",
    "\n",
    "# You can examine what your function returns by calling it in the cell. If you have questions\n",
    "# about the assignment formats, check out the discussion forums for any FAQs\n",
    "answer_zero() "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Question 1\n",
    "Which country has won the most gold medals in summer games?\n",
    "\n",
    "*This function should return a single string value.*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "nbgrader": {
     "grade": false,
     "locked": false,
     "solution": false
    },
    "umich_part_id": "001",
    "umich_partlist_id": "001"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'United States'"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def answer_one():\n",
    "    \n",
    "    return df[df['Gold'] == max(df['Gold'])].index[0]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Question 2\n",
    "Which country had the biggest difference between their summer and winter gold medal counts?\n",
    "\n",
    "*This function should return a single string value.*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {
    "umich_part_id": "002",
    "umich_partlist_id": "001"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'United States'"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def answer_two():\n",
    "    diff = df['Gold']-df['Gold.1']\n",
    "    \n",
    "    return df[diff == max(diff)].index[0]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Question 3\n",
    "Which country has the biggest difference between their summer gold medal counts and winter gold medal counts relative to their total gold medal count? \n",
    "\n",
    "$$\\frac{Summer~Gold - Winter~Gold}{Total~Gold}$$\n",
    "\n",
    "Only include countries that have won at least 1 gold in both summer and winter.\n",
    "\n",
    "*This function should return a single string value.*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {
    "umich_part_id": "003",
    "umich_partlist_id": "001"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Bulgaria'"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def answer_three():\n",
    "    d = df[(df['Gold']>0) & (df['Gold.1']>0)]\n",
    "    mean = (d['Gold']-d['Gold.1'])/(d['Gold']+d['Gold.1'])\n",
    "    \n",
    "    return d[mean == max(mean)].index[0]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Question 4\n",
    "Write a function that creates a Series called \"Points\" which is a weighted value where each gold medal (`Gold.2`) counts for 3 points, silver medals (`Silver.2`) for 2 points, and bronze medals (`Bronze.2`) for 1 point. The function should return only the column (a Series object) which you created, with the country names as indices.\n",
    "\n",
    "*This function should return a Series named `Points` of length 146*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {
    "scrolled": true,
    "umich_part_id": "004",
    "umich_partlist_id": "001"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Afghanistan                            2\n",
       "Algeria                               27\n",
       "Argentina                            130\n",
       "Armenia                               16\n",
       "Australasia                           22\n",
       "Australia                            923\n",
       "Austria                              569\n",
       "Azerbaijan                            43\n",
       "Bahamas                               24\n",
       "Bahrain                                1\n",
       "Barbados                               1\n",
       "Belarus                              154\n",
       "Belgium                              276\n",
       "Bermuda                                1\n",
       "Bohemia                                5\n",
       "Botswana                               2\n",
       "Brazil                               184\n",
       "British West Indies                    2\n",
       "Bulgaria                             411\n",
       "Burundi                                3\n",
       "Cameroon                              12\n",
       "Canada                               846\n",
       "Chile                                 24\n",
       "China                               1120\n",
       "Colombia                              29\n",
       "Costa Rica                             7\n",
       "Ivory Coast                            2\n",
       "Croatia                               67\n",
       "Cuba                                 420\n",
       "Cyprus                                 2\n",
       "                                    ... \n",
       "Spain                                268\n",
       "Sri Lanka                              4\n",
       "Sudan                                  2\n",
       "Suriname                               4\n",
       "Sweden                              1217\n",
       "Switzerland                          630\n",
       "Syria                                  6\n",
       "Chinese Taipei                        32\n",
       "Tajikistan                             4\n",
       "Tanzania                               4\n",
       "Thailand                              44\n",
       "Togo                                   1\n",
       "Tonga                                  2\n",
       "Trinidad and Tobago                   27\n",
       "Tunisia                               19\n",
       "Turkey                               191\n",
       "Uganda                                14\n",
       "Ukraine                              220\n",
       "United Arab Emirates                   3\n",
       "United States                       5684\n",
       "Uruguay                               16\n",
       "Uzbekistan                            38\n",
       "Venezuela                             18\n",
       "Vietnam                                4\n",
       "Virgin Islands                         2\n",
       "Yugoslavia                           171\n",
       "Independent Olympic Participants       4\n",
       "Zambia                                 3\n",
       "Zimbabwe                              18\n",
       "Mixed team                            38\n",
       "Name: Points, dtype: int64"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def answer_four():\n",
    "    \n",
    "    return pd.Series(df['Gold.2']*3+df['Silver.2']*2+df['Bronze.2'], index=df.index, name='Points')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Part 2\n",
    "For the next set of questions, we will be using census data from the [United States Census Bureau](http://www.census.gov). Counties are political and geographic subdivisions of states in the United States. This dataset contains population data for counties and states in the US from 2010 to 2015. [See this document](https://www2.census.gov/programs-surveys/popest/technical-documentation/file-layouts/2010-2015/co-est2015-alldata.pdf) for a description of the variable names.\n",
    "\n",
    "The census dataset (census.csv) should be loaded as census_df. Answer questions using this as appropriate.\n",
    "\n",
    "### Question 5\n",
    "Which state has the most counties in it? (hint: consider the sumlevel key carefully! You'll need this for future questions too...)\n",
    "\n",
    "*This function should return a single string value.*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "umich_question": "prolog-005"
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\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": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "census_df = pd.read_csv('census.csv')\n",
    "census_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {
    "umich_part_id": "005",
    "umich_partlist_id": "002"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Texas'"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def answer_five():\n",
    "    census = census_df.set_index(['STNAME','CTYNAME'])\n",
    "    census = census.count(level=0)\n",
    "    census = census.sort_values(by='COUNTY')\n",
    "\n",
    "    return census.index[-1]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Question 6\n",
    "**Only looking at the three most populous counties for each state**, what are the three most populous states (in order of highest population to lowest population)? Use `CENSUS2010POP`.\n",
    "\n",
    "*This function should return a list of string values.*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "umich_part_id": "006",
    "umich_partlist_id": "002"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['California', 'Texas', 'Illinois']"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def answer_six():\n",
    "\n",
    "    lista = []\n",
    "    df = census_df.set_index(['STNAME'])\n",
    "\n",
    "    for state in set(df.index):\n",
    "\n",
    "        pop = df.loc[state]\n",
    "        pop = pop[state != pop['CTYNAME']]\n",
    "        pop = pop.sort_values(by='CENSUS2010POP',ascending=False)\n",
    "        pop = pop[:3]['CENSUS2010POP']\n",
    "        pop = pop.sum()\n",
    "        lista.append((state,pop))\n",
    "\n",
    "    lista.sort(reverse=True,key=lambda x: x[1])\n",
    "    lista = [x[0] for x in lista[:3]]\n",
    "    \n",
    "    return lista"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Question 7\n",
    "Which county has had the largest absolute change in population within the period 2010-2015? (Hint: population values are stored in columns POPESTIMATE2010 through POPESTIMATE2015, you need to consider all six columns.)\n",
    "\n",
    "e.g. If County Population in the 5 year period is 100, 120, 80, 105, 100, 130, then its largest change in the period would be |130-80| = 50.\n",
    "\n",
    "*This function should return a single string value.*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "umich_part_id": "007",
    "umich_partlist_id": "002"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Harris County'"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def answer_seven():\n",
    "\n",
    "    df = census_df.copy()\n",
    "    col1 = df.columns.get_loc('POPESTIMATE2010')\n",
    "    col2 = df.columns.get_loc('POPESTIMATE2015')\n",
    "\n",
    "    lista = []\n",
    "\n",
    "    for index, row in df.iterrows():\n",
    "        maxi = max(row[col1:col2+1])\n",
    "        mini = min(row[col1:col2+1])\n",
    "\n",
    "        if(row['STNAME'] != row['CTYNAME']):\n",
    "            lista.append((row['CTYNAME'],maxi-mini))\n",
    "\n",
    "    lista.sort(reverse=True, key=lambda x: x[1])\n",
    "    \n",
    "    return lista[0][0]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Question 8\n",
    "In this datafile, the United States is broken up into four regions using the \"REGION\" column. \n",
    "\n",
    "Create a query that finds the counties that belong to regions 1 or 2, whose name starts with 'Washington', and whose POPESTIMATE2015 was greater than their POPESTIMATE 2014.\n",
    "\n",
    "*This function should return a 5x2 DataFrame with the columns = ['STNAME', 'CTYNAME'] and the same index ID as the census_df (sorted ascending by index).*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {
    "umich_part_id": "008",
    "umich_partlist_id": "002"
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\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": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def answer_eight():\n",
    "\n",
    "    df = census_df.copy()\n",
    "    df = df[(df['REGION'] < 3) & (df['POPESTIMATE2015'] > df['POPESTIMATE2014'])]\n",
    "\n",
    "    for index,row in df.iterrows():\n",
    "        if(row['CTYNAME'].split(' ')[0] != 'Washington'):\n",
    "            df = df.drop(labels=index)\n",
    "\n",
    "    df = df.drop(df.columns.difference(['STNAME','CTYNAME']),axis=1)\n",
    "    \n",
    "    return df"
   ]
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "coursera": {
   "course_slug": "python-data-analysis",
   "graded_item_id": "tHmgx",
   "launcher_item_id": "Um6Bz",
   "part_id": "OQsnr"
  },
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.2"
  },
  "umich": {
   "id": "Assignment 2",
   "version": "1.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}