ModelSelection.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 151,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "from sklearn.ensemble import (RandomTreesEmbedding, RandomForestClassifier,\n",
    "                              GradientBoostingClassifier)\n",
    "from sklearn.preprocessing import OneHotEncoder\n",
    "from sklearn.model_selection import train_test_split\n",
    "from sklearn.metrics import roc_curve\n",
    "from sklearn.pipeline import Pipeline\n",
    "from sklearn.ensemble import RandomForestRegressor\n",
    "from sklearn.metrics import classification_report\n",
    "from sklearn.preprocessing import Imputer\n",
    "from sklearn.metrics import r2_score"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import os\n",
    "\n",
    "os.getcwd()\n",
    "#os.chdir(\"data\")\n",
    "masterdf = pd.read_csv(\"master_wo_error.csv\", low_memory=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 116,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(7448, 838)"
      ]
     },
     "execution_count": 116,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "masterdf.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 158,
   "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>Year_x</th>\n",
       "      <th>FIPS Code</th>\n",
       "      <th>Type</th>\n",
       "      <th>Year_y</th>\n",
       "      <th>Rate_x</th>\n",
       "      <th>County</th>\n",
       "      <th>State</th>\n",
       "      <th>FIPS County Code</th>\n",
       "      <th>Total; Estimate; Total population</th>\n",
       "      <th>Male; Estimate; Total population</th>\n",
       "      <th>...</th>\n",
       "      <th>Employment/Population Ratio; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - High school graduate (includes equivalency)</th>\n",
       "      <th>Unemployment rate; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - High school graduate (includes equivalency)</th>\n",
       "      <th>Total; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Some college or associate's degree</th>\n",
       "      <th>Labor Force Participation Rate; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Some college or associate's degree</th>\n",
       "      <th>Employment/Population Ratio; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Some college or associate's degree</th>\n",
       "      <th>Unemployment rate; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Some college or associate's degree</th>\n",
       "      <th>Total; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Bachelor's degree or higher</th>\n",
       "      <th>Labor Force Participation Rate; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Bachelor's degree or higher</th>\n",
       "      <th>Employment/Population Ratio; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Bachelor's degree or higher</th>\n",
       "      <th>Unemployment rate; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Bachelor's degree or higher</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4272</th>\n",
       "      <td>2013</td>\n",
       "      <td>51003</td>\n",
       "      <td>Diagnosed HIV</td>\n",
       "      <td>2015</td>\n",
       "      <td>4.7</td>\n",
       "      <td>Albemarle, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51003.0</td>\n",
       "      <td>103108.0</td>\n",
       "      <td>49365.0</td>\n",
       "      <td>...</td>\n",
       "      <td>74.3</td>\n",
       "      <td>3.3</td>\n",
       "      <td>11388.0</td>\n",
       "      <td>79.3</td>\n",
       "      <td>74.6</td>\n",
       "      <td>4.1</td>\n",
       "      <td>28478.0</td>\n",
       "      <td>81.2</td>\n",
       "      <td>79.1</td>\n",
       "      <td>1.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4273</th>\n",
       "      <td>2013</td>\n",
       "      <td>51003</td>\n",
       "      <td>Diagnosed HIV</td>\n",
       "      <td>2015</td>\n",
       "      <td>4.7</td>\n",
       "      <td>Albemarle, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51003.0</td>\n",
       "      <td>103108.0</td>\n",
       "      <td>49365.0</td>\n",
       "      <td>...</td>\n",
       "      <td>74.3</td>\n",
       "      <td>3.3</td>\n",
       "      <td>11388.0</td>\n",
       "      <td>79.3</td>\n",
       "      <td>74.6</td>\n",
       "      <td>4.1</td>\n",
       "      <td>28478.0</td>\n",
       "      <td>81.2</td>\n",
       "      <td>79.1</td>\n",
       "      <td>1.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4274</th>\n",
       "      <td>2013</td>\n",
       "      <td>51003</td>\n",
       "      <td>ED Heroin Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>11.4</td>\n",
       "      <td>Albemarle, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51003.0</td>\n",
       "      <td>103108.0</td>\n",
       "      <td>49365.0</td>\n",
       "      <td>...</td>\n",
       "      <td>74.3</td>\n",
       "      <td>3.3</td>\n",
       "      <td>11388.0</td>\n",
       "      <td>79.3</td>\n",
       "      <td>74.6</td>\n",
       "      <td>4.1</td>\n",
       "      <td>28478.0</td>\n",
       "      <td>81.2</td>\n",
       "      <td>79.1</td>\n",
       "      <td>1.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4275</th>\n",
       "      <td>2013</td>\n",
       "      <td>51003</td>\n",
       "      <td>ED Heroin Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>11.4</td>\n",
       "      <td>Albemarle, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51003.0</td>\n",
       "      <td>103108.0</td>\n",
       "      <td>49365.0</td>\n",
       "      <td>...</td>\n",
       "      <td>74.3</td>\n",
       "      <td>3.3</td>\n",
       "      <td>11388.0</td>\n",
       "      <td>79.3</td>\n",
       "      <td>74.6</td>\n",
       "      <td>4.1</td>\n",
       "      <td>28478.0</td>\n",
       "      <td>81.2</td>\n",
       "      <td>79.1</td>\n",
       "      <td>1.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4276</th>\n",
       "      <td>2013</td>\n",
       "      <td>51003</td>\n",
       "      <td>ED Opioid Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>71.9</td>\n",
       "      <td>Albemarle, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51003.0</td>\n",
       "      <td>103108.0</td>\n",
       "      <td>49365.0</td>\n",
       "      <td>...</td>\n",
       "      <td>74.3</td>\n",
       "      <td>3.3</td>\n",
       "      <td>11388.0</td>\n",
       "      <td>79.3</td>\n",
       "      <td>74.6</td>\n",
       "      <td>4.1</td>\n",
       "      <td>28478.0</td>\n",
       "      <td>81.2</td>\n",
       "      <td>79.1</td>\n",
       "      <td>1.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4277</th>\n",
       "      <td>2013</td>\n",
       "      <td>51003</td>\n",
       "      <td>ED Opioid Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>71.9</td>\n",
       "      <td>Albemarle, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51003.0</td>\n",
       "      <td>103108.0</td>\n",
       "      <td>49365.0</td>\n",
       "      <td>...</td>\n",
       "      <td>74.3</td>\n",
       "      <td>3.3</td>\n",
       "      <td>11388.0</td>\n",
       "      <td>79.3</td>\n",
       "      <td>74.6</td>\n",
       "      <td>4.1</td>\n",
       "      <td>28478.0</td>\n",
       "      <td>81.2</td>\n",
       "      <td>79.1</td>\n",
       "      <td>1.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4278</th>\n",
       "      <td>2013</td>\n",
       "      <td>51003</td>\n",
       "      <td>EMS Narcan</td>\n",
       "      <td>2015</td>\n",
       "      <td>15.1</td>\n",
       "      <td>Albemarle, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51003.0</td>\n",
       "      <td>103108.0</td>\n",
       "      <td>49365.0</td>\n",
       "      <td>...</td>\n",
       "      <td>74.3</td>\n",
       "      <td>3.3</td>\n",
       "      <td>11388.0</td>\n",
       "      <td>79.3</td>\n",
       "      <td>74.6</td>\n",
       "      <td>4.1</td>\n",
       "      <td>28478.0</td>\n",
       "      <td>81.2</td>\n",
       "      <td>79.1</td>\n",
       "      <td>1.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4279</th>\n",
       "      <td>2013</td>\n",
       "      <td>51003</td>\n",
       "      <td>EMS Narcan</td>\n",
       "      <td>2015</td>\n",
       "      <td>15.1</td>\n",
       "      <td>Albemarle, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51003.0</td>\n",
       "      <td>103108.0</td>\n",
       "      <td>49365.0</td>\n",
       "      <td>...</td>\n",
       "      <td>74.3</td>\n",
       "      <td>3.3</td>\n",
       "      <td>11388.0</td>\n",
       "      <td>79.3</td>\n",
       "      <td>74.6</td>\n",
       "      <td>4.1</td>\n",
       "      <td>28478.0</td>\n",
       "      <td>81.2</td>\n",
       "      <td>79.1</td>\n",
       "      <td>1.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4280</th>\n",
       "      <td>2013</td>\n",
       "      <td>51003</td>\n",
       "      <td>Fatal Fentanyl and/or Heroin Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>0.9</td>\n",
       "      <td>Albemarle, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51003.0</td>\n",
       "      <td>103108.0</td>\n",
       "      <td>49365.0</td>\n",
       "      <td>...</td>\n",
       "      <td>74.3</td>\n",
       "      <td>3.3</td>\n",
       "      <td>11388.0</td>\n",
       "      <td>79.3</td>\n",
       "      <td>74.6</td>\n",
       "      <td>4.1</td>\n",
       "      <td>28478.0</td>\n",
       "      <td>81.2</td>\n",
       "      <td>79.1</td>\n",
       "      <td>1.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4281</th>\n",
       "      <td>2013</td>\n",
       "      <td>51003</td>\n",
       "      <td>Fatal Fentanyl and/or Heroin Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>0.9</td>\n",
       "      <td>Albemarle, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51003.0</td>\n",
       "      <td>103108.0</td>\n",
       "      <td>49365.0</td>\n",
       "      <td>...</td>\n",
       "      <td>74.3</td>\n",
       "      <td>3.3</td>\n",
       "      <td>11388.0</td>\n",
       "      <td>79.3</td>\n",
       "      <td>74.6</td>\n",
       "      <td>4.1</td>\n",
       "      <td>28478.0</td>\n",
       "      <td>81.2</td>\n",
       "      <td>79.1</td>\n",
       "      <td>1.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4282</th>\n",
       "      <td>2013</td>\n",
       "      <td>51003</td>\n",
       "      <td>Fatal Prescription Opioid Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>1.9</td>\n",
       "      <td>Albemarle, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51003.0</td>\n",
       "      <td>103108.0</td>\n",
       "      <td>49365.0</td>\n",
       "      <td>...</td>\n",
       "      <td>74.3</td>\n",
       "      <td>3.3</td>\n",
       "      <td>11388.0</td>\n",
       "      <td>79.3</td>\n",
       "      <td>74.6</td>\n",
       "      <td>4.1</td>\n",
       "      <td>28478.0</td>\n",
       "      <td>81.2</td>\n",
       "      <td>79.1</td>\n",
       "      <td>1.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4283</th>\n",
       "      <td>2013</td>\n",
       "      <td>51003</td>\n",
       "      <td>Fatal Prescription Opioid Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>1.9</td>\n",
       "      <td>Albemarle, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51003.0</td>\n",
       "      <td>103108.0</td>\n",
       "      <td>49365.0</td>\n",
       "      <td>...</td>\n",
       "      <td>74.3</td>\n",
       "      <td>3.3</td>\n",
       "      <td>11388.0</td>\n",
       "      <td>79.3</td>\n",
       "      <td>74.6</td>\n",
       "      <td>4.1</td>\n",
       "      <td>28478.0</td>\n",
       "      <td>81.2</td>\n",
       "      <td>79.1</td>\n",
       "      <td>1.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4284</th>\n",
       "      <td>2013</td>\n",
       "      <td>51003</td>\n",
       "      <td>Neonatal Abstinance Syndrome</td>\n",
       "      <td>2015</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Albemarle, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51003.0</td>\n",
       "      <td>103108.0</td>\n",
       "      <td>49365.0</td>\n",
       "      <td>...</td>\n",
       "      <td>74.3</td>\n",
       "      <td>3.3</td>\n",
       "      <td>11388.0</td>\n",
       "      <td>79.3</td>\n",
       "      <td>74.6</td>\n",
       "      <td>4.1</td>\n",
       "      <td>28478.0</td>\n",
       "      <td>81.2</td>\n",
       "      <td>79.1</td>\n",
       "      <td>1.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4285</th>\n",
       "      <td>2013</td>\n",
       "      <td>51003</td>\n",
       "      <td>Neonatal Abstinance Syndrome</td>\n",
       "      <td>2015</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Albemarle, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51003.0</td>\n",
       "      <td>103108.0</td>\n",
       "      <td>49365.0</td>\n",
       "      <td>...</td>\n",
       "      <td>74.3</td>\n",
       "      <td>3.3</td>\n",
       "      <td>11388.0</td>\n",
       "      <td>79.3</td>\n",
       "      <td>74.6</td>\n",
       "      <td>4.1</td>\n",
       "      <td>28478.0</td>\n",
       "      <td>81.2</td>\n",
       "      <td>79.1</td>\n",
       "      <td>1.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4286</th>\n",
       "      <td>2013</td>\n",
       "      <td>51003</td>\n",
       "      <td>Reported Hepatitis C (1830 year olds)</td>\n",
       "      <td>2015</td>\n",
       "      <td>18.9</td>\n",
       "      <td>Albemarle, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51003.0</td>\n",
       "      <td>103108.0</td>\n",
       "      <td>49365.0</td>\n",
       "      <td>...</td>\n",
       "      <td>74.3</td>\n",
       "      <td>3.3</td>\n",
       "      <td>11388.0</td>\n",
       "      <td>79.3</td>\n",
       "      <td>74.6</td>\n",
       "      <td>4.1</td>\n",
       "      <td>28478.0</td>\n",
       "      <td>81.2</td>\n",
       "      <td>79.1</td>\n",
       "      <td>1.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4287</th>\n",
       "      <td>2013</td>\n",
       "      <td>51003</td>\n",
       "      <td>Reported Hepatitis C (1830 year olds)</td>\n",
       "      <td>2015</td>\n",
       "      <td>18.9</td>\n",
       "      <td>Albemarle, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51003.0</td>\n",
       "      <td>103108.0</td>\n",
       "      <td>49365.0</td>\n",
       "      <td>...</td>\n",
       "      <td>74.3</td>\n",
       "      <td>3.3</td>\n",
       "      <td>11388.0</td>\n",
       "      <td>79.3</td>\n",
       "      <td>74.6</td>\n",
       "      <td>4.1</td>\n",
       "      <td>28478.0</td>\n",
       "      <td>81.2</td>\n",
       "      <td>79.1</td>\n",
       "      <td>1.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4352</th>\n",
       "      <td>2013</td>\n",
       "      <td>51013</td>\n",
       "      <td>Diagnosed HIV</td>\n",
       "      <td>2015</td>\n",
       "      <td>14.8</td>\n",
       "      <td>Arlington, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51013.0</td>\n",
       "      <td>223945.0</td>\n",
       "      <td>112006.0</td>\n",
       "      <td>...</td>\n",
       "      <td>70.8</td>\n",
       "      <td>6.5</td>\n",
       "      <td>17446.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>78.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>111202.0</td>\n",
       "      <td>90.5</td>\n",
       "      <td>87.0</td>\n",
       "      <td>2.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4353</th>\n",
       "      <td>2013</td>\n",
       "      <td>51013</td>\n",
       "      <td>Diagnosed HIV</td>\n",
       "      <td>2015</td>\n",
       "      <td>14.8</td>\n",
       "      <td>Arlington, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51013.0</td>\n",
       "      <td>223945.0</td>\n",
       "      <td>112006.0</td>\n",
       "      <td>...</td>\n",
       "      <td>70.8</td>\n",
       "      <td>6.5</td>\n",
       "      <td>17446.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>78.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>111202.0</td>\n",
       "      <td>90.5</td>\n",
       "      <td>87.0</td>\n",
       "      <td>2.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4354</th>\n",
       "      <td>2013</td>\n",
       "      <td>51013</td>\n",
       "      <td>ED Heroin Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>1.7</td>\n",
       "      <td>Arlington, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51013.0</td>\n",
       "      <td>223945.0</td>\n",
       "      <td>112006.0</td>\n",
       "      <td>...</td>\n",
       "      <td>70.8</td>\n",
       "      <td>6.5</td>\n",
       "      <td>17446.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>78.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>111202.0</td>\n",
       "      <td>90.5</td>\n",
       "      <td>87.0</td>\n",
       "      <td>2.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4355</th>\n",
       "      <td>2013</td>\n",
       "      <td>51013</td>\n",
       "      <td>ED Heroin Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>1.7</td>\n",
       "      <td>Arlington, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51013.0</td>\n",
       "      <td>223945.0</td>\n",
       "      <td>112006.0</td>\n",
       "      <td>...</td>\n",
       "      <td>70.8</td>\n",
       "      <td>6.5</td>\n",
       "      <td>17446.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>78.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>111202.0</td>\n",
       "      <td>90.5</td>\n",
       "      <td>87.0</td>\n",
       "      <td>2.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4356</th>\n",
       "      <td>2013</td>\n",
       "      <td>51013</td>\n",
       "      <td>ED Opioid Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>46.3</td>\n",
       "      <td>Arlington, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51013.0</td>\n",
       "      <td>223945.0</td>\n",
       "      <td>112006.0</td>\n",
       "      <td>...</td>\n",
       "      <td>70.8</td>\n",
       "      <td>6.5</td>\n",
       "      <td>17446.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>78.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>111202.0</td>\n",
       "      <td>90.5</td>\n",
       "      <td>87.0</td>\n",
       "      <td>2.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4357</th>\n",
       "      <td>2013</td>\n",
       "      <td>51013</td>\n",
       "      <td>ED Opioid Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>46.3</td>\n",
       "      <td>Arlington, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51013.0</td>\n",
       "      <td>223945.0</td>\n",
       "      <td>112006.0</td>\n",
       "      <td>...</td>\n",
       "      <td>70.8</td>\n",
       "      <td>6.5</td>\n",
       "      <td>17446.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>78.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>111202.0</td>\n",
       "      <td>90.5</td>\n",
       "      <td>87.0</td>\n",
       "      <td>2.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4358</th>\n",
       "      <td>2013</td>\n",
       "      <td>51013</td>\n",
       "      <td>EMS Narcan</td>\n",
       "      <td>2015</td>\n",
       "      <td>15.7</td>\n",
       "      <td>Arlington, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51013.0</td>\n",
       "      <td>223945.0</td>\n",
       "      <td>112006.0</td>\n",
       "      <td>...</td>\n",
       "      <td>70.8</td>\n",
       "      <td>6.5</td>\n",
       "      <td>17446.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>78.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>111202.0</td>\n",
       "      <td>90.5</td>\n",
       "      <td>87.0</td>\n",
       "      <td>2.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4359</th>\n",
       "      <td>2013</td>\n",
       "      <td>51013</td>\n",
       "      <td>EMS Narcan</td>\n",
       "      <td>2015</td>\n",
       "      <td>15.7</td>\n",
       "      <td>Arlington, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51013.0</td>\n",
       "      <td>223945.0</td>\n",
       "      <td>112006.0</td>\n",
       "      <td>...</td>\n",
       "      <td>70.8</td>\n",
       "      <td>6.5</td>\n",
       "      <td>17446.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>78.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>111202.0</td>\n",
       "      <td>90.5</td>\n",
       "      <td>87.0</td>\n",
       "      <td>2.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4360</th>\n",
       "      <td>2013</td>\n",
       "      <td>51013</td>\n",
       "      <td>Fatal Fentanyl and/or Heroin Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>1.7</td>\n",
       "      <td>Arlington, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51013.0</td>\n",
       "      <td>223945.0</td>\n",
       "      <td>112006.0</td>\n",
       "      <td>...</td>\n",
       "      <td>70.8</td>\n",
       "      <td>6.5</td>\n",
       "      <td>17446.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>78.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>111202.0</td>\n",
       "      <td>90.5</td>\n",
       "      <td>87.0</td>\n",
       "      <td>2.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4361</th>\n",
       "      <td>2013</td>\n",
       "      <td>51013</td>\n",
       "      <td>Fatal Fentanyl and/or Heroin Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>1.7</td>\n",
       "      <td>Arlington, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51013.0</td>\n",
       "      <td>223945.0</td>\n",
       "      <td>112006.0</td>\n",
       "      <td>...</td>\n",
       "      <td>70.8</td>\n",
       "      <td>6.5</td>\n",
       "      <td>17446.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>78.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>111202.0</td>\n",
       "      <td>90.5</td>\n",
       "      <td>87.0</td>\n",
       "      <td>2.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4362</th>\n",
       "      <td>2013</td>\n",
       "      <td>51013</td>\n",
       "      <td>Fatal Prescription Opioid Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>3.9</td>\n",
       "      <td>Arlington, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51013.0</td>\n",
       "      <td>223945.0</td>\n",
       "      <td>112006.0</td>\n",
       "      <td>...</td>\n",
       "      <td>70.8</td>\n",
       "      <td>6.5</td>\n",
       "      <td>17446.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>78.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>111202.0</td>\n",
       "      <td>90.5</td>\n",
       "      <td>87.0</td>\n",
       "      <td>2.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4363</th>\n",
       "      <td>2013</td>\n",
       "      <td>51013</td>\n",
       "      <td>Fatal Prescription Opioid Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>3.9</td>\n",
       "      <td>Arlington, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51013.0</td>\n",
       "      <td>223945.0</td>\n",
       "      <td>112006.0</td>\n",
       "      <td>...</td>\n",
       "      <td>70.8</td>\n",
       "      <td>6.5</td>\n",
       "      <td>17446.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>78.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>111202.0</td>\n",
       "      <td>90.5</td>\n",
       "      <td>87.0</td>\n",
       "      <td>2.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4364</th>\n",
       "      <td>2013</td>\n",
       "      <td>51013</td>\n",
       "      <td>Neonatal Abstinance Syndrome</td>\n",
       "      <td>2015</td>\n",
       "      <td>0.9</td>\n",
       "      <td>Arlington, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51013.0</td>\n",
       "      <td>223945.0</td>\n",
       "      <td>112006.0</td>\n",
       "      <td>...</td>\n",
       "      <td>70.8</td>\n",
       "      <td>6.5</td>\n",
       "      <td>17446.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>78.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>111202.0</td>\n",
       "      <td>90.5</td>\n",
       "      <td>87.0</td>\n",
       "      <td>2.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4365</th>\n",
       "      <td>2013</td>\n",
       "      <td>51013</td>\n",
       "      <td>Neonatal Abstinance Syndrome</td>\n",
       "      <td>2015</td>\n",
       "      <td>0.9</td>\n",
       "      <td>Arlington, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51013.0</td>\n",
       "      <td>223945.0</td>\n",
       "      <td>112006.0</td>\n",
       "      <td>...</td>\n",
       "      <td>70.8</td>\n",
       "      <td>6.5</td>\n",
       "      <td>17446.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>78.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>111202.0</td>\n",
       "      <td>90.5</td>\n",
       "      <td>87.0</td>\n",
       "      <td>2.4</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>6306</th>\n",
       "      <td>2013</td>\n",
       "      <td>51800</td>\n",
       "      <td>ED Heroin Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>10.2</td>\n",
       "      <td>Suffolk, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51800.0</td>\n",
       "      <td>86184.0</td>\n",
       "      <td>41511.0</td>\n",
       "      <td>...</td>\n",
       "      <td>71.7</td>\n",
       "      <td>5.7</td>\n",
       "      <td>16102.0</td>\n",
       "      <td>81.7</td>\n",
       "      <td>72.8</td>\n",
       "      <td>5.4</td>\n",
       "      <td>12779.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>80.3</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6307</th>\n",
       "      <td>2013</td>\n",
       "      <td>51800</td>\n",
       "      <td>ED Heroin Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>10.2</td>\n",
       "      <td>Suffolk, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51800.0</td>\n",
       "      <td>86184.0</td>\n",
       "      <td>41511.0</td>\n",
       "      <td>...</td>\n",
       "      <td>71.7</td>\n",
       "      <td>5.7</td>\n",
       "      <td>16102.0</td>\n",
       "      <td>81.7</td>\n",
       "      <td>72.8</td>\n",
       "      <td>5.4</td>\n",
       "      <td>12779.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>80.3</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6308</th>\n",
       "      <td>2013</td>\n",
       "      <td>51800</td>\n",
       "      <td>ED Opioid Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>51.0</td>\n",
       "      <td>Suffolk, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51800.0</td>\n",
       "      <td>86184.0</td>\n",
       "      <td>41511.0</td>\n",
       "      <td>...</td>\n",
       "      <td>71.7</td>\n",
       "      <td>5.7</td>\n",
       "      <td>16102.0</td>\n",
       "      <td>81.7</td>\n",
       "      <td>72.8</td>\n",
       "      <td>5.4</td>\n",
       "      <td>12779.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>80.3</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6309</th>\n",
       "      <td>2013</td>\n",
       "      <td>51800</td>\n",
       "      <td>ED Opioid Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>51.0</td>\n",
       "      <td>Suffolk, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51800.0</td>\n",
       "      <td>86184.0</td>\n",
       "      <td>41511.0</td>\n",
       "      <td>...</td>\n",
       "      <td>71.7</td>\n",
       "      <td>5.7</td>\n",
       "      <td>16102.0</td>\n",
       "      <td>81.7</td>\n",
       "      <td>72.8</td>\n",
       "      <td>5.4</td>\n",
       "      <td>12779.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>80.3</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6310</th>\n",
       "      <td>2013</td>\n",
       "      <td>51800</td>\n",
       "      <td>EMS Narcan</td>\n",
       "      <td>2015</td>\n",
       "      <td>43.1</td>\n",
       "      <td>Suffolk, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51800.0</td>\n",
       "      <td>86184.0</td>\n",
       "      <td>41511.0</td>\n",
       "      <td>...</td>\n",
       "      <td>71.7</td>\n",
       "      <td>5.7</td>\n",
       "      <td>16102.0</td>\n",
       "      <td>81.7</td>\n",
       "      <td>72.8</td>\n",
       "      <td>5.4</td>\n",
       "      <td>12779.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>80.3</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6311</th>\n",
       "      <td>2013</td>\n",
       "      <td>51800</td>\n",
       "      <td>EMS Narcan</td>\n",
       "      <td>2015</td>\n",
       "      <td>43.1</td>\n",
       "      <td>Suffolk, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51800.0</td>\n",
       "      <td>86184.0</td>\n",
       "      <td>41511.0</td>\n",
       "      <td>...</td>\n",
       "      <td>71.7</td>\n",
       "      <td>5.7</td>\n",
       "      <td>16102.0</td>\n",
       "      <td>81.7</td>\n",
       "      <td>72.8</td>\n",
       "      <td>5.4</td>\n",
       "      <td>12779.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>80.3</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6312</th>\n",
       "      <td>2013</td>\n",
       "      <td>51800</td>\n",
       "      <td>Fatal Fentanyl and/or Heroin Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>6.8</td>\n",
       "      <td>Suffolk, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51800.0</td>\n",
       "      <td>86184.0</td>\n",
       "      <td>41511.0</td>\n",
       "      <td>...</td>\n",
       "      <td>71.7</td>\n",
       "      <td>5.7</td>\n",
       "      <td>16102.0</td>\n",
       "      <td>81.7</td>\n",
       "      <td>72.8</td>\n",
       "      <td>5.4</td>\n",
       "      <td>12779.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>80.3</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6313</th>\n",
       "      <td>2013</td>\n",
       "      <td>51800</td>\n",
       "      <td>Fatal Fentanyl and/or Heroin Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>6.8</td>\n",
       "      <td>Suffolk, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51800.0</td>\n",
       "      <td>86184.0</td>\n",
       "      <td>41511.0</td>\n",
       "      <td>...</td>\n",
       "      <td>71.7</td>\n",
       "      <td>5.7</td>\n",
       "      <td>16102.0</td>\n",
       "      <td>81.7</td>\n",
       "      <td>72.8</td>\n",
       "      <td>5.4</td>\n",
       "      <td>12779.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>80.3</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6314</th>\n",
       "      <td>2013</td>\n",
       "      <td>51800</td>\n",
       "      <td>Fatal Prescription Opioid Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>4.5</td>\n",
       "      <td>Suffolk, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51800.0</td>\n",
       "      <td>86184.0</td>\n",
       "      <td>41511.0</td>\n",
       "      <td>...</td>\n",
       "      <td>71.7</td>\n",
       "      <td>5.7</td>\n",
       "      <td>16102.0</td>\n",
       "      <td>81.7</td>\n",
       "      <td>72.8</td>\n",
       "      <td>5.4</td>\n",
       "      <td>12779.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>80.3</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6315</th>\n",
       "      <td>2013</td>\n",
       "      <td>51800</td>\n",
       "      <td>Fatal Prescription Opioid Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>4.5</td>\n",
       "      <td>Suffolk, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51800.0</td>\n",
       "      <td>86184.0</td>\n",
       "      <td>41511.0</td>\n",
       "      <td>...</td>\n",
       "      <td>71.7</td>\n",
       "      <td>5.7</td>\n",
       "      <td>16102.0</td>\n",
       "      <td>81.7</td>\n",
       "      <td>72.8</td>\n",
       "      <td>5.4</td>\n",
       "      <td>12779.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>80.3</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6316</th>\n",
       "      <td>2013</td>\n",
       "      <td>51800</td>\n",
       "      <td>Neonatal Abstinance Syndrome</td>\n",
       "      <td>2015</td>\n",
       "      <td>0.9</td>\n",
       "      <td>Suffolk, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51800.0</td>\n",
       "      <td>86184.0</td>\n",
       "      <td>41511.0</td>\n",
       "      <td>...</td>\n",
       "      <td>71.7</td>\n",
       "      <td>5.7</td>\n",
       "      <td>16102.0</td>\n",
       "      <td>81.7</td>\n",
       "      <td>72.8</td>\n",
       "      <td>5.4</td>\n",
       "      <td>12779.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>80.3</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6317</th>\n",
       "      <td>2013</td>\n",
       "      <td>51800</td>\n",
       "      <td>Neonatal Abstinance Syndrome</td>\n",
       "      <td>2015</td>\n",
       "      <td>0.9</td>\n",
       "      <td>Suffolk, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51800.0</td>\n",
       "      <td>86184.0</td>\n",
       "      <td>41511.0</td>\n",
       "      <td>...</td>\n",
       "      <td>71.7</td>\n",
       "      <td>5.7</td>\n",
       "      <td>16102.0</td>\n",
       "      <td>81.7</td>\n",
       "      <td>72.8</td>\n",
       "      <td>5.4</td>\n",
       "      <td>12779.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>80.3</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6318</th>\n",
       "      <td>2013</td>\n",
       "      <td>51800</td>\n",
       "      <td>Reported Hepatitis C (1830 year olds)</td>\n",
       "      <td>2015</td>\n",
       "      <td>55.7</td>\n",
       "      <td>Suffolk, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51800.0</td>\n",
       "      <td>86184.0</td>\n",
       "      <td>41511.0</td>\n",
       "      <td>...</td>\n",
       "      <td>71.7</td>\n",
       "      <td>5.7</td>\n",
       "      <td>16102.0</td>\n",
       "      <td>81.7</td>\n",
       "      <td>72.8</td>\n",
       "      <td>5.4</td>\n",
       "      <td>12779.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>80.3</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6319</th>\n",
       "      <td>2013</td>\n",
       "      <td>51800</td>\n",
       "      <td>Reported Hepatitis C (1830 year olds)</td>\n",
       "      <td>2015</td>\n",
       "      <td>55.7</td>\n",
       "      <td>Suffolk, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51800.0</td>\n",
       "      <td>86184.0</td>\n",
       "      <td>41511.0</td>\n",
       "      <td>...</td>\n",
       "      <td>71.7</td>\n",
       "      <td>5.7</td>\n",
       "      <td>16102.0</td>\n",
       "      <td>81.7</td>\n",
       "      <td>72.8</td>\n",
       "      <td>5.4</td>\n",
       "      <td>12779.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>80.3</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6320</th>\n",
       "      <td>2013</td>\n",
       "      <td>51810</td>\n",
       "      <td>Diagnosed HIV</td>\n",
       "      <td>2015</td>\n",
       "      <td>15.0</td>\n",
       "      <td>Virginia Beach, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51810.0</td>\n",
       "      <td>448290.0</td>\n",
       "      <td>220275.0</td>\n",
       "      <td>...</td>\n",
       "      <td>69.7</td>\n",
       "      <td>5.5</td>\n",
       "      <td>95586.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>71.1</td>\n",
       "      <td>6.1</td>\n",
       "      <td>84735.0</td>\n",
       "      <td>86.5</td>\n",
       "      <td>78.1</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6321</th>\n",
       "      <td>2013</td>\n",
       "      <td>51810</td>\n",
       "      <td>Diagnosed HIV</td>\n",
       "      <td>2015</td>\n",
       "      <td>15.0</td>\n",
       "      <td>Virginia Beach, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51810.0</td>\n",
       "      <td>448290.0</td>\n",
       "      <td>220275.0</td>\n",
       "      <td>...</td>\n",
       "      <td>69.7</td>\n",
       "      <td>5.5</td>\n",
       "      <td>95586.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>71.1</td>\n",
       "      <td>6.1</td>\n",
       "      <td>84735.0</td>\n",
       "      <td>86.5</td>\n",
       "      <td>78.1</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6322</th>\n",
       "      <td>2013</td>\n",
       "      <td>51810</td>\n",
       "      <td>ED Heroin Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>15.2</td>\n",
       "      <td>Virginia Beach, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51810.0</td>\n",
       "      <td>448290.0</td>\n",
       "      <td>220275.0</td>\n",
       "      <td>...</td>\n",
       "      <td>69.7</td>\n",
       "      <td>5.5</td>\n",
       "      <td>95586.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>71.1</td>\n",
       "      <td>6.1</td>\n",
       "      <td>84735.0</td>\n",
       "      <td>86.5</td>\n",
       "      <td>78.1</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6323</th>\n",
       "      <td>2013</td>\n",
       "      <td>51810</td>\n",
       "      <td>ED Heroin Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>15.2</td>\n",
       "      <td>Virginia Beach, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51810.0</td>\n",
       "      <td>448290.0</td>\n",
       "      <td>220275.0</td>\n",
       "      <td>...</td>\n",
       "      <td>69.7</td>\n",
       "      <td>5.5</td>\n",
       "      <td>95586.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>71.1</td>\n",
       "      <td>6.1</td>\n",
       "      <td>84735.0</td>\n",
       "      <td>86.5</td>\n",
       "      <td>78.1</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6324</th>\n",
       "      <td>2013</td>\n",
       "      <td>51810</td>\n",
       "      <td>ED Opioid Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>61.0</td>\n",
       "      <td>Virginia Beach, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51810.0</td>\n",
       "      <td>448290.0</td>\n",
       "      <td>220275.0</td>\n",
       "      <td>...</td>\n",
       "      <td>69.7</td>\n",
       "      <td>5.5</td>\n",
       "      <td>95586.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>71.1</td>\n",
       "      <td>6.1</td>\n",
       "      <td>84735.0</td>\n",
       "      <td>86.5</td>\n",
       "      <td>78.1</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6325</th>\n",
       "      <td>2013</td>\n",
       "      <td>51810</td>\n",
       "      <td>ED Opioid Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>61.0</td>\n",
       "      <td>Virginia Beach, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51810.0</td>\n",
       "      <td>448290.0</td>\n",
       "      <td>220275.0</td>\n",
       "      <td>...</td>\n",
       "      <td>69.7</td>\n",
       "      <td>5.5</td>\n",
       "      <td>95586.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>71.1</td>\n",
       "      <td>6.1</td>\n",
       "      <td>84735.0</td>\n",
       "      <td>86.5</td>\n",
       "      <td>78.1</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6326</th>\n",
       "      <td>2013</td>\n",
       "      <td>51810</td>\n",
       "      <td>EMS Narcan</td>\n",
       "      <td>2015</td>\n",
       "      <td>31.4</td>\n",
       "      <td>Virginia Beach, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51810.0</td>\n",
       "      <td>448290.0</td>\n",
       "      <td>220275.0</td>\n",
       "      <td>...</td>\n",
       "      <td>69.7</td>\n",
       "      <td>5.5</td>\n",
       "      <td>95586.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>71.1</td>\n",
       "      <td>6.1</td>\n",
       "      <td>84735.0</td>\n",
       "      <td>86.5</td>\n",
       "      <td>78.1</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6327</th>\n",
       "      <td>2013</td>\n",
       "      <td>51810</td>\n",
       "      <td>EMS Narcan</td>\n",
       "      <td>2015</td>\n",
       "      <td>31.4</td>\n",
       "      <td>Virginia Beach, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51810.0</td>\n",
       "      <td>448290.0</td>\n",
       "      <td>220275.0</td>\n",
       "      <td>...</td>\n",
       "      <td>69.7</td>\n",
       "      <td>5.5</td>\n",
       "      <td>95586.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>71.1</td>\n",
       "      <td>6.1</td>\n",
       "      <td>84735.0</td>\n",
       "      <td>86.5</td>\n",
       "      <td>78.1</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6328</th>\n",
       "      <td>2013</td>\n",
       "      <td>51810</td>\n",
       "      <td>Fatal Fentanyl and/or Heroin Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>7.5</td>\n",
       "      <td>Virginia Beach, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51810.0</td>\n",
       "      <td>448290.0</td>\n",
       "      <td>220275.0</td>\n",
       "      <td>...</td>\n",
       "      <td>69.7</td>\n",
       "      <td>5.5</td>\n",
       "      <td>95586.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>71.1</td>\n",
       "      <td>6.1</td>\n",
       "      <td>84735.0</td>\n",
       "      <td>86.5</td>\n",
       "      <td>78.1</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6329</th>\n",
       "      <td>2013</td>\n",
       "      <td>51810</td>\n",
       "      <td>Fatal Fentanyl and/or Heroin Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>7.5</td>\n",
       "      <td>Virginia Beach, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51810.0</td>\n",
       "      <td>448290.0</td>\n",
       "      <td>220275.0</td>\n",
       "      <td>...</td>\n",
       "      <td>69.7</td>\n",
       "      <td>5.5</td>\n",
       "      <td>95586.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>71.1</td>\n",
       "      <td>6.1</td>\n",
       "      <td>84735.0</td>\n",
       "      <td>86.5</td>\n",
       "      <td>78.1</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6330</th>\n",
       "      <td>2013</td>\n",
       "      <td>51810</td>\n",
       "      <td>Fatal Prescription Opioid Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>5.1</td>\n",
       "      <td>Virginia Beach, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51810.0</td>\n",
       "      <td>448290.0</td>\n",
       "      <td>220275.0</td>\n",
       "      <td>...</td>\n",
       "      <td>69.7</td>\n",
       "      <td>5.5</td>\n",
       "      <td>95586.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>71.1</td>\n",
       "      <td>6.1</td>\n",
       "      <td>84735.0</td>\n",
       "      <td>86.5</td>\n",
       "      <td>78.1</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6331</th>\n",
       "      <td>2013</td>\n",
       "      <td>51810</td>\n",
       "      <td>Fatal Prescription Opioid Overdose</td>\n",
       "      <td>2015</td>\n",
       "      <td>5.1</td>\n",
       "      <td>Virginia Beach, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51810.0</td>\n",
       "      <td>448290.0</td>\n",
       "      <td>220275.0</td>\n",
       "      <td>...</td>\n",
       "      <td>69.7</td>\n",
       "      <td>5.5</td>\n",
       "      <td>95586.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>71.1</td>\n",
       "      <td>6.1</td>\n",
       "      <td>84735.0</td>\n",
       "      <td>86.5</td>\n",
       "      <td>78.1</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6332</th>\n",
       "      <td>2013</td>\n",
       "      <td>51810</td>\n",
       "      <td>Neonatal Abstinance Syndrome</td>\n",
       "      <td>2015</td>\n",
       "      <td>3.6</td>\n",
       "      <td>Virginia Beach, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51810.0</td>\n",
       "      <td>448290.0</td>\n",
       "      <td>220275.0</td>\n",
       "      <td>...</td>\n",
       "      <td>69.7</td>\n",
       "      <td>5.5</td>\n",
       "      <td>95586.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>71.1</td>\n",
       "      <td>6.1</td>\n",
       "      <td>84735.0</td>\n",
       "      <td>86.5</td>\n",
       "      <td>78.1</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6333</th>\n",
       "      <td>2013</td>\n",
       "      <td>51810</td>\n",
       "      <td>Neonatal Abstinance Syndrome</td>\n",
       "      <td>2015</td>\n",
       "      <td>3.6</td>\n",
       "      <td>Virginia Beach, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51810.0</td>\n",
       "      <td>448290.0</td>\n",
       "      <td>220275.0</td>\n",
       "      <td>...</td>\n",
       "      <td>69.7</td>\n",
       "      <td>5.5</td>\n",
       "      <td>95586.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>71.1</td>\n",
       "      <td>6.1</td>\n",
       "      <td>84735.0</td>\n",
       "      <td>86.5</td>\n",
       "      <td>78.1</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6334</th>\n",
       "      <td>2013</td>\n",
       "      <td>51810</td>\n",
       "      <td>Reported Hepatitis C (1830 year olds)</td>\n",
       "      <td>2015</td>\n",
       "      <td>42.7</td>\n",
       "      <td>Virginia Beach, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51810.0</td>\n",
       "      <td>448290.0</td>\n",
       "      <td>220275.0</td>\n",
       "      <td>...</td>\n",
       "      <td>69.7</td>\n",
       "      <td>5.5</td>\n",
       "      <td>95586.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>71.1</td>\n",
       "      <td>6.1</td>\n",
       "      <td>84735.0</td>\n",
       "      <td>86.5</td>\n",
       "      <td>78.1</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6335</th>\n",
       "      <td>2013</td>\n",
       "      <td>51810</td>\n",
       "      <td>Reported Hepatitis C (1830 year olds)</td>\n",
       "      <td>2015</td>\n",
       "      <td>42.7</td>\n",
       "      <td>Virginia Beach, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>51810.0</td>\n",
       "      <td>448290.0</td>\n",
       "      <td>220275.0</td>\n",
       "      <td>...</td>\n",
       "      <td>69.7</td>\n",
       "      <td>5.5</td>\n",
       "      <td>95586.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>71.1</td>\n",
       "      <td>6.1</td>\n",
       "      <td>84735.0</td>\n",
       "      <td>86.5</td>\n",
       "      <td>78.1</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>448 rows × 1667 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Year_x  FIPS Code                                   Type  Year_y  \\\n",
       "4272    2013      51003                          Diagnosed HIV    2015   \n",
       "4273    2013      51003                          Diagnosed HIV    2015   \n",
       "4274    2013      51003                     ED Heroin Overdose    2015   \n",
       "4275    2013      51003                     ED Heroin Overdose    2015   \n",
       "4276    2013      51003                     ED Opioid Overdose    2015   \n",
       "4277    2013      51003                     ED Opioid Overdose    2015   \n",
       "4278    2013      51003                             EMS Narcan    2015   \n",
       "4279    2013      51003                             EMS Narcan    2015   \n",
       "4280    2013      51003  Fatal Fentanyl and/or Heroin Overdose    2015   \n",
       "4281    2013      51003  Fatal Fentanyl and/or Heroin Overdose    2015   \n",
       "4282    2013      51003     Fatal Prescription Opioid Overdose    2015   \n",
       "4283    2013      51003     Fatal Prescription Opioid Overdose    2015   \n",
       "4284    2013      51003           Neonatal Abstinance Syndrome    2015   \n",
       "4285    2013      51003           Neonatal Abstinance Syndrome    2015   \n",
       "4286    2013      51003  Reported Hepatitis C (1830 year olds)    2015   \n",
       "4287    2013      51003  Reported Hepatitis C (1830 year olds)    2015   \n",
       "4352    2013      51013                          Diagnosed HIV    2015   \n",
       "4353    2013      51013                          Diagnosed HIV    2015   \n",
       "4354    2013      51013                     ED Heroin Overdose    2015   \n",
       "4355    2013      51013                     ED Heroin Overdose    2015   \n",
       "4356    2013      51013                     ED Opioid Overdose    2015   \n",
       "4357    2013      51013                     ED Opioid Overdose    2015   \n",
       "4358    2013      51013                             EMS Narcan    2015   \n",
       "4359    2013      51013                             EMS Narcan    2015   \n",
       "4360    2013      51013  Fatal Fentanyl and/or Heroin Overdose    2015   \n",
       "4361    2013      51013  Fatal Fentanyl and/or Heroin Overdose    2015   \n",
       "4362    2013      51013     Fatal Prescription Opioid Overdose    2015   \n",
       "4363    2013      51013     Fatal Prescription Opioid Overdose    2015   \n",
       "4364    2013      51013           Neonatal Abstinance Syndrome    2015   \n",
       "4365    2013      51013           Neonatal Abstinance Syndrome    2015   \n",
       "...      ...        ...                                    ...     ...   \n",
       "6306    2013      51800                     ED Heroin Overdose    2015   \n",
       "6307    2013      51800                     ED Heroin Overdose    2015   \n",
       "6308    2013      51800                     ED Opioid Overdose    2015   \n",
       "6309    2013      51800                     ED Opioid Overdose    2015   \n",
       "6310    2013      51800                             EMS Narcan    2015   \n",
       "6311    2013      51800                             EMS Narcan    2015   \n",
       "6312    2013      51800  Fatal Fentanyl and/or Heroin Overdose    2015   \n",
       "6313    2013      51800  Fatal Fentanyl and/or Heroin Overdose    2015   \n",
       "6314    2013      51800     Fatal Prescription Opioid Overdose    2015   \n",
       "6315    2013      51800     Fatal Prescription Opioid Overdose    2015   \n",
       "6316    2013      51800           Neonatal Abstinance Syndrome    2015   \n",
       "6317    2013      51800           Neonatal Abstinance Syndrome    2015   \n",
       "6318    2013      51800  Reported Hepatitis C (1830 year olds)    2015   \n",
       "6319    2013      51800  Reported Hepatitis C (1830 year olds)    2015   \n",
       "6320    2013      51810                          Diagnosed HIV    2015   \n",
       "6321    2013      51810                          Diagnosed HIV    2015   \n",
       "6322    2013      51810                     ED Heroin Overdose    2015   \n",
       "6323    2013      51810                     ED Heroin Overdose    2015   \n",
       "6324    2013      51810                     ED Opioid Overdose    2015   \n",
       "6325    2013      51810                     ED Opioid Overdose    2015   \n",
       "6326    2013      51810                             EMS Narcan    2015   \n",
       "6327    2013      51810                             EMS Narcan    2015   \n",
       "6328    2013      51810  Fatal Fentanyl and/or Heroin Overdose    2015   \n",
       "6329    2013      51810  Fatal Fentanyl and/or Heroin Overdose    2015   \n",
       "6330    2013      51810     Fatal Prescription Opioid Overdose    2015   \n",
       "6331    2013      51810     Fatal Prescription Opioid Overdose    2015   \n",
       "6332    2013      51810           Neonatal Abstinance Syndrome    2015   \n",
       "6333    2013      51810           Neonatal Abstinance Syndrome    2015   \n",
       "6334    2013      51810  Reported Hepatitis C (1830 year olds)    2015   \n",
       "6335    2013      51810  Reported Hepatitis C (1830 year olds)    2015   \n",
       "\n",
       "      Rate_x              County State  FIPS County Code  \\\n",
       "4272     4.7       Albemarle, VA    VA           51003.0   \n",
       "4273     4.7       Albemarle, VA    VA           51003.0   \n",
       "4274    11.4       Albemarle, VA    VA           51003.0   \n",
       "4275    11.4       Albemarle, VA    VA           51003.0   \n",
       "4276    71.9       Albemarle, VA    VA           51003.0   \n",
       "4277    71.9       Albemarle, VA    VA           51003.0   \n",
       "4278    15.1       Albemarle, VA    VA           51003.0   \n",
       "4279    15.1       Albemarle, VA    VA           51003.0   \n",
       "4280     0.9       Albemarle, VA    VA           51003.0   \n",
       "4281     0.9       Albemarle, VA    VA           51003.0   \n",
       "4282     1.9       Albemarle, VA    VA           51003.0   \n",
       "4283     1.9       Albemarle, VA    VA           51003.0   \n",
       "4284     0.0       Albemarle, VA    VA           51003.0   \n",
       "4285     0.0       Albemarle, VA    VA           51003.0   \n",
       "4286    18.9       Albemarle, VA    VA           51003.0   \n",
       "4287    18.9       Albemarle, VA    VA           51003.0   \n",
       "4352    14.8       Arlington, VA    VA           51013.0   \n",
       "4353    14.8       Arlington, VA    VA           51013.0   \n",
       "4354     1.7       Arlington, VA    VA           51013.0   \n",
       "4355     1.7       Arlington, VA    VA           51013.0   \n",
       "4356    46.3       Arlington, VA    VA           51013.0   \n",
       "4357    46.3       Arlington, VA    VA           51013.0   \n",
       "4358    15.7       Arlington, VA    VA           51013.0   \n",
       "4359    15.7       Arlington, VA    VA           51013.0   \n",
       "4360     1.7       Arlington, VA    VA           51013.0   \n",
       "4361     1.7       Arlington, VA    VA           51013.0   \n",
       "4362     3.9       Arlington, VA    VA           51013.0   \n",
       "4363     3.9       Arlington, VA    VA           51013.0   \n",
       "4364     0.9       Arlington, VA    VA           51013.0   \n",
       "4365     0.9       Arlington, VA    VA           51013.0   \n",
       "...      ...                 ...   ...               ...   \n",
       "6306    10.2         Suffolk, VA    VA           51800.0   \n",
       "6307    10.2         Suffolk, VA    VA           51800.0   \n",
       "6308    51.0         Suffolk, VA    VA           51800.0   \n",
       "6309    51.0         Suffolk, VA    VA           51800.0   \n",
       "6310    43.1         Suffolk, VA    VA           51800.0   \n",
       "6311    43.1         Suffolk, VA    VA           51800.0   \n",
       "6312     6.8         Suffolk, VA    VA           51800.0   \n",
       "6313     6.8         Suffolk, VA    VA           51800.0   \n",
       "6314     4.5         Suffolk, VA    VA           51800.0   \n",
       "6315     4.5         Suffolk, VA    VA           51800.0   \n",
       "6316     0.9         Suffolk, VA    VA           51800.0   \n",
       "6317     0.9         Suffolk, VA    VA           51800.0   \n",
       "6318    55.7         Suffolk, VA    VA           51800.0   \n",
       "6319    55.7         Suffolk, VA    VA           51800.0   \n",
       "6320    15.0  Virginia Beach, VA    VA           51810.0   \n",
       "6321    15.0  Virginia Beach, VA    VA           51810.0   \n",
       "6322    15.2  Virginia Beach, VA    VA           51810.0   \n",
       "6323    15.2  Virginia Beach, VA    VA           51810.0   \n",
       "6324    61.0  Virginia Beach, VA    VA           51810.0   \n",
       "6325    61.0  Virginia Beach, VA    VA           51810.0   \n",
       "6326    31.4  Virginia Beach, VA    VA           51810.0   \n",
       "6327    31.4  Virginia Beach, VA    VA           51810.0   \n",
       "6328     7.5  Virginia Beach, VA    VA           51810.0   \n",
       "6329     7.5  Virginia Beach, VA    VA           51810.0   \n",
       "6330     5.1  Virginia Beach, VA    VA           51810.0   \n",
       "6331     5.1  Virginia Beach, VA    VA           51810.0   \n",
       "6332     3.6  Virginia Beach, VA    VA           51810.0   \n",
       "6333     3.6  Virginia Beach, VA    VA           51810.0   \n",
       "6334    42.7  Virginia Beach, VA    VA           51810.0   \n",
       "6335    42.7  Virginia Beach, VA    VA           51810.0   \n",
       "\n",
       "      Total; Estimate; Total population  Male; Estimate; Total population  \\\n",
       "4272                           103108.0                           49365.0   \n",
       "4273                           103108.0                           49365.0   \n",
       "4274                           103108.0                           49365.0   \n",
       "4275                           103108.0                           49365.0   \n",
       "4276                           103108.0                           49365.0   \n",
       "4277                           103108.0                           49365.0   \n",
       "4278                           103108.0                           49365.0   \n",
       "4279                           103108.0                           49365.0   \n",
       "4280                           103108.0                           49365.0   \n",
       "4281                           103108.0                           49365.0   \n",
       "4282                           103108.0                           49365.0   \n",
       "4283                           103108.0                           49365.0   \n",
       "4284                           103108.0                           49365.0   \n",
       "4285                           103108.0                           49365.0   \n",
       "4286                           103108.0                           49365.0   \n",
       "4287                           103108.0                           49365.0   \n",
       "4352                           223945.0                          112006.0   \n",
       "4353                           223945.0                          112006.0   \n",
       "4354                           223945.0                          112006.0   \n",
       "4355                           223945.0                          112006.0   \n",
       "4356                           223945.0                          112006.0   \n",
       "4357                           223945.0                          112006.0   \n",
       "4358                           223945.0                          112006.0   \n",
       "4359                           223945.0                          112006.0   \n",
       "4360                           223945.0                          112006.0   \n",
       "4361                           223945.0                          112006.0   \n",
       "4362                           223945.0                          112006.0   \n",
       "4363                           223945.0                          112006.0   \n",
       "4364                           223945.0                          112006.0   \n",
       "4365                           223945.0                          112006.0   \n",
       "...                                 ...                               ...   \n",
       "6306                            86184.0                           41511.0   \n",
       "6307                            86184.0                           41511.0   \n",
       "6308                            86184.0                           41511.0   \n",
       "6309                            86184.0                           41511.0   \n",
       "6310                            86184.0                           41511.0   \n",
       "6311                            86184.0                           41511.0   \n",
       "6312                            86184.0                           41511.0   \n",
       "6313                            86184.0                           41511.0   \n",
       "6314                            86184.0                           41511.0   \n",
       "6315                            86184.0                           41511.0   \n",
       "6316                            86184.0                           41511.0   \n",
       "6317                            86184.0                           41511.0   \n",
       "6318                            86184.0                           41511.0   \n",
       "6319                            86184.0                           41511.0   \n",
       "6320                           448290.0                          220275.0   \n",
       "6321                           448290.0                          220275.0   \n",
       "6322                           448290.0                          220275.0   \n",
       "6323                           448290.0                          220275.0   \n",
       "6324                           448290.0                          220275.0   \n",
       "6325                           448290.0                          220275.0   \n",
       "6326                           448290.0                          220275.0   \n",
       "6327                           448290.0                          220275.0   \n",
       "6328                           448290.0                          220275.0   \n",
       "6329                           448290.0                          220275.0   \n",
       "6330                           448290.0                          220275.0   \n",
       "6331                           448290.0                          220275.0   \n",
       "6332                           448290.0                          220275.0   \n",
       "6333                           448290.0                          220275.0   \n",
       "6334                           448290.0                          220275.0   \n",
       "6335                           448290.0                          220275.0   \n",
       "\n",
       "                                                          ...                                                        \\\n",
       "4272                                                      ...                                                         \n",
       "4273                                                      ...                                                         \n",
       "4274                                                      ...                                                         \n",
       "4275                                                      ...                                                         \n",
       "4276                                                      ...                                                         \n",
       "4277                                                      ...                                                         \n",
       "4278                                                      ...                                                         \n",
       "4279                                                      ...                                                         \n",
       "4280                                                      ...                                                         \n",
       "4281                                                      ...                                                         \n",
       "4282                                                      ...                                                         \n",
       "4283                                                      ...                                                         \n",
       "4284                                                      ...                                                         \n",
       "4285                                                      ...                                                         \n",
       "4286                                                      ...                                                         \n",
       "4287                                                      ...                                                         \n",
       "4352                                                      ...                                                         \n",
       "4353                                                      ...                                                         \n",
       "4354                                                      ...                                                         \n",
       "4355                                                      ...                                                         \n",
       "4356                                                      ...                                                         \n",
       "4357                                                      ...                                                         \n",
       "4358                                                      ...                                                         \n",
       "4359                                                      ...                                                         \n",
       "4360                                                      ...                                                         \n",
       "4361                                                      ...                                                         \n",
       "4362                                                      ...                                                         \n",
       "4363                                                      ...                                                         \n",
       "4364                                                      ...                                                         \n",
       "4365                                                      ...                                                         \n",
       "...                                                       ...                                                         \n",
       "6306                                                      ...                                                         \n",
       "6307                                                      ...                                                         \n",
       "6308                                                      ...                                                         \n",
       "6309                                                      ...                                                         \n",
       "6310                                                      ...                                                         \n",
       "6311                                                      ...                                                         \n",
       "6312                                                      ...                                                         \n",
       "6313                                                      ...                                                         \n",
       "6314                                                      ...                                                         \n",
       "6315                                                      ...                                                         \n",
       "6316                                                      ...                                                         \n",
       "6317                                                      ...                                                         \n",
       "6318                                                      ...                                                         \n",
       "6319                                                      ...                                                         \n",
       "6320                                                      ...                                                         \n",
       "6321                                                      ...                                                         \n",
       "6322                                                      ...                                                         \n",
       "6323                                                      ...                                                         \n",
       "6324                                                      ...                                                         \n",
       "6325                                                      ...                                                         \n",
       "6326                                                      ...                                                         \n",
       "6327                                                      ...                                                         \n",
       "6328                                                      ...                                                         \n",
       "6329                                                      ...                                                         \n",
       "6330                                                      ...                                                         \n",
       "6331                                                      ...                                                         \n",
       "6332                                                      ...                                                         \n",
       "6333                                                      ...                                                         \n",
       "6334                                                      ...                                                         \n",
       "6335                                                      ...                                                         \n",
       "\n",
       "      Employment/Population Ratio; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - High school graduate (includes equivalency)  \\\n",
       "4272                                               74.3                                                                                         \n",
       "4273                                               74.3                                                                                         \n",
       "4274                                               74.3                                                                                         \n",
       "4275                                               74.3                                                                                         \n",
       "4276                                               74.3                                                                                         \n",
       "4277                                               74.3                                                                                         \n",
       "4278                                               74.3                                                                                         \n",
       "4279                                               74.3                                                                                         \n",
       "4280                                               74.3                                                                                         \n",
       "4281                                               74.3                                                                                         \n",
       "4282                                               74.3                                                                                         \n",
       "4283                                               74.3                                                                                         \n",
       "4284                                               74.3                                                                                         \n",
       "4285                                               74.3                                                                                         \n",
       "4286                                               74.3                                                                                         \n",
       "4287                                               74.3                                                                                         \n",
       "4352                                               70.8                                                                                         \n",
       "4353                                               70.8                                                                                         \n",
       "4354                                               70.8                                                                                         \n",
       "4355                                               70.8                                                                                         \n",
       "4356                                               70.8                                                                                         \n",
       "4357                                               70.8                                                                                         \n",
       "4358                                               70.8                                                                                         \n",
       "4359                                               70.8                                                                                         \n",
       "4360                                               70.8                                                                                         \n",
       "4361                                               70.8                                                                                         \n",
       "4362                                               70.8                                                                                         \n",
       "4363                                               70.8                                                                                         \n",
       "4364                                               70.8                                                                                         \n",
       "4365                                               70.8                                                                                         \n",
       "...                                                 ...                                                                                         \n",
       "6306                                               71.7                                                                                         \n",
       "6307                                               71.7                                                                                         \n",
       "6308                                               71.7                                                                                         \n",
       "6309                                               71.7                                                                                         \n",
       "6310                                               71.7                                                                                         \n",
       "6311                                               71.7                                                                                         \n",
       "6312                                               71.7                                                                                         \n",
       "6313                                               71.7                                                                                         \n",
       "6314                                               71.7                                                                                         \n",
       "6315                                               71.7                                                                                         \n",
       "6316                                               71.7                                                                                         \n",
       "6317                                               71.7                                                                                         \n",
       "6318                                               71.7                                                                                         \n",
       "6319                                               71.7                                                                                         \n",
       "6320                                               69.7                                                                                         \n",
       "6321                                               69.7                                                                                         \n",
       "6322                                               69.7                                                                                         \n",
       "6323                                               69.7                                                                                         \n",
       "6324                                               69.7                                                                                         \n",
       "6325                                               69.7                                                                                         \n",
       "6326                                               69.7                                                                                         \n",
       "6327                                               69.7                                                                                         \n",
       "6328                                               69.7                                                                                         \n",
       "6329                                               69.7                                                                                         \n",
       "6330                                               69.7                                                                                         \n",
       "6331                                               69.7                                                                                         \n",
       "6332                                               69.7                                                                                         \n",
       "6333                                               69.7                                                                                         \n",
       "6334                                               69.7                                                                                         \n",
       "6335                                               69.7                                                                                         \n",
       "\n",
       "      Unemployment rate; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - High school graduate (includes equivalency)  \\\n",
       "4272                                                3.3                                                                               \n",
       "4273                                                3.3                                                                               \n",
       "4274                                                3.3                                                                               \n",
       "4275                                                3.3                                                                               \n",
       "4276                                                3.3                                                                               \n",
       "4277                                                3.3                                                                               \n",
       "4278                                                3.3                                                                               \n",
       "4279                                                3.3                                                                               \n",
       "4280                                                3.3                                                                               \n",
       "4281                                                3.3                                                                               \n",
       "4282                                                3.3                                                                               \n",
       "4283                                                3.3                                                                               \n",
       "4284                                                3.3                                                                               \n",
       "4285                                                3.3                                                                               \n",
       "4286                                                3.3                                                                               \n",
       "4287                                                3.3                                                                               \n",
       "4352                                                6.5                                                                               \n",
       "4353                                                6.5                                                                               \n",
       "4354                                                6.5                                                                               \n",
       "4355                                                6.5                                                                               \n",
       "4356                                                6.5                                                                               \n",
       "4357                                                6.5                                                                               \n",
       "4358                                                6.5                                                                               \n",
       "4359                                                6.5                                                                               \n",
       "4360                                                6.5                                                                               \n",
       "4361                                                6.5                                                                               \n",
       "4362                                                6.5                                                                               \n",
       "4363                                                6.5                                                                               \n",
       "4364                                                6.5                                                                               \n",
       "4365                                                6.5                                                                               \n",
       "...                                                 ...                                                                               \n",
       "6306                                                5.7                                                                               \n",
       "6307                                                5.7                                                                               \n",
       "6308                                                5.7                                                                               \n",
       "6309                                                5.7                                                                               \n",
       "6310                                                5.7                                                                               \n",
       "6311                                                5.7                                                                               \n",
       "6312                                                5.7                                                                               \n",
       "6313                                                5.7                                                                               \n",
       "6314                                                5.7                                                                               \n",
       "6315                                                5.7                                                                               \n",
       "6316                                                5.7                                                                               \n",
       "6317                                                5.7                                                                               \n",
       "6318                                                5.7                                                                               \n",
       "6319                                                5.7                                                                               \n",
       "6320                                                5.5                                                                               \n",
       "6321                                                5.5                                                                               \n",
       "6322                                                5.5                                                                               \n",
       "6323                                                5.5                                                                               \n",
       "6324                                                5.5                                                                               \n",
       "6325                                                5.5                                                                               \n",
       "6326                                                5.5                                                                               \n",
       "6327                                                5.5                                                                               \n",
       "6328                                                5.5                                                                               \n",
       "6329                                                5.5                                                                               \n",
       "6330                                                5.5                                                                               \n",
       "6331                                                5.5                                                                               \n",
       "6332                                                5.5                                                                               \n",
       "6333                                                5.5                                                                               \n",
       "6334                                                5.5                                                                               \n",
       "6335                                                5.5                                                                               \n",
       "\n",
       "      Total; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Some college or associate's degree  \\\n",
       "4272                                            11388.0                                                          \n",
       "4273                                            11388.0                                                          \n",
       "4274                                            11388.0                                                          \n",
       "4275                                            11388.0                                                          \n",
       "4276                                            11388.0                                                          \n",
       "4277                                            11388.0                                                          \n",
       "4278                                            11388.0                                                          \n",
       "4279                                            11388.0                                                          \n",
       "4280                                            11388.0                                                          \n",
       "4281                                            11388.0                                                          \n",
       "4282                                            11388.0                                                          \n",
       "4283                                            11388.0                                                          \n",
       "4284                                            11388.0                                                          \n",
       "4285                                            11388.0                                                          \n",
       "4286                                            11388.0                                                          \n",
       "4287                                            11388.0                                                          \n",
       "4352                                            17446.0                                                          \n",
       "4353                                            17446.0                                                          \n",
       "4354                                            17446.0                                                          \n",
       "4355                                            17446.0                                                          \n",
       "4356                                            17446.0                                                          \n",
       "4357                                            17446.0                                                          \n",
       "4358                                            17446.0                                                          \n",
       "4359                                            17446.0                                                          \n",
       "4360                                            17446.0                                                          \n",
       "4361                                            17446.0                                                          \n",
       "4362                                            17446.0                                                          \n",
       "4363                                            17446.0                                                          \n",
       "4364                                            17446.0                                                          \n",
       "4365                                            17446.0                                                          \n",
       "...                                                 ...                                                          \n",
       "6306                                            16102.0                                                          \n",
       "6307                                            16102.0                                                          \n",
       "6308                                            16102.0                                                          \n",
       "6309                                            16102.0                                                          \n",
       "6310                                            16102.0                                                          \n",
       "6311                                            16102.0                                                          \n",
       "6312                                            16102.0                                                          \n",
       "6313                                            16102.0                                                          \n",
       "6314                                            16102.0                                                          \n",
       "6315                                            16102.0                                                          \n",
       "6316                                            16102.0                                                          \n",
       "6317                                            16102.0                                                          \n",
       "6318                                            16102.0                                                          \n",
       "6319                                            16102.0                                                          \n",
       "6320                                            95586.0                                                          \n",
       "6321                                            95586.0                                                          \n",
       "6322                                            95586.0                                                          \n",
       "6323                                            95586.0                                                          \n",
       "6324                                            95586.0                                                          \n",
       "6325                                            95586.0                                                          \n",
       "6326                                            95586.0                                                          \n",
       "6327                                            95586.0                                                          \n",
       "6328                                            95586.0                                                          \n",
       "6329                                            95586.0                                                          \n",
       "6330                                            95586.0                                                          \n",
       "6331                                            95586.0                                                          \n",
       "6332                                            95586.0                                                          \n",
       "6333                                            95586.0                                                          \n",
       "6334                                            95586.0                                                          \n",
       "6335                                            95586.0                                                          \n",
       "\n",
       "      Labor Force Participation Rate; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Some college or associate's degree  \\\n",
       "4272                                               79.3                                                                                   \n",
       "4273                                               79.3                                                                                   \n",
       "4274                                               79.3                                                                                   \n",
       "4275                                               79.3                                                                                   \n",
       "4276                                               79.3                                                                                   \n",
       "4277                                               79.3                                                                                   \n",
       "4278                                               79.3                                                                                   \n",
       "4279                                               79.3                                                                                   \n",
       "4280                                               79.3                                                                                   \n",
       "4281                                               79.3                                                                                   \n",
       "4282                                               79.3                                                                                   \n",
       "4283                                               79.3                                                                                   \n",
       "4284                                               79.3                                                                                   \n",
       "4285                                               79.3                                                                                   \n",
       "4286                                               79.3                                                                                   \n",
       "4287                                               79.3                                                                                   \n",
       "4352                                               83.2                                                                                   \n",
       "4353                                               83.2                                                                                   \n",
       "4354                                               83.2                                                                                   \n",
       "4355                                               83.2                                                                                   \n",
       "4356                                               83.2                                                                                   \n",
       "4357                                               83.2                                                                                   \n",
       "4358                                               83.2                                                                                   \n",
       "4359                                               83.2                                                                                   \n",
       "4360                                               83.2                                                                                   \n",
       "4361                                               83.2                                                                                   \n",
       "4362                                               83.2                                                                                   \n",
       "4363                                               83.2                                                                                   \n",
       "4364                                               83.2                                                                                   \n",
       "4365                                               83.2                                                                                   \n",
       "...                                                 ...                                                                                   \n",
       "6306                                               81.7                                                                                   \n",
       "6307                                               81.7                                                                                   \n",
       "6308                                               81.7                                                                                   \n",
       "6309                                               81.7                                                                                   \n",
       "6310                                               81.7                                                                                   \n",
       "6311                                               81.7                                                                                   \n",
       "6312                                               81.7                                                                                   \n",
       "6313                                               81.7                                                                                   \n",
       "6314                                               81.7                                                                                   \n",
       "6315                                               81.7                                                                                   \n",
       "6316                                               81.7                                                                                   \n",
       "6317                                               81.7                                                                                   \n",
       "6318                                               81.7                                                                                   \n",
       "6319                                               81.7                                                                                   \n",
       "6320                                               83.2                                                                                   \n",
       "6321                                               83.2                                                                                   \n",
       "6322                                               83.2                                                                                   \n",
       "6323                                               83.2                                                                                   \n",
       "6324                                               83.2                                                                                   \n",
       "6325                                               83.2                                                                                   \n",
       "6326                                               83.2                                                                                   \n",
       "6327                                               83.2                                                                                   \n",
       "6328                                               83.2                                                                                   \n",
       "6329                                               83.2                                                                                   \n",
       "6330                                               83.2                                                                                   \n",
       "6331                                               83.2                                                                                   \n",
       "6332                                               83.2                                                                                   \n",
       "6333                                               83.2                                                                                   \n",
       "6334                                               83.2                                                                                   \n",
       "6335                                               83.2                                                                                   \n",
       "\n",
       "      Employment/Population Ratio; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Some college or associate's degree  \\\n",
       "4272                                               74.6                                                                                \n",
       "4273                                               74.6                                                                                \n",
       "4274                                               74.6                                                                                \n",
       "4275                                               74.6                                                                                \n",
       "4276                                               74.6                                                                                \n",
       "4277                                               74.6                                                                                \n",
       "4278                                               74.6                                                                                \n",
       "4279                                               74.6                                                                                \n",
       "4280                                               74.6                                                                                \n",
       "4281                                               74.6                                                                                \n",
       "4282                                               74.6                                                                                \n",
       "4283                                               74.6                                                                                \n",
       "4284                                               74.6                                                                                \n",
       "4285                                               74.6                                                                                \n",
       "4286                                               74.6                                                                                \n",
       "4287                                               74.6                                                                                \n",
       "4352                                               78.0                                                                                \n",
       "4353                                               78.0                                                                                \n",
       "4354                                               78.0                                                                                \n",
       "4355                                               78.0                                                                                \n",
       "4356                                               78.0                                                                                \n",
       "4357                                               78.0                                                                                \n",
       "4358                                               78.0                                                                                \n",
       "4359                                               78.0                                                                                \n",
       "4360                                               78.0                                                                                \n",
       "4361                                               78.0                                                                                \n",
       "4362                                               78.0                                                                                \n",
       "4363                                               78.0                                                                                \n",
       "4364                                               78.0                                                                                \n",
       "4365                                               78.0                                                                                \n",
       "...                                                 ...                                                                                \n",
       "6306                                               72.8                                                                                \n",
       "6307                                               72.8                                                                                \n",
       "6308                                               72.8                                                                                \n",
       "6309                                               72.8                                                                                \n",
       "6310                                               72.8                                                                                \n",
       "6311                                               72.8                                                                                \n",
       "6312                                               72.8                                                                                \n",
       "6313                                               72.8                                                                                \n",
       "6314                                               72.8                                                                                \n",
       "6315                                               72.8                                                                                \n",
       "6316                                               72.8                                                                                \n",
       "6317                                               72.8                                                                                \n",
       "6318                                               72.8                                                                                \n",
       "6319                                               72.8                                                                                \n",
       "6320                                               71.1                                                                                \n",
       "6321                                               71.1                                                                                \n",
       "6322                                               71.1                                                                                \n",
       "6323                                               71.1                                                                                \n",
       "6324                                               71.1                                                                                \n",
       "6325                                               71.1                                                                                \n",
       "6326                                               71.1                                                                                \n",
       "6327                                               71.1                                                                                \n",
       "6328                                               71.1                                                                                \n",
       "6329                                               71.1                                                                                \n",
       "6330                                               71.1                                                                                \n",
       "6331                                               71.1                                                                                \n",
       "6332                                               71.1                                                                                \n",
       "6333                                               71.1                                                                                \n",
       "6334                                               71.1                                                                                \n",
       "6335                                               71.1                                                                                \n",
       "\n",
       "      Unemployment rate; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Some college or associate's degree  \\\n",
       "4272                                                4.1                                                                      \n",
       "4273                                                4.1                                                                      \n",
       "4274                                                4.1                                                                      \n",
       "4275                                                4.1                                                                      \n",
       "4276                                                4.1                                                                      \n",
       "4277                                                4.1                                                                      \n",
       "4278                                                4.1                                                                      \n",
       "4279                                                4.1                                                                      \n",
       "4280                                                4.1                                                                      \n",
       "4281                                                4.1                                                                      \n",
       "4282                                                4.1                                                                      \n",
       "4283                                                4.1                                                                      \n",
       "4284                                                4.1                                                                      \n",
       "4285                                                4.1                                                                      \n",
       "4286                                                4.1                                                                      \n",
       "4287                                                4.1                                                                      \n",
       "4352                                                4.5                                                                      \n",
       "4353                                                4.5                                                                      \n",
       "4354                                                4.5                                                                      \n",
       "4355                                                4.5                                                                      \n",
       "4356                                                4.5                                                                      \n",
       "4357                                                4.5                                                                      \n",
       "4358                                                4.5                                                                      \n",
       "4359                                                4.5                                                                      \n",
       "4360                                                4.5                                                                      \n",
       "4361                                                4.5                                                                      \n",
       "4362                                                4.5                                                                      \n",
       "4363                                                4.5                                                                      \n",
       "4364                                                4.5                                                                      \n",
       "4365                                                4.5                                                                      \n",
       "...                                                 ...                                                                      \n",
       "6306                                                5.4                                                                      \n",
       "6307                                                5.4                                                                      \n",
       "6308                                                5.4                                                                      \n",
       "6309                                                5.4                                                                      \n",
       "6310                                                5.4                                                                      \n",
       "6311                                                5.4                                                                      \n",
       "6312                                                5.4                                                                      \n",
       "6313                                                5.4                                                                      \n",
       "6314                                                5.4                                                                      \n",
       "6315                                                5.4                                                                      \n",
       "6316                                                5.4                                                                      \n",
       "6317                                                5.4                                                                      \n",
       "6318                                                5.4                                                                      \n",
       "6319                                                5.4                                                                      \n",
       "6320                                                6.1                                                                      \n",
       "6321                                                6.1                                                                      \n",
       "6322                                                6.1                                                                      \n",
       "6323                                                6.1                                                                      \n",
       "6324                                                6.1                                                                      \n",
       "6325                                                6.1                                                                      \n",
       "6326                                                6.1                                                                      \n",
       "6327                                                6.1                                                                      \n",
       "6328                                                6.1                                                                      \n",
       "6329                                                6.1                                                                      \n",
       "6330                                                6.1                                                                      \n",
       "6331                                                6.1                                                                      \n",
       "6332                                                6.1                                                                      \n",
       "6333                                                6.1                                                                      \n",
       "6334                                                6.1                                                                      \n",
       "6335                                                6.1                                                                      \n",
       "\n",
       "      Total; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Bachelor's degree or higher  \\\n",
       "4272                                            28478.0                                                   \n",
       "4273                                            28478.0                                                   \n",
       "4274                                            28478.0                                                   \n",
       "4275                                            28478.0                                                   \n",
       "4276                                            28478.0                                                   \n",
       "4277                                            28478.0                                                   \n",
       "4278                                            28478.0                                                   \n",
       "4279                                            28478.0                                                   \n",
       "4280                                            28478.0                                                   \n",
       "4281                                            28478.0                                                   \n",
       "4282                                            28478.0                                                   \n",
       "4283                                            28478.0                                                   \n",
       "4284                                            28478.0                                                   \n",
       "4285                                            28478.0                                                   \n",
       "4286                                            28478.0                                                   \n",
       "4287                                            28478.0                                                   \n",
       "4352                                           111202.0                                                   \n",
       "4353                                           111202.0                                                   \n",
       "4354                                           111202.0                                                   \n",
       "4355                                           111202.0                                                   \n",
       "4356                                           111202.0                                                   \n",
       "4357                                           111202.0                                                   \n",
       "4358                                           111202.0                                                   \n",
       "4359                                           111202.0                                                   \n",
       "4360                                           111202.0                                                   \n",
       "4361                                           111202.0                                                   \n",
       "4362                                           111202.0                                                   \n",
       "4363                                           111202.0                                                   \n",
       "4364                                           111202.0                                                   \n",
       "4365                                           111202.0                                                   \n",
       "...                                                 ...                                                   \n",
       "6306                                            12779.0                                                   \n",
       "6307                                            12779.0                                                   \n",
       "6308                                            12779.0                                                   \n",
       "6309                                            12779.0                                                   \n",
       "6310                                            12779.0                                                   \n",
       "6311                                            12779.0                                                   \n",
       "6312                                            12779.0                                                   \n",
       "6313                                            12779.0                                                   \n",
       "6314                                            12779.0                                                   \n",
       "6315                                            12779.0                                                   \n",
       "6316                                            12779.0                                                   \n",
       "6317                                            12779.0                                                   \n",
       "6318                                            12779.0                                                   \n",
       "6319                                            12779.0                                                   \n",
       "6320                                            84735.0                                                   \n",
       "6321                                            84735.0                                                   \n",
       "6322                                            84735.0                                                   \n",
       "6323                                            84735.0                                                   \n",
       "6324                                            84735.0                                                   \n",
       "6325                                            84735.0                                                   \n",
       "6326                                            84735.0                                                   \n",
       "6327                                            84735.0                                                   \n",
       "6328                                            84735.0                                                   \n",
       "6329                                            84735.0                                                   \n",
       "6330                                            84735.0                                                   \n",
       "6331                                            84735.0                                                   \n",
       "6332                                            84735.0                                                   \n",
       "6333                                            84735.0                                                   \n",
       "6334                                            84735.0                                                   \n",
       "6335                                            84735.0                                                   \n",
       "\n",
       "      Labor Force Participation Rate; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Bachelor's degree or higher  \\\n",
       "4272                                               81.2                                                                            \n",
       "4273                                               81.2                                                                            \n",
       "4274                                               81.2                                                                            \n",
       "4275                                               81.2                                                                            \n",
       "4276                                               81.2                                                                            \n",
       "4277                                               81.2                                                                            \n",
       "4278                                               81.2                                                                            \n",
       "4279                                               81.2                                                                            \n",
       "4280                                               81.2                                                                            \n",
       "4281                                               81.2                                                                            \n",
       "4282                                               81.2                                                                            \n",
       "4283                                               81.2                                                                            \n",
       "4284                                               81.2                                                                            \n",
       "4285                                               81.2                                                                            \n",
       "4286                                               81.2                                                                            \n",
       "4287                                               81.2                                                                            \n",
       "4352                                               90.5                                                                            \n",
       "4353                                               90.5                                                                            \n",
       "4354                                               90.5                                                                            \n",
       "4355                                               90.5                                                                            \n",
       "4356                                               90.5                                                                            \n",
       "4357                                               90.5                                                                            \n",
       "4358                                               90.5                                                                            \n",
       "4359                                               90.5                                                                            \n",
       "4360                                               90.5                                                                            \n",
       "4361                                               90.5                                                                            \n",
       "4362                                               90.5                                                                            \n",
       "4363                                               90.5                                                                            \n",
       "4364                                               90.5                                                                            \n",
       "4365                                               90.5                                                                            \n",
       "...                                                 ...                                                                            \n",
       "6306                                               87.0                                                                            \n",
       "6307                                               87.0                                                                            \n",
       "6308                                               87.0                                                                            \n",
       "6309                                               87.0                                                                            \n",
       "6310                                               87.0                                                                            \n",
       "6311                                               87.0                                                                            \n",
       "6312                                               87.0                                                                            \n",
       "6313                                               87.0                                                                            \n",
       "6314                                               87.0                                                                            \n",
       "6315                                               87.0                                                                            \n",
       "6316                                               87.0                                                                            \n",
       "6317                                               87.0                                                                            \n",
       "6318                                               87.0                                                                            \n",
       "6319                                               87.0                                                                            \n",
       "6320                                               86.5                                                                            \n",
       "6321                                               86.5                                                                            \n",
       "6322                                               86.5                                                                            \n",
       "6323                                               86.5                                                                            \n",
       "6324                                               86.5                                                                            \n",
       "6325                                               86.5                                                                            \n",
       "6326                                               86.5                                                                            \n",
       "6327                                               86.5                                                                            \n",
       "6328                                               86.5                                                                            \n",
       "6329                                               86.5                                                                            \n",
       "6330                                               86.5                                                                            \n",
       "6331                                               86.5                                                                            \n",
       "6332                                               86.5                                                                            \n",
       "6333                                               86.5                                                                            \n",
       "6334                                               86.5                                                                            \n",
       "6335                                               86.5                                                                            \n",
       "\n",
       "      Employment/Population Ratio; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Bachelor's degree or higher  \\\n",
       "4272                                               79.1                                                                         \n",
       "4273                                               79.1                                                                         \n",
       "4274                                               79.1                                                                         \n",
       "4275                                               79.1                                                                         \n",
       "4276                                               79.1                                                                         \n",
       "4277                                               79.1                                                                         \n",
       "4278                                               79.1                                                                         \n",
       "4279                                               79.1                                                                         \n",
       "4280                                               79.1                                                                         \n",
       "4281                                               79.1                                                                         \n",
       "4282                                               79.1                                                                         \n",
       "4283                                               79.1                                                                         \n",
       "4284                                               79.1                                                                         \n",
       "4285                                               79.1                                                                         \n",
       "4286                                               79.1                                                                         \n",
       "4287                                               79.1                                                                         \n",
       "4352                                               87.0                                                                         \n",
       "4353                                               87.0                                                                         \n",
       "4354                                               87.0                                                                         \n",
       "4355                                               87.0                                                                         \n",
       "4356                                               87.0                                                                         \n",
       "4357                                               87.0                                                                         \n",
       "4358                                               87.0                                                                         \n",
       "4359                                               87.0                                                                         \n",
       "4360                                               87.0                                                                         \n",
       "4361                                               87.0                                                                         \n",
       "4362                                               87.0                                                                         \n",
       "4363                                               87.0                                                                         \n",
       "4364                                               87.0                                                                         \n",
       "4365                                               87.0                                                                         \n",
       "...                                                 ...                                                                         \n",
       "6306                                               80.3                                                                         \n",
       "6307                                               80.3                                                                         \n",
       "6308                                               80.3                                                                         \n",
       "6309                                               80.3                                                                         \n",
       "6310                                               80.3                                                                         \n",
       "6311                                               80.3                                                                         \n",
       "6312                                               80.3                                                                         \n",
       "6313                                               80.3                                                                         \n",
       "6314                                               80.3                                                                         \n",
       "6315                                               80.3                                                                         \n",
       "6316                                               80.3                                                                         \n",
       "6317                                               80.3                                                                         \n",
       "6318                                               80.3                                                                         \n",
       "6319                                               80.3                                                                         \n",
       "6320                                               78.1                                                                         \n",
       "6321                                               78.1                                                                         \n",
       "6322                                               78.1                                                                         \n",
       "6323                                               78.1                                                                         \n",
       "6324                                               78.1                                                                         \n",
       "6325                                               78.1                                                                         \n",
       "6326                                               78.1                                                                         \n",
       "6327                                               78.1                                                                         \n",
       "6328                                               78.1                                                                         \n",
       "6329                                               78.1                                                                         \n",
       "6330                                               78.1                                                                         \n",
       "6331                                               78.1                                                                         \n",
       "6332                                               78.1                                                                         \n",
       "6333                                               78.1                                                                         \n",
       "6334                                               78.1                                                                         \n",
       "6335                                               78.1                                                                         \n",
       "\n",
       "      Unemployment rate; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Bachelor's degree or higher  \n",
       "4272                                                1.9                                                              \n",
       "4273                                                1.9                                                              \n",
       "4274                                                1.9                                                              \n",
       "4275                                                1.9                                                              \n",
       "4276                                                1.9                                                              \n",
       "4277                                                1.9                                                              \n",
       "4278                                                1.9                                                              \n",
       "4279                                                1.9                                                              \n",
       "4280                                                1.9                                                              \n",
       "4281                                                1.9                                                              \n",
       "4282                                                1.9                                                              \n",
       "4283                                                1.9                                                              \n",
       "4284                                                1.9                                                              \n",
       "4285                                                1.9                                                              \n",
       "4286                                                1.9                                                              \n",
       "4287                                                1.9                                                              \n",
       "4352                                                2.4                                                              \n",
       "4353                                                2.4                                                              \n",
       "4354                                                2.4                                                              \n",
       "4355                                                2.4                                                              \n",
       "4356                                                2.4                                                              \n",
       "4357                                                2.4                                                              \n",
       "4358                                                2.4                                                              \n",
       "4359                                                2.4                                                              \n",
       "4360                                                2.4                                                              \n",
       "4361                                                2.4                                                              \n",
       "4362                                                2.4                                                              \n",
       "4363                                                2.4                                                              \n",
       "4364                                                2.4                                                              \n",
       "4365                                                2.4                                                              \n",
       "...                                                 ...                                                              \n",
       "6306                                                2.8                                                              \n",
       "6307                                                2.8                                                              \n",
       "6308                                                2.8                                                              \n",
       "6309                                                2.8                                                              \n",
       "6310                                                2.8                                                              \n",
       "6311                                                2.8                                                              \n",
       "6312                                                2.8                                                              \n",
       "6313                                                2.8                                                              \n",
       "6314                                                2.8                                                              \n",
       "6315                                                2.8                                                              \n",
       "6316                                                2.8                                                              \n",
       "6317                                                2.8                                                              \n",
       "6318                                                2.8                                                              \n",
       "6319                                                2.8                                                              \n",
       "6320                                                2.8                                                              \n",
       "6321                                                2.8                                                              \n",
       "6322                                                2.8                                                              \n",
       "6323                                                2.8                                                              \n",
       "6324                                                2.8                                                              \n",
       "6325                                                2.8                                                              \n",
       "6326                                                2.8                                                              \n",
       "6327                                                2.8                                                              \n",
       "6328                                                2.8                                                              \n",
       "6329                                                2.8                                                              \n",
       "6330                                                2.8                                                              \n",
       "6331                                                2.8                                                              \n",
       "6332                                                2.8                                                              \n",
       "6333                                                2.8                                                              \n",
       "6334                                                2.8                                                              \n",
       "6335                                                2.8                                                              \n",
       "\n",
       "[448 rows x 1667 columns]"
      ]
     },
     "execution_count": 158,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2015 = masterdf[masterdf[\"Year\"]==2015].iloc[:, 1:840]\n",
    "dfother = masterdf[masterdf[\"Year\"] != 2015].iloc[:, 1:4]\n",
    "dfother.columns\n",
    "dfother = pd.merge(dfother, df2015, how='left', on=['FIPS Code', 'Type'])\n",
    "\n",
    "\n",
    "masterdf2 = pd.concat([dfother, df2015], axis=1)\n",
    "masterdf2.drop(masterdf2.columns[[8,9,10,11]], axis=1, inplace=True)\n",
    "masterdf2.dropna(how='any')\n",
    "#masterdf2 = masterdf2.T.drop_duplicates().T\n",
    "\n",
    "#coerce 'object' class to numeric."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 121,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "masterdf2.to_csv('forbonnie.csv')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 143,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "from pandas import DataFrame\n",
    "from IPython.display import HTML\n",
    "#HTML(DataFrame(g[dtype('O')]).to_html())\n",
    "#masterdf3 = masterdf2.apply(pd.to_numeric, errors='coerce')\n",
    "\n",
    "X = masterdf2.drop(['Rate_x'], axis=1)\n",
    "X = X._get_numeric_data()\n",
    "y = masterdf2[\"Rate_x\"].iloc[:,0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 144,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0         15.2\n",
       "1         15.2\n",
       "2          0.0\n",
       "3          0.0\n",
       "4         51.6\n",
       "5         51.6\n",
       "6          6.1\n",
       "7          6.1\n",
       "8          0.0\n",
       "9          0.0\n",
       "10         3.0\n",
       "11         3.0\n",
       "12        15.5\n",
       "13        15.5\n",
       "14       111.2\n",
       "15       111.2\n",
       "16         4.7\n",
       "17         4.7\n",
       "18        11.4\n",
       "19        11.4\n",
       "20        71.9\n",
       "21        71.9\n",
       "22        15.1\n",
       "23        15.1\n",
       "24         0.9\n",
       "25         0.9\n",
       "26         1.9\n",
       "27         1.9\n",
       "28         0.0\n",
       "29         0.0\n",
       "         ...  \n",
       "10610      0.0\n",
       "10611      0.0\n",
       "10612      0.0\n",
       "10613      0.0\n",
       "10614     19.9\n",
       "10615     19.9\n",
       "10616      0.0\n",
       "10617      0.0\n",
       "10618      0.0\n",
       "10619      0.0\n",
       "10620      0.0\n",
       "10621      0.0\n",
       "10622     58.2\n",
       "10623     58.2\n",
       "10624     14.7\n",
       "10625     14.7\n",
       "10626     58.6\n",
       "10627     58.6\n",
       "10628    293.2\n",
       "10629    293.2\n",
       "10630     44.0\n",
       "10631     44.0\n",
       "10632     18.3\n",
       "10633     18.3\n",
       "10634      3.7\n",
       "10635      3.7\n",
       "10636     37.3\n",
       "10637     37.3\n",
       "10638    364.5\n",
       "10639    364.5\n",
       "Name: Rate_x, dtype: float64"
      ]
     },
     "execution_count": 144,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "masterdf2.shape[1]\n",
    "X.shape\n",
    "y"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "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>Year</th>\n",
       "      <th>FIPS Code</th>\n",
       "      <th>Type</th>\n",
       "      <th>Rate_x</th>\n",
       "      <th>Year</th>\n",
       "      <th>FIPS Code</th>\n",
       "      <th>Type</th>\n",
       "      <th>Rate_x</th>\n",
       "      <th>County</th>\n",
       "      <th>State</th>\n",
       "      <th>...</th>\n",
       "      <th>Employment/Population Ratio; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - High school graduate (includes equivalency)</th>\n",
       "      <th>Unemployment rate; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - High school graduate (includes equivalency)</th>\n",
       "      <th>Total; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Some college or associate's degree</th>\n",
       "      <th>Labor Force Participation Rate; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Some college or associate's degree</th>\n",
       "      <th>Employment/Population Ratio; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Some college or associate's degree</th>\n",
       "      <th>Unemployment rate; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Some college or associate's degree</th>\n",
       "      <th>Total; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Bachelor's degree or higher</th>\n",
       "      <th>Labor Force Participation Rate; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Bachelor's degree or higher</th>\n",
       "      <th>Employment/Population Ratio; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Bachelor's degree or higher</th>\n",
       "      <th>Unemployment rate; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Bachelor's degree or higher</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2011</td>\n",
       "      <td>51001</td>\n",
       "      <td>Diagnosed HIV</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2011</td>\n",
       "      <td>51001</td>\n",
       "      <td>ED Heroin Overdose</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2011</td>\n",
       "      <td>51001</td>\n",
       "      <td>ED Opioid Overdose</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2011</td>\n",
       "      <td>51001</td>\n",
       "      <td>EMS Narcan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2011</td>\n",
       "      <td>51001</td>\n",
       "      <td>Fatal Fentanyl and/or Heroin Overdose</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2011</td>\n",
       "      <td>51001</td>\n",
       "      <td>Fatal Prescription Opioid Overdose</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2011</td>\n",
       "      <td>51001</td>\n",
       "      <td>Neonatal Abstinance Syndrome</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2011</td>\n",
       "      <td>51001</td>\n",
       "      <td>Reported Hepatitis C (1830 year olds)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2011</td>\n",
       "      <td>51003</td>\n",
       "      <td>Diagnosed HIV</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2011</td>\n",
       "      <td>51003</td>\n",
       "      <td>ED Heroin Overdose</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2011</td>\n",
       "      <td>51003</td>\n",
       "      <td>ED Opioid Overdose</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2011</td>\n",
       "      <td>51003</td>\n",
       "      <td>EMS Narcan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2011</td>\n",
       "      <td>51003</td>\n",
       "      <td>Fatal Fentanyl and/or Heroin Overdose</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2011</td>\n",
       "      <td>51003</td>\n",
       "      <td>Fatal Prescription Opioid Overdose</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2011</td>\n",
       "      <td>51003</td>\n",
       "      <td>Neonatal Abstinance Syndrome</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2011</td>\n",
       "      <td>51003</td>\n",
       "      <td>Reported Hepatitis C (1830 year olds)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2011</td>\n",
       "      <td>51005</td>\n",
       "      <td>Diagnosed HIV</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2011</td>\n",
       "      <td>51005</td>\n",
       "      <td>ED Heroin Overdose</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2011</td>\n",
       "      <td>51005</td>\n",
       "      <td>ED Opioid Overdose</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2011</td>\n",
       "      <td>51005</td>\n",
       "      <td>EMS Narcan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2011</td>\n",
       "      <td>51005</td>\n",
       "      <td>Fatal Fentanyl and/or Heroin Overdose</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2011</td>\n",
       "      <td>51005</td>\n",
       "      <td>Fatal Prescription Opioid Overdose</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2011</td>\n",
       "      <td>51005</td>\n",
       "      <td>Neonatal Abstinance Syndrome</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2011</td>\n",
       "      <td>51005</td>\n",
       "      <td>Reported Hepatitis C (1830 year olds)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2011</td>\n",
       "      <td>51007</td>\n",
       "      <td>Diagnosed HIV</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2011</td>\n",
       "      <td>51007</td>\n",
       "      <td>ED Heroin Overdose</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2011</td>\n",
       "      <td>51007</td>\n",
       "      <td>ED Opioid Overdose</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2011</td>\n",
       "      <td>51007</td>\n",
       "      <td>EMS Narcan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2011</td>\n",
       "      <td>51007</td>\n",
       "      <td>Fatal Fentanyl and/or Heroin Overdose</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2011</td>\n",
       "      <td>51007</td>\n",
       "      <td>Fatal Prescription Opioid Overdose</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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>6354</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51830</td>\n",
       "      <td>ED Heroin Overdose</td>\n",
       "      <td>0</td>\n",
       "      <td>Williamsburg, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>79.9</td>\n",
       "      <td>2.7</td>\n",
       "      <td>1258</td>\n",
       "      <td>70.7</td>\n",
       "      <td>68.8</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2503</td>\n",
       "      <td>80.6</td>\n",
       "      <td>75.4</td>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6355</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51830</td>\n",
       "      <td>ED Heroin Overdose</td>\n",
       "      <td>0</td>\n",
       "      <td>Williamsburg, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>79.9</td>\n",
       "      <td>2.7</td>\n",
       "      <td>1258</td>\n",
       "      <td>70.7</td>\n",
       "      <td>68.8</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2503</td>\n",
       "      <td>80.6</td>\n",
       "      <td>75.4</td>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6356</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51830</td>\n",
       "      <td>ED Opioid Overdose</td>\n",
       "      <td>0</td>\n",
       "      <td>Williamsburg, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>79.9</td>\n",
       "      <td>2.7</td>\n",
       "      <td>1258</td>\n",
       "      <td>70.7</td>\n",
       "      <td>68.8</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2503</td>\n",
       "      <td>80.6</td>\n",
       "      <td>75.4</td>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6357</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51830</td>\n",
       "      <td>ED Opioid Overdose</td>\n",
       "      <td>0</td>\n",
       "      <td>Williamsburg, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>79.9</td>\n",
       "      <td>2.7</td>\n",
       "      <td>1258</td>\n",
       "      <td>70.7</td>\n",
       "      <td>68.8</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2503</td>\n",
       "      <td>80.6</td>\n",
       "      <td>75.4</td>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6358</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51830</td>\n",
       "      <td>EMS Narcan</td>\n",
       "      <td>19.9</td>\n",
       "      <td>Williamsburg, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>79.9</td>\n",
       "      <td>2.7</td>\n",
       "      <td>1258</td>\n",
       "      <td>70.7</td>\n",
       "      <td>68.8</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2503</td>\n",
       "      <td>80.6</td>\n",
       "      <td>75.4</td>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6359</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51830</td>\n",
       "      <td>EMS Narcan</td>\n",
       "      <td>19.9</td>\n",
       "      <td>Williamsburg, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>79.9</td>\n",
       "      <td>2.7</td>\n",
       "      <td>1258</td>\n",
       "      <td>70.7</td>\n",
       "      <td>68.8</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2503</td>\n",
       "      <td>80.6</td>\n",
       "      <td>75.4</td>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6360</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51830</td>\n",
       "      <td>Fatal Fentanyl and/or Heroin Overdose</td>\n",
       "      <td>0</td>\n",
       "      <td>Williamsburg, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>79.9</td>\n",
       "      <td>2.7</td>\n",
       "      <td>1258</td>\n",
       "      <td>70.7</td>\n",
       "      <td>68.8</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2503</td>\n",
       "      <td>80.6</td>\n",
       "      <td>75.4</td>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6361</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51830</td>\n",
       "      <td>Fatal Fentanyl and/or Heroin Overdose</td>\n",
       "      <td>0</td>\n",
       "      <td>Williamsburg, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>79.9</td>\n",
       "      <td>2.7</td>\n",
       "      <td>1258</td>\n",
       "      <td>70.7</td>\n",
       "      <td>68.8</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2503</td>\n",
       "      <td>80.6</td>\n",
       "      <td>75.4</td>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6362</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51830</td>\n",
       "      <td>Fatal Prescription Opioid Overdose</td>\n",
       "      <td>0</td>\n",
       "      <td>Williamsburg, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>79.9</td>\n",
       "      <td>2.7</td>\n",
       "      <td>1258</td>\n",
       "      <td>70.7</td>\n",
       "      <td>68.8</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2503</td>\n",
       "      <td>80.6</td>\n",
       "      <td>75.4</td>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6363</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51830</td>\n",
       "      <td>Fatal Prescription Opioid Overdose</td>\n",
       "      <td>0</td>\n",
       "      <td>Williamsburg, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>79.9</td>\n",
       "      <td>2.7</td>\n",
       "      <td>1258</td>\n",
       "      <td>70.7</td>\n",
       "      <td>68.8</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2503</td>\n",
       "      <td>80.6</td>\n",
       "      <td>75.4</td>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6364</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51830</td>\n",
       "      <td>Neonatal Abstinance Syndrome</td>\n",
       "      <td>0</td>\n",
       "      <td>Williamsburg, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>79.9</td>\n",
       "      <td>2.7</td>\n",
       "      <td>1258</td>\n",
       "      <td>70.7</td>\n",
       "      <td>68.8</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2503</td>\n",
       "      <td>80.6</td>\n",
       "      <td>75.4</td>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6365</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51830</td>\n",
       "      <td>Neonatal Abstinance Syndrome</td>\n",
       "      <td>0</td>\n",
       "      <td>Williamsburg, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>79.9</td>\n",
       "      <td>2.7</td>\n",
       "      <td>1258</td>\n",
       "      <td>70.7</td>\n",
       "      <td>68.8</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2503</td>\n",
       "      <td>80.6</td>\n",
       "      <td>75.4</td>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6366</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51830</td>\n",
       "      <td>Reported Hepatitis C (1830 year olds)</td>\n",
       "      <td>58.2</td>\n",
       "      <td>Williamsburg, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>79.9</td>\n",
       "      <td>2.7</td>\n",
       "      <td>1258</td>\n",
       "      <td>70.7</td>\n",
       "      <td>68.8</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2503</td>\n",
       "      <td>80.6</td>\n",
       "      <td>75.4</td>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6367</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51830</td>\n",
       "      <td>Reported Hepatitis C (1830 year olds)</td>\n",
       "      <td>58.2</td>\n",
       "      <td>Williamsburg, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>79.9</td>\n",
       "      <td>2.7</td>\n",
       "      <td>1258</td>\n",
       "      <td>70.7</td>\n",
       "      <td>68.8</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2503</td>\n",
       "      <td>80.6</td>\n",
       "      <td>75.4</td>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6368</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51840</td>\n",
       "      <td>Diagnosed HIV</td>\n",
       "      <td>14.7</td>\n",
       "      <td>Winchester, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>68</td>\n",
       "      <td>9.7</td>\n",
       "      <td>3707</td>\n",
       "      <td>82.1</td>\n",
       "      <td>80.4</td>\n",
       "      <td>2</td>\n",
       "      <td>4118</td>\n",
       "      <td>80.4</td>\n",
       "      <td>76.1</td>\n",
       "      <td>4.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6369</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51840</td>\n",
       "      <td>Diagnosed HIV</td>\n",
       "      <td>14.7</td>\n",
       "      <td>Winchester, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>68</td>\n",
       "      <td>9.7</td>\n",
       "      <td>3707</td>\n",
       "      <td>82.1</td>\n",
       "      <td>80.4</td>\n",
       "      <td>2</td>\n",
       "      <td>4118</td>\n",
       "      <td>80.4</td>\n",
       "      <td>76.1</td>\n",
       "      <td>4.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6370</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51840</td>\n",
       "      <td>ED Heroin Overdose</td>\n",
       "      <td>58.6</td>\n",
       "      <td>Winchester, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>68</td>\n",
       "      <td>9.7</td>\n",
       "      <td>3707</td>\n",
       "      <td>82.1</td>\n",
       "      <td>80.4</td>\n",
       "      <td>2</td>\n",
       "      <td>4118</td>\n",
       "      <td>80.4</td>\n",
       "      <td>76.1</td>\n",
       "      <td>4.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6371</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51840</td>\n",
       "      <td>ED Heroin Overdose</td>\n",
       "      <td>58.6</td>\n",
       "      <td>Winchester, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>68</td>\n",
       "      <td>9.7</td>\n",
       "      <td>3707</td>\n",
       "      <td>82.1</td>\n",
       "      <td>80.4</td>\n",
       "      <td>2</td>\n",
       "      <td>4118</td>\n",
       "      <td>80.4</td>\n",
       "      <td>76.1</td>\n",
       "      <td>4.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6372</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51840</td>\n",
       "      <td>ED Opioid Overdose</td>\n",
       "      <td>293.2</td>\n",
       "      <td>Winchester, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>68</td>\n",
       "      <td>9.7</td>\n",
       "      <td>3707</td>\n",
       "      <td>82.1</td>\n",
       "      <td>80.4</td>\n",
       "      <td>2</td>\n",
       "      <td>4118</td>\n",
       "      <td>80.4</td>\n",
       "      <td>76.1</td>\n",
       "      <td>4.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6373</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51840</td>\n",
       "      <td>ED Opioid Overdose</td>\n",
       "      <td>293.2</td>\n",
       "      <td>Winchester, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>68</td>\n",
       "      <td>9.7</td>\n",
       "      <td>3707</td>\n",
       "      <td>82.1</td>\n",
       "      <td>80.4</td>\n",
       "      <td>2</td>\n",
       "      <td>4118</td>\n",
       "      <td>80.4</td>\n",
       "      <td>76.1</td>\n",
       "      <td>4.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6374</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51840</td>\n",
       "      <td>EMS Narcan</td>\n",
       "      <td>44</td>\n",
       "      <td>Winchester, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>68</td>\n",
       "      <td>9.7</td>\n",
       "      <td>3707</td>\n",
       "      <td>82.1</td>\n",
       "      <td>80.4</td>\n",
       "      <td>2</td>\n",
       "      <td>4118</td>\n",
       "      <td>80.4</td>\n",
       "      <td>76.1</td>\n",
       "      <td>4.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6375</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51840</td>\n",
       "      <td>EMS Narcan</td>\n",
       "      <td>44</td>\n",
       "      <td>Winchester, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>68</td>\n",
       "      <td>9.7</td>\n",
       "      <td>3707</td>\n",
       "      <td>82.1</td>\n",
       "      <td>80.4</td>\n",
       "      <td>2</td>\n",
       "      <td>4118</td>\n",
       "      <td>80.4</td>\n",
       "      <td>76.1</td>\n",
       "      <td>4.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6376</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51840</td>\n",
       "      <td>Fatal Fentanyl and/or Heroin Overdose</td>\n",
       "      <td>18.3</td>\n",
       "      <td>Winchester, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>68</td>\n",
       "      <td>9.7</td>\n",
       "      <td>3707</td>\n",
       "      <td>82.1</td>\n",
       "      <td>80.4</td>\n",
       "      <td>2</td>\n",
       "      <td>4118</td>\n",
       "      <td>80.4</td>\n",
       "      <td>76.1</td>\n",
       "      <td>4.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6377</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51840</td>\n",
       "      <td>Fatal Fentanyl and/or Heroin Overdose</td>\n",
       "      <td>18.3</td>\n",
       "      <td>Winchester, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>68</td>\n",
       "      <td>9.7</td>\n",
       "      <td>3707</td>\n",
       "      <td>82.1</td>\n",
       "      <td>80.4</td>\n",
       "      <td>2</td>\n",
       "      <td>4118</td>\n",
       "      <td>80.4</td>\n",
       "      <td>76.1</td>\n",
       "      <td>4.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6378</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51840</td>\n",
       "      <td>Fatal Prescription Opioid Overdose</td>\n",
       "      <td>3.7</td>\n",
       "      <td>Winchester, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>68</td>\n",
       "      <td>9.7</td>\n",
       "      <td>3707</td>\n",
       "      <td>82.1</td>\n",
       "      <td>80.4</td>\n",
       "      <td>2</td>\n",
       "      <td>4118</td>\n",
       "      <td>80.4</td>\n",
       "      <td>76.1</td>\n",
       "      <td>4.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6379</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51840</td>\n",
       "      <td>Fatal Prescription Opioid Overdose</td>\n",
       "      <td>3.7</td>\n",
       "      <td>Winchester, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>68</td>\n",
       "      <td>9.7</td>\n",
       "      <td>3707</td>\n",
       "      <td>82.1</td>\n",
       "      <td>80.4</td>\n",
       "      <td>2</td>\n",
       "      <td>4118</td>\n",
       "      <td>80.4</td>\n",
       "      <td>76.1</td>\n",
       "      <td>4.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6380</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51840</td>\n",
       "      <td>Neonatal Abstinance Syndrome</td>\n",
       "      <td>37.3</td>\n",
       "      <td>Winchester, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>68</td>\n",
       "      <td>9.7</td>\n",
       "      <td>3707</td>\n",
       "      <td>82.1</td>\n",
       "      <td>80.4</td>\n",
       "      <td>2</td>\n",
       "      <td>4118</td>\n",
       "      <td>80.4</td>\n",
       "      <td>76.1</td>\n",
       "      <td>4.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6381</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51840</td>\n",
       "      <td>Neonatal Abstinance Syndrome</td>\n",
       "      <td>37.3</td>\n",
       "      <td>Winchester, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>68</td>\n",
       "      <td>9.7</td>\n",
       "      <td>3707</td>\n",
       "      <td>82.1</td>\n",
       "      <td>80.4</td>\n",
       "      <td>2</td>\n",
       "      <td>4118</td>\n",
       "      <td>80.4</td>\n",
       "      <td>76.1</td>\n",
       "      <td>4.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6382</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51840</td>\n",
       "      <td>Reported Hepatitis C (1830 year olds)</td>\n",
       "      <td>364.5</td>\n",
       "      <td>Winchester, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>68</td>\n",
       "      <td>9.7</td>\n",
       "      <td>3707</td>\n",
       "      <td>82.1</td>\n",
       "      <td>80.4</td>\n",
       "      <td>2</td>\n",
       "      <td>4118</td>\n",
       "      <td>80.4</td>\n",
       "      <td>76.1</td>\n",
       "      <td>4.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6383</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015</td>\n",
       "      <td>51840</td>\n",
       "      <td>Reported Hepatitis C (1830 year olds)</td>\n",
       "      <td>364.5</td>\n",
       "      <td>Winchester, VA</td>\n",
       "      <td>VA</td>\n",
       "      <td>...</td>\n",
       "      <td>68</td>\n",
       "      <td>9.7</td>\n",
       "      <td>3707</td>\n",
       "      <td>82.1</td>\n",
       "      <td>80.4</td>\n",
       "      <td>2</td>\n",
       "      <td>4118</td>\n",
       "      <td>80.4</td>\n",
       "      <td>76.1</td>\n",
       "      <td>4.1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6384 rows × 835 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Year FIPS Code                                   Type Rate_x  Year  \\\n",
       "0     2011     51001                          Diagnosed HIV    NaN   NaN   \n",
       "1     2011     51001                     ED Heroin Overdose    NaN   NaN   \n",
       "2     2011     51001                     ED Opioid Overdose    NaN   NaN   \n",
       "3     2011     51001                             EMS Narcan    NaN   NaN   \n",
       "4     2011     51001  Fatal Fentanyl and/or Heroin Overdose    NaN   NaN   \n",
       "5     2011     51001     Fatal Prescription Opioid Overdose    NaN   NaN   \n",
       "6     2011     51001           Neonatal Abstinance Syndrome    NaN   NaN   \n",
       "7     2011     51001  Reported Hepatitis C (1830 year olds)    NaN   NaN   \n",
       "8     2011     51003                          Diagnosed HIV    NaN   NaN   \n",
       "9     2011     51003                     ED Heroin Overdose    NaN   NaN   \n",
       "10    2011     51003                     ED Opioid Overdose    NaN   NaN   \n",
       "11    2011     51003                             EMS Narcan    NaN   NaN   \n",
       "12    2011     51003  Fatal Fentanyl and/or Heroin Overdose    NaN   NaN   \n",
       "13    2011     51003     Fatal Prescription Opioid Overdose    NaN   NaN   \n",
       "14    2011     51003           Neonatal Abstinance Syndrome    NaN   NaN   \n",
       "15    2011     51003  Reported Hepatitis C (1830 year olds)    NaN   NaN   \n",
       "16    2011     51005                          Diagnosed HIV    NaN   NaN   \n",
       "17    2011     51005                     ED Heroin Overdose    NaN   NaN   \n",
       "18    2011     51005                     ED Opioid Overdose    NaN   NaN   \n",
       "19    2011     51005                             EMS Narcan    NaN   NaN   \n",
       "20    2011     51005  Fatal Fentanyl and/or Heroin Overdose    NaN   NaN   \n",
       "21    2011     51005     Fatal Prescription Opioid Overdose    NaN   NaN   \n",
       "22    2011     51005           Neonatal Abstinance Syndrome    NaN   NaN   \n",
       "23    2011     51005  Reported Hepatitis C (1830 year olds)    NaN   NaN   \n",
       "24    2011     51007                          Diagnosed HIV    NaN   NaN   \n",
       "25    2011     51007                     ED Heroin Overdose    NaN   NaN   \n",
       "26    2011     51007                     ED Opioid Overdose    NaN   NaN   \n",
       "27    2011     51007                             EMS Narcan    NaN   NaN   \n",
       "28    2011     51007  Fatal Fentanyl and/or Heroin Overdose    NaN   NaN   \n",
       "29    2011     51007     Fatal Prescription Opioid Overdose    NaN   NaN   \n",
       "...    ...       ...                                    ...    ...   ...   \n",
       "6354   NaN       NaN                                    NaN    NaN  2015   \n",
       "6355   NaN       NaN                                    NaN    NaN  2015   \n",
       "6356   NaN       NaN                                    NaN    NaN  2015   \n",
       "6357   NaN       NaN                                    NaN    NaN  2015   \n",
       "6358   NaN       NaN                                    NaN    NaN  2015   \n",
       "6359   NaN       NaN                                    NaN    NaN  2015   \n",
       "6360   NaN       NaN                                    NaN    NaN  2015   \n",
       "6361   NaN       NaN                                    NaN    NaN  2015   \n",
       "6362   NaN       NaN                                    NaN    NaN  2015   \n",
       "6363   NaN       NaN                                    NaN    NaN  2015   \n",
       "6364   NaN       NaN                                    NaN    NaN  2015   \n",
       "6365   NaN       NaN                                    NaN    NaN  2015   \n",
       "6366   NaN       NaN                                    NaN    NaN  2015   \n",
       "6367   NaN       NaN                                    NaN    NaN  2015   \n",
       "6368   NaN       NaN                                    NaN    NaN  2015   \n",
       "6369   NaN       NaN                                    NaN    NaN  2015   \n",
       "6370   NaN       NaN                                    NaN    NaN  2015   \n",
       "6371   NaN       NaN                                    NaN    NaN  2015   \n",
       "6372   NaN       NaN                                    NaN    NaN  2015   \n",
       "6373   NaN       NaN                                    NaN    NaN  2015   \n",
       "6374   NaN       NaN                                    NaN    NaN  2015   \n",
       "6375   NaN       NaN                                    NaN    NaN  2015   \n",
       "6376   NaN       NaN                                    NaN    NaN  2015   \n",
       "6377   NaN       NaN                                    NaN    NaN  2015   \n",
       "6378   NaN       NaN                                    NaN    NaN  2015   \n",
       "6379   NaN       NaN                                    NaN    NaN  2015   \n",
       "6380   NaN       NaN                                    NaN    NaN  2015   \n",
       "6381   NaN       NaN                                    NaN    NaN  2015   \n",
       "6382   NaN       NaN                                    NaN    NaN  2015   \n",
       "6383   NaN       NaN                                    NaN    NaN  2015   \n",
       "\n",
       "     FIPS Code                                   Type Rate_x  \\\n",
       "0          NaN                                    NaN    NaN   \n",
       "1          NaN                                    NaN    NaN   \n",
       "2          NaN                                    NaN    NaN   \n",
       "3          NaN                                    NaN    NaN   \n",
       "4          NaN                                    NaN    NaN   \n",
       "5          NaN                                    NaN    NaN   \n",
       "6          NaN                                    NaN    NaN   \n",
       "7          NaN                                    NaN    NaN   \n",
       "8          NaN                                    NaN    NaN   \n",
       "9          NaN                                    NaN    NaN   \n",
       "10         NaN                                    NaN    NaN   \n",
       "11         NaN                                    NaN    NaN   \n",
       "12         NaN                                    NaN    NaN   \n",
       "13         NaN                                    NaN    NaN   \n",
       "14         NaN                                    NaN    NaN   \n",
       "15         NaN                                    NaN    NaN   \n",
       "16         NaN                                    NaN    NaN   \n",
       "17         NaN                                    NaN    NaN   \n",
       "18         NaN                                    NaN    NaN   \n",
       "19         NaN                                    NaN    NaN   \n",
       "20         NaN                                    NaN    NaN   \n",
       "21         NaN                                    NaN    NaN   \n",
       "22         NaN                                    NaN    NaN   \n",
       "23         NaN                                    NaN    NaN   \n",
       "24         NaN                                    NaN    NaN   \n",
       "25         NaN                                    NaN    NaN   \n",
       "26         NaN                                    NaN    NaN   \n",
       "27         NaN                                    NaN    NaN   \n",
       "28         NaN                                    NaN    NaN   \n",
       "29         NaN                                    NaN    NaN   \n",
       "...        ...                                    ...    ...   \n",
       "6354     51830                     ED Heroin Overdose      0   \n",
       "6355     51830                     ED Heroin Overdose      0   \n",
       "6356     51830                     ED Opioid Overdose      0   \n",
       "6357     51830                     ED Opioid Overdose      0   \n",
       "6358     51830                             EMS Narcan   19.9   \n",
       "6359     51830                             EMS Narcan   19.9   \n",
       "6360     51830  Fatal Fentanyl and/or Heroin Overdose      0   \n",
       "6361     51830  Fatal Fentanyl and/or Heroin Overdose      0   \n",
       "6362     51830     Fatal Prescription Opioid Overdose      0   \n",
       "6363     51830     Fatal Prescription Opioid Overdose      0   \n",
       "6364     51830           Neonatal Abstinance Syndrome      0   \n",
       "6365     51830           Neonatal Abstinance Syndrome      0   \n",
       "6366     51830  Reported Hepatitis C (1830 year olds)   58.2   \n",
       "6367     51830  Reported Hepatitis C (1830 year olds)   58.2   \n",
       "6368     51840                          Diagnosed HIV   14.7   \n",
       "6369     51840                          Diagnosed HIV   14.7   \n",
       "6370     51840                     ED Heroin Overdose   58.6   \n",
       "6371     51840                     ED Heroin Overdose   58.6   \n",
       "6372     51840                     ED Opioid Overdose  293.2   \n",
       "6373     51840                     ED Opioid Overdose  293.2   \n",
       "6374     51840                             EMS Narcan     44   \n",
       "6375     51840                             EMS Narcan     44   \n",
       "6376     51840  Fatal Fentanyl and/or Heroin Overdose   18.3   \n",
       "6377     51840  Fatal Fentanyl and/or Heroin Overdose   18.3   \n",
       "6378     51840     Fatal Prescription Opioid Overdose    3.7   \n",
       "6379     51840     Fatal Prescription Opioid Overdose    3.7   \n",
       "6380     51840           Neonatal Abstinance Syndrome   37.3   \n",
       "6381     51840           Neonatal Abstinance Syndrome   37.3   \n",
       "6382     51840  Reported Hepatitis C (1830 year olds)  364.5   \n",
       "6383     51840  Reported Hepatitis C (1830 year olds)  364.5   \n",
       "\n",
       "                County State  \\\n",
       "0                  NaN   NaN   \n",
       "1                  NaN   NaN   \n",
       "2                  NaN   NaN   \n",
       "3                  NaN   NaN   \n",
       "4                  NaN   NaN   \n",
       "5                  NaN   NaN   \n",
       "6                  NaN   NaN   \n",
       "7                  NaN   NaN   \n",
       "8                  NaN   NaN   \n",
       "9                  NaN   NaN   \n",
       "10                 NaN   NaN   \n",
       "11                 NaN   NaN   \n",
       "12                 NaN   NaN   \n",
       "13                 NaN   NaN   \n",
       "14                 NaN   NaN   \n",
       "15                 NaN   NaN   \n",
       "16                 NaN   NaN   \n",
       "17                 NaN   NaN   \n",
       "18                 NaN   NaN   \n",
       "19                 NaN   NaN   \n",
       "20                 NaN   NaN   \n",
       "21                 NaN   NaN   \n",
       "22                 NaN   NaN   \n",
       "23                 NaN   NaN   \n",
       "24                 NaN   NaN   \n",
       "25                 NaN   NaN   \n",
       "26                 NaN   NaN   \n",
       "27                 NaN   NaN   \n",
       "28                 NaN   NaN   \n",
       "29                 NaN   NaN   \n",
       "...                ...   ...   \n",
       "6354  Williamsburg, VA    VA   \n",
       "6355  Williamsburg, VA    VA   \n",
       "6356  Williamsburg, VA    VA   \n",
       "6357  Williamsburg, VA    VA   \n",
       "6358  Williamsburg, VA    VA   \n",
       "6359  Williamsburg, VA    VA   \n",
       "6360  Williamsburg, VA    VA   \n",
       "6361  Williamsburg, VA    VA   \n",
       "6362  Williamsburg, VA    VA   \n",
       "6363  Williamsburg, VA    VA   \n",
       "6364  Williamsburg, VA    VA   \n",
       "6365  Williamsburg, VA    VA   \n",
       "6366  Williamsburg, VA    VA   \n",
       "6367  Williamsburg, VA    VA   \n",
       "6368    Winchester, VA    VA   \n",
       "6369    Winchester, VA    VA   \n",
       "6370    Winchester, VA    VA   \n",
       "6371    Winchester, VA    VA   \n",
       "6372    Winchester, VA    VA   \n",
       "6373    Winchester, VA    VA   \n",
       "6374    Winchester, VA    VA   \n",
       "6375    Winchester, VA    VA   \n",
       "6376    Winchester, VA    VA   \n",
       "6377    Winchester, VA    VA   \n",
       "6378    Winchester, VA    VA   \n",
       "6379    Winchester, VA    VA   \n",
       "6380    Winchester, VA    VA   \n",
       "6381    Winchester, VA    VA   \n",
       "6382    Winchester, VA    VA   \n",
       "6383    Winchester, VA    VA   \n",
       "\n",
       "                                                          ...                                                       \\\n",
       "0                                                         ...                                                        \n",
       "1                                                         ...                                                        \n",
       "2                                                         ...                                                        \n",
       "3                                                         ...                                                        \n",
       "4                                                         ...                                                        \n",
       "5                                                         ...                                                        \n",
       "6                                                         ...                                                        \n",
       "7                                                         ...                                                        \n",
       "8                                                         ...                                                        \n",
       "9                                                         ...                                                        \n",
       "10                                                        ...                                                        \n",
       "11                                                        ...                                                        \n",
       "12                                                        ...                                                        \n",
       "13                                                        ...                                                        \n",
       "14                                                        ...                                                        \n",
       "15                                                        ...                                                        \n",
       "16                                                        ...                                                        \n",
       "17                                                        ...                                                        \n",
       "18                                                        ...                                                        \n",
       "19                                                        ...                                                        \n",
       "20                                                        ...                                                        \n",
       "21                                                        ...                                                        \n",
       "22                                                        ...                                                        \n",
       "23                                                        ...                                                        \n",
       "24                                                        ...                                                        \n",
       "25                                                        ...                                                        \n",
       "26                                                        ...                                                        \n",
       "27                                                        ...                                                        \n",
       "28                                                        ...                                                        \n",
       "29                                                        ...                                                        \n",
       "...                                                       ...                                                        \n",
       "6354                                                      ...                                                        \n",
       "6355                                                      ...                                                        \n",
       "6356                                                      ...                                                        \n",
       "6357                                                      ...                                                        \n",
       "6358                                                      ...                                                        \n",
       "6359                                                      ...                                                        \n",
       "6360                                                      ...                                                        \n",
       "6361                                                      ...                                                        \n",
       "6362                                                      ...                                                        \n",
       "6363                                                      ...                                                        \n",
       "6364                                                      ...                                                        \n",
       "6365                                                      ...                                                        \n",
       "6366                                                      ...                                                        \n",
       "6367                                                      ...                                                        \n",
       "6368                                                      ...                                                        \n",
       "6369                                                      ...                                                        \n",
       "6370                                                      ...                                                        \n",
       "6371                                                      ...                                                        \n",
       "6372                                                      ...                                                        \n",
       "6373                                                      ...                                                        \n",
       "6374                                                      ...                                                        \n",
       "6375                                                      ...                                                        \n",
       "6376                                                      ...                                                        \n",
       "6377                                                      ...                                                        \n",
       "6378                                                      ...                                                        \n",
       "6379                                                      ...                                                        \n",
       "6380                                                      ...                                                        \n",
       "6381                                                      ...                                                        \n",
       "6382                                                      ...                                                        \n",
       "6383                                                      ...                                                        \n",
       "\n",
       "     Employment/Population Ratio; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - High school graduate (includes equivalency)  \\\n",
       "0                                                   NaN                                                                                        \n",
       "1                                                   NaN                                                                                        \n",
       "2                                                   NaN                                                                                        \n",
       "3                                                   NaN                                                                                        \n",
       "4                                                   NaN                                                                                        \n",
       "5                                                   NaN                                                                                        \n",
       "6                                                   NaN                                                                                        \n",
       "7                                                   NaN                                                                                        \n",
       "8                                                   NaN                                                                                        \n",
       "9                                                   NaN                                                                                        \n",
       "10                                                  NaN                                                                                        \n",
       "11                                                  NaN                                                                                        \n",
       "12                                                  NaN                                                                                        \n",
       "13                                                  NaN                                                                                        \n",
       "14                                                  NaN                                                                                        \n",
       "15                                                  NaN                                                                                        \n",
       "16                                                  NaN                                                                                        \n",
       "17                                                  NaN                                                                                        \n",
       "18                                                  NaN                                                                                        \n",
       "19                                                  NaN                                                                                        \n",
       "20                                                  NaN                                                                                        \n",
       "21                                                  NaN                                                                                        \n",
       "22                                                  NaN                                                                                        \n",
       "23                                                  NaN                                                                                        \n",
       "24                                                  NaN                                                                                        \n",
       "25                                                  NaN                                                                                        \n",
       "26                                                  NaN                                                                                        \n",
       "27                                                  NaN                                                                                        \n",
       "28                                                  NaN                                                                                        \n",
       "29                                                  NaN                                                                                        \n",
       "...                                                 ...                                                                                        \n",
       "6354                                               79.9                                                                                        \n",
       "6355                                               79.9                                                                                        \n",
       "6356                                               79.9                                                                                        \n",
       "6357                                               79.9                                                                                        \n",
       "6358                                               79.9                                                                                        \n",
       "6359                                               79.9                                                                                        \n",
       "6360                                               79.9                                                                                        \n",
       "6361                                               79.9                                                                                        \n",
       "6362                                               79.9                                                                                        \n",
       "6363                                               79.9                                                                                        \n",
       "6364                                               79.9                                                                                        \n",
       "6365                                               79.9                                                                                        \n",
       "6366                                               79.9                                                                                        \n",
       "6367                                               79.9                                                                                        \n",
       "6368                                                 68                                                                                        \n",
       "6369                                                 68                                                                                        \n",
       "6370                                                 68                                                                                        \n",
       "6371                                                 68                                                                                        \n",
       "6372                                                 68                                                                                        \n",
       "6373                                                 68                                                                                        \n",
       "6374                                                 68                                                                                        \n",
       "6375                                                 68                                                                                        \n",
       "6376                                                 68                                                                                        \n",
       "6377                                                 68                                                                                        \n",
       "6378                                                 68                                                                                        \n",
       "6379                                                 68                                                                                        \n",
       "6380                                                 68                                                                                        \n",
       "6381                                                 68                                                                                        \n",
       "6382                                                 68                                                                                        \n",
       "6383                                                 68                                                                                        \n",
       "\n",
       "     Unemployment rate; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - High school graduate (includes equivalency)  \\\n",
       "0                                                   NaN                                                                              \n",
       "1                                                   NaN                                                                              \n",
       "2                                                   NaN                                                                              \n",
       "3                                                   NaN                                                                              \n",
       "4                                                   NaN                                                                              \n",
       "5                                                   NaN                                                                              \n",
       "6                                                   NaN                                                                              \n",
       "7                                                   NaN                                                                              \n",
       "8                                                   NaN                                                                              \n",
       "9                                                   NaN                                                                              \n",
       "10                                                  NaN                                                                              \n",
       "11                                                  NaN                                                                              \n",
       "12                                                  NaN                                                                              \n",
       "13                                                  NaN                                                                              \n",
       "14                                                  NaN                                                                              \n",
       "15                                                  NaN                                                                              \n",
       "16                                                  NaN                                                                              \n",
       "17                                                  NaN                                                                              \n",
       "18                                                  NaN                                                                              \n",
       "19                                                  NaN                                                                              \n",
       "20                                                  NaN                                                                              \n",
       "21                                                  NaN                                                                              \n",
       "22                                                  NaN                                                                              \n",
       "23                                                  NaN                                                                              \n",
       "24                                                  NaN                                                                              \n",
       "25                                                  NaN                                                                              \n",
       "26                                                  NaN                                                                              \n",
       "27                                                  NaN                                                                              \n",
       "28                                                  NaN                                                                              \n",
       "29                                                  NaN                                                                              \n",
       "...                                                 ...                                                                              \n",
       "6354                                                2.7                                                                              \n",
       "6355                                                2.7                                                                              \n",
       "6356                                                2.7                                                                              \n",
       "6357                                                2.7                                                                              \n",
       "6358                                                2.7                                                                              \n",
       "6359                                                2.7                                                                              \n",
       "6360                                                2.7                                                                              \n",
       "6361                                                2.7                                                                              \n",
       "6362                                                2.7                                                                              \n",
       "6363                                                2.7                                                                              \n",
       "6364                                                2.7                                                                              \n",
       "6365                                                2.7                                                                              \n",
       "6366                                                2.7                                                                              \n",
       "6367                                                2.7                                                                              \n",
       "6368                                                9.7                                                                              \n",
       "6369                                                9.7                                                                              \n",
       "6370                                                9.7                                                                              \n",
       "6371                                                9.7                                                                              \n",
       "6372                                                9.7                                                                              \n",
       "6373                                                9.7                                                                              \n",
       "6374                                                9.7                                                                              \n",
       "6375                                                9.7                                                                              \n",
       "6376                                                9.7                                                                              \n",
       "6377                                                9.7                                                                              \n",
       "6378                                                9.7                                                                              \n",
       "6379                                                9.7                                                                              \n",
       "6380                                                9.7                                                                              \n",
       "6381                                                9.7                                                                              \n",
       "6382                                                9.7                                                                              \n",
       "6383                                                9.7                                                                              \n",
       "\n",
       "     Total; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Some college or associate's degree  \\\n",
       "0                                                   NaN                                                         \n",
       "1                                                   NaN                                                         \n",
       "2                                                   NaN                                                         \n",
       "3                                                   NaN                                                         \n",
       "4                                                   NaN                                                         \n",
       "5                                                   NaN                                                         \n",
       "6                                                   NaN                                                         \n",
       "7                                                   NaN                                                         \n",
       "8                                                   NaN                                                         \n",
       "9                                                   NaN                                                         \n",
       "10                                                  NaN                                                         \n",
       "11                                                  NaN                                                         \n",
       "12                                                  NaN                                                         \n",
       "13                                                  NaN                                                         \n",
       "14                                                  NaN                                                         \n",
       "15                                                  NaN                                                         \n",
       "16                                                  NaN                                                         \n",
       "17                                                  NaN                                                         \n",
       "18                                                  NaN                                                         \n",
       "19                                                  NaN                                                         \n",
       "20                                                  NaN                                                         \n",
       "21                                                  NaN                                                         \n",
       "22                                                  NaN                                                         \n",
       "23                                                  NaN                                                         \n",
       "24                                                  NaN                                                         \n",
       "25                                                  NaN                                                         \n",
       "26                                                  NaN                                                         \n",
       "27                                                  NaN                                                         \n",
       "28                                                  NaN                                                         \n",
       "29                                                  NaN                                                         \n",
       "...                                                 ...                                                         \n",
       "6354                                               1258                                                         \n",
       "6355                                               1258                                                         \n",
       "6356                                               1258                                                         \n",
       "6357                                               1258                                                         \n",
       "6358                                               1258                                                         \n",
       "6359                                               1258                                                         \n",
       "6360                                               1258                                                         \n",
       "6361                                               1258                                                         \n",
       "6362                                               1258                                                         \n",
       "6363                                               1258                                                         \n",
       "6364                                               1258                                                         \n",
       "6365                                               1258                                                         \n",
       "6366                                               1258                                                         \n",
       "6367                                               1258                                                         \n",
       "6368                                               3707                                                         \n",
       "6369                                               3707                                                         \n",
       "6370                                               3707                                                         \n",
       "6371                                               3707                                                         \n",
       "6372                                               3707                                                         \n",
       "6373                                               3707                                                         \n",
       "6374                                               3707                                                         \n",
       "6375                                               3707                                                         \n",
       "6376                                               3707                                                         \n",
       "6377                                               3707                                                         \n",
       "6378                                               3707                                                         \n",
       "6379                                               3707                                                         \n",
       "6380                                               3707                                                         \n",
       "6381                                               3707                                                         \n",
       "6382                                               3707                                                         \n",
       "6383                                               3707                                                         \n",
       "\n",
       "     Labor Force Participation Rate; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Some college or associate's degree  \\\n",
       "0                                                   NaN                                                                                  \n",
       "1                                                   NaN                                                                                  \n",
       "2                                                   NaN                                                                                  \n",
       "3                                                   NaN                                                                                  \n",
       "4                                                   NaN                                                                                  \n",
       "5                                                   NaN                                                                                  \n",
       "6                                                   NaN                                                                                  \n",
       "7                                                   NaN                                                                                  \n",
       "8                                                   NaN                                                                                  \n",
       "9                                                   NaN                                                                                  \n",
       "10                                                  NaN                                                                                  \n",
       "11                                                  NaN                                                                                  \n",
       "12                                                  NaN                                                                                  \n",
       "13                                                  NaN                                                                                  \n",
       "14                                                  NaN                                                                                  \n",
       "15                                                  NaN                                                                                  \n",
       "16                                                  NaN                                                                                  \n",
       "17                                                  NaN                                                                                  \n",
       "18                                                  NaN                                                                                  \n",
       "19                                                  NaN                                                                                  \n",
       "20                                                  NaN                                                                                  \n",
       "21                                                  NaN                                                                                  \n",
       "22                                                  NaN                                                                                  \n",
       "23                                                  NaN                                                                                  \n",
       "24                                                  NaN                                                                                  \n",
       "25                                                  NaN                                                                                  \n",
       "26                                                  NaN                                                                                  \n",
       "27                                                  NaN                                                                                  \n",
       "28                                                  NaN                                                                                  \n",
       "29                                                  NaN                                                                                  \n",
       "...                                                 ...                                                                                  \n",
       "6354                                               70.7                                                                                  \n",
       "6355                                               70.7                                                                                  \n",
       "6356                                               70.7                                                                                  \n",
       "6357                                               70.7                                                                                  \n",
       "6358                                               70.7                                                                                  \n",
       "6359                                               70.7                                                                                  \n",
       "6360                                               70.7                                                                                  \n",
       "6361                                               70.7                                                                                  \n",
       "6362                                               70.7                                                                                  \n",
       "6363                                               70.7                                                                                  \n",
       "6364                                               70.7                                                                                  \n",
       "6365                                               70.7                                                                                  \n",
       "6366                                               70.7                                                                                  \n",
       "6367                                               70.7                                                                                  \n",
       "6368                                               82.1                                                                                  \n",
       "6369                                               82.1                                                                                  \n",
       "6370                                               82.1                                                                                  \n",
       "6371                                               82.1                                                                                  \n",
       "6372                                               82.1                                                                                  \n",
       "6373                                               82.1                                                                                  \n",
       "6374                                               82.1                                                                                  \n",
       "6375                                               82.1                                                                                  \n",
       "6376                                               82.1                                                                                  \n",
       "6377                                               82.1                                                                                  \n",
       "6378                                               82.1                                                                                  \n",
       "6379                                               82.1                                                                                  \n",
       "6380                                               82.1                                                                                  \n",
       "6381                                               82.1                                                                                  \n",
       "6382                                               82.1                                                                                  \n",
       "6383                                               82.1                                                                                  \n",
       "\n",
       "     Employment/Population Ratio; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Some college or associate's degree  \\\n",
       "0                                                   NaN                                                                               \n",
       "1                                                   NaN                                                                               \n",
       "2                                                   NaN                                                                               \n",
       "3                                                   NaN                                                                               \n",
       "4                                                   NaN                                                                               \n",
       "5                                                   NaN                                                                               \n",
       "6                                                   NaN                                                                               \n",
       "7                                                   NaN                                                                               \n",
       "8                                                   NaN                                                                               \n",
       "9                                                   NaN                                                                               \n",
       "10                                                  NaN                                                                               \n",
       "11                                                  NaN                                                                               \n",
       "12                                                  NaN                                                                               \n",
       "13                                                  NaN                                                                               \n",
       "14                                                  NaN                                                                               \n",
       "15                                                  NaN                                                                               \n",
       "16                                                  NaN                                                                               \n",
       "17                                                  NaN                                                                               \n",
       "18                                                  NaN                                                                               \n",
       "19                                                  NaN                                                                               \n",
       "20                                                  NaN                                                                               \n",
       "21                                                  NaN                                                                               \n",
       "22                                                  NaN                                                                               \n",
       "23                                                  NaN                                                                               \n",
       "24                                                  NaN                                                                               \n",
       "25                                                  NaN                                                                               \n",
       "26                                                  NaN                                                                               \n",
       "27                                                  NaN                                                                               \n",
       "28                                                  NaN                                                                               \n",
       "29                                                  NaN                                                                               \n",
       "...                                                 ...                                                                               \n",
       "6354                                               68.8                                                                               \n",
       "6355                                               68.8                                                                               \n",
       "6356                                               68.8                                                                               \n",
       "6357                                               68.8                                                                               \n",
       "6358                                               68.8                                                                               \n",
       "6359                                               68.8                                                                               \n",
       "6360                                               68.8                                                                               \n",
       "6361                                               68.8                                                                               \n",
       "6362                                               68.8                                                                               \n",
       "6363                                               68.8                                                                               \n",
       "6364                                               68.8                                                                               \n",
       "6365                                               68.8                                                                               \n",
       "6366                                               68.8                                                                               \n",
       "6367                                               68.8                                                                               \n",
       "6368                                               80.4                                                                               \n",
       "6369                                               80.4                                                                               \n",
       "6370                                               80.4                                                                               \n",
       "6371                                               80.4                                                                               \n",
       "6372                                               80.4                                                                               \n",
       "6373                                               80.4                                                                               \n",
       "6374                                               80.4                                                                               \n",
       "6375                                               80.4                                                                               \n",
       "6376                                               80.4                                                                               \n",
       "6377                                               80.4                                                                               \n",
       "6378                                               80.4                                                                               \n",
       "6379                                               80.4                                                                               \n",
       "6380                                               80.4                                                                               \n",
       "6381                                               80.4                                                                               \n",
       "6382                                               80.4                                                                               \n",
       "6383                                               80.4                                                                               \n",
       "\n",
       "     Unemployment rate; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Some college or associate's degree  \\\n",
       "0                                                   NaN                                                                     \n",
       "1                                                   NaN                                                                     \n",
       "2                                                   NaN                                                                     \n",
       "3                                                   NaN                                                                     \n",
       "4                                                   NaN                                                                     \n",
       "5                                                   NaN                                                                     \n",
       "6                                                   NaN                                                                     \n",
       "7                                                   NaN                                                                     \n",
       "8                                                   NaN                                                                     \n",
       "9                                                   NaN                                                                     \n",
       "10                                                  NaN                                                                     \n",
       "11                                                  NaN                                                                     \n",
       "12                                                  NaN                                                                     \n",
       "13                                                  NaN                                                                     \n",
       "14                                                  NaN                                                                     \n",
       "15                                                  NaN                                                                     \n",
       "16                                                  NaN                                                                     \n",
       "17                                                  NaN                                                                     \n",
       "18                                                  NaN                                                                     \n",
       "19                                                  NaN                                                                     \n",
       "20                                                  NaN                                                                     \n",
       "21                                                  NaN                                                                     \n",
       "22                                                  NaN                                                                     \n",
       "23                                                  NaN                                                                     \n",
       "24                                                  NaN                                                                     \n",
       "25                                                  NaN                                                                     \n",
       "26                                                  NaN                                                                     \n",
       "27                                                  NaN                                                                     \n",
       "28                                                  NaN                                                                     \n",
       "29                                                  NaN                                                                     \n",
       "...                                                 ...                                                                     \n",
       "6354                                                1.6                                                                     \n",
       "6355                                                1.6                                                                     \n",
       "6356                                                1.6                                                                     \n",
       "6357                                                1.6                                                                     \n",
       "6358                                                1.6                                                                     \n",
       "6359                                                1.6                                                                     \n",
       "6360                                                1.6                                                                     \n",
       "6361                                                1.6                                                                     \n",
       "6362                                                1.6                                                                     \n",
       "6363                                                1.6                                                                     \n",
       "6364                                                1.6                                                                     \n",
       "6365                                                1.6                                                                     \n",
       "6366                                                1.6                                                                     \n",
       "6367                                                1.6                                                                     \n",
       "6368                                                  2                                                                     \n",
       "6369                                                  2                                                                     \n",
       "6370                                                  2                                                                     \n",
       "6371                                                  2                                                                     \n",
       "6372                                                  2                                                                     \n",
       "6373                                                  2                                                                     \n",
       "6374                                                  2                                                                     \n",
       "6375                                                  2                                                                     \n",
       "6376                                                  2                                                                     \n",
       "6377                                                  2                                                                     \n",
       "6378                                                  2                                                                     \n",
       "6379                                                  2                                                                     \n",
       "6380                                                  2                                                                     \n",
       "6381                                                  2                                                                     \n",
       "6382                                                  2                                                                     \n",
       "6383                                                  2                                                                     \n",
       "\n",
       "     Total; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Bachelor's degree or higher  \\\n",
       "0                                                   NaN                                                  \n",
       "1                                                   NaN                                                  \n",
       "2                                                   NaN                                                  \n",
       "3                                                   NaN                                                  \n",
       "4                                                   NaN                                                  \n",
       "5                                                   NaN                                                  \n",
       "6                                                   NaN                                                  \n",
       "7                                                   NaN                                                  \n",
       "8                                                   NaN                                                  \n",
       "9                                                   NaN                                                  \n",
       "10                                                  NaN                                                  \n",
       "11                                                  NaN                                                  \n",
       "12                                                  NaN                                                  \n",
       "13                                                  NaN                                                  \n",
       "14                                                  NaN                                                  \n",
       "15                                                  NaN                                                  \n",
       "16                                                  NaN                                                  \n",
       "17                                                  NaN                                                  \n",
       "18                                                  NaN                                                  \n",
       "19                                                  NaN                                                  \n",
       "20                                                  NaN                                                  \n",
       "21                                                  NaN                                                  \n",
       "22                                                  NaN                                                  \n",
       "23                                                  NaN                                                  \n",
       "24                                                  NaN                                                  \n",
       "25                                                  NaN                                                  \n",
       "26                                                  NaN                                                  \n",
       "27                                                  NaN                                                  \n",
       "28                                                  NaN                                                  \n",
       "29                                                  NaN                                                  \n",
       "...                                                 ...                                                  \n",
       "6354                                               2503                                                  \n",
       "6355                                               2503                                                  \n",
       "6356                                               2503                                                  \n",
       "6357                                               2503                                                  \n",
       "6358                                               2503                                                  \n",
       "6359                                               2503                                                  \n",
       "6360                                               2503                                                  \n",
       "6361                                               2503                                                  \n",
       "6362                                               2503                                                  \n",
       "6363                                               2503                                                  \n",
       "6364                                               2503                                                  \n",
       "6365                                               2503                                                  \n",
       "6366                                               2503                                                  \n",
       "6367                                               2503                                                  \n",
       "6368                                               4118                                                  \n",
       "6369                                               4118                                                  \n",
       "6370                                               4118                                                  \n",
       "6371                                               4118                                                  \n",
       "6372                                               4118                                                  \n",
       "6373                                               4118                                                  \n",
       "6374                                               4118                                                  \n",
       "6375                                               4118                                                  \n",
       "6376                                               4118                                                  \n",
       "6377                                               4118                                                  \n",
       "6378                                               4118                                                  \n",
       "6379                                               4118                                                  \n",
       "6380                                               4118                                                  \n",
       "6381                                               4118                                                  \n",
       "6382                                               4118                                                  \n",
       "6383                                               4118                                                  \n",
       "\n",
       "     Labor Force Participation Rate; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Bachelor's degree or higher  \\\n",
       "0                                                   NaN                                                                           \n",
       "1                                                   NaN                                                                           \n",
       "2                                                   NaN                                                                           \n",
       "3                                                   NaN                                                                           \n",
       "4                                                   NaN                                                                           \n",
       "5                                                   NaN                                                                           \n",
       "6                                                   NaN                                                                           \n",
       "7                                                   NaN                                                                           \n",
       "8                                                   NaN                                                                           \n",
       "9                                                   NaN                                                                           \n",
       "10                                                  NaN                                                                           \n",
       "11                                                  NaN                                                                           \n",
       "12                                                  NaN                                                                           \n",
       "13                                                  NaN                                                                           \n",
       "14                                                  NaN                                                                           \n",
       "15                                                  NaN                                                                           \n",
       "16                                                  NaN                                                                           \n",
       "17                                                  NaN                                                                           \n",
       "18                                                  NaN                                                                           \n",
       "19                                                  NaN                                                                           \n",
       "20                                                  NaN                                                                           \n",
       "21                                                  NaN                                                                           \n",
       "22                                                  NaN                                                                           \n",
       "23                                                  NaN                                                                           \n",
       "24                                                  NaN                                                                           \n",
       "25                                                  NaN                                                                           \n",
       "26                                                  NaN                                                                           \n",
       "27                                                  NaN                                                                           \n",
       "28                                                  NaN                                                                           \n",
       "29                                                  NaN                                                                           \n",
       "...                                                 ...                                                                           \n",
       "6354                                               80.6                                                                           \n",
       "6355                                               80.6                                                                           \n",
       "6356                                               80.6                                                                           \n",
       "6357                                               80.6                                                                           \n",
       "6358                                               80.6                                                                           \n",
       "6359                                               80.6                                                                           \n",
       "6360                                               80.6                                                                           \n",
       "6361                                               80.6                                                                           \n",
       "6362                                               80.6                                                                           \n",
       "6363                                               80.6                                                                           \n",
       "6364                                               80.6                                                                           \n",
       "6365                                               80.6                                                                           \n",
       "6366                                               80.6                                                                           \n",
       "6367                                               80.6                                                                           \n",
       "6368                                               80.4                                                                           \n",
       "6369                                               80.4                                                                           \n",
       "6370                                               80.4                                                                           \n",
       "6371                                               80.4                                                                           \n",
       "6372                                               80.4                                                                           \n",
       "6373                                               80.4                                                                           \n",
       "6374                                               80.4                                                                           \n",
       "6375                                               80.4                                                                           \n",
       "6376                                               80.4                                                                           \n",
       "6377                                               80.4                                                                           \n",
       "6378                                               80.4                                                                           \n",
       "6379                                               80.4                                                                           \n",
       "6380                                               80.4                                                                           \n",
       "6381                                               80.4                                                                           \n",
       "6382                                               80.4                                                                           \n",
       "6383                                               80.4                                                                           \n",
       "\n",
       "     Employment/Population Ratio; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Bachelor's degree or higher  \\\n",
       "0                                                   NaN                                                                        \n",
       "1                                                   NaN                                                                        \n",
       "2                                                   NaN                                                                        \n",
       "3                                                   NaN                                                                        \n",
       "4                                                   NaN                                                                        \n",
       "5                                                   NaN                                                                        \n",
       "6                                                   NaN                                                                        \n",
       "7                                                   NaN                                                                        \n",
       "8                                                   NaN                                                                        \n",
       "9                                                   NaN                                                                        \n",
       "10                                                  NaN                                                                        \n",
       "11                                                  NaN                                                                        \n",
       "12                                                  NaN                                                                        \n",
       "13                                                  NaN                                                                        \n",
       "14                                                  NaN                                                                        \n",
       "15                                                  NaN                                                                        \n",
       "16                                                  NaN                                                                        \n",
       "17                                                  NaN                                                                        \n",
       "18                                                  NaN                                                                        \n",
       "19                                                  NaN                                                                        \n",
       "20                                                  NaN                                                                        \n",
       "21                                                  NaN                                                                        \n",
       "22                                                  NaN                                                                        \n",
       "23                                                  NaN                                                                        \n",
       "24                                                  NaN                                                                        \n",
       "25                                                  NaN                                                                        \n",
       "26                                                  NaN                                                                        \n",
       "27                                                  NaN                                                                        \n",
       "28                                                  NaN                                                                        \n",
       "29                                                  NaN                                                                        \n",
       "...                                                 ...                                                                        \n",
       "6354                                               75.4                                                                        \n",
       "6355                                               75.4                                                                        \n",
       "6356                                               75.4                                                                        \n",
       "6357                                               75.4                                                                        \n",
       "6358                                               75.4                                                                        \n",
       "6359                                               75.4                                                                        \n",
       "6360                                               75.4                                                                        \n",
       "6361                                               75.4                                                                        \n",
       "6362                                               75.4                                                                        \n",
       "6363                                               75.4                                                                        \n",
       "6364                                               75.4                                                                        \n",
       "6365                                               75.4                                                                        \n",
       "6366                                               75.4                                                                        \n",
       "6367                                               75.4                                                                        \n",
       "6368                                               76.1                                                                        \n",
       "6369                                               76.1                                                                        \n",
       "6370                                               76.1                                                                        \n",
       "6371                                               76.1                                                                        \n",
       "6372                                               76.1                                                                        \n",
       "6373                                               76.1                                                                        \n",
       "6374                                               76.1                                                                        \n",
       "6375                                               76.1                                                                        \n",
       "6376                                               76.1                                                                        \n",
       "6377                                               76.1                                                                        \n",
       "6378                                               76.1                                                                        \n",
       "6379                                               76.1                                                                        \n",
       "6380                                               76.1                                                                        \n",
       "6381                                               76.1                                                                        \n",
       "6382                                               76.1                                                                        \n",
       "6383                                               76.1                                                                        \n",
       "\n",
       "     Unemployment rate; Estimate; EDUCATIONAL ATTAINMENT - Population 25 to 64 years - Bachelor's degree or higher  \n",
       "0                                                   NaN                                                             \n",
       "1                                                   NaN                                                             \n",
       "2                                                   NaN                                                             \n",
       "3                                                   NaN                                                             \n",
       "4                                                   NaN                                                             \n",
       "5                                                   NaN                                                             \n",
       "6                                                   NaN                                                             \n",
       "7                                                   NaN                                                             \n",
       "8                                                   NaN                                                             \n",
       "9                                                   NaN                                                             \n",
       "10                                                  NaN                                                             \n",
       "11                                                  NaN                                                             \n",
       "12                                                  NaN                                                             \n",
       "13                                                  NaN                                                             \n",
       "14                                                  NaN                                                             \n",
       "15                                                  NaN                                                             \n",
       "16                                                  NaN                                                             \n",
       "17                                                  NaN                                                             \n",
       "18                                                  NaN                                                             \n",
       "19                                                  NaN                                                             \n",
       "20                                                  NaN                                                             \n",
       "21                                                  NaN                                                             \n",
       "22                                                  NaN                                                             \n",
       "23                                                  NaN                                                             \n",
       "24                                                  NaN                                                             \n",
       "25                                                  NaN                                                             \n",
       "26                                                  NaN                                                             \n",
       "27                                                  NaN                                                             \n",
       "28                                                  NaN                                                             \n",
       "29                                                  NaN                                                             \n",
       "...                                                 ...                                                             \n",
       "6354                                                3.9                                                             \n",
       "6355                                                3.9                                                             \n",
       "6356                                                3.9                                                             \n",
       "6357                                                3.9                                                             \n",
       "6358                                                3.9                                                             \n",
       "6359                                                3.9                                                             \n",
       "6360                                                3.9                                                             \n",
       "6361                                                3.9                                                             \n",
       "6362                                                3.9                                                             \n",
       "6363                                                3.9                                                             \n",
       "6364                                                3.9                                                             \n",
       "6365                                                3.9                                                             \n",
       "6366                                                3.9                                                             \n",
       "6367                                                3.9                                                             \n",
       "6368                                                4.1                                                             \n",
       "6369                                                4.1                                                             \n",
       "6370                                                4.1                                                             \n",
       "6371                                                4.1                                                             \n",
       "6372                                                4.1                                                             \n",
       "6373                                                4.1                                                             \n",
       "6374                                                4.1                                                             \n",
       "6375                                                4.1                                                             \n",
       "6376                                                4.1                                                             \n",
       "6377                                                4.1                                                             \n",
       "6378                                                4.1                                                             \n",
       "6379                                                4.1                                                             \n",
       "6380                                                4.1                                                             \n",
       "6381                                                4.1                                                             \n",
       "6382                                                4.1                                                             \n",
       "6383                                                4.1                                                             \n",
       "\n",
       "[6384 rows x 835 columns]"
      ]
     },
     "execution_count": 114,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "masterdf2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 145,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict_keys([dtype('int64'), dtype('float64'), dtype('O')])"
      ]
     },
     "execution_count": 145,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "g = masterdf2.columns.to_series().groupby(masterdf2.dtypes).groups\n",
    "g.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 156,
   "metadata": {
    "collapsed": false,
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\577731\\AppData\\Local\\Continuum\\Anaconda3\\lib\\site-packages\\numpy\\ma\\core.py:852: RuntimeWarning: invalid value encountered in greater_equal\n",
      "  return umath.absolute(a) * self.tolerance >= umath.absolute(b)\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "Pipeline(steps=[('imputer', Imputer(axis=0, copy=True, missing_values=1, strategy='mean', verbose=0)), ('forest', RandomForestRegressor(bootstrap=True, criterion='mse', max_depth=None,\n",
       "           max_features='auto', max_leaf_nodes=None,\n",
       "           min_impurity_split=1e-07, min_samples_leaf=1,\n",
       "           min_samples_split=2, min_weight_fraction_leaf=0.0,\n",
       "           n_estimators=100, n_jobs=1, oob_score=False, random_state=0,\n",
       "           verbose=0, warm_start=False))])"
      ]
     },
     "execution_count": 156,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "X_train, X_test, y_train, y_test = train_test_split(X, y, test_size=0.3)\n",
    "\n",
    "\n",
    "# Supervised transformation based on random forests\n",
    "estimator = Pipeline([(\"imputer\", Imputer(missing_values=1,\n",
    "                                          strategy=\"mean\",\n",
    "                                          axis=0)),\n",
    "                      (\"forest\", RandomForestRegressor(random_state=0,\n",
    "                                                       n_estimators=100, oob_score=False))])\n",
    "\n",
    "\n",
    "estimator.fit(X_train, y_train)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 157,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.06519454965046001"
      ]
     },
     "execution_count": 157,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#scoring\n",
    "y_pred = estimator.predict(X_test)\n",
    "\n",
    "estimator.score(X_test, y_test)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#Paramemters for gridge search\n",
    "parameters = dict(feature_selection__k=[100, 200], \n",
    "              random_forest__n_estimators=[50, 100, 200],\n",
    "              random_forest__min_samples_split=[2, 3, 4, 5, 10])\n",
    "\n",
    "cv = sklearn.grid_search.GridSearchCV(estimator, param_grid=parameters)\n",
    "print(classification_report(y, test.target))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "\n",
    "#RF eval.\n",
    "\n",
    "plt.figure(1)\n",
    "plt.plot([0, 1], [0, 1], 'k--')\n",
    "plt.plot(fpr_rt_lm, tpr_rt_lm, label='RT + LR')\n",
    "plt.plot(fpr_rf, tpr_rf, label='RF')\n",
    "plt.plot(fpr_rf_lm, tpr_rf_lm, label='RF + LR')\n",
    "plt.plot(fpr_grd, tpr_grd, label='GBT')\n",
    "plt.plot(fpr_grd_lm, tpr_grd_lm, label='GBT + LR')\n",
    "plt.xlabel('False positive rate')\n",
    "plt.ylabel('True positive rate')\n",
    "plt.title('ROC curve')\n",
    "plt.legend(loc='best')\n",
    "plt.show()\n",
    "\n",
    "plt.figure(2)\n",
    "plt.xlim(0, 0.2)\n",
    "plt.ylim(0.8, 1)\n",
    "plt.plot([0, 1], [0, 1], 'k--')\n",
    "plt.plot(fpr_rt_lm, tpr_rt_lm, label='RT + LR')\n",
    "plt.plot(fpr_rf, tpr_rf, label='RF')\n",
    "plt.plot(fpr_rf_lm, tpr_rf_lm, label='RF + LR')\n",
    "plt.plot(fpr_grd, tpr_grd, label='GBT')\n",
    "plt.plot(fpr_grd_lm, tpr_grd_lm, label='GBT + LR')\n",
    "plt.xlabel('False positive rate')\n",
    "plt.ylabel('True positive rate')\n",
    "plt.title('ROC curve (zoomed in at top left)')\n",
    "plt.legend(loc='best')\n",
    "plt.show()\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}