internet access by income, town-level.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>Id</th>\n",
       "      <th>Id2</th>\n",
       "      <th>Geography</th>\n",
       "      <th>Estimate; Total:</th>\n",
       "      <th>Margin of Error; Total:</th>\n",
       "      <th>Estimate; Less than $10,000:</th>\n",
       "      <th>Margin of Error; Less than $10,000:</th>\n",
       "      <th>Estimate; Less than $10,000: - With dial-up Internet subscription alone</th>\n",
       "      <th>Margin of Error; Less than $10,000: - With dial-up Internet subscription alone</th>\n",
       "      <th>Estimate; Less than $10,000: - With a broadband Internet subscription</th>\n",
       "      <th>...</th>\n",
       "      <th>Estimate; $50,000 to $74,999: - Without an Internet subscription</th>\n",
       "      <th>Margin of Error; $50,000 to $74,999: - Without an Internet subscription</th>\n",
       "      <th>Estimate; $75,000 or more:</th>\n",
       "      <th>Margin of Error; $75,000 or more:</th>\n",
       "      <th>Estimate; $75,000 or more: - With dial-up Internet subscription alone</th>\n",
       "      <th>Margin of Error; $75,000 or more: - With dial-up Internet subscription alone</th>\n",
       "      <th>Estimate; $75,000 or more: - With a broadband Internet subscription</th>\n",
       "      <th>Margin of Error; $75,000 or more: - With a broadband Internet subscription</th>\n",
       "      <th>Estimate; $75,000 or more: - Without an Internet subscription</th>\n",
       "      <th>Margin of Error; $75,000 or more: - Without an Internet subscription</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0600000US0900108070</td>\n",
       "      <td>900108070</td>\n",
       "      <td>Bridgeport town, Fairfield County, Connecticut</td>\n",
       "      <td>49811</td>\n",
       "      <td>2237</td>\n",
       "      <td>5321</td>\n",
       "      <td>1086</td>\n",
       "      <td>0</td>\n",
       "      <td>198</td>\n",
       "      <td>2134</td>\n",
       "      <td>...</td>\n",
       "      <td>1093</td>\n",
       "      <td>520</td>\n",
       "      <td>13487</td>\n",
       "      <td>1329</td>\n",
       "      <td>97</td>\n",
       "      <td>119</td>\n",
       "      <td>11615</td>\n",
       "      <td>1236</td>\n",
       "      <td>1775</td>\n",
       "      <td>666</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0600000US0900118500</td>\n",
       "      <td>900118500</td>\n",
       "      <td>Danbury town, Fairfield County, Connecticut</td>\n",
       "      <td>29775</td>\n",
       "      <td>2154</td>\n",
       "      <td>1981</td>\n",
       "      <td>827</td>\n",
       "      <td>0</td>\n",
       "      <td>198</td>\n",
       "      <td>1454</td>\n",
       "      <td>...</td>\n",
       "      <td>333</td>\n",
       "      <td>235</td>\n",
       "      <td>13142</td>\n",
       "      <td>1509</td>\n",
       "      <td>178</td>\n",
       "      <td>174</td>\n",
       "      <td>12479</td>\n",
       "      <td>1516</td>\n",
       "      <td>485</td>\n",
       "      <td>354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0600000US0900156060</td>\n",
       "      <td>900156060</td>\n",
       "      <td>Norwalk town, Fairfield County, Connecticut</td>\n",
       "      <td>32467</td>\n",
       "      <td>1764</td>\n",
       "      <td>1528</td>\n",
       "      <td>626</td>\n",
       "      <td>63</td>\n",
       "      <td>107</td>\n",
       "      <td>697</td>\n",
       "      <td>...</td>\n",
       "      <td>658</td>\n",
       "      <td>358</td>\n",
       "      <td>17500</td>\n",
       "      <td>1454</td>\n",
       "      <td>79</td>\n",
       "      <td>90</td>\n",
       "      <td>16832</td>\n",
       "      <td>1479</td>\n",
       "      <td>589</td>\n",
       "      <td>285</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0600000US0900173070</td>\n",
       "      <td>900173070</td>\n",
       "      <td>Stamford town, Fairfield County, Connecticut</td>\n",
       "      <td>47256</td>\n",
       "      <td>2090</td>\n",
       "      <td>2845</td>\n",
       "      <td>872</td>\n",
       "      <td>0</td>\n",
       "      <td>198</td>\n",
       "      <td>1512</td>\n",
       "      <td>...</td>\n",
       "      <td>671</td>\n",
       "      <td>477</td>\n",
       "      <td>25393</td>\n",
       "      <td>1722</td>\n",
       "      <td>0</td>\n",
       "      <td>198</td>\n",
       "      <td>24191</td>\n",
       "      <td>1841</td>\n",
       "      <td>1202</td>\n",
       "      <td>556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0600000US0900337070</td>\n",
       "      <td>900337070</td>\n",
       "      <td>Hartford town, Hartford County, Connecticut</td>\n",
       "      <td>44867</td>\n",
       "      <td>2041</td>\n",
       "      <td>7566</td>\n",
       "      <td>1419</td>\n",
       "      <td>30</td>\n",
       "      <td>51</td>\n",
       "      <td>3205</td>\n",
       "      <td>...</td>\n",
       "      <td>1139</td>\n",
       "      <td>522</td>\n",
       "      <td>8180</td>\n",
       "      <td>1199</td>\n",
       "      <td>72</td>\n",
       "      <td>93</td>\n",
       "      <td>7139</td>\n",
       "      <td>1088</td>\n",
       "      <td>969</td>\n",
       "      <td>516</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0600000US0900350440</td>\n",
       "      <td>900350440</td>\n",
       "      <td>New Britain town, Hartford County, Connecticut</td>\n",
       "      <td>27834</td>\n",
       "      <td>1277</td>\n",
       "      <td>4079</td>\n",
       "      <td>1019</td>\n",
       "      <td>0</td>\n",
       "      <td>198</td>\n",
       "      <td>1632</td>\n",
       "      <td>...</td>\n",
       "      <td>921</td>\n",
       "      <td>409</td>\n",
       "      <td>7070</td>\n",
       "      <td>1233</td>\n",
       "      <td>0</td>\n",
       "      <td>198</td>\n",
       "      <td>6203</td>\n",
       "      <td>1139</td>\n",
       "      <td>867</td>\n",
       "      <td>580</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0600000US0900952070</td>\n",
       "      <td>900952070</td>\n",
       "      <td>New Haven town, New Haven County, Connecticut</td>\n",
       "      <td>48690</td>\n",
       "      <td>2528</td>\n",
       "      <td>7508</td>\n",
       "      <td>1649</td>\n",
       "      <td>35</td>\n",
       "      <td>62</td>\n",
       "      <td>4099</td>\n",
       "      <td>...</td>\n",
       "      <td>1151</td>\n",
       "      <td>642</td>\n",
       "      <td>11043</td>\n",
       "      <td>1331</td>\n",
       "      <td>0</td>\n",
       "      <td>198</td>\n",
       "      <td>10223</td>\n",
       "      <td>1291</td>\n",
       "      <td>820</td>\n",
       "      <td>396</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0600000US0900980070</td>\n",
       "      <td>900980070</td>\n",
       "      <td>Waterbury town, New Haven County, Connecticut</td>\n",
       "      <td>39441</td>\n",
       "      <td>1869</td>\n",
       "      <td>5470</td>\n",
       "      <td>1123</td>\n",
       "      <td>0</td>\n",
       "      <td>198</td>\n",
       "      <td>1740</td>\n",
       "      <td>...</td>\n",
       "      <td>1548</td>\n",
       "      <td>678</td>\n",
       "      <td>9480</td>\n",
       "      <td>1262</td>\n",
       "      <td>0</td>\n",
       "      <td>198</td>\n",
       "      <td>8517</td>\n",
       "      <td>1142</td>\n",
       "      <td>963</td>\n",
       "      <td>577</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8 rows × 53 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Id        Id2  \\\n",
       "0  0600000US0900108070  900108070   \n",
       "1  0600000US0900118500  900118500   \n",
       "2  0600000US0900156060  900156060   \n",
       "3  0600000US0900173070  900173070   \n",
       "4  0600000US0900337070  900337070   \n",
       "5  0600000US0900350440  900350440   \n",
       "6  0600000US0900952070  900952070   \n",
       "7  0600000US0900980070  900980070   \n",
       "\n",
       "                                        Geography  Estimate; Total:  \\\n",
       "0  Bridgeport town, Fairfield County, Connecticut             49811   \n",
       "1     Danbury town, Fairfield County, Connecticut             29775   \n",
       "2     Norwalk town, Fairfield County, Connecticut             32467   \n",
       "3    Stamford town, Fairfield County, Connecticut             47256   \n",
       "4     Hartford town, Hartford County, Connecticut             44867   \n",
       "5  New Britain town, Hartford County, Connecticut             27834   \n",
       "6   New Haven town, New Haven County, Connecticut             48690   \n",
       "7   Waterbury town, New Haven County, Connecticut             39441   \n",
       "\n",
       "   Margin of Error; Total:  Estimate; Less than $10,000:  \\\n",
       "0                     2237                          5321   \n",
       "1                     2154                          1981   \n",
       "2                     1764                          1528   \n",
       "3                     2090                          2845   \n",
       "4                     2041                          7566   \n",
       "5                     1277                          4079   \n",
       "6                     2528                          7508   \n",
       "7                     1869                          5470   \n",
       "\n",
       "   Margin of Error; Less than $10,000:  \\\n",
       "0                                 1086   \n",
       "1                                  827   \n",
       "2                                  626   \n",
       "3                                  872   \n",
       "4                                 1419   \n",
       "5                                 1019   \n",
       "6                                 1649   \n",
       "7                                 1123   \n",
       "\n",
       "   Estimate; Less than $10,000: - With dial-up Internet subscription alone  \\\n",
       "0                                                  0                         \n",
       "1                                                  0                         \n",
       "2                                                 63                         \n",
       "3                                                  0                         \n",
       "4                                                 30                         \n",
       "5                                                  0                         \n",
       "6                                                 35                         \n",
       "7                                                  0                         \n",
       "\n",
       "   Margin of Error; Less than $10,000: - With dial-up Internet subscription alone  \\\n",
       "0                                                198                                \n",
       "1                                                198                                \n",
       "2                                                107                                \n",
       "3                                                198                                \n",
       "4                                                 51                                \n",
       "5                                                198                                \n",
       "6                                                 62                                \n",
       "7                                                198                                \n",
       "\n",
       "   Estimate; Less than $10,000: - With a broadband Internet subscription  \\\n",
       "0                                               2134                       \n",
       "1                                               1454                       \n",
       "2                                                697                       \n",
       "3                                               1512                       \n",
       "4                                               3205                       \n",
       "5                                               1632                       \n",
       "6                                               4099                       \n",
       "7                                               1740                       \n",
       "\n",
       "                                   ...                                   \\\n",
       "0                                  ...                                    \n",
       "1                                  ...                                    \n",
       "2                                  ...                                    \n",
       "3                                  ...                                    \n",
       "4                                  ...                                    \n",
       "5                                  ...                                    \n",
       "6                                  ...                                    \n",
       "7                                  ...                                    \n",
       "\n",
       "   Estimate; $50,000 to $74,999: - Without an Internet subscription  \\\n",
       "0                                               1093                  \n",
       "1                                                333                  \n",
       "2                                                658                  \n",
       "3                                                671                  \n",
       "4                                               1139                  \n",
       "5                                                921                  \n",
       "6                                               1151                  \n",
       "7                                               1548                  \n",
       "\n",
       "   Margin of Error; $50,000 to $74,999: - Without an Internet subscription  \\\n",
       "0                                                520                         \n",
       "1                                                235                         \n",
       "2                                                358                         \n",
       "3                                                477                         \n",
       "4                                                522                         \n",
       "5                                                409                         \n",
       "6                                                642                         \n",
       "7                                                678                         \n",
       "\n",
       "   Estimate; $75,000 or more:  Margin of Error; $75,000 or more:  \\\n",
       "0                       13487                               1329   \n",
       "1                       13142                               1509   \n",
       "2                       17500                               1454   \n",
       "3                       25393                               1722   \n",
       "4                        8180                               1199   \n",
       "5                        7070                               1233   \n",
       "6                       11043                               1331   \n",
       "7                        9480                               1262   \n",
       "\n",
       "   Estimate; $75,000 or more: - With dial-up Internet subscription alone  \\\n",
       "0                                                 97                       \n",
       "1                                                178                       \n",
       "2                                                 79                       \n",
       "3                                                  0                       \n",
       "4                                                 72                       \n",
       "5                                                  0                       \n",
       "6                                                  0                       \n",
       "7                                                  0                       \n",
       "\n",
       "   Margin of Error; $75,000 or more: - With dial-up Internet subscription alone  \\\n",
       "0                                                119                              \n",
       "1                                                174                              \n",
       "2                                                 90                              \n",
       "3                                                198                              \n",
       "4                                                 93                              \n",
       "5                                                198                              \n",
       "6                                                198                              \n",
       "7                                                198                              \n",
       "\n",
       "   Estimate; $75,000 or more: - With a broadband Internet subscription  \\\n",
       "0                                              11615                     \n",
       "1                                              12479                     \n",
       "2                                              16832                     \n",
       "3                                              24191                     \n",
       "4                                               7139                     \n",
       "5                                               6203                     \n",
       "6                                              10223                     \n",
       "7                                               8517                     \n",
       "\n",
       "   Margin of Error; $75,000 or more: - With a broadband Internet subscription  \\\n",
       "0                                               1236                            \n",
       "1                                               1516                            \n",
       "2                                               1479                            \n",
       "3                                               1841                            \n",
       "4                                               1088                            \n",
       "5                                               1139                            \n",
       "6                                               1291                            \n",
       "7                                               1142                            \n",
       "\n",
       "   Estimate; $75,000 or more: - Without an Internet subscription  \\\n",
       "0                                               1775               \n",
       "1                                                485               \n",
       "2                                                589               \n",
       "3                                               1202               \n",
       "4                                                969               \n",
       "5                                                867               \n",
       "6                                                820               \n",
       "7                                                963               \n",
       "\n",
       "   Margin of Error; $75,000 or more: - Without an Internet subscription  \n",
       "0                                                666                     \n",
       "1                                                354                     \n",
       "2                                                285                     \n",
       "3                                                556                     \n",
       "4                                                516                     \n",
       "5                                                580                     \n",
       "6                                                396                     \n",
       "7                                                577                     \n",
       "\n",
       "[8 rows x 53 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def get_data(year=\"15\"):\n",
    "    df = pd.read_csv(\"data/census/income/ACS_\"+str(year)+\"_1YR_B28004/ACS_\"+str(year)+\"_1YR_B28004_with_ann.csv\",\n",
    "                    skiprows=1)\n",
    "    return df\n",
    "\n",
    "data_15 = get_data(year=\"15\")\n",
    "data_15"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Id\n",
      "Id2\n",
      "Geography\n",
      "Estimate; Total:\n",
      "Margin of Error; Total:\n",
      "Estimate; Less than $10,000:\n",
      "Margin of Error; Less than $10,000:\n",
      "Estimate; Less than $10,000: - With dial-up Internet subscription alone\n",
      "Margin of Error; Less than $10,000: - With dial-up Internet subscription alone\n",
      "Estimate; Less than $10,000: - With a broadband Internet subscription\n",
      "Margin of Error; Less than $10,000: - With a broadband Internet subscription\n",
      "Estimate; Less than $10,000: - Without an Internet subscription\n",
      "Margin of Error; Less than $10,000: - Without an Internet subscription\n",
      "Estimate; $10,000 to $19,999:\n",
      "Margin of Error; $10,000 to $19,999:\n",
      "Estimate; $10,000 to $19,999: - With dial-up Internet subscription alone\n",
      "Margin of Error; $10,000 to $19,999: - With dial-up Internet subscription alone\n",
      "Estimate; $10,000 to $19,999: - With a broadband Internet subscription\n",
      "Margin of Error; $10,000 to $19,999: - With a broadband Internet subscription\n",
      "Estimate; $10,000 to $19,999: - Without an Internet subscription\n",
      "Margin of Error; $10,000 to $19,999: - Without an Internet subscription\n",
      "Estimate; $20,000 to $34,999:\n",
      "Margin of Error; $20,000 to $34,999:\n",
      "Estimate; $20,000 to $34,999: - With dial-up Internet subscription alone\n",
      "Margin of Error; $20,000 to $34,999: - With dial-up Internet subscription alone\n",
      "Estimate; $20,000 to $34,999: - With a broadband Internet subscription\n",
      "Margin of Error; $20,000 to $34,999: - With a broadband Internet subscription\n",
      "Estimate; $20,000 to $34,999: - Without an Internet subscription\n",
      "Margin of Error; $20,000 to $34,999: - Without an Internet subscription\n",
      "Estimate; $35,000 to $49,999:\n",
      "Margin of Error; $35,000 to $49,999:\n",
      "Estimate; $35,000 to $49,999: - With dial-up Internet subscription alone\n",
      "Margin of Error; $35,000 to $49,999: - With dial-up Internet subscription alone\n",
      "Estimate; $35,000 to $49,999: - With a broadband Internet subscription\n",
      "Margin of Error; $35,000 to $49,999: - With a broadband Internet subscription\n",
      "Estimate; $35,000 to $49,999: - Without an Internet subscription\n",
      "Margin of Error; $35,000 to $49,999: - Without an Internet subscription\n",
      "Estimate; $50,000 to $74,999:\n",
      "Margin of Error; $50,000 to $74,999:\n",
      "Estimate; $50,000 to $74,999: - With dial-up Internet subscription alone\n",
      "Margin of Error; $50,000 to $74,999: - With dial-up Internet subscription alone\n",
      "Estimate; $50,000 to $74,999: - With a broadband Internet subscription\n",
      "Margin of Error; $50,000 to $74,999: - With a broadband Internet subscription\n",
      "Estimate; $50,000 to $74,999: - Without an Internet subscription\n",
      "Margin of Error; $50,000 to $74,999: - Without an Internet subscription\n",
      "Estimate; $75,000 or more:\n",
      "Margin of Error; $75,000 or more:\n",
      "Estimate; $75,000 or more: - With dial-up Internet subscription alone\n",
      "Margin of Error; $75,000 or more: - With dial-up Internet subscription alone\n",
      "Estimate; $75,000 or more: - With a broadband Internet subscription\n",
      "Margin of Error; $75,000 or more: - With a broadband Internet subscription\n",
      "Estimate; $75,000 or more: - Without an Internet subscription\n",
      "Margin of Error; $75,000 or more: - Without an Internet subscription\n"
     ]
    }
   ],
   "source": [
    "for c in data_15.columns:\n",
    "    print c"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# data types\n",
    "datum = {\n",
    "    \"MOE\":\"Margin of Error\",\n",
    "    \"est\":\"Estimate\"\n",
    "}\n",
    "    \n",
    "# income buckets\n",
    "inc_buckets = {\n",
    "    \"20K\":\"$10,000 to $19,999\",\n",
    "    \"35K\":\"$20,000 to $34,999\",\n",
    "    \"50K\":\"$35,000 to $49,999\",\n",
    "    \"75K\":\"$50,000 to $74,999\",\n",
    "    \"75+\":\"$75,000 or more\",\n",
    "    \"NA\":\"\"\n",
    "}\n",
    "\n",
    "#subscription types\n",
    "sub_types = {\n",
    "    \"dialup\":\" - With dial-up Internet subscription alone\",\n",
    "    \"broadband\":\" - With a broadband Internet subscription\",\n",
    "    \"none\":\" - Without an Internet subscription\",\n",
    "    \"NA\":\"\"\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Generate a column name\n",
    "def col(dat, inc, sub):\n",
    "   \n",
    "    \n",
    "    return datum[dat] + \"; \" + inc_buckets[inc] +\":\" + sub_types[sub]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Estimate; $10,000 to $19,999: - With a broadband Internet subscription'"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "col(\"est\",\"20K\",\"broadband\")"
   ]
  },
  {
   "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>Id</th>\n",
       "      <th>Id2</th>\n",
       "      <th>Geography</th>\n",
       "      <th>Estimate; Total:</th>\n",
       "      <th>Margin of Error; Total:</th>\n",
       "      <th>Estimate; Less than $10,000:</th>\n",
       "      <th>Margin of Error; Less than $10,000:</th>\n",
       "      <th>Estimate; Less than $10,000: - With dial-up Internet subscription alone</th>\n",
       "      <th>Margin of Error; Less than $10,000: - With dial-up Internet subscription alone</th>\n",
       "      <th>Estimate; Less than $10,000: - With a broadband Internet subscription</th>\n",
       "      <th>...</th>\n",
       "      <th>Estimate; $75,000 or more:</th>\n",
       "      <th>Margin of Error; $75,000 or more:</th>\n",
       "      <th>Estimate; $75,000 or more: - With dial-up Internet subscription alone</th>\n",
       "      <th>Margin of Error; $75,000 or more: - With dial-up Internet subscription alone</th>\n",
       "      <th>Estimate; $75,000 or more: - With a broadband Internet subscription</th>\n",
       "      <th>Margin of Error; $75,000 or more: - With a broadband Internet subscription</th>\n",
       "      <th>Estimate; $75,000 or more: - Without an Internet subscription</th>\n",
       "      <th>Margin of Error; $75,000 or more: - Without an Internet subscription</th>\n",
       "      <th>COMBINED $20,000 to $49,999 with broadband</th>\n",
       "      <th>COMBINED $20,000 to $49,999 pop</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0600000US0900108070</td>\n",
       "      <td>900108070</td>\n",
       "      <td>Bridgeport town, Fairfield County, Connecticut</td>\n",
       "      <td>49811</td>\n",
       "      <td>2237</td>\n",
       "      <td>5321</td>\n",
       "      <td>1086</td>\n",
       "      <td>0</td>\n",
       "      <td>198</td>\n",
       "      <td>2134</td>\n",
       "      <td>...</td>\n",
       "      <td>13487</td>\n",
       "      <td>1329</td>\n",
       "      <td>97</td>\n",
       "      <td>119</td>\n",
       "      <td>11615</td>\n",
       "      <td>1236</td>\n",
       "      <td>1775</td>\n",
       "      <td>666</td>\n",
       "      <td>11648</td>\n",
       "      <td>16721</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0600000US0900118500</td>\n",
       "      <td>900118500</td>\n",
       "      <td>Danbury town, Fairfield County, Connecticut</td>\n",
       "      <td>29775</td>\n",
       "      <td>2154</td>\n",
       "      <td>1981</td>\n",
       "      <td>827</td>\n",
       "      <td>0</td>\n",
       "      <td>198</td>\n",
       "      <td>1454</td>\n",
       "      <td>...</td>\n",
       "      <td>13142</td>\n",
       "      <td>1509</td>\n",
       "      <td>178</td>\n",
       "      <td>174</td>\n",
       "      <td>12479</td>\n",
       "      <td>1516</td>\n",
       "      <td>485</td>\n",
       "      <td>354</td>\n",
       "      <td>4824</td>\n",
       "      <td>7184</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0600000US0900156060</td>\n",
       "      <td>900156060</td>\n",
       "      <td>Norwalk town, Fairfield County, Connecticut</td>\n",
       "      <td>32467</td>\n",
       "      <td>1764</td>\n",
       "      <td>1528</td>\n",
       "      <td>626</td>\n",
       "      <td>63</td>\n",
       "      <td>107</td>\n",
       "      <td>697</td>\n",
       "      <td>...</td>\n",
       "      <td>17500</td>\n",
       "      <td>1454</td>\n",
       "      <td>79</td>\n",
       "      <td>90</td>\n",
       "      <td>16832</td>\n",
       "      <td>1479</td>\n",
       "      <td>589</td>\n",
       "      <td>285</td>\n",
       "      <td>4317</td>\n",
       "      <td>5953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0600000US0900173070</td>\n",
       "      <td>900173070</td>\n",
       "      <td>Stamford town, Fairfield County, Connecticut</td>\n",
       "      <td>47256</td>\n",
       "      <td>2090</td>\n",
       "      <td>2845</td>\n",
       "      <td>872</td>\n",
       "      <td>0</td>\n",
       "      <td>198</td>\n",
       "      <td>1512</td>\n",
       "      <td>...</td>\n",
       "      <td>25393</td>\n",
       "      <td>1722</td>\n",
       "      <td>0</td>\n",
       "      <td>198</td>\n",
       "      <td>24191</td>\n",
       "      <td>1841</td>\n",
       "      <td>1202</td>\n",
       "      <td>556</td>\n",
       "      <td>8289</td>\n",
       "      <td>9892</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0600000US0900337070</td>\n",
       "      <td>900337070</td>\n",
       "      <td>Hartford town, Hartford County, Connecticut</td>\n",
       "      <td>44867</td>\n",
       "      <td>2041</td>\n",
       "      <td>7566</td>\n",
       "      <td>1419</td>\n",
       "      <td>30</td>\n",
       "      <td>51</td>\n",
       "      <td>3205</td>\n",
       "      <td>...</td>\n",
       "      <td>8180</td>\n",
       "      <td>1199</td>\n",
       "      <td>72</td>\n",
       "      <td>93</td>\n",
       "      <td>7139</td>\n",
       "      <td>1088</td>\n",
       "      <td>969</td>\n",
       "      <td>516</td>\n",
       "      <td>10818</td>\n",
       "      <td>16663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0600000US0900350440</td>\n",
       "      <td>900350440</td>\n",
       "      <td>New Britain town, Hartford County, Connecticut</td>\n",
       "      <td>27834</td>\n",
       "      <td>1277</td>\n",
       "      <td>4079</td>\n",
       "      <td>1019</td>\n",
       "      <td>0</td>\n",
       "      <td>198</td>\n",
       "      <td>1632</td>\n",
       "      <td>...</td>\n",
       "      <td>7070</td>\n",
       "      <td>1233</td>\n",
       "      <td>0</td>\n",
       "      <td>198</td>\n",
       "      <td>6203</td>\n",
       "      <td>1139</td>\n",
       "      <td>867</td>\n",
       "      <td>580</td>\n",
       "      <td>6069</td>\n",
       "      <td>8392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0600000US0900952070</td>\n",
       "      <td>900952070</td>\n",
       "      <td>New Haven town, New Haven County, Connecticut</td>\n",
       "      <td>48690</td>\n",
       "      <td>2528</td>\n",
       "      <td>7508</td>\n",
       "      <td>1649</td>\n",
       "      <td>35</td>\n",
       "      <td>62</td>\n",
       "      <td>4099</td>\n",
       "      <td>...</td>\n",
       "      <td>11043</td>\n",
       "      <td>1331</td>\n",
       "      <td>0</td>\n",
       "      <td>198</td>\n",
       "      <td>10223</td>\n",
       "      <td>1291</td>\n",
       "      <td>820</td>\n",
       "      <td>396</td>\n",
       "      <td>10822</td>\n",
       "      <td>14270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0600000US0900980070</td>\n",
       "      <td>900980070</td>\n",
       "      <td>Waterbury town, New Haven County, Connecticut</td>\n",
       "      <td>39441</td>\n",
       "      <td>1869</td>\n",
       "      <td>5470</td>\n",
       "      <td>1123</td>\n",
       "      <td>0</td>\n",
       "      <td>198</td>\n",
       "      <td>1740</td>\n",
       "      <td>...</td>\n",
       "      <td>9480</td>\n",
       "      <td>1262</td>\n",
       "      <td>0</td>\n",
       "      <td>198</td>\n",
       "      <td>8517</td>\n",
       "      <td>1142</td>\n",
       "      <td>963</td>\n",
       "      <td>577</td>\n",
       "      <td>7448</td>\n",
       "      <td>11657</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8 rows × 55 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Id        Id2  \\\n",
       "0  0600000US0900108070  900108070   \n",
       "1  0600000US0900118500  900118500   \n",
       "2  0600000US0900156060  900156060   \n",
       "3  0600000US0900173070  900173070   \n",
       "4  0600000US0900337070  900337070   \n",
       "5  0600000US0900350440  900350440   \n",
       "6  0600000US0900952070  900952070   \n",
       "7  0600000US0900980070  900980070   \n",
       "\n",
       "                                        Geography  Estimate; Total:  \\\n",
       "0  Bridgeport town, Fairfield County, Connecticut             49811   \n",
       "1     Danbury town, Fairfield County, Connecticut             29775   \n",
       "2     Norwalk town, Fairfield County, Connecticut             32467   \n",
       "3    Stamford town, Fairfield County, Connecticut             47256   \n",
       "4     Hartford town, Hartford County, Connecticut             44867   \n",
       "5  New Britain town, Hartford County, Connecticut             27834   \n",
       "6   New Haven town, New Haven County, Connecticut             48690   \n",
       "7   Waterbury town, New Haven County, Connecticut             39441   \n",
       "\n",
       "   Margin of Error; Total:  Estimate; Less than $10,000:  \\\n",
       "0                     2237                          5321   \n",
       "1                     2154                          1981   \n",
       "2                     1764                          1528   \n",
       "3                     2090                          2845   \n",
       "4                     2041                          7566   \n",
       "5                     1277                          4079   \n",
       "6                     2528                          7508   \n",
       "7                     1869                          5470   \n",
       "\n",
       "   Margin of Error; Less than $10,000:  \\\n",
       "0                                 1086   \n",
       "1                                  827   \n",
       "2                                  626   \n",
       "3                                  872   \n",
       "4                                 1419   \n",
       "5                                 1019   \n",
       "6                                 1649   \n",
       "7                                 1123   \n",
       "\n",
       "   Estimate; Less than $10,000: - With dial-up Internet subscription alone  \\\n",
       "0                                                  0                         \n",
       "1                                                  0                         \n",
       "2                                                 63                         \n",
       "3                                                  0                         \n",
       "4                                                 30                         \n",
       "5                                                  0                         \n",
       "6                                                 35                         \n",
       "7                                                  0                         \n",
       "\n",
       "   Margin of Error; Less than $10,000: - With dial-up Internet subscription alone  \\\n",
       "0                                                198                                \n",
       "1                                                198                                \n",
       "2                                                107                                \n",
       "3                                                198                                \n",
       "4                                                 51                                \n",
       "5                                                198                                \n",
       "6                                                 62                                \n",
       "7                                                198                                \n",
       "\n",
       "   Estimate; Less than $10,000: - With a broadband Internet subscription  \\\n",
       "0                                               2134                       \n",
       "1                                               1454                       \n",
       "2                                                697                       \n",
       "3                                               1512                       \n",
       "4                                               3205                       \n",
       "5                                               1632                       \n",
       "6                                               4099                       \n",
       "7                                               1740                       \n",
       "\n",
       "                ...                 Estimate; $75,000 or more:  \\\n",
       "0               ...                                      13487   \n",
       "1               ...                                      13142   \n",
       "2               ...                                      17500   \n",
       "3               ...                                      25393   \n",
       "4               ...                                       8180   \n",
       "5               ...                                       7070   \n",
       "6               ...                                      11043   \n",
       "7               ...                                       9480   \n",
       "\n",
       "   Margin of Error; $75,000 or more:  \\\n",
       "0                               1329   \n",
       "1                               1509   \n",
       "2                               1454   \n",
       "3                               1722   \n",
       "4                               1199   \n",
       "5                               1233   \n",
       "6                               1331   \n",
       "7                               1262   \n",
       "\n",
       "   Estimate; $75,000 or more: - With dial-up Internet subscription alone  \\\n",
       "0                                                 97                       \n",
       "1                                                178                       \n",
       "2                                                 79                       \n",
       "3                                                  0                       \n",
       "4                                                 72                       \n",
       "5                                                  0                       \n",
       "6                                                  0                       \n",
       "7                                                  0                       \n",
       "\n",
       "   Margin of Error; $75,000 or more: - With dial-up Internet subscription alone  \\\n",
       "0                                                119                              \n",
       "1                                                174                              \n",
       "2                                                 90                              \n",
       "3                                                198                              \n",
       "4                                                 93                              \n",
       "5                                                198                              \n",
       "6                                                198                              \n",
       "7                                                198                              \n",
       "\n",
       "   Estimate; $75,000 or more: - With a broadband Internet subscription  \\\n",
       "0                                              11615                     \n",
       "1                                              12479                     \n",
       "2                                              16832                     \n",
       "3                                              24191                     \n",
       "4                                               7139                     \n",
       "5                                               6203                     \n",
       "6                                              10223                     \n",
       "7                                               8517                     \n",
       "\n",
       "   Margin of Error; $75,000 or more: - With a broadband Internet subscription  \\\n",
       "0                                               1236                            \n",
       "1                                               1516                            \n",
       "2                                               1479                            \n",
       "3                                               1841                            \n",
       "4                                               1088                            \n",
       "5                                               1139                            \n",
       "6                                               1291                            \n",
       "7                                               1142                            \n",
       "\n",
       "   Estimate; $75,000 or more: - Without an Internet subscription  \\\n",
       "0                                               1775               \n",
       "1                                                485               \n",
       "2                                                589               \n",
       "3                                               1202               \n",
       "4                                                969               \n",
       "5                                                867               \n",
       "6                                                820               \n",
       "7                                                963               \n",
       "\n",
       "   Margin of Error; $75,000 or more: - Without an Internet subscription  \\\n",
       "0                                                666                      \n",
       "1                                                354                      \n",
       "2                                                285                      \n",
       "3                                                556                      \n",
       "4                                                516                      \n",
       "5                                                580                      \n",
       "6                                                396                      \n",
       "7                                                577                      \n",
       "\n",
       "   COMBINED $20,000 to $49,999 with broadband  COMBINED $20,000 to $49,999 pop  \n",
       "0                                       11648                            16721  \n",
       "1                                        4824                             7184  \n",
       "2                                        4317                             5953  \n",
       "3                                        8289                             9892  \n",
       "4                                       10818                            16663  \n",
       "5                                        6069                             8392  \n",
       "6                                       10822                            14270  \n",
       "7                                        7448                            11657  \n",
       "\n",
       "[8 rows x 55 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def three_buckets(df):\n",
    "    ret = df.copy()\n",
    "    ret[\"COMBINED $20,000 to $49,999 with broadband\"] = ret[col(\"est\",\"35K\",\"broadband\")]\\\n",
    "    + ret[col(\"est\",\"50K\",\"broadband\")]\n",
    "    \n",
    "    ret[\"COMBINED $20,000 to $49,999 pop\"] = ret[col(\"est\",\"35K\",\"NA\")]\\\n",
    "    + ret[col(\"est\",\"50K\",\"NA\")]\n",
    "\n",
    "    return ret\n",
    "\n",
    "three_buckets(get_data(15))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "def three_buckets_pcts(df):\n",
    "    cols = [\"Geography\",\n",
    "            col(\"est\",\"20K\",\"broadband\"),\n",
    "            col(\"est\",\"20K\",\"NA\"),\n",
    "            \"COMBINED $20,000 to $49,999 with broadband\",\n",
    "            \"COMBINED $20,000 to $49,999 pop\",\n",
    "            col(\"est\",\"75K\",\"broadband\"),\n",
    "            col(\"est\",\"75K\",\"NA\"),\n",
    "            col(\"est\",\"75+\",\"broadband\"),\n",
    "            col(\"est\",\"75+\",\"NA\"),\n",
    "           ]\n",
    "    \n",
    "    return df[cols]\n",
    "\n",
    "#three_buckets_pcts(three_buckets(get_data(2015)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Geography\n",
      "Estimate; $10,000 to $19,999: - With a broadband Internet subscription\n",
      "Estimate; $10,000 to $19,999:\n",
      "COMBINED $20,000 to $49,999 with broadband\n",
      "COMBINED $20,000 to $49,999 pop\n",
      "Estimate; $50,000 to $74,999: - With a broadband Internet subscription\n",
      "Estimate; $50,000 to $74,999:\n",
      "Estimate; $75,000 or more: - With a broadband Internet subscription\n",
      "Estimate; $75,000 or more:\n"
     ]
    }
   ],
   "source": [
    "for c in three_buckets_pcts(three_buckets(get_data(15))).columns:\n",
    "    print c"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>Geography</th>\n",
       "      <th>pct_20K</th>\n",
       "      <th>pct_50K</th>\n",
       "      <th>pct_75K</th>\n",
       "      <th>pct_75+</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Bridgeport town, Fairfield County, Connecticut</td>\n",
       "      <td>0.489068</td>\n",
       "      <td>0.696609</td>\n",
       "      <td>0.853623</td>\n",
       "      <td>0.861200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Danbury town, Fairfield County, Connecticut</td>\n",
       "      <td>0.336105</td>\n",
       "      <td>0.671492</td>\n",
       "      <td>0.935751</td>\n",
       "      <td>0.949551</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Norwalk town, Fairfield County, Connecticut</td>\n",
       "      <td>0.792508</td>\n",
       "      <td>0.725181</td>\n",
       "      <td>0.871233</td>\n",
       "      <td>0.961829</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Stamford town, Fairfield County, Connecticut</td>\n",
       "      <td>0.619848</td>\n",
       "      <td>0.837950</td>\n",
       "      <td>0.889874</td>\n",
       "      <td>0.952664</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Hartford town, Hartford County, Connecticut</td>\n",
       "      <td>0.460646</td>\n",
       "      <td>0.649223</td>\n",
       "      <td>0.815367</td>\n",
       "      <td>0.872738</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>New Britain town, Hartford County, Connecticut</td>\n",
       "      <td>0.446235</td>\n",
       "      <td>0.723189</td>\n",
       "      <td>0.795697</td>\n",
       "      <td>0.877369</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>New Haven town, New Haven County, Connecticut</td>\n",
       "      <td>0.494194</td>\n",
       "      <td>0.758374</td>\n",
       "      <td>0.861175</td>\n",
       "      <td>0.925745</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Waterbury town, New Haven County, Connecticut</td>\n",
       "      <td>0.458256</td>\n",
       "      <td>0.638929</td>\n",
       "      <td>0.757746</td>\n",
       "      <td>0.898418</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        Geography   pct_20K   pct_50K  \\\n",
       "0  Bridgeport town, Fairfield County, Connecticut  0.489068  0.696609   \n",
       "1     Danbury town, Fairfield County, Connecticut  0.336105  0.671492   \n",
       "2     Norwalk town, Fairfield County, Connecticut  0.792508  0.725181   \n",
       "3    Stamford town, Fairfield County, Connecticut  0.619848  0.837950   \n",
       "4     Hartford town, Hartford County, Connecticut  0.460646  0.649223   \n",
       "5  New Britain town, Hartford County, Connecticut  0.446235  0.723189   \n",
       "6   New Haven town, New Haven County, Connecticut  0.494194  0.758374   \n",
       "7   Waterbury town, New Haven County, Connecticut  0.458256  0.638929   \n",
       "\n",
       "    pct_75K   pct_75+  \n",
       "0  0.853623  0.861200  \n",
       "1  0.935751  0.949551  \n",
       "2  0.871233  0.961829  \n",
       "3  0.889874  0.952664  \n",
       "4  0.815367  0.872738  \n",
       "5  0.795697  0.877369  \n",
       "6  0.861175  0.925745  \n",
       "7  0.757746  0.898418  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def pcts(df):\n",
    "    ret = three_buckets_pcts(three_buckets(df))\n",
    "    ret[\"pct_20K\"] = ret[\"Estimate; $10,000 to $19,999: - With a broadband Internet subscription\"]\\\n",
    "    / ret[\"Estimate; $10,000 to $19,999:\"]\n",
    "    ret[\"pct_50K\"] = ret[\"COMBINED $20,000 to $49,999 with broadband\"]\\\n",
    "    /ret[\"COMBINED $20,000 to $49,999 pop\"]\n",
    "    ret[\"pct_75K\"] = ret[\"Estimate; $50,000 to $74,999: - With a broadband Internet subscription\"]\\\n",
    "    /ret[\"Estimate; $50,000 to $74,999:\"]\n",
    "    ret[\"pct_75+\"] = ret[\"Estimate; $75,000 or more: - With a broadband Internet subscription\"]\\\n",
    "    /ret[\"Estimate; $75,000 or more:\"]\n",
    "    \n",
    "    return ret[[\"Geography\",\"pct_20K\",\"pct_50K\",\"pct_75K\",\"pct_75+\"]]\n",
    "\n",
    "pcts(get_data(15))#.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>Geography</th>\n",
       "      <th>pct_20K</th>\n",
       "      <th>pct_50K</th>\n",
       "      <th>pct_75K</th>\n",
       "      <th>pct_75+</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Bridgeport town, Fairfield County, Connecticut</td>\n",
       "      <td>0.547352</td>\n",
       "      <td>0.746492</td>\n",
       "      <td>0.882597</td>\n",
       "      <td>0.917325</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Danbury town, Fairfield County, Connecticut</td>\n",
       "      <td>0.378098</td>\n",
       "      <td>0.734333</td>\n",
       "      <td>0.819381</td>\n",
       "      <td>0.928728</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Norwalk town, Fairfield County, Connecticut</td>\n",
       "      <td>0.584274</td>\n",
       "      <td>0.756171</td>\n",
       "      <td>0.856000</td>\n",
       "      <td>0.964028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Stamford town, Fairfield County, Connecticut</td>\n",
       "      <td>0.587367</td>\n",
       "      <td>0.806315</td>\n",
       "      <td>0.842573</td>\n",
       "      <td>0.947573</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Hartford town, Hartford County, Connecticut</td>\n",
       "      <td>0.443323</td>\n",
       "      <td>0.662580</td>\n",
       "      <td>0.783788</td>\n",
       "      <td>0.862006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>New Britain town, Hartford County, Connecticut</td>\n",
       "      <td>0.385661</td>\n",
       "      <td>0.672226</td>\n",
       "      <td>0.855744</td>\n",
       "      <td>0.879397</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>New Haven town, New Haven County, Connecticut</td>\n",
       "      <td>0.467317</td>\n",
       "      <td>0.665866</td>\n",
       "      <td>0.791210</td>\n",
       "      <td>0.898354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Waterbury town, New Haven County, Connecticut</td>\n",
       "      <td>0.546588</td>\n",
       "      <td>0.586597</td>\n",
       "      <td>0.757304</td>\n",
       "      <td>0.868374</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        Geography   pct_20K   pct_50K  \\\n",
       "0  Bridgeport town, Fairfield County, Connecticut  0.547352  0.746492   \n",
       "1     Danbury town, Fairfield County, Connecticut  0.378098  0.734333   \n",
       "2     Norwalk town, Fairfield County, Connecticut  0.584274  0.756171   \n",
       "3    Stamford town, Fairfield County, Connecticut  0.587367  0.806315   \n",
       "4     Hartford town, Hartford County, Connecticut  0.443323  0.662580   \n",
       "5  New Britain town, Hartford County, Connecticut  0.385661  0.672226   \n",
       "6   New Haven town, New Haven County, Connecticut  0.467317  0.665866   \n",
       "7   Waterbury town, New Haven County, Connecticut  0.546588  0.586597   \n",
       "\n",
       "    pct_75K   pct_75+  \n",
       "0  0.882597  0.917325  \n",
       "1  0.819381  0.928728  \n",
       "2  0.856000  0.964028  \n",
       "3  0.842573  0.947573  \n",
       "4  0.783788  0.862006  \n",
       "5  0.855744  0.879397  \n",
       "6  0.791210  0.898354  \n",
       "7  0.757304  0.868374  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pcts(get_data(14))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>Geography</th>\n",
       "      <th>pct_20K</th>\n",
       "      <th>pct_50K</th>\n",
       "      <th>pct_75K</th>\n",
       "      <th>pct_75+</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Bridgeport town, Fairfield County, Connecticut</td>\n",
       "      <td>0.601450</td>\n",
       "      <td>0.712193</td>\n",
       "      <td>0.778162</td>\n",
       "      <td>0.876624</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Danbury town, Fairfield County, Connecticut</td>\n",
       "      <td>0.590340</td>\n",
       "      <td>0.650289</td>\n",
       "      <td>0.939902</td>\n",
       "      <td>0.942768</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Norwalk town, Fairfield County, Connecticut</td>\n",
       "      <td>0.557424</td>\n",
       "      <td>0.790465</td>\n",
       "      <td>0.922803</td>\n",
       "      <td>0.946571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Stamford town, Fairfield County, Connecticut</td>\n",
       "      <td>0.471928</td>\n",
       "      <td>0.639449</td>\n",
       "      <td>0.871152</td>\n",
       "      <td>0.949842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Hartford town, Hartford County, Connecticut</td>\n",
       "      <td>0.364305</td>\n",
       "      <td>0.523807</td>\n",
       "      <td>0.712506</td>\n",
       "      <td>0.850346</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>New Britain town, Hartford County, Connecticut</td>\n",
       "      <td>0.433246</td>\n",
       "      <td>0.472851</td>\n",
       "      <td>0.778108</td>\n",
       "      <td>0.852276</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>New Haven town, New Haven County, Connecticut</td>\n",
       "      <td>0.325311</td>\n",
       "      <td>0.532605</td>\n",
       "      <td>0.713775</td>\n",
       "      <td>0.844098</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Waterbury town, New Haven County, Connecticut</td>\n",
       "      <td>0.394234</td>\n",
       "      <td>0.575915</td>\n",
       "      <td>0.753955</td>\n",
       "      <td>0.915840</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        Geography   pct_20K   pct_50K  \\\n",
       "0  Bridgeport town, Fairfield County, Connecticut  0.601450  0.712193   \n",
       "1     Danbury town, Fairfield County, Connecticut  0.590340  0.650289   \n",
       "2     Norwalk town, Fairfield County, Connecticut  0.557424  0.790465   \n",
       "3    Stamford town, Fairfield County, Connecticut  0.471928  0.639449   \n",
       "4     Hartford town, Hartford County, Connecticut  0.364305  0.523807   \n",
       "5  New Britain town, Hartford County, Connecticut  0.433246  0.472851   \n",
       "6   New Haven town, New Haven County, Connecticut  0.325311  0.532605   \n",
       "7   Waterbury town, New Haven County, Connecticut  0.394234  0.575915   \n",
       "\n",
       "    pct_75K   pct_75+  \n",
       "0  0.778162  0.876624  \n",
       "1  0.939902  0.942768  \n",
       "2  0.922803  0.946571  \n",
       "3  0.871152  0.949842  \n",
       "4  0.712506  0.850346  \n",
       "5  0.778108  0.852276  \n",
       "6  0.713775  0.844098  \n",
       "7  0.753955  0.915840  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pcts(get_data(13))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}