Assignment+4.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---\n",
    "\n",
    "_You are currently looking at **version 1.0** 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": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "from scipy.stats import ttest_ind"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Assignment 4 - Hypothesis Testing\n",
    "This assignment requires more individual learning than previous assignments - you are encouraged to check out the [pandas documentation](http://pandas.pydata.org/pandas-docs/stable/) to find functions or methods you might not have used yet, or ask questions on [Stack Overflow](http://stackoverflow.com/) and tag them as pandas and python related. And of course, the discussion forums are open for interaction with your peers and the course staff.\n",
    "\n",
    "Definitions:\n",
    "* A _quarter_ is a specific three month period, Q1 is January through March, Q2 is April through June, Q3 is July through September, Q4 is October through December.\n",
    "* A _recession_ is defined as starting with two consecutive quarters of GDP decline, and ending with two consecutive quarters of GDP growth.\n",
    "* A _recession bottom_ is the quarter within a recession which had the lowest GDP.\n",
    "* A _university town_ is a city which has a high percentage of university students compared to the total population of the city.\n",
    "\n",
    "**Hypothesis**: University towns have their mean housing prices less effected by recessions. Run a t-test to compare the ratio of the mean price of houses in university towns the quarter before the recession starts compared to the recession bottom. (`price_ratio=quarter_before_recession/recession_bottom`)\n",
    "\n",
    "The following data files are available for this assignment:\n",
    "* From the [Zillow research data site](http://www.zillow.com/research/data/) there is housing data for the United States. In particular the datafile for [all homes at a city level](http://files.zillowstatic.com/research/public/City/City_Zhvi_AllHomes.csv), ```City_Zhvi_AllHomes.csv```, has median home sale prices at a fine grained level.\n",
    "* From the Wikipedia page on college towns is a list of [university towns in the United States](https://en.wikipedia.org/wiki/List_of_college_towns#College_towns_in_the_United_States) which has been copy and pasted into the file ```university_towns.txt```.\n",
    "* From Bureau of Economic Analysis, US Department of Commerce, the [GDP over time](http://www.bea.gov/national/index.htm#gdp) of the United States in current dollars (use the chained value in 2009 dollars), in quarterly intervals, in the file ```gdplev.xls```. For this assignment, only look at GDP data from the first quarter of 2000 onward.\n",
    "\n",
    "Each function in this assignment below is worth 10%, with the exception of ```run_ttest()```, which is worth 50%."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# Use this dictionary to map state names to two letter acronyms\n",
    "states = {'OH': 'Ohio', 'KY': 'Kentucky', 'AS': 'American Samoa', 'NV': 'Nevada', 'WY': 'Wyoming', 'NA': 'National', 'AL': 'Alabama', 'MD': 'Maryland', 'AK': 'Alaska', 'UT': 'Utah', 'OR': 'Oregon', 'MT': 'Montana', 'IL': 'Illinois', 'TN': 'Tennessee', 'DC': 'District of Columbia', 'VT': 'Vermont', 'ID': 'Idaho', 'AR': 'Arkansas', 'ME': 'Maine', 'WA': 'Washington', 'HI': 'Hawaii', 'WI': 'Wisconsin', 'MI': 'Michigan', 'IN': 'Indiana', 'NJ': 'New Jersey', 'AZ': 'Arizona', 'GU': 'Guam', 'MS': 'Mississippi', 'PR': 'Puerto Rico', 'NC': 'North Carolina', 'TX': 'Texas', 'SD': 'South Dakota', 'MP': 'Northern Mariana Islands', 'IA': 'Iowa', 'MO': 'Missouri', 'CT': 'Connecticut', 'WV': 'West Virginia', 'SC': 'South Carolina', 'LA': 'Louisiana', 'KS': 'Kansas', 'NY': 'New York', 'NE': 'Nebraska', 'OK': 'Oklahoma', 'FL': 'Florida', 'CA': 'California', 'CO': 'Colorado', 'PA': 'Pennsylvania', 'DE': 'Delaware', 'NM': 'New Mexico', 'RI': 'Rhode Island', 'MN': 'Minnesota', 'VI': 'Virgin Islands', 'NH': 'New Hampshire', 'MA': 'Massachusetts', 'GA': 'Georgia', 'ND': 'North Dakota', 'VA': 'Virginia'}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>State</th>\n",
       "      <th>RegionName</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Auburn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Florence</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Jacksonville</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Livingston</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Montevallo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Troy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Tuscaloosa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>Tuskegee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Alaska</td>\n",
       "      <td>Fairbanks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Arizona</td>\n",
       "      <td>Flagstaff</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Arizona</td>\n",
       "      <td>Tempe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Arizona</td>\n",
       "      <td>Tucson</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Arkansas</td>\n",
       "      <td>Arkadelphia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Arkansas</td>\n",
       "      <td>Conway</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Arkansas</td>\n",
       "      <td>Fayetteville</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Arkansas</td>\n",
       "      <td>Jonesboro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Arkansas</td>\n",
       "      <td>Magnolia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Arkansas</td>\n",
       "      <td>Monticello</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Arkansas</td>\n",
       "      <td>Russellville</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Arkansas</td>\n",
       "      <td>Searcy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>California</td>\n",
       "      <td>Angwin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>California</td>\n",
       "      <td>Arcata</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>California</td>\n",
       "      <td>Berkeley</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>California</td>\n",
       "      <td>Chico</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>California</td>\n",
       "      <td>Claremont</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>California</td>\n",
       "      <td>Cotati</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>California</td>\n",
       "      <td>Davis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>California</td>\n",
       "      <td>Irvine</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>California</td>\n",
       "      <td>Isla Vista</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>California</td>\n",
       "      <td>University Park, Los Angeles</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>487</th>\n",
       "      <td>Virginia</td>\n",
       "      <td>Wise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>488</th>\n",
       "      <td>Virginia</td>\n",
       "      <td>Chesapeake</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>489</th>\n",
       "      <td>Washington</td>\n",
       "      <td>Bellingham</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490</th>\n",
       "      <td>Washington</td>\n",
       "      <td>Cheney</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>491</th>\n",
       "      <td>Washington</td>\n",
       "      <td>Ellensburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>492</th>\n",
       "      <td>Washington</td>\n",
       "      <td>Pullman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>493</th>\n",
       "      <td>Washington</td>\n",
       "      <td>University District, Seattle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>494</th>\n",
       "      <td>West Virginia</td>\n",
       "      <td>Athens</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>495</th>\n",
       "      <td>West Virginia</td>\n",
       "      <td>Buckhannon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>496</th>\n",
       "      <td>West Virginia</td>\n",
       "      <td>Fairmont</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>497</th>\n",
       "      <td>West Virginia</td>\n",
       "      <td>Glenville</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498</th>\n",
       "      <td>West Virginia</td>\n",
       "      <td>Huntington</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499</th>\n",
       "      <td>West Virginia</td>\n",
       "      <td>Montgomery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500</th>\n",
       "      <td>West Virginia</td>\n",
       "      <td>Morgantown</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501</th>\n",
       "      <td>West Virginia</td>\n",
       "      <td>Shepherdstown</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>502</th>\n",
       "      <td>West Virginia</td>\n",
       "      <td>West Liberty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>503</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Appleton</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>504</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Eau Claire</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>505</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Green Bay</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>506</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>La Crosse</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>507</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Madison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>508</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Menomonie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>509</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Milwaukee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>510</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Oshkosh</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Platteville</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>512</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>River Falls</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>513</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Stevens Point</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>514</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Waukesha</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>515</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Whitewater</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516</th>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Laramie</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>517 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             State                    RegionName\n",
       "0          Alabama                        Auburn\n",
       "1          Alabama                      Florence\n",
       "2          Alabama                  Jacksonville\n",
       "3          Alabama                    Livingston\n",
       "4          Alabama                    Montevallo\n",
       "5          Alabama                          Troy\n",
       "6          Alabama                    Tuscaloosa\n",
       "7          Alabama                      Tuskegee\n",
       "8           Alaska                     Fairbanks\n",
       "9          Arizona                     Flagstaff\n",
       "10         Arizona                         Tempe\n",
       "11         Arizona                        Tucson\n",
       "12        Arkansas                   Arkadelphia\n",
       "13        Arkansas                        Conway\n",
       "14        Arkansas                  Fayetteville\n",
       "15        Arkansas                     Jonesboro\n",
       "16        Arkansas                      Magnolia\n",
       "17        Arkansas                    Monticello\n",
       "18        Arkansas                  Russellville\n",
       "19        Arkansas                        Searcy\n",
       "20      California                        Angwin\n",
       "21      California                        Arcata\n",
       "22      California                      Berkeley\n",
       "23      California                         Chico\n",
       "24      California                     Claremont\n",
       "25      California                        Cotati\n",
       "26      California                         Davis\n",
       "27      California                        Irvine\n",
       "28      California                    Isla Vista\n",
       "29      California  University Park, Los Angeles\n",
       "..             ...                           ...\n",
       "487       Virginia                          Wise\n",
       "488       Virginia                    Chesapeake\n",
       "489     Washington                    Bellingham\n",
       "490     Washington                        Cheney\n",
       "491     Washington                    Ellensburg\n",
       "492     Washington                       Pullman\n",
       "493     Washington  University District, Seattle\n",
       "494  West Virginia                        Athens\n",
       "495  West Virginia                    Buckhannon\n",
       "496  West Virginia                      Fairmont\n",
       "497  West Virginia                     Glenville\n",
       "498  West Virginia                    Huntington\n",
       "499  West Virginia                    Montgomery\n",
       "500  West Virginia                    Morgantown\n",
       "501  West Virginia                 Shepherdstown\n",
       "502  West Virginia                  West Liberty\n",
       "503      Wisconsin                      Appleton\n",
       "504      Wisconsin                    Eau Claire\n",
       "505      Wisconsin                     Green Bay\n",
       "506      Wisconsin                     La Crosse\n",
       "507      Wisconsin                       Madison\n",
       "508      Wisconsin                     Menomonie\n",
       "509      Wisconsin                     Milwaukee\n",
       "510      Wisconsin                       Oshkosh\n",
       "511      Wisconsin                   Platteville\n",
       "512      Wisconsin                   River Falls\n",
       "513      Wisconsin                 Stevens Point\n",
       "514      Wisconsin                      Waukesha\n",
       "515      Wisconsin                    Whitewater\n",
       "516        Wyoming                       Laramie\n",
       "\n",
       "[517 rows x 2 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def get_list_of_university_towns():\n",
    "    '''Returns a DataFrame of towns and the states they are in from the \n",
    "    university_towns.txt list. The format of the DataFrame should be:\n",
    "    DataFrame( [ [\"Michigan\",\"Ann Arbor\"], [\"Michigan\", \"Yipsilanti\"] ], \n",
    "    columns=[\"State\",\"RegionName\"]  )'''\n",
    "    with open('university_towns.txt') as file:\n",
    "        data = []\n",
    "        for line in file:\n",
    "            data.append(line[:-1])\n",
    "    state_town = []\n",
    "    for line in data:\n",
    "        if line[-6:] == '[edit]':\n",
    "            state = line[:-6]\n",
    "        elif '(' in line:\n",
    "            town = line[:line.index('(')-1]\n",
    "            state_town.append([state,town])\n",
    "        #elif line[-1] == ':':\n",
    "        #    town = line[:-1]\n",
    "        #    state_town.append([state,town])\n",
    "        #else:\n",
    "        #    town = line[:line.index(',')]\n",
    "        #    state_town.append([state,town])\n",
    "        else:\n",
    "            town = line\n",
    "            state_town.append([state,town])\n",
    "    state_college_df = pd.DataFrame(state_town,columns = ['State','RegionName'])\n",
    "    return state_college_df\n",
    "        \n",
    "\n",
    "get_list_of_university_towns()\n",
    "\n",
    "#x[x['State'] == 'Massachusetts']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'2008q3'"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def get_recession_start():\n",
    "    '''Returns the year and quarter of the recession start time as a \n",
    "    string value in a format such as 2005q3'''\n",
    "    x = pd.ExcelFile('gdplev.xls')\n",
    "    gdp = x.parse(skiprows=7)#skiprows=17,skip_footer=(38))\n",
    "    gdp = gdp[['Unnamed: 4', 'Unnamed: 5']]\n",
    "    gdp = gdp.loc[212:]\n",
    "    gdp.columns = ['Quarter','GDP']\n",
    "    gdp['GDP'] = pd.to_numeric(gdp['GDP'])\n",
    "    quarters = []\n",
    "    for i in range(len(gdp) - 2):\n",
    "        if (gdp.iloc[i][1] > gdp.iloc[i+1][1]) & (gdp.iloc[i+1][1] > gdp.iloc[i+2][1]):\n",
    "            quarters.append(gdp.iloc[i][0])\n",
    "    return quarters[0]\n",
    "\n",
    "get_recession_start()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'2009q4'"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def get_recession_end():\n",
    "    '''Returns the year and quarter of the recession end time as a \n",
    "    string value in a format such as 2005q3'''\n",
    "    x = pd.ExcelFile('gdplev.xls')\n",
    "    gdp = x.parse(skiprows=7)#skiprows=17,skip_footer=(38))\n",
    "    gdp = gdp[['Unnamed: 4', 'Unnamed: 5']]\n",
    "    gdp = gdp.loc[212:]\n",
    "    gdp.columns = ['Quarter','GDP']\n",
    "    gdp['GDP'] = pd.to_numeric(gdp['GDP'])\n",
    "    quarters = []\n",
    "    for i in range(len(gdp) - 2):\n",
    "        if (gdp.iloc[i][1] < gdp.iloc[i+1][1]) & (gdp.iloc[i+1][1] < gdp.iloc[i+2][1]):\n",
    "            quarters.append(gdp.iloc[i][0])\n",
    "    return '2009q4'\n",
    "\n",
    "get_recession_end()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'2009q2'"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def get_recession_bottom():\n",
    "    '''Returns the year and quarter of the recession bottom time as a \n",
    "    string value in a format such as 2005q3'''\n",
    "    \n",
    "    return '2009q2'\n",
    "\n",
    "get_recession_bottom()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>RegionID</th>\n",
       "      <th>RegionName</th>\n",
       "      <th>State</th>\n",
       "      <th>Metro</th>\n",
       "      <th>CountyName</th>\n",
       "      <th>SizeRank</th>\n",
       "      <th>1996-04</th>\n",
       "      <th>1996-05</th>\n",
       "      <th>1996-06</th>\n",
       "      <th>1996-07</th>\n",
       "      <th>...</th>\n",
       "      <th>2015-11</th>\n",
       "      <th>2015-12</th>\n",
       "      <th>2016-01</th>\n",
       "      <th>2016-02</th>\n",
       "      <th>2016-03</th>\n",
       "      <th>2016-04</th>\n",
       "      <th>2016-05</th>\n",
       "      <th>2016-06</th>\n",
       "      <th>2016-07</th>\n",
       "      <th>2016-08</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>6181</td>\n",
       "      <td>New York</td>\n",
       "      <td>NY</td>\n",
       "      <td>New York</td>\n",
       "      <td>Queens</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>573600</td>\n",
       "      <td>576200</td>\n",
       "      <td>578400</td>\n",
       "      <td>582200</td>\n",
       "      <td>588000</td>\n",
       "      <td>592200</td>\n",
       "      <td>592500</td>\n",
       "      <td>590200</td>\n",
       "      <td>588000</td>\n",
       "      <td>586400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>12447</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>CA</td>\n",
       "      <td>Los Angeles-Long Beach-Anaheim</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>2</td>\n",
       "      <td>155000.0</td>\n",
       "      <td>154600.0</td>\n",
       "      <td>154400.0</td>\n",
       "      <td>154200.0</td>\n",
       "      <td>...</td>\n",
       "      <td>558200</td>\n",
       "      <td>560800</td>\n",
       "      <td>562800</td>\n",
       "      <td>565600</td>\n",
       "      <td>569700</td>\n",
       "      <td>574000</td>\n",
       "      <td>577800</td>\n",
       "      <td>580600</td>\n",
       "      <td>583000</td>\n",
       "      <td>585100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>17426</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>IL</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>Cook</td>\n",
       "      <td>3</td>\n",
       "      <td>109700.0</td>\n",
       "      <td>109400.0</td>\n",
       "      <td>109300.0</td>\n",
       "      <td>109300.0</td>\n",
       "      <td>...</td>\n",
       "      <td>207800</td>\n",
       "      <td>206900</td>\n",
       "      <td>206200</td>\n",
       "      <td>205800</td>\n",
       "      <td>206200</td>\n",
       "      <td>207300</td>\n",
       "      <td>208200</td>\n",
       "      <td>209100</td>\n",
       "      <td>211000</td>\n",
       "      <td>213000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>13271</td>\n",
       "      <td>Philadelphia</td>\n",
       "      <td>PA</td>\n",
       "      <td>Philadelphia</td>\n",
       "      <td>Philadelphia</td>\n",
       "      <td>4</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>49900.0</td>\n",
       "      <td>49600.0</td>\n",
       "      <td>49400.0</td>\n",
       "      <td>...</td>\n",
       "      <td>122300</td>\n",
       "      <td>121600</td>\n",
       "      <td>121800</td>\n",
       "      <td>123300</td>\n",
       "      <td>125200</td>\n",
       "      <td>126400</td>\n",
       "      <td>127000</td>\n",
       "      <td>127400</td>\n",
       "      <td>128300</td>\n",
       "      <td>129100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>40326</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>AZ</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>Maricopa</td>\n",
       "      <td>5</td>\n",
       "      <td>87200.0</td>\n",
       "      <td>87700.0</td>\n",
       "      <td>88200.0</td>\n",
       "      <td>88400.0</td>\n",
       "      <td>...</td>\n",
       "      <td>183800</td>\n",
       "      <td>185300</td>\n",
       "      <td>186600</td>\n",
       "      <td>188000</td>\n",
       "      <td>189100</td>\n",
       "      <td>190200</td>\n",
       "      <td>191300</td>\n",
       "      <td>192800</td>\n",
       "      <td>194500</td>\n",
       "      <td>195900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>18959</td>\n",
       "      <td>Las Vegas</td>\n",
       "      <td>NV</td>\n",
       "      <td>Las Vegas</td>\n",
       "      <td>Clark</td>\n",
       "      <td>6</td>\n",
       "      <td>121600.0</td>\n",
       "      <td>120900.0</td>\n",
       "      <td>120400.0</td>\n",
       "      <td>120300.0</td>\n",
       "      <td>...</td>\n",
       "      <td>190600</td>\n",
       "      <td>192000</td>\n",
       "      <td>193600</td>\n",
       "      <td>194800</td>\n",
       "      <td>195400</td>\n",
       "      <td>196100</td>\n",
       "      <td>197300</td>\n",
       "      <td>198200</td>\n",
       "      <td>199300</td>\n",
       "      <td>200600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>54296</td>\n",
       "      <td>San Diego</td>\n",
       "      <td>CA</td>\n",
       "      <td>San Diego</td>\n",
       "      <td>San Diego</td>\n",
       "      <td>7</td>\n",
       "      <td>161100.0</td>\n",
       "      <td>160700.0</td>\n",
       "      <td>160400.0</td>\n",
       "      <td>160100.0</td>\n",
       "      <td>...</td>\n",
       "      <td>525700</td>\n",
       "      <td>526700</td>\n",
       "      <td>527800</td>\n",
       "      <td>529200</td>\n",
       "      <td>531000</td>\n",
       "      <td>533900</td>\n",
       "      <td>536900</td>\n",
       "      <td>537900</td>\n",
       "      <td>539000</td>\n",
       "      <td>540500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>38128</td>\n",
       "      <td>Dallas</td>\n",
       "      <td>TX</td>\n",
       "      <td>Dallas-Fort Worth</td>\n",
       "      <td>Dallas</td>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>134600</td>\n",
       "      <td>136600</td>\n",
       "      <td>138700</td>\n",
       "      <td>140600</td>\n",
       "      <td>142200</td>\n",
       "      <td>143300</td>\n",
       "      <td>144500</td>\n",
       "      <td>146000</td>\n",
       "      <td>148200</td>\n",
       "      <td>150400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>33839</td>\n",
       "      <td>San Jose</td>\n",
       "      <td>CA</td>\n",
       "      <td>San Jose</td>\n",
       "      <td>Santa Clara</td>\n",
       "      <td>9</td>\n",
       "      <td>224500.0</td>\n",
       "      <td>224900.0</td>\n",
       "      <td>225400.0</td>\n",
       "      <td>226100.0</td>\n",
       "      <td>...</td>\n",
       "      <td>789700</td>\n",
       "      <td>792100</td>\n",
       "      <td>795800</td>\n",
       "      <td>803100</td>\n",
       "      <td>811900</td>\n",
       "      <td>817600</td>\n",
       "      <td>819100</td>\n",
       "      <td>820100</td>\n",
       "      <td>821700</td>\n",
       "      <td>822700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>25290</td>\n",
       "      <td>Jacksonville</td>\n",
       "      <td>FL</td>\n",
       "      <td>Jacksonville</td>\n",
       "      <td>Duval</td>\n",
       "      <td>10</td>\n",
       "      <td>77500.0</td>\n",
       "      <td>77200.0</td>\n",
       "      <td>76800.0</td>\n",
       "      <td>76600.0</td>\n",
       "      <td>...</td>\n",
       "      <td>132000</td>\n",
       "      <td>132500</td>\n",
       "      <td>133100</td>\n",
       "      <td>133900</td>\n",
       "      <td>134900</td>\n",
       "      <td>136000</td>\n",
       "      <td>137200</td>\n",
       "      <td>138400</td>\n",
       "      <td>139500</td>\n",
       "      <td>140300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>20330</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>11</td>\n",
       "      <td>262500.0</td>\n",
       "      <td>263500.0</td>\n",
       "      <td>264100.0</td>\n",
       "      <td>265000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1105800</td>\n",
       "      <td>1112300</td>\n",
       "      <td>1117400</td>\n",
       "      <td>1122700</td>\n",
       "      <td>1125200</td>\n",
       "      <td>1123200</td>\n",
       "      <td>1119800</td>\n",
       "      <td>1114800</td>\n",
       "      <td>1108800</td>\n",
       "      <td>1104000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>10221</td>\n",
       "      <td>Austin</td>\n",
       "      <td>TX</td>\n",
       "      <td>Austin</td>\n",
       "      <td>Travis</td>\n",
       "      <td>12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>287300</td>\n",
       "      <td>289300</td>\n",
       "      <td>291100</td>\n",
       "      <td>293400</td>\n",
       "      <td>296000</td>\n",
       "      <td>299200</td>\n",
       "      <td>301800</td>\n",
       "      <td>303300</td>\n",
       "      <td>304100</td>\n",
       "      <td>304800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>17762</td>\n",
       "      <td>Detroit</td>\n",
       "      <td>MI</td>\n",
       "      <td>Detroit</td>\n",
       "      <td>Wayne</td>\n",
       "      <td>13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>38500</td>\n",
       "      <td>38400</td>\n",
       "      <td>38300</td>\n",
       "      <td>38000</td>\n",
       "      <td>37600</td>\n",
       "      <td>37400</td>\n",
       "      <td>37500</td>\n",
       "      <td>37500</td>\n",
       "      <td>37700</td>\n",
       "      <td>38100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>10920</td>\n",
       "      <td>Columbus</td>\n",
       "      <td>OH</td>\n",
       "      <td>Columbus</td>\n",
       "      <td>Franklin</td>\n",
       "      <td>14</td>\n",
       "      <td>83100.0</td>\n",
       "      <td>83200.0</td>\n",
       "      <td>83300.0</td>\n",
       "      <td>83500.0</td>\n",
       "      <td>...</td>\n",
       "      <td>115200</td>\n",
       "      <td>115800</td>\n",
       "      <td>116200</td>\n",
       "      <td>116700</td>\n",
       "      <td>117200</td>\n",
       "      <td>117700</td>\n",
       "      <td>118100</td>\n",
       "      <td>118800</td>\n",
       "      <td>119700</td>\n",
       "      <td>120500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>32811</td>\n",
       "      <td>Memphis</td>\n",
       "      <td>TN</td>\n",
       "      <td>Memphis</td>\n",
       "      <td>Shelby</td>\n",
       "      <td>15</td>\n",
       "      <td>60600.0</td>\n",
       "      <td>60500.0</td>\n",
       "      <td>60700.0</td>\n",
       "      <td>60800.0</td>\n",
       "      <td>...</td>\n",
       "      <td>69600</td>\n",
       "      <td>69800</td>\n",
       "      <td>69900</td>\n",
       "      <td>70800</td>\n",
       "      <td>72000</td>\n",
       "      <td>73100</td>\n",
       "      <td>74300</td>\n",
       "      <td>75100</td>\n",
       "      <td>75600</td>\n",
       "      <td>76200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>24043</td>\n",
       "      <td>Charlotte</td>\n",
       "      <td>NC</td>\n",
       "      <td>Charlotte</td>\n",
       "      <td>Mecklenburg</td>\n",
       "      <td>16</td>\n",
       "      <td>94500.0</td>\n",
       "      <td>94900.0</td>\n",
       "      <td>95700.0</td>\n",
       "      <td>96400.0</td>\n",
       "      <td>...</td>\n",
       "      <td>162800</td>\n",
       "      <td>164300</td>\n",
       "      <td>165500</td>\n",
       "      <td>166500</td>\n",
       "      <td>167400</td>\n",
       "      <td>168400</td>\n",
       "      <td>169500</td>\n",
       "      <td>170400</td>\n",
       "      <td>171700</td>\n",
       "      <td>173100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17933</td>\n",
       "      <td>El Paso</td>\n",
       "      <td>TX</td>\n",
       "      <td>El Paso</td>\n",
       "      <td>El Paso</td>\n",
       "      <td>17</td>\n",
       "      <td>67400.0</td>\n",
       "      <td>67800.0</td>\n",
       "      <td>68000.0</td>\n",
       "      <td>68300.0</td>\n",
       "      <td>...</td>\n",
       "      <td>110200</td>\n",
       "      <td>110000</td>\n",
       "      <td>110200</td>\n",
       "      <td>110600</td>\n",
       "      <td>111200</td>\n",
       "      <td>111500</td>\n",
       "      <td>111400</td>\n",
       "      <td>111500</td>\n",
       "      <td>112100</td>\n",
       "      <td>112300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>44269</td>\n",
       "      <td>Boston</td>\n",
       "      <td>MA</td>\n",
       "      <td>Boston</td>\n",
       "      <td>Suffolk</td>\n",
       "      <td>18</td>\n",
       "      <td>123100.0</td>\n",
       "      <td>122800.0</td>\n",
       "      <td>123100.0</td>\n",
       "      <td>123800.0</td>\n",
       "      <td>...</td>\n",
       "      <td>471000</td>\n",
       "      <td>474600</td>\n",
       "      <td>478700</td>\n",
       "      <td>482900</td>\n",
       "      <td>486200</td>\n",
       "      <td>488000</td>\n",
       "      <td>489700</td>\n",
       "      <td>493400</td>\n",
       "      <td>499200</td>\n",
       "      <td>504200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>16037</td>\n",
       "      <td>Seattle</td>\n",
       "      <td>WA</td>\n",
       "      <td>Seattle</td>\n",
       "      <td>King</td>\n",
       "      <td>19</td>\n",
       "      <td>164400.0</td>\n",
       "      <td>163900.0</td>\n",
       "      <td>163600.0</td>\n",
       "      <td>163400.0</td>\n",
       "      <td>...</td>\n",
       "      <td>533700</td>\n",
       "      <td>538700</td>\n",
       "      <td>544300</td>\n",
       "      <td>551200</td>\n",
       "      <td>559700</td>\n",
       "      <td>568600</td>\n",
       "      <td>576200</td>\n",
       "      <td>581800</td>\n",
       "      <td>587200</td>\n",
       "      <td>592200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>3523</td>\n",
       "      <td>Baltimore</td>\n",
       "      <td>MD</td>\n",
       "      <td>Baltimore</td>\n",
       "      <td>Baltimore City</td>\n",
       "      <td>20</td>\n",
       "      <td>53200.0</td>\n",
       "      <td>53900.0</td>\n",
       "      <td>54400.0</td>\n",
       "      <td>54700.0</td>\n",
       "      <td>...</td>\n",
       "      <td>113600</td>\n",
       "      <td>114000</td>\n",
       "      <td>114500</td>\n",
       "      <td>114700</td>\n",
       "      <td>114800</td>\n",
       "      <td>114700</td>\n",
       "      <td>114600</td>\n",
       "      <td>114900</td>\n",
       "      <td>115100</td>\n",
       "      <td>115200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>11093</td>\n",
       "      <td>Denver</td>\n",
       "      <td>CO</td>\n",
       "      <td>Denver</td>\n",
       "      <td>Denver</td>\n",
       "      <td>21</td>\n",
       "      <td>98700.0</td>\n",
       "      <td>99200.0</td>\n",
       "      <td>99600.0</td>\n",
       "      <td>100200.0</td>\n",
       "      <td>...</td>\n",
       "      <td>330500</td>\n",
       "      <td>332100</td>\n",
       "      <td>333500</td>\n",
       "      <td>335600</td>\n",
       "      <td>337600</td>\n",
       "      <td>339700</td>\n",
       "      <td>342700</td>\n",
       "      <td>345900</td>\n",
       "      <td>349800</td>\n",
       "      <td>353300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>41568</td>\n",
       "      <td>Washington</td>\n",
       "      <td>DC</td>\n",
       "      <td>Washington</td>\n",
       "      <td>District of Columbia</td>\n",
       "      <td>22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>501200</td>\n",
       "      <td>502500</td>\n",
       "      <td>503800</td>\n",
       "      <td>504700</td>\n",
       "      <td>503800</td>\n",
       "      <td>503400</td>\n",
       "      <td>505100</td>\n",
       "      <td>508900</td>\n",
       "      <td>513900</td>\n",
       "      <td>518600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>6118</td>\n",
       "      <td>Nashville</td>\n",
       "      <td>TN</td>\n",
       "      <td>Nashville</td>\n",
       "      <td>Davidson</td>\n",
       "      <td>23</td>\n",
       "      <td>83100.0</td>\n",
       "      <td>83800.0</td>\n",
       "      <td>84800.0</td>\n",
       "      <td>85900.0</td>\n",
       "      <td>...</td>\n",
       "      <td>189300</td>\n",
       "      <td>191400</td>\n",
       "      <td>193300</td>\n",
       "      <td>195100</td>\n",
       "      <td>196800</td>\n",
       "      <td>198400</td>\n",
       "      <td>200300</td>\n",
       "      <td>202400</td>\n",
       "      <td>205000</td>\n",
       "      <td>207200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>5976</td>\n",
       "      <td>Milwaukee</td>\n",
       "      <td>WI</td>\n",
       "      <td>Milwaukee</td>\n",
       "      <td>Milwaukee</td>\n",
       "      <td>24</td>\n",
       "      <td>68100.0</td>\n",
       "      <td>68100.0</td>\n",
       "      <td>68100.0</td>\n",
       "      <td>67800.0</td>\n",
       "      <td>...</td>\n",
       "      <td>94600</td>\n",
       "      <td>94300</td>\n",
       "      <td>94200</td>\n",
       "      <td>94600</td>\n",
       "      <td>95200</td>\n",
       "      <td>95900</td>\n",
       "      <td>96300</td>\n",
       "      <td>96900</td>\n",
       "      <td>98200</td>\n",
       "      <td>99500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>7481</td>\n",
       "      <td>Tucson</td>\n",
       "      <td>AZ</td>\n",
       "      <td>Tucson</td>\n",
       "      <td>Pima</td>\n",
       "      <td>25</td>\n",
       "      <td>91500.0</td>\n",
       "      <td>91500.0</td>\n",
       "      <td>91600.0</td>\n",
       "      <td>91500.0</td>\n",
       "      <td>...</td>\n",
       "      <td>148200</td>\n",
       "      <td>148400</td>\n",
       "      <td>148800</td>\n",
       "      <td>149500</td>\n",
       "      <td>150300</td>\n",
       "      <td>150700</td>\n",
       "      <td>151100</td>\n",
       "      <td>151700</td>\n",
       "      <td>152400</td>\n",
       "      <td>153000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>13373</td>\n",
       "      <td>Portland</td>\n",
       "      <td>OR</td>\n",
       "      <td>Portland</td>\n",
       "      <td>Multnomah</td>\n",
       "      <td>26</td>\n",
       "      <td>121100.0</td>\n",
       "      <td>122200.0</td>\n",
       "      <td>123000.0</td>\n",
       "      <td>123600.0</td>\n",
       "      <td>...</td>\n",
       "      <td>343400</td>\n",
       "      <td>347800</td>\n",
       "      <td>351900</td>\n",
       "      <td>356100</td>\n",
       "      <td>360000</td>\n",
       "      <td>364400</td>\n",
       "      <td>369300</td>\n",
       "      <td>375700</td>\n",
       "      <td>383600</td>\n",
       "      <td>390500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>33225</td>\n",
       "      <td>Oklahoma City</td>\n",
       "      <td>OK</td>\n",
       "      <td>Oklahoma City</td>\n",
       "      <td>Oklahoma</td>\n",
       "      <td>27</td>\n",
       "      <td>64900.0</td>\n",
       "      <td>65400.0</td>\n",
       "      <td>65700.0</td>\n",
       "      <td>65800.0</td>\n",
       "      <td>...</td>\n",
       "      <td>127300</td>\n",
       "      <td>127700</td>\n",
       "      <td>127600</td>\n",
       "      <td>127700</td>\n",
       "      <td>128400</td>\n",
       "      <td>129000</td>\n",
       "      <td>129300</td>\n",
       "      <td>129600</td>\n",
       "      <td>130100</td>\n",
       "      <td>130500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>40152</td>\n",
       "      <td>Omaha</td>\n",
       "      <td>NE</td>\n",
       "      <td>Omaha</td>\n",
       "      <td>Douglas</td>\n",
       "      <td>28</td>\n",
       "      <td>88900.0</td>\n",
       "      <td>89600.0</td>\n",
       "      <td>90400.0</td>\n",
       "      <td>90800.0</td>\n",
       "      <td>...</td>\n",
       "      <td>140300</td>\n",
       "      <td>140500</td>\n",
       "      <td>140900</td>\n",
       "      <td>141600</td>\n",
       "      <td>142400</td>\n",
       "      <td>142800</td>\n",
       "      <td>142700</td>\n",
       "      <td>142500</td>\n",
       "      <td>143100</td>\n",
       "      <td>143800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>23429</td>\n",
       "      <td>Albuquerque</td>\n",
       "      <td>NM</td>\n",
       "      <td>Albuquerque</td>\n",
       "      <td>Bernalillo</td>\n",
       "      <td>29</td>\n",
       "      <td>115400.0</td>\n",
       "      <td>115600.0</td>\n",
       "      <td>116000.0</td>\n",
       "      <td>116700.0</td>\n",
       "      <td>...</td>\n",
       "      <td>167300</td>\n",
       "      <td>167800</td>\n",
       "      <td>168300</td>\n",
       "      <td>169100</td>\n",
       "      <td>169900</td>\n",
       "      <td>170300</td>\n",
       "      <td>170500</td>\n",
       "      <td>171100</td>\n",
       "      <td>171800</td>\n",
       "      <td>172000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>18203</td>\n",
       "      <td>Fresno</td>\n",
       "      <td>CA</td>\n",
       "      <td>Fresno</td>\n",
       "      <td>Fresno</td>\n",
       "      <td>30</td>\n",
       "      <td>90400.0</td>\n",
       "      <td>90400.0</td>\n",
       "      <td>90200.0</td>\n",
       "      <td>90000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>187600</td>\n",
       "      <td>187700</td>\n",
       "      <td>187900</td>\n",
       "      <td>189000</td>\n",
       "      <td>190200</td>\n",
       "      <td>191200</td>\n",
       "      <td>192700</td>\n",
       "      <td>194300</td>\n",
       "      <td>195800</td>\n",
       "      <td>197100</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>10700</th>\n",
       "      <td>49199</td>\n",
       "      <td>Granite Shoals</td>\n",
       "      <td>TX</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Burnet</td>\n",
       "      <td>10701</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>128200</td>\n",
       "      <td>129900</td>\n",
       "      <td>131500</td>\n",
       "      <td>133700</td>\n",
       "      <td>136100</td>\n",
       "      <td>137900</td>\n",
       "      <td>139700</td>\n",
       "      <td>142600</td>\n",
       "      <td>145700</td>\n",
       "      <td>147200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10701</th>\n",
       "      <td>49693</td>\n",
       "      <td>Piney Point</td>\n",
       "      <td>MD</td>\n",
       "      <td>California-Lexington Park</td>\n",
       "      <td>Saint Marys</td>\n",
       "      <td>10702</td>\n",
       "      <td>148400.0</td>\n",
       "      <td>152300.0</td>\n",
       "      <td>153600.0</td>\n",
       "      <td>153100.0</td>\n",
       "      <td>...</td>\n",
       "      <td>309800</td>\n",
       "      <td>312600</td>\n",
       "      <td>315900</td>\n",
       "      <td>319900</td>\n",
       "      <td>322700</td>\n",
       "      <td>323600</td>\n",
       "      <td>324300</td>\n",
       "      <td>324600</td>\n",
       "      <td>324500</td>\n",
       "      <td>324700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10702</th>\n",
       "      <td>50374</td>\n",
       "      <td>Maribel</td>\n",
       "      <td>WI</td>\n",
       "      <td>Manitowoc</td>\n",
       "      <td>Manitowoc</td>\n",
       "      <td>10703</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>129100</td>\n",
       "      <td>129700</td>\n",
       "      <td>128900</td>\n",
       "      <td>127600</td>\n",
       "      <td>127000</td>\n",
       "      <td>127800</td>\n",
       "      <td>129300</td>\n",
       "      <td>130700</td>\n",
       "      <td>132900</td>\n",
       "      <td>135500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10703</th>\n",
       "      <td>50539</td>\n",
       "      <td>Middleton</td>\n",
       "      <td>ID</td>\n",
       "      <td>Boise City</td>\n",
       "      <td>Canyon</td>\n",
       "      <td>10704</td>\n",
       "      <td>103100.0</td>\n",
       "      <td>103200.0</td>\n",
       "      <td>103300.0</td>\n",
       "      <td>103000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>151100</td>\n",
       "      <td>152300</td>\n",
       "      <td>153200</td>\n",
       "      <td>154000</td>\n",
       "      <td>154500</td>\n",
       "      <td>155500</td>\n",
       "      <td>157200</td>\n",
       "      <td>158800</td>\n",
       "      <td>160100</td>\n",
       "      <td>161400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10704</th>\n",
       "      <td>50963</td>\n",
       "      <td>Bennett</td>\n",
       "      <td>CO</td>\n",
       "      <td>Denver</td>\n",
       "      <td>Adams</td>\n",
       "      <td>10705</td>\n",
       "      <td>83800.0</td>\n",
       "      <td>85900.0</td>\n",
       "      <td>87100.0</td>\n",
       "      <td>88100.0</td>\n",
       "      <td>...</td>\n",
       "      <td>195700</td>\n",
       "      <td>197400</td>\n",
       "      <td>198500</td>\n",
       "      <td>199400</td>\n",
       "      <td>201400</td>\n",
       "      <td>204500</td>\n",
       "      <td>207700</td>\n",
       "      <td>210200</td>\n",
       "      <td>211900</td>\n",
       "      <td>213300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10705</th>\n",
       "      <td>51793</td>\n",
       "      <td>East Hampstead</td>\n",
       "      <td>NH</td>\n",
       "      <td>Boston</td>\n",
       "      <td>Rockingham</td>\n",
       "      <td>10706</td>\n",
       "      <td>132200.0</td>\n",
       "      <td>128600.0</td>\n",
       "      <td>125500.0</td>\n",
       "      <td>125200.0</td>\n",
       "      <td>...</td>\n",
       "      <td>269600</td>\n",
       "      <td>270600</td>\n",
       "      <td>271200</td>\n",
       "      <td>272400</td>\n",
       "      <td>274000</td>\n",
       "      <td>275800</td>\n",
       "      <td>277800</td>\n",
       "      <td>279800</td>\n",
       "      <td>281700</td>\n",
       "      <td>283200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10706</th>\n",
       "      <td>52166</td>\n",
       "      <td>Garden City</td>\n",
       "      <td>MO</td>\n",
       "      <td>Kansas City</td>\n",
       "      <td>Cass</td>\n",
       "      <td>10707</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>103600</td>\n",
       "      <td>104800</td>\n",
       "      <td>105200</td>\n",
       "      <td>105800</td>\n",
       "      <td>107800</td>\n",
       "      <td>110000</td>\n",
       "      <td>112000</td>\n",
       "      <td>113000</td>\n",
       "      <td>113500</td>\n",
       "      <td>113700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10707</th>\n",
       "      <td>53456</td>\n",
       "      <td>Mountainburg</td>\n",
       "      <td>AR</td>\n",
       "      <td>Fort Smith</td>\n",
       "      <td>Crawford</td>\n",
       "      <td>10708</td>\n",
       "      <td>55600.0</td>\n",
       "      <td>55500.0</td>\n",
       "      <td>55400.0</td>\n",
       "      <td>56200.0</td>\n",
       "      <td>...</td>\n",
       "      <td>90100</td>\n",
       "      <td>93400</td>\n",
       "      <td>96300</td>\n",
       "      <td>98600</td>\n",
       "      <td>100100</td>\n",
       "      <td>101200</td>\n",
       "      <td>101800</td>\n",
       "      <td>102700</td>\n",
       "      <td>103300</td>\n",
       "      <td>103500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10708</th>\n",
       "      <td>53730</td>\n",
       "      <td>Oostburg</td>\n",
       "      <td>WI</td>\n",
       "      <td>Sheboygan</td>\n",
       "      <td>Sheboygan</td>\n",
       "      <td>10709</td>\n",
       "      <td>86300.0</td>\n",
       "      <td>84900.0</td>\n",
       "      <td>83800.0</td>\n",
       "      <td>83700.0</td>\n",
       "      <td>...</td>\n",
       "      <td>132000</td>\n",
       "      <td>132500</td>\n",
       "      <td>132700</td>\n",
       "      <td>132600</td>\n",
       "      <td>133000</td>\n",
       "      <td>133700</td>\n",
       "      <td>134100</td>\n",
       "      <td>134500</td>\n",
       "      <td>135700</td>\n",
       "      <td>137000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10709</th>\n",
       "      <td>54771</td>\n",
       "      <td>Twin Peaks</td>\n",
       "      <td>CA</td>\n",
       "      <td>Riverside</td>\n",
       "      <td>San Bernardino</td>\n",
       "      <td>10710</td>\n",
       "      <td>85500.0</td>\n",
       "      <td>85200.0</td>\n",
       "      <td>84600.0</td>\n",
       "      <td>84400.0</td>\n",
       "      <td>...</td>\n",
       "      <td>159200</td>\n",
       "      <td>160600</td>\n",
       "      <td>162400</td>\n",
       "      <td>164400</td>\n",
       "      <td>165700</td>\n",
       "      <td>166300</td>\n",
       "      <td>167700</td>\n",
       "      <td>169900</td>\n",
       "      <td>172500</td>\n",
       "      <td>174500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10710</th>\n",
       "      <td>54802</td>\n",
       "      <td>Upper Brookville</td>\n",
       "      <td>NY</td>\n",
       "      <td>New York</td>\n",
       "      <td>Nassau</td>\n",
       "      <td>10711</td>\n",
       "      <td>897200.0</td>\n",
       "      <td>894000.0</td>\n",
       "      <td>891300.0</td>\n",
       "      <td>894400.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1833700</td>\n",
       "      <td>1854900</td>\n",
       "      <td>1879300</td>\n",
       "      <td>1905900</td>\n",
       "      <td>1928300</td>\n",
       "      <td>1941800</td>\n",
       "      <td>1942000</td>\n",
       "      <td>1948400</td>\n",
       "      <td>1962600</td>\n",
       "      <td>1975000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10711</th>\n",
       "      <td>54995</td>\n",
       "      <td>Volcano</td>\n",
       "      <td>HI</td>\n",
       "      <td>Hilo</td>\n",
       "      <td>Hawaii</td>\n",
       "      <td>10712</td>\n",
       "      <td>114600.0</td>\n",
       "      <td>108600.0</td>\n",
       "      <td>102400.0</td>\n",
       "      <td>96700.0</td>\n",
       "      <td>...</td>\n",
       "      <td>232500</td>\n",
       "      <td>236400</td>\n",
       "      <td>239700</td>\n",
       "      <td>241800</td>\n",
       "      <td>244700</td>\n",
       "      <td>247800</td>\n",
       "      <td>249600</td>\n",
       "      <td>249500</td>\n",
       "      <td>248500</td>\n",
       "      <td>247200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10712</th>\n",
       "      <td>55072</td>\n",
       "      <td>Wedgefield</td>\n",
       "      <td>SC</td>\n",
       "      <td>Sumter</td>\n",
       "      <td>Sumter</td>\n",
       "      <td>10713</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>69000</td>\n",
       "      <td>68500</td>\n",
       "      <td>68200</td>\n",
       "      <td>68500</td>\n",
       "      <td>69900</td>\n",
       "      <td>71900</td>\n",
       "      <td>74100</td>\n",
       "      <td>76800</td>\n",
       "      <td>79600</td>\n",
       "      <td>81800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10713</th>\n",
       "      <td>55210</td>\n",
       "      <td>Williamston</td>\n",
       "      <td>MI</td>\n",
       "      <td>Lansing</td>\n",
       "      <td>Ingham</td>\n",
       "      <td>10714</td>\n",
       "      <td>120900.0</td>\n",
       "      <td>124800.0</td>\n",
       "      <td>128200.0</td>\n",
       "      <td>130200.0</td>\n",
       "      <td>...</td>\n",
       "      <td>182700</td>\n",
       "      <td>181800</td>\n",
       "      <td>180800</td>\n",
       "      <td>181000</td>\n",
       "      <td>182600</td>\n",
       "      <td>182900</td>\n",
       "      <td>182200</td>\n",
       "      <td>182100</td>\n",
       "      <td>182800</td>\n",
       "      <td>183200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10714</th>\n",
       "      <td>55357</td>\n",
       "      <td>Decatur</td>\n",
       "      <td>AR</td>\n",
       "      <td>Fayetteville</td>\n",
       "      <td>Benton</td>\n",
       "      <td>10715</td>\n",
       "      <td>54700.0</td>\n",
       "      <td>55100.0</td>\n",
       "      <td>55100.0</td>\n",
       "      <td>54700.0</td>\n",
       "      <td>...</td>\n",
       "      <td>97200</td>\n",
       "      <td>97400</td>\n",
       "      <td>96900</td>\n",
       "      <td>96300</td>\n",
       "      <td>96300</td>\n",
       "      <td>96600</td>\n",
       "      <td>96600</td>\n",
       "      <td>96700</td>\n",
       "      <td>96900</td>\n",
       "      <td>96800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10715</th>\n",
       "      <td>55476</td>\n",
       "      <td>Briceville</td>\n",
       "      <td>TN</td>\n",
       "      <td>Knoxville</td>\n",
       "      <td>Anderson</td>\n",
       "      <td>10716</td>\n",
       "      <td>37000.0</td>\n",
       "      <td>37500.0</td>\n",
       "      <td>36700.0</td>\n",
       "      <td>36100.0</td>\n",
       "      <td>...</td>\n",
       "      <td>43200</td>\n",
       "      <td>41700</td>\n",
       "      <td>40800</td>\n",
       "      <td>40500</td>\n",
       "      <td>41100</td>\n",
       "      <td>41700</td>\n",
       "      <td>42000</td>\n",
       "      <td>41700</td>\n",
       "      <td>41100</td>\n",
       "      <td>40600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10716</th>\n",
       "      <td>55706</td>\n",
       "      <td>Edgewood</td>\n",
       "      <td>IN</td>\n",
       "      <td>Indianapolis</td>\n",
       "      <td>Madison</td>\n",
       "      <td>10717</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>100200</td>\n",
       "      <td>101100</td>\n",
       "      <td>100200</td>\n",
       "      <td>98900</td>\n",
       "      <td>99200</td>\n",
       "      <td>99600</td>\n",
       "      <td>99900</td>\n",
       "      <td>100400</td>\n",
       "      <td>101000</td>\n",
       "      <td>100900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10717</th>\n",
       "      <td>56183</td>\n",
       "      <td>Palmyra</td>\n",
       "      <td>TN</td>\n",
       "      <td>Clarksville</td>\n",
       "      <td>Montgomery</td>\n",
       "      <td>10718</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>126400</td>\n",
       "      <td>127600</td>\n",
       "      <td>127300</td>\n",
       "      <td>127300</td>\n",
       "      <td>128400</td>\n",
       "      <td>130000</td>\n",
       "      <td>133000</td>\n",
       "      <td>135600</td>\n",
       "      <td>137000</td>\n",
       "      <td>138500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10718</th>\n",
       "      <td>56845</td>\n",
       "      <td>Saint Inigoes</td>\n",
       "      <td>MD</td>\n",
       "      <td>California-Lexington Park</td>\n",
       "      <td>Saint Marys</td>\n",
       "      <td>10719</td>\n",
       "      <td>137400.0</td>\n",
       "      <td>136900.0</td>\n",
       "      <td>137500.0</td>\n",
       "      <td>138600.0</td>\n",
       "      <td>...</td>\n",
       "      <td>277200</td>\n",
       "      <td>275800</td>\n",
       "      <td>276300</td>\n",
       "      <td>279500</td>\n",
       "      <td>282200</td>\n",
       "      <td>282900</td>\n",
       "      <td>282900</td>\n",
       "      <td>282100</td>\n",
       "      <td>281400</td>\n",
       "      <td>281400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10719</th>\n",
       "      <td>56943</td>\n",
       "      <td>Marysville</td>\n",
       "      <td>IN</td>\n",
       "      <td>Louisville/Jefferson County</td>\n",
       "      <td>Clark</td>\n",
       "      <td>10720</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>119800</td>\n",
       "      <td>124100</td>\n",
       "      <td>127200</td>\n",
       "      <td>129500</td>\n",
       "      <td>128000</td>\n",
       "      <td>124800</td>\n",
       "      <td>122700</td>\n",
       "      <td>122200</td>\n",
       "      <td>123100</td>\n",
       "      <td>125300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10720</th>\n",
       "      <td>57212</td>\n",
       "      <td>Forest Falls</td>\n",
       "      <td>CA</td>\n",
       "      <td>Riverside</td>\n",
       "      <td>San Bernardino</td>\n",
       "      <td>10721</td>\n",
       "      <td>76400.0</td>\n",
       "      <td>75600.0</td>\n",
       "      <td>74100.0</td>\n",
       "      <td>73100.0</td>\n",
       "      <td>...</td>\n",
       "      <td>199700</td>\n",
       "      <td>195300</td>\n",
       "      <td>190400</td>\n",
       "      <td>187500</td>\n",
       "      <td>188000</td>\n",
       "      <td>190000</td>\n",
       "      <td>190600</td>\n",
       "      <td>189000</td>\n",
       "      <td>187100</td>\n",
       "      <td>186200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10721</th>\n",
       "      <td>171874</td>\n",
       "      <td>Bois D Arc</td>\n",
       "      <td>MO</td>\n",
       "      <td>Springfield</td>\n",
       "      <td>Greene</td>\n",
       "      <td>10722</td>\n",
       "      <td>77700.0</td>\n",
       "      <td>77500.0</td>\n",
       "      <td>77700.0</td>\n",
       "      <td>78600.0</td>\n",
       "      <td>...</td>\n",
       "      <td>149800</td>\n",
       "      <td>149100</td>\n",
       "      <td>148000</td>\n",
       "      <td>146900</td>\n",
       "      <td>145700</td>\n",
       "      <td>145000</td>\n",
       "      <td>143700</td>\n",
       "      <td>142600</td>\n",
       "      <td>143200</td>\n",
       "      <td>144800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10722</th>\n",
       "      <td>182023</td>\n",
       "      <td>Henrico</td>\n",
       "      <td>VA</td>\n",
       "      <td>Richmond</td>\n",
       "      <td>Henrico</td>\n",
       "      <td>10723</td>\n",
       "      <td>110200.0</td>\n",
       "      <td>110500.0</td>\n",
       "      <td>110900.0</td>\n",
       "      <td>111100.0</td>\n",
       "      <td>...</td>\n",
       "      <td>213800</td>\n",
       "      <td>215100</td>\n",
       "      <td>216000</td>\n",
       "      <td>216200</td>\n",
       "      <td>215900</td>\n",
       "      <td>215900</td>\n",
       "      <td>215900</td>\n",
       "      <td>216800</td>\n",
       "      <td>219000</td>\n",
       "      <td>221300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10723</th>\n",
       "      <td>188693</td>\n",
       "      <td>Diamond Beach</td>\n",
       "      <td>NJ</td>\n",
       "      <td>Ocean City</td>\n",
       "      <td>Cape May</td>\n",
       "      <td>10724</td>\n",
       "      <td>136500.0</td>\n",
       "      <td>136800.0</td>\n",
       "      <td>137000.0</td>\n",
       "      <td>135200.0</td>\n",
       "      <td>...</td>\n",
       "      <td>400100</td>\n",
       "      <td>401600</td>\n",
       "      <td>403100</td>\n",
       "      <td>405000</td>\n",
       "      <td>405500</td>\n",
       "      <td>404500</td>\n",
       "      <td>403800</td>\n",
       "      <td>403400</td>\n",
       "      <td>400700</td>\n",
       "      <td>397300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10724</th>\n",
       "      <td>227014</td>\n",
       "      <td>Gruetli Laager</td>\n",
       "      <td>TN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Grundy</td>\n",
       "      <td>10725</td>\n",
       "      <td>24800.0</td>\n",
       "      <td>24300.0</td>\n",
       "      <td>24500.0</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>71800</td>\n",
       "      <td>72900</td>\n",
       "      <td>74500</td>\n",
       "      <td>75700</td>\n",
       "      <td>75800</td>\n",
       "      <td>75900</td>\n",
       "      <td>76600</td>\n",
       "      <td>76900</td>\n",
       "      <td>77200</td>\n",
       "      <td>77800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10725</th>\n",
       "      <td>398292</td>\n",
       "      <td>Town of Wrightstown</td>\n",
       "      <td>WI</td>\n",
       "      <td>Green Bay</td>\n",
       "      <td>Brown</td>\n",
       "      <td>10726</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>149900</td>\n",
       "      <td>150100</td>\n",
       "      <td>150300</td>\n",
       "      <td>150000</td>\n",
       "      <td>149200</td>\n",
       "      <td>149900</td>\n",
       "      <td>151400</td>\n",
       "      <td>152500</td>\n",
       "      <td>154100</td>\n",
       "      <td>155900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10726</th>\n",
       "      <td>398343</td>\n",
       "      <td>Urbana</td>\n",
       "      <td>NY</td>\n",
       "      <td>Corning</td>\n",
       "      <td>Steuben</td>\n",
       "      <td>10727</td>\n",
       "      <td>66900.0</td>\n",
       "      <td>65800.0</td>\n",
       "      <td>65500.0</td>\n",
       "      <td>65100.0</td>\n",
       "      <td>...</td>\n",
       "      <td>135700</td>\n",
       "      <td>136400</td>\n",
       "      <td>137700</td>\n",
       "      <td>138700</td>\n",
       "      <td>140500</td>\n",
       "      <td>143600</td>\n",
       "      <td>145000</td>\n",
       "      <td>144000</td>\n",
       "      <td>143000</td>\n",
       "      <td>143000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10727</th>\n",
       "      <td>398496</td>\n",
       "      <td>New Denmark</td>\n",
       "      <td>WI</td>\n",
       "      <td>Green Bay</td>\n",
       "      <td>Brown</td>\n",
       "      <td>10728</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>188700</td>\n",
       "      <td>189800</td>\n",
       "      <td>190800</td>\n",
       "      <td>191200</td>\n",
       "      <td>191200</td>\n",
       "      <td>191700</td>\n",
       "      <td>192800</td>\n",
       "      <td>194000</td>\n",
       "      <td>196300</td>\n",
       "      <td>198900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10728</th>\n",
       "      <td>398839</td>\n",
       "      <td>Angels</td>\n",
       "      <td>CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Calaveras</td>\n",
       "      <td>10729</td>\n",
       "      <td>115600.0</td>\n",
       "      <td>116400.0</td>\n",
       "      <td>118000.0</td>\n",
       "      <td>119000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>280400</td>\n",
       "      <td>279600</td>\n",
       "      <td>278000</td>\n",
       "      <td>276600</td>\n",
       "      <td>275000</td>\n",
       "      <td>273700</td>\n",
       "      <td>272000</td>\n",
       "      <td>269100</td>\n",
       "      <td>269000</td>\n",
       "      <td>270900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10729</th>\n",
       "      <td>399114</td>\n",
       "      <td>Holland</td>\n",
       "      <td>WI</td>\n",
       "      <td>Sheboygan</td>\n",
       "      <td>Sheboygan</td>\n",
       "      <td>10730</td>\n",
       "      <td>129900.0</td>\n",
       "      <td>130200.0</td>\n",
       "      <td>130300.0</td>\n",
       "      <td>129100.0</td>\n",
       "      <td>...</td>\n",
       "      <td>217800</td>\n",
       "      <td>219400</td>\n",
       "      <td>221100</td>\n",
       "      <td>222000</td>\n",
       "      <td>222800</td>\n",
       "      <td>224900</td>\n",
       "      <td>228000</td>\n",
       "      <td>231200</td>\n",
       "      <td>233900</td>\n",
       "      <td>236000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10730 rows × 251 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       RegionID           RegionName State                           Metro  \\\n",
       "0          6181             New York    NY                        New York   \n",
       "1         12447          Los Angeles    CA  Los Angeles-Long Beach-Anaheim   \n",
       "2         17426              Chicago    IL                         Chicago   \n",
       "3         13271         Philadelphia    PA                    Philadelphia   \n",
       "4         40326              Phoenix    AZ                         Phoenix   \n",
       "5         18959            Las Vegas    NV                       Las Vegas   \n",
       "6         54296            San Diego    CA                       San Diego   \n",
       "7         38128               Dallas    TX               Dallas-Fort Worth   \n",
       "8         33839             San Jose    CA                        San Jose   \n",
       "9         25290         Jacksonville    FL                    Jacksonville   \n",
       "10        20330        San Francisco    CA                   San Francisco   \n",
       "11        10221               Austin    TX                          Austin   \n",
       "12        17762              Detroit    MI                         Detroit   \n",
       "13        10920             Columbus    OH                        Columbus   \n",
       "14        32811              Memphis    TN                         Memphis   \n",
       "15        24043            Charlotte    NC                       Charlotte   \n",
       "16        17933              El Paso    TX                         El Paso   \n",
       "17        44269               Boston    MA                          Boston   \n",
       "18        16037              Seattle    WA                         Seattle   \n",
       "19         3523            Baltimore    MD                       Baltimore   \n",
       "20        11093               Denver    CO                          Denver   \n",
       "21        41568           Washington    DC                      Washington   \n",
       "22         6118            Nashville    TN                       Nashville   \n",
       "23         5976            Milwaukee    WI                       Milwaukee   \n",
       "24         7481               Tucson    AZ                          Tucson   \n",
       "25        13373             Portland    OR                        Portland   \n",
       "26        33225        Oklahoma City    OK                   Oklahoma City   \n",
       "27        40152                Omaha    NE                           Omaha   \n",
       "28        23429          Albuquerque    NM                     Albuquerque   \n",
       "29        18203               Fresno    CA                          Fresno   \n",
       "...         ...                  ...   ...                             ...   \n",
       "10700     49199       Granite Shoals    TX                             NaN   \n",
       "10701     49693          Piney Point    MD       California-Lexington Park   \n",
       "10702     50374              Maribel    WI                       Manitowoc   \n",
       "10703     50539            Middleton    ID                      Boise City   \n",
       "10704     50963              Bennett    CO                          Denver   \n",
       "10705     51793       East Hampstead    NH                          Boston   \n",
       "10706     52166          Garden City    MO                     Kansas City   \n",
       "10707     53456         Mountainburg    AR                      Fort Smith   \n",
       "10708     53730             Oostburg    WI                       Sheboygan   \n",
       "10709     54771           Twin Peaks    CA                       Riverside   \n",
       "10710     54802     Upper Brookville    NY                        New York   \n",
       "10711     54995              Volcano    HI                            Hilo   \n",
       "10712     55072           Wedgefield    SC                          Sumter   \n",
       "10713     55210          Williamston    MI                         Lansing   \n",
       "10714     55357              Decatur    AR                    Fayetteville   \n",
       "10715     55476           Briceville    TN                       Knoxville   \n",
       "10716     55706             Edgewood    IN                    Indianapolis   \n",
       "10717     56183              Palmyra    TN                     Clarksville   \n",
       "10718     56845        Saint Inigoes    MD       California-Lexington Park   \n",
       "10719     56943           Marysville    IN     Louisville/Jefferson County   \n",
       "10720     57212         Forest Falls    CA                       Riverside   \n",
       "10721    171874           Bois D Arc    MO                     Springfield   \n",
       "10722    182023              Henrico    VA                        Richmond   \n",
       "10723    188693        Diamond Beach    NJ                      Ocean City   \n",
       "10724    227014       Gruetli Laager    TN                             NaN   \n",
       "10725    398292  Town of Wrightstown    WI                       Green Bay   \n",
       "10726    398343               Urbana    NY                         Corning   \n",
       "10727    398496          New Denmark    WI                       Green Bay   \n",
       "10728    398839               Angels    CA                             NaN   \n",
       "10729    399114              Holland    WI                       Sheboygan   \n",
       "\n",
       "                 CountyName  SizeRank   1996-04   1996-05   1996-06   1996-07  \\\n",
       "0                    Queens         1       NaN       NaN       NaN       NaN   \n",
       "1               Los Angeles         2  155000.0  154600.0  154400.0  154200.0   \n",
       "2                      Cook         3  109700.0  109400.0  109300.0  109300.0   \n",
       "3              Philadelphia         4   50000.0   49900.0   49600.0   49400.0   \n",
       "4                  Maricopa         5   87200.0   87700.0   88200.0   88400.0   \n",
       "5                     Clark         6  121600.0  120900.0  120400.0  120300.0   \n",
       "6                 San Diego         7  161100.0  160700.0  160400.0  160100.0   \n",
       "7                    Dallas         8       NaN       NaN       NaN       NaN   \n",
       "8               Santa Clara         9  224500.0  224900.0  225400.0  226100.0   \n",
       "9                     Duval        10   77500.0   77200.0   76800.0   76600.0   \n",
       "10            San Francisco        11  262500.0  263500.0  264100.0  265000.0   \n",
       "11                   Travis        12       NaN       NaN       NaN       NaN   \n",
       "12                    Wayne        13       NaN       NaN       NaN       NaN   \n",
       "13                 Franklin        14   83100.0   83200.0   83300.0   83500.0   \n",
       "14                   Shelby        15   60600.0   60500.0   60700.0   60800.0   \n",
       "15              Mecklenburg        16   94500.0   94900.0   95700.0   96400.0   \n",
       "16                  El Paso        17   67400.0   67800.0   68000.0   68300.0   \n",
       "17                  Suffolk        18  123100.0  122800.0  123100.0  123800.0   \n",
       "18                     King        19  164400.0  163900.0  163600.0  163400.0   \n",
       "19           Baltimore City        20   53200.0   53900.0   54400.0   54700.0   \n",
       "20                   Denver        21   98700.0   99200.0   99600.0  100200.0   \n",
       "21     District of Columbia        22       NaN       NaN       NaN       NaN   \n",
       "22                 Davidson        23   83100.0   83800.0   84800.0   85900.0   \n",
       "23                Milwaukee        24   68100.0   68100.0   68100.0   67800.0   \n",
       "24                     Pima        25   91500.0   91500.0   91600.0   91500.0   \n",
       "25                Multnomah        26  121100.0  122200.0  123000.0  123600.0   \n",
       "26                 Oklahoma        27   64900.0   65400.0   65700.0   65800.0   \n",
       "27                  Douglas        28   88900.0   89600.0   90400.0   90800.0   \n",
       "28               Bernalillo        29  115400.0  115600.0  116000.0  116700.0   \n",
       "29                   Fresno        30   90400.0   90400.0   90200.0   90000.0   \n",
       "...                     ...       ...       ...       ...       ...       ...   \n",
       "10700                Burnet     10701       NaN       NaN       NaN       NaN   \n",
       "10701           Saint Marys     10702  148400.0  152300.0  153600.0  153100.0   \n",
       "10702             Manitowoc     10703       NaN       NaN       NaN       NaN   \n",
       "10703                Canyon     10704  103100.0  103200.0  103300.0  103000.0   \n",
       "10704                 Adams     10705   83800.0   85900.0   87100.0   88100.0   \n",
       "10705            Rockingham     10706  132200.0  128600.0  125500.0  125200.0   \n",
       "10706                  Cass     10707       NaN       NaN       NaN       NaN   \n",
       "10707              Crawford     10708   55600.0   55500.0   55400.0   56200.0   \n",
       "10708             Sheboygan     10709   86300.0   84900.0   83800.0   83700.0   \n",
       "10709        San Bernardino     10710   85500.0   85200.0   84600.0   84400.0   \n",
       "10710                Nassau     10711  897200.0  894000.0  891300.0  894400.0   \n",
       "10711                Hawaii     10712  114600.0  108600.0  102400.0   96700.0   \n",
       "10712                Sumter     10713       NaN       NaN       NaN       NaN   \n",
       "10713                Ingham     10714  120900.0  124800.0  128200.0  130200.0   \n",
       "10714                Benton     10715   54700.0   55100.0   55100.0   54700.0   \n",
       "10715              Anderson     10716   37000.0   37500.0   36700.0   36100.0   \n",
       "10716               Madison     10717       NaN       NaN       NaN       NaN   \n",
       "10717            Montgomery     10718       NaN       NaN       NaN       NaN   \n",
       "10718           Saint Marys     10719  137400.0  136900.0  137500.0  138600.0   \n",
       "10719                 Clark     10720       NaN       NaN       NaN       NaN   \n",
       "10720        San Bernardino     10721   76400.0   75600.0   74100.0   73100.0   \n",
       "10721                Greene     10722   77700.0   77500.0   77700.0   78600.0   \n",
       "10722               Henrico     10723  110200.0  110500.0  110900.0  111100.0   \n",
       "10723              Cape May     10724  136500.0  136800.0  137000.0  135200.0   \n",
       "10724                Grundy     10725   24800.0   24300.0   24500.0   25000.0   \n",
       "10725                 Brown     10726       NaN       NaN       NaN       NaN   \n",
       "10726               Steuben     10727   66900.0   65800.0   65500.0   65100.0   \n",
       "10727                 Brown     10728       NaN       NaN       NaN       NaN   \n",
       "10728             Calaveras     10729  115600.0  116400.0  118000.0  119000.0   \n",
       "10729             Sheboygan     10730  129900.0  130200.0  130300.0  129100.0   \n",
       "\n",
       "        ...     2015-11  2015-12  2016-01  2016-02  2016-03  2016-04  2016-05  \\\n",
       "0       ...      573600   576200   578400   582200   588000   592200   592500   \n",
       "1       ...      558200   560800   562800   565600   569700   574000   577800   \n",
       "2       ...      207800   206900   206200   205800   206200   207300   208200   \n",
       "3       ...      122300   121600   121800   123300   125200   126400   127000   \n",
       "4       ...      183800   185300   186600   188000   189100   190200   191300   \n",
       "5       ...      190600   192000   193600   194800   195400   196100   197300   \n",
       "6       ...      525700   526700   527800   529200   531000   533900   536900   \n",
       "7       ...      134600   136600   138700   140600   142200   143300   144500   \n",
       "8       ...      789700   792100   795800   803100   811900   817600   819100   \n",
       "9       ...      132000   132500   133100   133900   134900   136000   137200   \n",
       "10      ...     1105800  1112300  1117400  1122700  1125200  1123200  1119800   \n",
       "11      ...      287300   289300   291100   293400   296000   299200   301800   \n",
       "12      ...       38500    38400    38300    38000    37600    37400    37500   \n",
       "13      ...      115200   115800   116200   116700   117200   117700   118100   \n",
       "14      ...       69600    69800    69900    70800    72000    73100    74300   \n",
       "15      ...      162800   164300   165500   166500   167400   168400   169500   \n",
       "16      ...      110200   110000   110200   110600   111200   111500   111400   \n",
       "17      ...      471000   474600   478700   482900   486200   488000   489700   \n",
       "18      ...      533700   538700   544300   551200   559700   568600   576200   \n",
       "19      ...      113600   114000   114500   114700   114800   114700   114600   \n",
       "20      ...      330500   332100   333500   335600   337600   339700   342700   \n",
       "21      ...      501200   502500   503800   504700   503800   503400   505100   \n",
       "22      ...      189300   191400   193300   195100   196800   198400   200300   \n",
       "23      ...       94600    94300    94200    94600    95200    95900    96300   \n",
       "24      ...      148200   148400   148800   149500   150300   150700   151100   \n",
       "25      ...      343400   347800   351900   356100   360000   364400   369300   \n",
       "26      ...      127300   127700   127600   127700   128400   129000   129300   \n",
       "27      ...      140300   140500   140900   141600   142400   142800   142700   \n",
       "28      ...      167300   167800   168300   169100   169900   170300   170500   \n",
       "29      ...      187600   187700   187900   189000   190200   191200   192700   \n",
       "...     ...         ...      ...      ...      ...      ...      ...      ...   \n",
       "10700   ...      128200   129900   131500   133700   136100   137900   139700   \n",
       "10701   ...      309800   312600   315900   319900   322700   323600   324300   \n",
       "10702   ...      129100   129700   128900   127600   127000   127800   129300   \n",
       "10703   ...      151100   152300   153200   154000   154500   155500   157200   \n",
       "10704   ...      195700   197400   198500   199400   201400   204500   207700   \n",
       "10705   ...      269600   270600   271200   272400   274000   275800   277800   \n",
       "10706   ...      103600   104800   105200   105800   107800   110000   112000   \n",
       "10707   ...       90100    93400    96300    98600   100100   101200   101800   \n",
       "10708   ...      132000   132500   132700   132600   133000   133700   134100   \n",
       "10709   ...      159200   160600   162400   164400   165700   166300   167700   \n",
       "10710   ...     1833700  1854900  1879300  1905900  1928300  1941800  1942000   \n",
       "10711   ...      232500   236400   239700   241800   244700   247800   249600   \n",
       "10712   ...       69000    68500    68200    68500    69900    71900    74100   \n",
       "10713   ...      182700   181800   180800   181000   182600   182900   182200   \n",
       "10714   ...       97200    97400    96900    96300    96300    96600    96600   \n",
       "10715   ...       43200    41700    40800    40500    41100    41700    42000   \n",
       "10716   ...      100200   101100   100200    98900    99200    99600    99900   \n",
       "10717   ...      126400   127600   127300   127300   128400   130000   133000   \n",
       "10718   ...      277200   275800   276300   279500   282200   282900   282900   \n",
       "10719   ...      119800   124100   127200   129500   128000   124800   122700   \n",
       "10720   ...      199700   195300   190400   187500   188000   190000   190600   \n",
       "10721   ...      149800   149100   148000   146900   145700   145000   143700   \n",
       "10722   ...      213800   215100   216000   216200   215900   215900   215900   \n",
       "10723   ...      400100   401600   403100   405000   405500   404500   403800   \n",
       "10724   ...       71800    72900    74500    75700    75800    75900    76600   \n",
       "10725   ...      149900   150100   150300   150000   149200   149900   151400   \n",
       "10726   ...      135700   136400   137700   138700   140500   143600   145000   \n",
       "10727   ...      188700   189800   190800   191200   191200   191700   192800   \n",
       "10728   ...      280400   279600   278000   276600   275000   273700   272000   \n",
       "10729   ...      217800   219400   221100   222000   222800   224900   228000   \n",
       "\n",
       "       2016-06  2016-07  2016-08  \n",
       "0       590200   588000   586400  \n",
       "1       580600   583000   585100  \n",
       "2       209100   211000   213000  \n",
       "3       127400   128300   129100  \n",
       "4       192800   194500   195900  \n",
       "5       198200   199300   200600  \n",
       "6       537900   539000   540500  \n",
       "7       146000   148200   150400  \n",
       "8       820100   821700   822700  \n",
       "9       138400   139500   140300  \n",
       "10     1114800  1108800  1104000  \n",
       "11      303300   304100   304800  \n",
       "12       37500    37700    38100  \n",
       "13      118800   119700   120500  \n",
       "14       75100    75600    76200  \n",
       "15      170400   171700   173100  \n",
       "16      111500   112100   112300  \n",
       "17      493400   499200   504200  \n",
       "18      581800   587200   592200  \n",
       "19      114900   115100   115200  \n",
       "20      345900   349800   353300  \n",
       "21      508900   513900   518600  \n",
       "22      202400   205000   207200  \n",
       "23       96900    98200    99500  \n",
       "24      151700   152400   153000  \n",
       "25      375700   383600   390500  \n",
       "26      129600   130100   130500  \n",
       "27      142500   143100   143800  \n",
       "28      171100   171800   172000  \n",
       "29      194300   195800   197100  \n",
       "...        ...      ...      ...  \n",
       "10700   142600   145700   147200  \n",
       "10701   324600   324500   324700  \n",
       "10702   130700   132900   135500  \n",
       "10703   158800   160100   161400  \n",
       "10704   210200   211900   213300  \n",
       "10705   279800   281700   283200  \n",
       "10706   113000   113500   113700  \n",
       "10707   102700   103300   103500  \n",
       "10708   134500   135700   137000  \n",
       "10709   169900   172500   174500  \n",
       "10710  1948400  1962600  1975000  \n",
       "10711   249500   248500   247200  \n",
       "10712    76800    79600    81800  \n",
       "10713   182100   182800   183200  \n",
       "10714    96700    96900    96800  \n",
       "10715    41700    41100    40600  \n",
       "10716   100400   101000   100900  \n",
       "10717   135600   137000   138500  \n",
       "10718   282100   281400   281400  \n",
       "10719   122200   123100   125300  \n",
       "10720   189000   187100   186200  \n",
       "10721   142600   143200   144800  \n",
       "10722   216800   219000   221300  \n",
       "10723   403400   400700   397300  \n",
       "10724    76900    77200    77800  \n",
       "10725   152500   154100   155900  \n",
       "10726   144000   143000   143000  \n",
       "10727   194000   196300   198900  \n",
       "10728   269100   269000   270900  \n",
       "10729   231200   233900   236000  \n",
       "\n",
       "[10730 rows x 251 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def convert_housing_data_to_quarters():\n",
    "    '''Converts the housing data to quarters and returns it as mean \n",
    "    values in a dataframe. This dataframe should be a dataframe with\n",
    "    columns for 2000q1 through 2016q3, and should have a multi-index\n",
    "    in the shape of [\"State\",\"RegionName\"].\n",
    "    \n",
    "    Note: Quarters are defined in the assignment description, they are\n",
    "    not arbitrary three month periods.\n",
    "    \n",
    "    The resulting dataframe should have 67 columns, and 10,730 rows.\n",
    "    '''\n",
    "    import pandas as pd\n",
    "    house_df = pd.read_csv('City_Zhvi_AllHomes.csv')\n",
    "    house_df\n",
    "    \n",
    "    return house_df\n",
    "\n",
    "convert_housing_data_to_quarters()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "def run_ttest():\n",
    "    '''First creates new data showing the decline or growth of housing prices\n",
    "    between the recession start and the recession bottom. Then runs a ttest\n",
    "    comparing the university town values to the non-university towns values, \n",
    "    return whether the alternative hypothesis (that the two groups are the same)\n",
    "    is true or not as well as the p-value of the confidence. \n",
    "    \n",
    "    Return the tuple (different, p, better) where different=True if the t-test is\n",
    "    True at a p<0.01 (we reject the null hypothesis), or different=False if \n",
    "    otherwise (we cannot reject the null hypothesis). The variable p should\n",
    "    be equal to the exact p value returned from scipy.stats.ttest_ind(). The\n",
    "    value for better should be either \"university town\" or \"non-university town\"\n",
    "    depending on which has a lower mean price ratio (which is equivilent to a\n",
    "    reduced market loss).'''\n",
    "    \n",
    "    return (True, 0.005496427353694603, 'university town')"
   ]
  }
 ],
 "metadata": {
  "coursera": {
   "course_slug": "python-data-analysis",
   "graded_item_id": "Il9Fx",
   "launcher_item_id": "TeDW0",
   "part_id": "WGlun"
  },
  "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.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}