part3_data_scrubbing.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import string"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This notebook is being used to take raw data from the CDC & NIH and convert into something that can be read by Plotly"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Wonder ny state data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The first data set is from wonder.cdc.gov and just represents each county in NY State, it was found that the text file was tab seperated which was an easy conversion to comma seperated with pandas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 245,
   "metadata": {},
   "outputs": [],
   "source": [
    "nystate = pd.read_csv('./scrubbed by jupyter/Multiple Cause of Death, 1999-2016WONDER_NYSTSATE_with_county_with_race_with_gender.txt')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 246,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Notes\t\"County\"\t\"County Code\"\t\"Ten-Year Age Groups\"\t\"Ten-Year Age Groups Code\"\t\"Year\"\t\"Year Code\"\t\"Gender\"\t\"Gender Code\"\t\"Race\"\t\"Race Code\"\tDeaths\tPopulation\tCrude Rate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>\\t\"Albany County</th>\n",
       "      <td>NY\"\\t\"36001\"\\t\"25-34 years\"\\t\"25-34\"\\t\"2014\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Albany County</th>\n",
       "      <td>NY\"\\t\"36001\"\\t\"45-54 years\"\\t\"45-54\"\\t\"2011\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Albany County</th>\n",
       "      <td>NY\"\\t\"36001\"\\t\"45-54 years\"\\t\"45-54\"\\t\"2013\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Albany County</th>\n",
       "      <td>NY\"\\t\"36001\"\\t\"55-64 years\"\\t\"55-64\"\\t\"2014\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Bronx County</th>\n",
       "      <td>NY\"\\t\"36005\"\\t\"15-24 years\"\\t\"15-24\"\\t\"2016\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Bronx County</th>\n",
       "      <td>NY\"\\t\"36005\"\\t\"25-34 years\"\\t\"25-34\"\\t\"2010\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Bronx County</th>\n",
       "      <td>NY\"\\t\"36005\"\\t\"25-34 years\"\\t\"25-34\"\\t\"2011\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Bronx County</th>\n",
       "      <td>NY\"\\t\"36005\"\\t\"25-34 years\"\\t\"25-34\"\\t\"2012\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Bronx County</th>\n",
       "      <td>NY\"\\t\"36005\"\\t\"25-34 years\"\\t\"25-34\"\\t\"2013\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Bronx County</th>\n",
       "      <td>NY\"\\t\"36005\"\\t\"25-34 years\"\\t\"25-34\"\\t\"2014\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Bronx County</th>\n",
       "      <td>NY\"\\t\"36005\"\\t\"25-34 years\"\\t\"25-34\"\\t\"2015\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Bronx County</th>\n",
       "      <td>NY\"\\t\"36005\"\\t\"25-34 years\"\\t\"25-34\"\\t\"2016\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Bronx County</th>\n",
       "      <td>NY\"\\t\"36005\"\\t\"35-44 years\"\\t\"35-44\"\\t\"2010\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Bronx County</th>\n",
       "      <td>NY\"\\t\"36005\"\\t\"35-44 years\"\\t\"35-44\"\\t\"2011\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Bronx County</th>\n",
       "      <td>NY\"\\t\"36005\"\\t\"35-44 years\"\\t\"35-44\"\\t\"2011\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Bronx County</th>\n",
       "      <td>NY\"\\t\"36005\"\\t\"35-44 years\"\\t\"35-44\"\\t\"2012\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Bronx County</th>\n",
       "      <td>NY\"\\t\"36005\"\\t\"35-44 years\"\\t\"35-44\"\\t\"2012\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Bronx County</th>\n",
       "      <td>NY\"\\t\"36005\"\\t\"35-44 years\"\\t\"35-44\"\\t\"2013\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Bronx County</th>\n",
       "      <td>NY\"\\t\"36005\"\\t\"35-44 years\"\\t\"35-44\"\\t\"2013\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Bronx County</th>\n",
       "      <td>NY\"\\t\"36005\"\\t\"35-44 years\"\\t\"35-44\"\\t\"2013\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Bronx County</th>\n",
       "      <td>NY\"\\t\"36005\"\\t\"35-44 years\"\\t\"35-44\"\\t\"2014\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Bronx County</th>\n",
       "      <td>NY\"\\t\"36005\"\\t\"35-44 years\"\\t\"35-44\"\\t\"2014\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Bronx County</th>\n",
       "      <td>NY\"\\t\"36005\"\\t\"35-44 years\"\\t\"35-44\"\\t\"2015\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Bronx County</th>\n",
       "      <td>NY\"\\t\"36005\"\\t\"35-44 years\"\\t\"35-44\"\\t\"2015\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Bronx County</th>\n",
       "      <td>NY\"\\t\"36005\"\\t\"35-44 years\"\\t\"35-44\"\\t\"2016\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Bronx County</th>\n",
       "      <td>NY\"\\t\"36005\"\\t\"35-44 years\"\\t\"35-44\"\\t\"2016\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Bronx County</th>\n",
       "      <td>NY\"\\t\"36005\"\\t\"45-54 years\"\\t\"45-54\"\\t\"2010\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Bronx County</th>\n",
       "      <td>NY\"\\t\"36005\"\\t\"45-54 years\"\\t\"45-54\"\\t\"2010\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Bronx County</th>\n",
       "      <td>NY\"\\t\"36005\"\\t\"45-54 years\"\\t\"45-54\"\\t\"2010\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>\\t\"Bronx County</th>\n",
       "      <td>NY\"\\t\"36005\"\\t\"45-54 years\"\\t\"45-54\"\\t\"2010\"\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>---</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Caveats:</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1. As of April 3, 2017, the underlying cause of death has been revised for 125 deaths in 2014. More information:</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://wonder.cdc.gov/wonder/help/mcd.html#2014-Revision.</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2. Data are Suppressed when the data meet the criteria for confidentiality constraints. More information:</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://wonder.cdc.gov/wonder/help/mcd.html#Assurance of Confidentiality.</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3. Death rates are flagged as Unreliable when the rate is calculated with a numerator of 20 or less. More information:</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://wonder.cdc.gov/wonder/help/mcd.html#Unreliable.</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4. Deaths of persons with Age \"Not Stated\" are included in \"All\" counts and rates, but are not distributed among age groups,</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>so are not included in age-specific counts, age-specific rates or in any age-adjusted rates. More information:</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://wonder.cdc.gov/wonder/help/mcd.html#Not Stated.</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5. Information included on the death certificate about the race and Hispanic ethnicity of the decedent is reported by the</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>funeral director as provided by an informant, often the surviving next of kin, or, in the absence of an informant, on the basis</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>of observation. Race and ethnicity information from the census is by self-report. To the extent that race and Hispanic origin</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>are inconsistent between these two data sources, death rates will be biased. More information:</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://wonder.cdc.gov/wonder/help/mcd.html#Racial Differences.</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6. The population figures for year 2016 are bridged-race estimates of the July 1 resident population, from the Vintage 2016</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>postcensal series released by NCHS on June 26, 2017. The population figures for year 2015 are bridged-race estimates of the July</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1 resident population, from the Vintage 2015 postcensal series released by NCHS on June 28, 2016. The population figures for</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>year 2014 are bridged-race estimates of the July 1 resident population, from the Vintage 2014 postcensal series released by NCHS</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>on June 30, 2015. The population figures for year 2013 are bridged-race estimates of the July 1 resident population, from the</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Vintage 2013 postcensal series released by NCHS on June 26, 2014. The population figures for year 2012 are bridged-race</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>estimates of the July 1 resident population, from the Vintage 2012 postcensal series released by NCHS on June 13, 2013.</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Population figures for 2011 are bridged-race estimates of the July 1 resident population, from the county-level postcensal</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Vintage 2011 series released by NCHS on July 18, 2012. Population figures for 2010 are April 1 Census counts. The population</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>figures for years 2001 - 2009, are bridged-race estimates of the July 1 resident population, from the revised intercensal</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>county-level 2000 - 2009 series released by NCHS on October 26, 2012. Population figures for 2000 are April 1 Census counts.</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Population figures for 1999 are from the 1990-1999 intercensal series of July 1 estimates. Population figures for Infant Age</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Groups are the number of live births. &lt;br/&gt;&lt;b&gt;Note:&lt;/b&gt; Rates and population figures for years 2001 - 2009 differ slightly from</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>previously published reports, due to use of the population estimates which were available at the time of release.</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>777 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   Notes\\t\"County\"\\t\"County Code\"\\t\"Ten-Year Age Groups\"\\t\"Ten-Year Age Groups Code\"\\t\"Year\"\\t\"Year Code\"\\t\"Gender\"\\t\"Gender Code\"\\t\"Race\"\\t\"Race Code\"\\tDeaths\\tPopulation\\tCrude Rate\n",
       "\\t\"Albany County                                     NY\"\\t\"36001\"\\t\"25-34 years\"\\t\"25-34\"\\t\"2014\"\\...                                                                                                                                  \n",
       "\\t\"Albany County                                     NY\"\\t\"36001\"\\t\"45-54 years\"\\t\"45-54\"\\t\"2011\"\\...                                                                                                                                  \n",
       "\\t\"Albany County                                     NY\"\\t\"36001\"\\t\"45-54 years\"\\t\"45-54\"\\t\"2013\"\\...                                                                                                                                  \n",
       "\\t\"Albany County                                     NY\"\\t\"36001\"\\t\"55-64 years\"\\t\"55-64\"\\t\"2014\"\\...                                                                                                                                  \n",
       "\\t\"Bronx County                                      NY\"\\t\"36005\"\\t\"15-24 years\"\\t\"15-24\"\\t\"2016\"\\...                                                                                                                                  \n",
       "\\t\"Bronx County                                      NY\"\\t\"36005\"\\t\"25-34 years\"\\t\"25-34\"\\t\"2010\"\\...                                                                                                                                  \n",
       "\\t\"Bronx County                                      NY\"\\t\"36005\"\\t\"25-34 years\"\\t\"25-34\"\\t\"2011\"\\...                                                                                                                                  \n",
       "\\t\"Bronx County                                      NY\"\\t\"36005\"\\t\"25-34 years\"\\t\"25-34\"\\t\"2012\"\\...                                                                                                                                  \n",
       "\\t\"Bronx County                                      NY\"\\t\"36005\"\\t\"25-34 years\"\\t\"25-34\"\\t\"2013\"\\...                                                                                                                                  \n",
       "\\t\"Bronx County                                      NY\"\\t\"36005\"\\t\"25-34 years\"\\t\"25-34\"\\t\"2014\"\\...                                                                                                                                  \n",
       "\\t\"Bronx County                                      NY\"\\t\"36005\"\\t\"25-34 years\"\\t\"25-34\"\\t\"2015\"\\...                                                                                                                                  \n",
       "\\t\"Bronx County                                      NY\"\\t\"36005\"\\t\"25-34 years\"\\t\"25-34\"\\t\"2016\"\\...                                                                                                                                  \n",
       "\\t\"Bronx County                                      NY\"\\t\"36005\"\\t\"35-44 years\"\\t\"35-44\"\\t\"2010\"\\...                                                                                                                                  \n",
       "\\t\"Bronx County                                      NY\"\\t\"36005\"\\t\"35-44 years\"\\t\"35-44\"\\t\"2011\"\\...                                                                                                                                  \n",
       "\\t\"Bronx County                                      NY\"\\t\"36005\"\\t\"35-44 years\"\\t\"35-44\"\\t\"2011\"\\...                                                                                                                                  \n",
       "\\t\"Bronx County                                      NY\"\\t\"36005\"\\t\"35-44 years\"\\t\"35-44\"\\t\"2012\"\\...                                                                                                                                  \n",
       "\\t\"Bronx County                                      NY\"\\t\"36005\"\\t\"35-44 years\"\\t\"35-44\"\\t\"2012\"\\...                                                                                                                                  \n",
       "\\t\"Bronx County                                      NY\"\\t\"36005\"\\t\"35-44 years\"\\t\"35-44\"\\t\"2013\"\\...                                                                                                                                  \n",
       "\\t\"Bronx County                                      NY\"\\t\"36005\"\\t\"35-44 years\"\\t\"35-44\"\\t\"2013\"\\...                                                                                                                                  \n",
       "\\t\"Bronx County                                      NY\"\\t\"36005\"\\t\"35-44 years\"\\t\"35-44\"\\t\"2013\"\\...                                                                                                                                  \n",
       "\\t\"Bronx County                                      NY\"\\t\"36005\"\\t\"35-44 years\"\\t\"35-44\"\\t\"2014\"\\...                                                                                                                                  \n",
       "\\t\"Bronx County                                      NY\"\\t\"36005\"\\t\"35-44 years\"\\t\"35-44\"\\t\"2014\"\\...                                                                                                                                  \n",
       "\\t\"Bronx County                                      NY\"\\t\"36005\"\\t\"35-44 years\"\\t\"35-44\"\\t\"2015\"\\...                                                                                                                                  \n",
       "\\t\"Bronx County                                      NY\"\\t\"36005\"\\t\"35-44 years\"\\t\"35-44\"\\t\"2015\"\\...                                                                                                                                  \n",
       "\\t\"Bronx County                                      NY\"\\t\"36005\"\\t\"35-44 years\"\\t\"35-44\"\\t\"2016\"\\...                                                                                                                                  \n",
       "\\t\"Bronx County                                      NY\"\\t\"36005\"\\t\"35-44 years\"\\t\"35-44\"\\t\"2016\"\\...                                                                                                                                  \n",
       "\\t\"Bronx County                                      NY\"\\t\"36005\"\\t\"45-54 years\"\\t\"45-54\"\\t\"2010\"\\...                                                                                                                                  \n",
       "\\t\"Bronx County                                      NY\"\\t\"36005\"\\t\"45-54 years\"\\t\"45-54\"\\t\"2010\"\\...                                                                                                                                  \n",
       "\\t\"Bronx County                                      NY\"\\t\"36005\"\\t\"45-54 years\"\\t\"45-54\"\\t\"2010\"\\...                                                                                                                                  \n",
       "\\t\"Bronx County                                      NY\"\\t\"36005\"\\t\"45-54 years\"\\t\"45-54\"\\t\"2010\"\\...                                                                                                                                  \n",
       "...                                                                                               ...                                                                                                                                  \n",
       "---                                                                                               NaN                                                                                                                                  \n",
       "Caveats:                                                                                          NaN                                                                                                                                  \n",
       "1. As of April 3, 2017, the underlying cause of...                                                NaN                                                                                                                                  \n",
       "http://wonder.cdc.gov/wonder/help/mcd.html#2014...                                                NaN                                                                                                                                  \n",
       "2. Data are Suppressed when the data meet the c...                                                NaN                                                                                                                                  \n",
       "http://wonder.cdc.gov/wonder/help/mcd.html#Assu...                                                NaN                                                                                                                                  \n",
       "3. Death rates are flagged as Unreliable when t...                                                NaN                                                                                                                                  \n",
       "http://wonder.cdc.gov/wonder/help/mcd.html#Unre...                                                NaN                                                                                                                                  \n",
       "4. Deaths of persons with Age \"Not Stated\" are ...                                                NaN                                                                                                                                  \n",
       "so are not included in age-specific counts, age...                                                NaN                                                                                                                                  \n",
       "http://wonder.cdc.gov/wonder/help/mcd.html#Not ...                                                NaN                                                                                                                                  \n",
       "5. Information included on the death certificat...                                                NaN                                                                                                                                  \n",
       "funeral director as provided by an informant, o...                                                NaN                                                                                                                                  \n",
       "of observation. Race and ethnicity information ...                                                NaN                                                                                                                                  \n",
       "are inconsistent between these two data sources...                                                NaN                                                                                                                                  \n",
       "http://wonder.cdc.gov/wonder/help/mcd.html#Raci...                                                NaN                                                                                                                                  \n",
       "6. The population figures for year 2016 are bri...                                                NaN                                                                                                                                  \n",
       "postcensal series released by NCHS on June 26, ...                                                NaN                                                                                                                                  \n",
       "1 resident population, from the Vintage 2015 po...                                                NaN                                                                                                                                  \n",
       "year 2014 are bridged-race estimates of the Jul...                                                NaN                                                                                                                                  \n",
       "on June 30, 2015. The population figures for ye...                                                NaN                                                                                                                                  \n",
       "Vintage 2013 postcensal series released by NCHS...                                                NaN                                                                                                                                  \n",
       "estimates of the July 1 resident population, fr...                                                NaN                                                                                                                                  \n",
       "Population figures for 2011 are bridged-race es...                                                NaN                                                                                                                                  \n",
       "Vintage 2011 series released by NCHS on July 18...                                                NaN                                                                                                                                  \n",
       "figures for years 2001 - 2009, are bridged-race...                                                NaN                                                                                                                                  \n",
       "county-level 2000 - 2009 series released by NCH...                                                NaN                                                                                                                                  \n",
       "Population figures for 1999 are from the 1990-1...                                                NaN                                                                                                                                  \n",
       "Groups are the number of live births. <br/><b>N...                                                NaN                                                                                                                                  \n",
       "previously published reports, due to use of the...                                                NaN                                                                                                                                  \n",
       "\n",
       "[777 rows x 1 columns]"
      ]
     },
     "execution_count": 246,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nystate"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 247,
   "metadata": {},
   "outputs": [],
   "source": [
    "nystate = pd.read_csv('./scrubbed by jupyter/Multiple Cause of Death, 1999-2016WONDER_NYSTSATE_with_county_with_race_with_gender.txt', sep=\"\\t\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 248,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Notes</th>\n",
       "      <th>County</th>\n",
       "      <th>County Code</th>\n",
       "      <th>Ten-Year Age Groups</th>\n",
       "      <th>Ten-Year Age Groups Code</th>\n",
       "      <th>Year</th>\n",
       "      <th>Year Code</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Gender Code</th>\n",
       "      <th>Race</th>\n",
       "      <th>Race Code</th>\n",
       "      <th>Deaths</th>\n",
       "      <th>Population</th>\n",
       "      <th>Crude Rate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Albany County, NY</td>\n",
       "      <td>36001.0</td>\n",
       "      <td>25-34 years</td>\n",
       "      <td>25-34</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>11.0</td>\n",
       "      <td>15534.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Albany County, NY</td>\n",
       "      <td>36001.0</td>\n",
       "      <td>45-54 years</td>\n",
       "      <td>45-54</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>12.0</td>\n",
       "      <td>17900.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Albany County, NY</td>\n",
       "      <td>36001.0</td>\n",
       "      <td>45-54 years</td>\n",
       "      <td>45-54</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>12.0</td>\n",
       "      <td>17091.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Albany County, NY</td>\n",
       "      <td>36001.0</td>\n",
       "      <td>55-64 years</td>\n",
       "      <td>55-64</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>11.0</td>\n",
       "      <td>16853.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>15-24 years</td>\n",
       "      <td>15-24</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>14.0</td>\n",
       "      <td>50085.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>25-34 years</td>\n",
       "      <td>25-34</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>17.0</td>\n",
       "      <td>45341.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>25-34 years</td>\n",
       "      <td>25-34</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>22.0</td>\n",
       "      <td>46848.0</td>\n",
       "      <td>47.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>25-34 years</td>\n",
       "      <td>25-34</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>25.0</td>\n",
       "      <td>47267.0</td>\n",
       "      <td>52.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>25-34 years</td>\n",
       "      <td>25-34</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>19.0</td>\n",
       "      <td>48813.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>25-34 years</td>\n",
       "      <td>25-34</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>21.0</td>\n",
       "      <td>50145.0</td>\n",
       "      <td>41.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>25-34 years</td>\n",
       "      <td>25-34</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>34.0</td>\n",
       "      <td>51280.0</td>\n",
       "      <td>66.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>25-34 years</td>\n",
       "      <td>25-34</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>30.0</td>\n",
       "      <td>51890.0</td>\n",
       "      <td>57.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>29.0</td>\n",
       "      <td>40212.0</td>\n",
       "      <td>72.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>Black or African American</td>\n",
       "      <td>2054-5</td>\n",
       "      <td>12.0</td>\n",
       "      <td>36898.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>31.0</td>\n",
       "      <td>39682.0</td>\n",
       "      <td>78.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>F</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>12.0</td>\n",
       "      <td>43185.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>25.0</td>\n",
       "      <td>39817.0</td>\n",
       "      <td>62.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>F</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>11.0</td>\n",
       "      <td>42989.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>Black or African American</td>\n",
       "      <td>2054-5</td>\n",
       "      <td>12.0</td>\n",
       "      <td>36637.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>28.0</td>\n",
       "      <td>39673.0</td>\n",
       "      <td>70.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>F</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>10.0</td>\n",
       "      <td>43545.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>36.0</td>\n",
       "      <td>39588.0</td>\n",
       "      <td>90.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>F</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>15.0</td>\n",
       "      <td>44308.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>34.0</td>\n",
       "      <td>39912.0</td>\n",
       "      <td>85.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>F</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>19.0</td>\n",
       "      <td>43358.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>57.0</td>\n",
       "      <td>39508.0</td>\n",
       "      <td>144.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>45-54 years</td>\n",
       "      <td>45-54</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>F</td>\n",
       "      <td>Black or African American</td>\n",
       "      <td>2054-5</td>\n",
       "      <td>10.0</td>\n",
       "      <td>49095.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>45-54 years</td>\n",
       "      <td>45-54</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>F</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>17.0</td>\n",
       "      <td>43643.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>45-54 years</td>\n",
       "      <td>45-54</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>Black or African American</td>\n",
       "      <td>2054-5</td>\n",
       "      <td>15.0</td>\n",
       "      <td>39649.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>45-54 years</td>\n",
       "      <td>45-54</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>59.0</td>\n",
       "      <td>38040.0</td>\n",
       "      <td>155.1</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>747</th>\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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>748</th>\n",
       "      <td>Caveats:</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>749</th>\n",
       "      <td>1. As of April 3, 2017, the underlying cause o...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>750</th>\n",
       "      <td>http://wonder.cdc.gov/wonder/help/mcd.html#201...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>751</th>\n",
       "      <td>2. Data are Suppressed when the data meet the ...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>752</th>\n",
       "      <td>http://wonder.cdc.gov/wonder/help/mcd.html#Ass...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>753</th>\n",
       "      <td>3. Death rates are flagged as Unreliable when ...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>754</th>\n",
       "      <td>http://wonder.cdc.gov/wonder/help/mcd.html#Unr...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>755</th>\n",
       "      <td>4. Deaths of persons with Age \"Not Stated\" are...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>756</th>\n",
       "      <td>so are not included in age-specific counts, ag...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>757</th>\n",
       "      <td>http://wonder.cdc.gov/wonder/help/mcd.html#Not...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>758</th>\n",
       "      <td>5. Information included on the death certifica...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>759</th>\n",
       "      <td>funeral director as provided by an informant, ...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760</th>\n",
       "      <td>of observation. Race and ethnicity information...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>761</th>\n",
       "      <td>are inconsistent between these two data source...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>762</th>\n",
       "      <td>http://wonder.cdc.gov/wonder/help/mcd.html#Rac...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>763</th>\n",
       "      <td>6. The population figures for year 2016 are br...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>764</th>\n",
       "      <td>postcensal series released by NCHS on June 26,...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>765</th>\n",
       "      <td>1 resident population, from the Vintage 2015 p...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>766</th>\n",
       "      <td>year 2014 are bridged-race estimates of the Ju...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>767</th>\n",
       "      <td>on June 30, 2015. The population figures for y...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>768</th>\n",
       "      <td>Vintage 2013 postcensal series released by NCH...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>769</th>\n",
       "      <td>estimates of the July 1 resident population, f...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>770</th>\n",
       "      <td>Population figures for 2011 are bridged-race e...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>771</th>\n",
       "      <td>Vintage 2011 series released by NCHS on July 1...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>772</th>\n",
       "      <td>figures for years 2001 - 2009, are bridged-rac...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>773</th>\n",
       "      <td>county-level 2000 - 2009 series released by NC...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>774</th>\n",
       "      <td>Population figures for 1999 are from the 1990-...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775</th>\n",
       "      <td>Groups are the number of live births. &lt;br/&gt;&lt;b&gt;...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>776</th>\n",
       "      <td>previously published reports, due to use of th...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>777 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 Notes             County  \\\n",
       "0                                                  NaN  Albany County, NY   \n",
       "1                                                  NaN  Albany County, NY   \n",
       "2                                                  NaN  Albany County, NY   \n",
       "3                                                  NaN  Albany County, NY   \n",
       "4                                                  NaN   Bronx County, NY   \n",
       "5                                                  NaN   Bronx County, NY   \n",
       "6                                                  NaN   Bronx County, NY   \n",
       "7                                                  NaN   Bronx County, NY   \n",
       "8                                                  NaN   Bronx County, NY   \n",
       "9                                                  NaN   Bronx County, NY   \n",
       "10                                                 NaN   Bronx County, NY   \n",
       "11                                                 NaN   Bronx County, NY   \n",
       "12                                                 NaN   Bronx County, NY   \n",
       "13                                                 NaN   Bronx County, NY   \n",
       "14                                                 NaN   Bronx County, NY   \n",
       "15                                                 NaN   Bronx County, NY   \n",
       "16                                                 NaN   Bronx County, NY   \n",
       "17                                                 NaN   Bronx County, NY   \n",
       "18                                                 NaN   Bronx County, NY   \n",
       "19                                                 NaN   Bronx County, NY   \n",
       "20                                                 NaN   Bronx County, NY   \n",
       "21                                                 NaN   Bronx County, NY   \n",
       "22                                                 NaN   Bronx County, NY   \n",
       "23                                                 NaN   Bronx County, NY   \n",
       "24                                                 NaN   Bronx County, NY   \n",
       "25                                                 NaN   Bronx County, NY   \n",
       "26                                                 NaN   Bronx County, NY   \n",
       "27                                                 NaN   Bronx County, NY   \n",
       "28                                                 NaN   Bronx County, NY   \n",
       "29                                                 NaN   Bronx County, NY   \n",
       "..                                                 ...                ...   \n",
       "747                                                ---                NaN   \n",
       "748                                           Caveats:                NaN   \n",
       "749  1. As of April 3, 2017, the underlying cause o...                NaN   \n",
       "750  http://wonder.cdc.gov/wonder/help/mcd.html#201...                NaN   \n",
       "751  2. Data are Suppressed when the data meet the ...                NaN   \n",
       "752  http://wonder.cdc.gov/wonder/help/mcd.html#Ass...                NaN   \n",
       "753  3. Death rates are flagged as Unreliable when ...                NaN   \n",
       "754  http://wonder.cdc.gov/wonder/help/mcd.html#Unr...                NaN   \n",
       "755  4. Deaths of persons with Age \"Not Stated\" are...                NaN   \n",
       "756  so are not included in age-specific counts, ag...                NaN   \n",
       "757  http://wonder.cdc.gov/wonder/help/mcd.html#Not...                NaN   \n",
       "758  5. Information included on the death certifica...                NaN   \n",
       "759  funeral director as provided by an informant, ...                NaN   \n",
       "760  of observation. Race and ethnicity information...                NaN   \n",
       "761  are inconsistent between these two data source...                NaN   \n",
       "762  http://wonder.cdc.gov/wonder/help/mcd.html#Rac...                NaN   \n",
       "763  6. The population figures for year 2016 are br...                NaN   \n",
       "764  postcensal series released by NCHS on June 26,...                NaN   \n",
       "765  1 resident population, from the Vintage 2015 p...                NaN   \n",
       "766  year 2014 are bridged-race estimates of the Ju...                NaN   \n",
       "767  on June 30, 2015. The population figures for y...                NaN   \n",
       "768  Vintage 2013 postcensal series released by NCH...                NaN   \n",
       "769  estimates of the July 1 resident population, f...                NaN   \n",
       "770  Population figures for 2011 are bridged-race e...                NaN   \n",
       "771  Vintage 2011 series released by NCHS on July 1...                NaN   \n",
       "772  figures for years 2001 - 2009, are bridged-rac...                NaN   \n",
       "773  county-level 2000 - 2009 series released by NC...                NaN   \n",
       "774  Population figures for 1999 are from the 1990-...                NaN   \n",
       "775  Groups are the number of live births. <br/><b>...                NaN   \n",
       "776  previously published reports, due to use of th...                NaN   \n",
       "\n",
       "     County Code Ten-Year Age Groups Ten-Year Age Groups Code    Year  \\\n",
       "0        36001.0         25-34 years                    25-34  2014.0   \n",
       "1        36001.0         45-54 years                    45-54  2011.0   \n",
       "2        36001.0         45-54 years                    45-54  2013.0   \n",
       "3        36001.0         55-64 years                    55-64  2014.0   \n",
       "4        36005.0         15-24 years                    15-24  2016.0   \n",
       "5        36005.0         25-34 years                    25-34  2010.0   \n",
       "6        36005.0         25-34 years                    25-34  2011.0   \n",
       "7        36005.0         25-34 years                    25-34  2012.0   \n",
       "8        36005.0         25-34 years                    25-34  2013.0   \n",
       "9        36005.0         25-34 years                    25-34  2014.0   \n",
       "10       36005.0         25-34 years                    25-34  2015.0   \n",
       "11       36005.0         25-34 years                    25-34  2016.0   \n",
       "12       36005.0         35-44 years                    35-44  2010.0   \n",
       "13       36005.0         35-44 years                    35-44  2011.0   \n",
       "14       36005.0         35-44 years                    35-44  2011.0   \n",
       "15       36005.0         35-44 years                    35-44  2012.0   \n",
       "16       36005.0         35-44 years                    35-44  2012.0   \n",
       "17       36005.0         35-44 years                    35-44  2013.0   \n",
       "18       36005.0         35-44 years                    35-44  2013.0   \n",
       "19       36005.0         35-44 years                    35-44  2013.0   \n",
       "20       36005.0         35-44 years                    35-44  2014.0   \n",
       "21       36005.0         35-44 years                    35-44  2014.0   \n",
       "22       36005.0         35-44 years                    35-44  2015.0   \n",
       "23       36005.0         35-44 years                    35-44  2015.0   \n",
       "24       36005.0         35-44 years                    35-44  2016.0   \n",
       "25       36005.0         35-44 years                    35-44  2016.0   \n",
       "26       36005.0         45-54 years                    45-54  2010.0   \n",
       "27       36005.0         45-54 years                    45-54  2010.0   \n",
       "28       36005.0         45-54 years                    45-54  2010.0   \n",
       "29       36005.0         45-54 years                    45-54  2010.0   \n",
       "..           ...                 ...                      ...     ...   \n",
       "747          NaN                 NaN                      NaN     NaN   \n",
       "748          NaN                 NaN                      NaN     NaN   \n",
       "749          NaN                 NaN                      NaN     NaN   \n",
       "750          NaN                 NaN                      NaN     NaN   \n",
       "751          NaN                 NaN                      NaN     NaN   \n",
       "752          NaN                 NaN                      NaN     NaN   \n",
       "753          NaN                 NaN                      NaN     NaN   \n",
       "754          NaN                 NaN                      NaN     NaN   \n",
       "755          NaN                 NaN                      NaN     NaN   \n",
       "756          NaN                 NaN                      NaN     NaN   \n",
       "757          NaN                 NaN                      NaN     NaN   \n",
       "758          NaN                 NaN                      NaN     NaN   \n",
       "759          NaN                 NaN                      NaN     NaN   \n",
       "760          NaN                 NaN                      NaN     NaN   \n",
       "761          NaN                 NaN                      NaN     NaN   \n",
       "762          NaN                 NaN                      NaN     NaN   \n",
       "763          NaN                 NaN                      NaN     NaN   \n",
       "764          NaN                 NaN                      NaN     NaN   \n",
       "765          NaN                 NaN                      NaN     NaN   \n",
       "766          NaN                 NaN                      NaN     NaN   \n",
       "767          NaN                 NaN                      NaN     NaN   \n",
       "768          NaN                 NaN                      NaN     NaN   \n",
       "769          NaN                 NaN                      NaN     NaN   \n",
       "770          NaN                 NaN                      NaN     NaN   \n",
       "771          NaN                 NaN                      NaN     NaN   \n",
       "772          NaN                 NaN                      NaN     NaN   \n",
       "773          NaN                 NaN                      NaN     NaN   \n",
       "774          NaN                 NaN                      NaN     NaN   \n",
       "775          NaN                 NaN                      NaN     NaN   \n",
       "776          NaN                 NaN                      NaN     NaN   \n",
       "\n",
       "     Year Code  Gender Gender Code                       Race Race Code  \\\n",
       "0       2014.0    Male           M                      White    2106-3   \n",
       "1       2011.0    Male           M                      White    2106-3   \n",
       "2       2013.0    Male           M                      White    2106-3   \n",
       "3       2014.0    Male           M                      White    2106-3   \n",
       "4       2016.0    Male           M                      White    2106-3   \n",
       "5       2010.0    Male           M                      White    2106-3   \n",
       "6       2011.0    Male           M                      White    2106-3   \n",
       "7       2012.0    Male           M                      White    2106-3   \n",
       "8       2013.0    Male           M                      White    2106-3   \n",
       "9       2014.0    Male           M                      White    2106-3   \n",
       "10      2015.0    Male           M                      White    2106-3   \n",
       "11      2016.0    Male           M                      White    2106-3   \n",
       "12      2010.0    Male           M                      White    2106-3   \n",
       "13      2011.0    Male           M  Black or African American    2054-5   \n",
       "14      2011.0    Male           M                      White    2106-3   \n",
       "15      2012.0  Female           F                      White    2106-3   \n",
       "16      2012.0    Male           M                      White    2106-3   \n",
       "17      2013.0  Female           F                      White    2106-3   \n",
       "18      2013.0    Male           M  Black or African American    2054-5   \n",
       "19      2013.0    Male           M                      White    2106-3   \n",
       "20      2014.0  Female           F                      White    2106-3   \n",
       "21      2014.0    Male           M                      White    2106-3   \n",
       "22      2015.0  Female           F                      White    2106-3   \n",
       "23      2015.0    Male           M                      White    2106-3   \n",
       "24      2016.0  Female           F                      White    2106-3   \n",
       "25      2016.0    Male           M                      White    2106-3   \n",
       "26      2010.0  Female           F  Black or African American    2054-5   \n",
       "27      2010.0  Female           F                      White    2106-3   \n",
       "28      2010.0    Male           M  Black or African American    2054-5   \n",
       "29      2010.0    Male           M                      White    2106-3   \n",
       "..         ...     ...         ...                        ...       ...   \n",
       "747        NaN     NaN         NaN                        NaN       NaN   \n",
       "748        NaN     NaN         NaN                        NaN       NaN   \n",
       "749        NaN     NaN         NaN                        NaN       NaN   \n",
       "750        NaN     NaN         NaN                        NaN       NaN   \n",
       "751        NaN     NaN         NaN                        NaN       NaN   \n",
       "752        NaN     NaN         NaN                        NaN       NaN   \n",
       "753        NaN     NaN         NaN                        NaN       NaN   \n",
       "754        NaN     NaN         NaN                        NaN       NaN   \n",
       "755        NaN     NaN         NaN                        NaN       NaN   \n",
       "756        NaN     NaN         NaN                        NaN       NaN   \n",
       "757        NaN     NaN         NaN                        NaN       NaN   \n",
       "758        NaN     NaN         NaN                        NaN       NaN   \n",
       "759        NaN     NaN         NaN                        NaN       NaN   \n",
       "760        NaN     NaN         NaN                        NaN       NaN   \n",
       "761        NaN     NaN         NaN                        NaN       NaN   \n",
       "762        NaN     NaN         NaN                        NaN       NaN   \n",
       "763        NaN     NaN         NaN                        NaN       NaN   \n",
       "764        NaN     NaN         NaN                        NaN       NaN   \n",
       "765        NaN     NaN         NaN                        NaN       NaN   \n",
       "766        NaN     NaN         NaN                        NaN       NaN   \n",
       "767        NaN     NaN         NaN                        NaN       NaN   \n",
       "768        NaN     NaN         NaN                        NaN       NaN   \n",
       "769        NaN     NaN         NaN                        NaN       NaN   \n",
       "770        NaN     NaN         NaN                        NaN       NaN   \n",
       "771        NaN     NaN         NaN                        NaN       NaN   \n",
       "772        NaN     NaN         NaN                        NaN       NaN   \n",
       "773        NaN     NaN         NaN                        NaN       NaN   \n",
       "774        NaN     NaN         NaN                        NaN       NaN   \n",
       "775        NaN     NaN         NaN                        NaN       NaN   \n",
       "776        NaN     NaN         NaN                        NaN       NaN   \n",
       "\n",
       "     Deaths  Population  Crude Rate  \n",
       "0      11.0     15534.0  Unreliable  \n",
       "1      12.0     17900.0  Unreliable  \n",
       "2      12.0     17091.0  Unreliable  \n",
       "3      11.0     16853.0  Unreliable  \n",
       "4      14.0     50085.0  Unreliable  \n",
       "5      17.0     45341.0  Unreliable  \n",
       "6      22.0     46848.0        47.0  \n",
       "7      25.0     47267.0        52.9  \n",
       "8      19.0     48813.0  Unreliable  \n",
       "9      21.0     50145.0        41.9  \n",
       "10     34.0     51280.0        66.3  \n",
       "11     30.0     51890.0        57.8  \n",
       "12     29.0     40212.0        72.1  \n",
       "13     12.0     36898.0  Unreliable  \n",
       "14     31.0     39682.0        78.1  \n",
       "15     12.0     43185.0  Unreliable  \n",
       "16     25.0     39817.0        62.8  \n",
       "17     11.0     42989.0  Unreliable  \n",
       "18     12.0     36637.0  Unreliable  \n",
       "19     28.0     39673.0        70.6  \n",
       "20     10.0     43545.0  Unreliable  \n",
       "21     36.0     39588.0        90.9  \n",
       "22     15.0     44308.0  Unreliable  \n",
       "23     34.0     39912.0        85.2  \n",
       "24     19.0     43358.0  Unreliable  \n",
       "25     57.0     39508.0       144.3  \n",
       "26     10.0     49095.0  Unreliable  \n",
       "27     17.0     43643.0  Unreliable  \n",
       "28     15.0     39649.0  Unreliable  \n",
       "29     59.0     38040.0       155.1  \n",
       "..      ...         ...         ...  \n",
       "747     NaN         NaN         NaN  \n",
       "748     NaN         NaN         NaN  \n",
       "749     NaN         NaN         NaN  \n",
       "750     NaN         NaN         NaN  \n",
       "751     NaN         NaN         NaN  \n",
       "752     NaN         NaN         NaN  \n",
       "753     NaN         NaN         NaN  \n",
       "754     NaN         NaN         NaN  \n",
       "755     NaN         NaN         NaN  \n",
       "756     NaN         NaN         NaN  \n",
       "757     NaN         NaN         NaN  \n",
       "758     NaN         NaN         NaN  \n",
       "759     NaN         NaN         NaN  \n",
       "760     NaN         NaN         NaN  \n",
       "761     NaN         NaN         NaN  \n",
       "762     NaN         NaN         NaN  \n",
       "763     NaN         NaN         NaN  \n",
       "764     NaN         NaN         NaN  \n",
       "765     NaN         NaN         NaN  \n",
       "766     NaN         NaN         NaN  \n",
       "767     NaN         NaN         NaN  \n",
       "768     NaN         NaN         NaN  \n",
       "769     NaN         NaN         NaN  \n",
       "770     NaN         NaN         NaN  \n",
       "771     NaN         NaN         NaN  \n",
       "772     NaN         NaN         NaN  \n",
       "773     NaN         NaN         NaN  \n",
       "774     NaN         NaN         NaN  \n",
       "775     NaN         NaN         NaN  \n",
       "776     NaN         NaN         NaN  \n",
       "\n",
       "[777 rows x 14 columns]"
      ]
     },
     "execution_count": 248,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nystate"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "We just need to drop the notes column and rows 710-777 as they contain irrelevant information that is unreadable by pandas\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 249,
   "metadata": {},
   "outputs": [],
   "source": [
    "nystate = nystate.drop(range(710,777))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 250,
   "metadata": {},
   "outputs": [],
   "source": [
    "nystate.drop(columns=\"Notes\", inplace=True) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 251,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>County</th>\n",
       "      <th>County Code</th>\n",
       "      <th>Ten-Year Age Groups</th>\n",
       "      <th>Ten-Year Age Groups Code</th>\n",
       "      <th>Year</th>\n",
       "      <th>Year Code</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Gender Code</th>\n",
       "      <th>Race</th>\n",
       "      <th>Race Code</th>\n",
       "      <th>Deaths</th>\n",
       "      <th>Population</th>\n",
       "      <th>Crude Rate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Albany County, NY</td>\n",
       "      <td>36001.0</td>\n",
       "      <td>25-34 years</td>\n",
       "      <td>25-34</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>11.0</td>\n",
       "      <td>15534.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Albany County, NY</td>\n",
       "      <td>36001.0</td>\n",
       "      <td>45-54 years</td>\n",
       "      <td>45-54</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>12.0</td>\n",
       "      <td>17900.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Albany County, NY</td>\n",
       "      <td>36001.0</td>\n",
       "      <td>45-54 years</td>\n",
       "      <td>45-54</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>12.0</td>\n",
       "      <td>17091.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Albany County, NY</td>\n",
       "      <td>36001.0</td>\n",
       "      <td>55-64 years</td>\n",
       "      <td>55-64</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>11.0</td>\n",
       "      <td>16853.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>15-24 years</td>\n",
       "      <td>15-24</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>14.0</td>\n",
       "      <td>50085.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>25-34 years</td>\n",
       "      <td>25-34</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>17.0</td>\n",
       "      <td>45341.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>25-34 years</td>\n",
       "      <td>25-34</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>22.0</td>\n",
       "      <td>46848.0</td>\n",
       "      <td>47.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>25-34 years</td>\n",
       "      <td>25-34</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>25.0</td>\n",
       "      <td>47267.0</td>\n",
       "      <td>52.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>25-34 years</td>\n",
       "      <td>25-34</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>19.0</td>\n",
       "      <td>48813.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>25-34 years</td>\n",
       "      <td>25-34</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>21.0</td>\n",
       "      <td>50145.0</td>\n",
       "      <td>41.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>25-34 years</td>\n",
       "      <td>25-34</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>34.0</td>\n",
       "      <td>51280.0</td>\n",
       "      <td>66.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>25-34 years</td>\n",
       "      <td>25-34</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>30.0</td>\n",
       "      <td>51890.0</td>\n",
       "      <td>57.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>29.0</td>\n",
       "      <td>40212.0</td>\n",
       "      <td>72.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>Black or African American</td>\n",
       "      <td>2054-5</td>\n",
       "      <td>12.0</td>\n",
       "      <td>36898.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>31.0</td>\n",
       "      <td>39682.0</td>\n",
       "      <td>78.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>F</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>12.0</td>\n",
       "      <td>43185.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>25.0</td>\n",
       "      <td>39817.0</td>\n",
       "      <td>62.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>F</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>11.0</td>\n",
       "      <td>42989.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>Black or African American</td>\n",
       "      <td>2054-5</td>\n",
       "      <td>12.0</td>\n",
       "      <td>36637.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>28.0</td>\n",
       "      <td>39673.0</td>\n",
       "      <td>70.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>F</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>10.0</td>\n",
       "      <td>43545.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>36.0</td>\n",
       "      <td>39588.0</td>\n",
       "      <td>90.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>F</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>15.0</td>\n",
       "      <td>44308.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>34.0</td>\n",
       "      <td>39912.0</td>\n",
       "      <td>85.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>F</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>19.0</td>\n",
       "      <td>43358.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>57.0</td>\n",
       "      <td>39508.0</td>\n",
       "      <td>144.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>45-54 years</td>\n",
       "      <td>45-54</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>F</td>\n",
       "      <td>Black or African American</td>\n",
       "      <td>2054-5</td>\n",
       "      <td>10.0</td>\n",
       "      <td>49095.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>45-54 years</td>\n",
       "      <td>45-54</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>F</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>17.0</td>\n",
       "      <td>43643.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>45-54 years</td>\n",
       "      <td>45-54</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>Black or African American</td>\n",
       "      <td>2054-5</td>\n",
       "      <td>15.0</td>\n",
       "      <td>39649.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Bronx County, NY</td>\n",
       "      <td>36005.0</td>\n",
       "      <td>45-54 years</td>\n",
       "      <td>45-54</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>59.0</td>\n",
       "      <td>38040.0</td>\n",
       "      <td>155.1</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>680</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>25-34 years</td>\n",
       "      <td>25-34</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>11.0</td>\n",
       "      <td>39880.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>681</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>25-34 years</td>\n",
       "      <td>25-34</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>16.0</td>\n",
       "      <td>39629.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>682</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>25-34 years</td>\n",
       "      <td>25-34</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>F</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>10.0</td>\n",
       "      <td>37065.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>683</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>25-34 years</td>\n",
       "      <td>25-34</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>32.0</td>\n",
       "      <td>38905.0</td>\n",
       "      <td>82.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>684</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>17.0</td>\n",
       "      <td>49130.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>685</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>17.0</td>\n",
       "      <td>48204.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>686</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>13.0</td>\n",
       "      <td>46947.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>687</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>12.0</td>\n",
       "      <td>46270.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>688</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>15.0</td>\n",
       "      <td>45696.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>689</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>35-44 years</td>\n",
       "      <td>35-44</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>20.0</td>\n",
       "      <td>44919.0</td>\n",
       "      <td>44.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>690</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>45-54 years</td>\n",
       "      <td>45-54</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>20.0</td>\n",
       "      <td>57031.0</td>\n",
       "      <td>35.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>691</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>45-54 years</td>\n",
       "      <td>45-54</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>19.0</td>\n",
       "      <td>56822.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>692</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>45-54 years</td>\n",
       "      <td>45-54</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>28.0</td>\n",
       "      <td>56326.0</td>\n",
       "      <td>49.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>693</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>45-54 years</td>\n",
       "      <td>45-54</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>26.0</td>\n",
       "      <td>56106.0</td>\n",
       "      <td>46.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>694</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>45-54 years</td>\n",
       "      <td>45-54</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>F</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>13.0</td>\n",
       "      <td>57278.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>695</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>45-54 years</td>\n",
       "      <td>45-54</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>24.0</td>\n",
       "      <td>55732.0</td>\n",
       "      <td>43.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>696</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>45-54 years</td>\n",
       "      <td>45-54</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>23.0</td>\n",
       "      <td>55368.0</td>\n",
       "      <td>41.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>697</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>45-54 years</td>\n",
       "      <td>45-54</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>F</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>13.0</td>\n",
       "      <td>55476.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>698</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>45-54 years</td>\n",
       "      <td>45-54</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>29.0</td>\n",
       "      <td>54110.0</td>\n",
       "      <td>53.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>55-64 years</td>\n",
       "      <td>55-64</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>14.0</td>\n",
       "      <td>44275.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>700</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>55-64 years</td>\n",
       "      <td>55-64</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>F</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>11.0</td>\n",
       "      <td>49573.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>701</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>55-64 years</td>\n",
       "      <td>55-64</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>17.0</td>\n",
       "      <td>45850.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>702</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>55-64 years</td>\n",
       "      <td>55-64</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>F</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>10.0</td>\n",
       "      <td>49924.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>703</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>55-64 years</td>\n",
       "      <td>55-64</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>15.0</td>\n",
       "      <td>46334.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>704</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>55-64 years</td>\n",
       "      <td>55-64</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>F</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>13.0</td>\n",
       "      <td>50778.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>705</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>55-64 years</td>\n",
       "      <td>55-64</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>24.0</td>\n",
       "      <td>47348.0</td>\n",
       "      <td>50.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>706</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>55-64 years</td>\n",
       "      <td>55-64</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>16.0</td>\n",
       "      <td>48225.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>707</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>55-64 years</td>\n",
       "      <td>55-64</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>16.0</td>\n",
       "      <td>49179.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>708</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>55-64 years</td>\n",
       "      <td>55-64</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>16.0</td>\n",
       "      <td>49802.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>709</th>\n",
       "      <td>Westchester County, NY</td>\n",
       "      <td>36119.0</td>\n",
       "      <td>65-74 years</td>\n",
       "      <td>65-74</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>2106-3</td>\n",
       "      <td>12.0</td>\n",
       "      <td>29994.0</td>\n",
       "      <td>Unreliable</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>710 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     County  County Code Ten-Year Age Groups  \\\n",
       "0         Albany County, NY      36001.0         25-34 years   \n",
       "1         Albany County, NY      36001.0         45-54 years   \n",
       "2         Albany County, NY      36001.0         45-54 years   \n",
       "3         Albany County, NY      36001.0         55-64 years   \n",
       "4          Bronx County, NY      36005.0         15-24 years   \n",
       "5          Bronx County, NY      36005.0         25-34 years   \n",
       "6          Bronx County, NY      36005.0         25-34 years   \n",
       "7          Bronx County, NY      36005.0         25-34 years   \n",
       "8          Bronx County, NY      36005.0         25-34 years   \n",
       "9          Bronx County, NY      36005.0         25-34 years   \n",
       "10         Bronx County, NY      36005.0         25-34 years   \n",
       "11         Bronx County, NY      36005.0         25-34 years   \n",
       "12         Bronx County, NY      36005.0         35-44 years   \n",
       "13         Bronx County, NY      36005.0         35-44 years   \n",
       "14         Bronx County, NY      36005.0         35-44 years   \n",
       "15         Bronx County, NY      36005.0         35-44 years   \n",
       "16         Bronx County, NY      36005.0         35-44 years   \n",
       "17         Bronx County, NY      36005.0         35-44 years   \n",
       "18         Bronx County, NY      36005.0         35-44 years   \n",
       "19         Bronx County, NY      36005.0         35-44 years   \n",
       "20         Bronx County, NY      36005.0         35-44 years   \n",
       "21         Bronx County, NY      36005.0         35-44 years   \n",
       "22         Bronx County, NY      36005.0         35-44 years   \n",
       "23         Bronx County, NY      36005.0         35-44 years   \n",
       "24         Bronx County, NY      36005.0         35-44 years   \n",
       "25         Bronx County, NY      36005.0         35-44 years   \n",
       "26         Bronx County, NY      36005.0         45-54 years   \n",
       "27         Bronx County, NY      36005.0         45-54 years   \n",
       "28         Bronx County, NY      36005.0         45-54 years   \n",
       "29         Bronx County, NY      36005.0         45-54 years   \n",
       "..                      ...          ...                 ...   \n",
       "680  Westchester County, NY      36119.0         25-34 years   \n",
       "681  Westchester County, NY      36119.0         25-34 years   \n",
       "682  Westchester County, NY      36119.0         25-34 years   \n",
       "683  Westchester County, NY      36119.0         25-34 years   \n",
       "684  Westchester County, NY      36119.0         35-44 years   \n",
       "685  Westchester County, NY      36119.0         35-44 years   \n",
       "686  Westchester County, NY      36119.0         35-44 years   \n",
       "687  Westchester County, NY      36119.0         35-44 years   \n",
       "688  Westchester County, NY      36119.0         35-44 years   \n",
       "689  Westchester County, NY      36119.0         35-44 years   \n",
       "690  Westchester County, NY      36119.0         45-54 years   \n",
       "691  Westchester County, NY      36119.0         45-54 years   \n",
       "692  Westchester County, NY      36119.0         45-54 years   \n",
       "693  Westchester County, NY      36119.0         45-54 years   \n",
       "694  Westchester County, NY      36119.0         45-54 years   \n",
       "695  Westchester County, NY      36119.0         45-54 years   \n",
       "696  Westchester County, NY      36119.0         45-54 years   \n",
       "697  Westchester County, NY      36119.0         45-54 years   \n",
       "698  Westchester County, NY      36119.0         45-54 years   \n",
       "699  Westchester County, NY      36119.0         55-64 years   \n",
       "700  Westchester County, NY      36119.0         55-64 years   \n",
       "701  Westchester County, NY      36119.0         55-64 years   \n",
       "702  Westchester County, NY      36119.0         55-64 years   \n",
       "703  Westchester County, NY      36119.0         55-64 years   \n",
       "704  Westchester County, NY      36119.0         55-64 years   \n",
       "705  Westchester County, NY      36119.0         55-64 years   \n",
       "706  Westchester County, NY      36119.0         55-64 years   \n",
       "707  Westchester County, NY      36119.0         55-64 years   \n",
       "708  Westchester County, NY      36119.0         55-64 years   \n",
       "709  Westchester County, NY      36119.0         65-74 years   \n",
       "\n",
       "    Ten-Year Age Groups Code    Year  Year Code  Gender Gender Code  \\\n",
       "0                      25-34  2014.0     2014.0    Male           M   \n",
       "1                      45-54  2011.0     2011.0    Male           M   \n",
       "2                      45-54  2013.0     2013.0    Male           M   \n",
       "3                      55-64  2014.0     2014.0    Male           M   \n",
       "4                      15-24  2016.0     2016.0    Male           M   \n",
       "5                      25-34  2010.0     2010.0    Male           M   \n",
       "6                      25-34  2011.0     2011.0    Male           M   \n",
       "7                      25-34  2012.0     2012.0    Male           M   \n",
       "8                      25-34  2013.0     2013.0    Male           M   \n",
       "9                      25-34  2014.0     2014.0    Male           M   \n",
       "10                     25-34  2015.0     2015.0    Male           M   \n",
       "11                     25-34  2016.0     2016.0    Male           M   \n",
       "12                     35-44  2010.0     2010.0    Male           M   \n",
       "13                     35-44  2011.0     2011.0    Male           M   \n",
       "14                     35-44  2011.0     2011.0    Male           M   \n",
       "15                     35-44  2012.0     2012.0  Female           F   \n",
       "16                     35-44  2012.0     2012.0    Male           M   \n",
       "17                     35-44  2013.0     2013.0  Female           F   \n",
       "18                     35-44  2013.0     2013.0    Male           M   \n",
       "19                     35-44  2013.0     2013.0    Male           M   \n",
       "20                     35-44  2014.0     2014.0  Female           F   \n",
       "21                     35-44  2014.0     2014.0    Male           M   \n",
       "22                     35-44  2015.0     2015.0  Female           F   \n",
       "23                     35-44  2015.0     2015.0    Male           M   \n",
       "24                     35-44  2016.0     2016.0  Female           F   \n",
       "25                     35-44  2016.0     2016.0    Male           M   \n",
       "26                     45-54  2010.0     2010.0  Female           F   \n",
       "27                     45-54  2010.0     2010.0  Female           F   \n",
       "28                     45-54  2010.0     2010.0    Male           M   \n",
       "29                     45-54  2010.0     2010.0    Male           M   \n",
       "..                       ...     ...        ...     ...         ...   \n",
       "680                    25-34  2014.0     2014.0    Male           M   \n",
       "681                    25-34  2015.0     2015.0    Male           M   \n",
       "682                    25-34  2016.0     2016.0  Female           F   \n",
       "683                    25-34  2016.0     2016.0    Male           M   \n",
       "684                    35-44  2010.0     2010.0    Male           M   \n",
       "685                    35-44  2011.0     2011.0    Male           M   \n",
       "686                    35-44  2013.0     2013.0    Male           M   \n",
       "687                    35-44  2014.0     2014.0    Male           M   \n",
       "688                    35-44  2015.0     2015.0    Male           M   \n",
       "689                    35-44  2016.0     2016.0    Male           M   \n",
       "690                    45-54  2010.0     2010.0    Male           M   \n",
       "691                    45-54  2011.0     2011.0    Male           M   \n",
       "692                    45-54  2012.0     2012.0    Male           M   \n",
       "693                    45-54  2013.0     2013.0    Male           M   \n",
       "694                    45-54  2014.0     2014.0  Female           F   \n",
       "695                    45-54  2014.0     2014.0    Male           M   \n",
       "696                    45-54  2015.0     2015.0    Male           M   \n",
       "697                    45-54  2016.0     2016.0  Female           F   \n",
       "698                    45-54  2016.0     2016.0    Male           M   \n",
       "699                    55-64  2010.0     2010.0    Male           M   \n",
       "700                    55-64  2011.0     2011.0  Female           F   \n",
       "701                    55-64  2011.0     2011.0    Male           M   \n",
       "702                    55-64  2012.0     2012.0  Female           F   \n",
       "703                    55-64  2012.0     2012.0    Male           M   \n",
       "704                    55-64  2013.0     2013.0  Female           F   \n",
       "705                    55-64  2013.0     2013.0    Male           M   \n",
       "706                    55-64  2014.0     2014.0    Male           M   \n",
       "707                    55-64  2015.0     2015.0    Male           M   \n",
       "708                    55-64  2016.0     2016.0    Male           M   \n",
       "709                    65-74  2015.0     2015.0    Male           M   \n",
       "\n",
       "                          Race Race Code  Deaths  Population  Crude Rate  \n",
       "0                        White    2106-3    11.0     15534.0  Unreliable  \n",
       "1                        White    2106-3    12.0     17900.0  Unreliable  \n",
       "2                        White    2106-3    12.0     17091.0  Unreliable  \n",
       "3                        White    2106-3    11.0     16853.0  Unreliable  \n",
       "4                        White    2106-3    14.0     50085.0  Unreliable  \n",
       "5                        White    2106-3    17.0     45341.0  Unreliable  \n",
       "6                        White    2106-3    22.0     46848.0        47.0  \n",
       "7                        White    2106-3    25.0     47267.0        52.9  \n",
       "8                        White    2106-3    19.0     48813.0  Unreliable  \n",
       "9                        White    2106-3    21.0     50145.0        41.9  \n",
       "10                       White    2106-3    34.0     51280.0        66.3  \n",
       "11                       White    2106-3    30.0     51890.0        57.8  \n",
       "12                       White    2106-3    29.0     40212.0        72.1  \n",
       "13   Black or African American    2054-5    12.0     36898.0  Unreliable  \n",
       "14                       White    2106-3    31.0     39682.0        78.1  \n",
       "15                       White    2106-3    12.0     43185.0  Unreliable  \n",
       "16                       White    2106-3    25.0     39817.0        62.8  \n",
       "17                       White    2106-3    11.0     42989.0  Unreliable  \n",
       "18   Black or African American    2054-5    12.0     36637.0  Unreliable  \n",
       "19                       White    2106-3    28.0     39673.0        70.6  \n",
       "20                       White    2106-3    10.0     43545.0  Unreliable  \n",
       "21                       White    2106-3    36.0     39588.0        90.9  \n",
       "22                       White    2106-3    15.0     44308.0  Unreliable  \n",
       "23                       White    2106-3    34.0     39912.0        85.2  \n",
       "24                       White    2106-3    19.0     43358.0  Unreliable  \n",
       "25                       White    2106-3    57.0     39508.0       144.3  \n",
       "26   Black or African American    2054-5    10.0     49095.0  Unreliable  \n",
       "27                       White    2106-3    17.0     43643.0  Unreliable  \n",
       "28   Black or African American    2054-5    15.0     39649.0  Unreliable  \n",
       "29                       White    2106-3    59.0     38040.0       155.1  \n",
       "..                         ...       ...     ...         ...         ...  \n",
       "680                      White    2106-3    11.0     39880.0  Unreliable  \n",
       "681                      White    2106-3    16.0     39629.0  Unreliable  \n",
       "682                      White    2106-3    10.0     37065.0  Unreliable  \n",
       "683                      White    2106-3    32.0     38905.0        82.3  \n",
       "684                      White    2106-3    17.0     49130.0  Unreliable  \n",
       "685                      White    2106-3    17.0     48204.0  Unreliable  \n",
       "686                      White    2106-3    13.0     46947.0  Unreliable  \n",
       "687                      White    2106-3    12.0     46270.0  Unreliable  \n",
       "688                      White    2106-3    15.0     45696.0  Unreliable  \n",
       "689                      White    2106-3    20.0     44919.0        44.5  \n",
       "690                      White    2106-3    20.0     57031.0        35.1  \n",
       "691                      White    2106-3    19.0     56822.0  Unreliable  \n",
       "692                      White    2106-3    28.0     56326.0        49.7  \n",
       "693                      White    2106-3    26.0     56106.0        46.3  \n",
       "694                      White    2106-3    13.0     57278.0  Unreliable  \n",
       "695                      White    2106-3    24.0     55732.0        43.1  \n",
       "696                      White    2106-3    23.0     55368.0        41.5  \n",
       "697                      White    2106-3    13.0     55476.0  Unreliable  \n",
       "698                      White    2106-3    29.0     54110.0        53.6  \n",
       "699                      White    2106-3    14.0     44275.0  Unreliable  \n",
       "700                      White    2106-3    11.0     49573.0  Unreliable  \n",
       "701                      White    2106-3    17.0     45850.0  Unreliable  \n",
       "702                      White    2106-3    10.0     49924.0  Unreliable  \n",
       "703                      White    2106-3    15.0     46334.0  Unreliable  \n",
       "704                      White    2106-3    13.0     50778.0  Unreliable  \n",
       "705                      White    2106-3    24.0     47348.0        50.7  \n",
       "706                      White    2106-3    16.0     48225.0  Unreliable  \n",
       "707                      White    2106-3    16.0     49179.0  Unreliable  \n",
       "708                      White    2106-3    16.0     49802.0  Unreliable  \n",
       "709                      White    2106-3    12.0     29994.0  Unreliable  \n",
       "\n",
       "[710 rows x 13 columns]"
      ]
     },
     "execution_count": 251,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nystate"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 252,
   "metadata": {},
   "outputs": [],
   "source": [
    "nystate.to_csv(\"./csv's from jupyter/nystate_wonder_edited.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# now we want to look at the each age group and try to find different correlations"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "this can be achieved by using the groupby functions, and summing up death counts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 253,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>Deaths</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ten-Year Age Groups Code</th>\n",
       "      <th>Year</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"7\" valign=\"top\">15-24</th>\n",
       "      <th>2010.0</th>\n",
       "      <td>71.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011.0</th>\n",
       "      <td>70.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012.0</th>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013.0</th>\n",
       "      <td>71.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014.0</th>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015.0</th>\n",
       "      <td>108.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016.0</th>\n",
       "      <td>145.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"7\" valign=\"top\">25-34</th>\n",
       "      <th>2010.0</th>\n",
       "      <td>118.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011.0</th>\n",
       "      <td>239.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012.0</th>\n",
       "      <td>291.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013.0</th>\n",
       "      <td>329.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014.0</th>\n",
       "      <td>341.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015.0</th>\n",
       "      <td>452.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016.0</th>\n",
       "      <td>775.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"7\" valign=\"top\">35-44</th>\n",
       "      <th>2010.0</th>\n",
       "      <td>308.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011.0</th>\n",
       "      <td>317.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012.0</th>\n",
       "      <td>321.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013.0</th>\n",
       "      <td>353.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014.0</th>\n",
       "      <td>361.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015.0</th>\n",
       "      <td>456.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016.0</th>\n",
       "      <td>622.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"7\" valign=\"top\">45-54</th>\n",
       "      <th>2010.0</th>\n",
       "      <td>632.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011.0</th>\n",
       "      <td>752.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012.0</th>\n",
       "      <td>776.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013.0</th>\n",
       "      <td>802.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014.0</th>\n",
       "      <td>704.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015.0</th>\n",
       "      <td>832.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016.0</th>\n",
       "      <td>946.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"7\" valign=\"top\">55-64</th>\n",
       "      <th>2010.0</th>\n",
       "      <td>416.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011.0</th>\n",
       "      <td>528.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012.0</th>\n",
       "      <td>594.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013.0</th>\n",
       "      <td>622.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014.0</th>\n",
       "      <td>617.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015.0</th>\n",
       "      <td>710.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016.0</th>\n",
       "      <td>824.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"7\" valign=\"top\">65-74</th>\n",
       "      <th>2010.0</th>\n",
       "      <td>66.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011.0</th>\n",
       "      <td>77.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012.0</th>\n",
       "      <td>79.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013.0</th>\n",
       "      <td>132.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014.0</th>\n",
       "      <td>125.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015.0</th>\n",
       "      <td>180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016.0</th>\n",
       "      <td>182.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">75-84</th>\n",
       "      <th>2013.0</th>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015.0</th>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 Deaths\n",
       "Ten-Year Age Groups Code Year          \n",
       "15-24                    2010.0    71.0\n",
       "                         2011.0    70.0\n",
       "                         2012.0    90.0\n",
       "                         2013.0    71.0\n",
       "                         2014.0    94.0\n",
       "                         2015.0   108.0\n",
       "                         2016.0   145.0\n",
       "25-34                    2010.0   118.0\n",
       "                         2011.0   239.0\n",
       "                         2012.0   291.0\n",
       "                         2013.0   329.0\n",
       "                         2014.0   341.0\n",
       "                         2015.0   452.0\n",
       "                         2016.0   775.0\n",
       "35-44                    2010.0   308.0\n",
       "                         2011.0   317.0\n",
       "                         2012.0   321.0\n",
       "                         2013.0   353.0\n",
       "                         2014.0   361.0\n",
       "                         2015.0   456.0\n",
       "                         2016.0   622.0\n",
       "45-54                    2010.0   632.0\n",
       "                         2011.0   752.0\n",
       "                         2012.0   776.0\n",
       "                         2013.0   802.0\n",
       "                         2014.0   704.0\n",
       "                         2015.0   832.0\n",
       "                         2016.0   946.0\n",
       "55-64                    2010.0   416.0\n",
       "                         2011.0   528.0\n",
       "                         2012.0   594.0\n",
       "                         2013.0   622.0\n",
       "                         2014.0   617.0\n",
       "                         2015.0   710.0\n",
       "                         2016.0   824.0\n",
       "65-74                    2010.0    66.0\n",
       "                         2011.0    77.0\n",
       "                         2012.0    79.0\n",
       "                         2013.0   132.0\n",
       "                         2014.0   125.0\n",
       "                         2015.0   180.0\n",
       "                         2016.0   182.0\n",
       "75-84                    2013.0    10.0\n",
       "                         2015.0    12.0"
      ]
     },
     "execution_count": 253,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nystate.groupby(by=['Ten-Year Age Groups Code','Year'])['Deaths'].sum().to_frame()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Wonder us all data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "now we import the total US population data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "981"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cdc_wonder_all = pd.read_csv('./Multiple Cause of Death, 1999-2016.txt', sep=\"\\t\")\n",
    "len(cdc_wonder_all)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 255,
   "metadata": {},
   "outputs": [],
   "source": [
    "# drop the unessecary rows and cols\n",
    "cdc_wonder_all.drop((range(918, len(cdc_wonder_all)\n",
    "                )), inplace=True) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 256,
   "metadata": {},
   "outputs": [],
   "source": [
    "cdc_wonder_all = cdc_wonder_all.drop(columns=\"Notes\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 257,
   "metadata": {},
   "outputs": [],
   "source": [
    "cdc_wonder_all.to_csv(\"./csv's from jupyter/cdc_for_plotly.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## NIH data "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 258,
   "metadata": {},
   "outputs": [],
   "source": [
    "nih_od = pd.read_excel(\"./overdose_data_1999-2015_drugabuse_org.xlsx\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 259,
   "metadata": {},
   "outputs": [],
   "source": [
    "nih_od = nih_od.transpose()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 260,
   "metadata": {},
   "outputs": [],
   "source": [
    "types = []\n",
    "for i in range(0,len(list(nih_od)),3):\n",
    "        types.append(i)\n",
    "females = []\n",
    "for i in range(0,len(list(nih_od)),3):\n",
    "        females.append(i+1)\n",
    "males = []\n",
    "for i in range(0,len(list(nih_od)),3):\n",
    "        males.append(i+2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 261,
   "metadata": {},
   "outputs": [],
   "source": [
    "nih_new_df_females = nih_od.iloc[:,females]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 262,
   "metadata": {},
   "outputs": [],
   "source": [
    "nih_new_df_females.columns = nih_od.columns[types]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 263,
   "metadata": {},
   "outputs": [],
   "source": [
    "nih_new_df_males = nih_od.iloc[:,males]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 264,
   "metadata": {},
   "outputs": [],
   "source": [
    "nih_new_df_males.columns = nih_od.columns[types]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 265,
   "metadata": {},
   "outputs": [],
   "source": [
    "nih_new_df_males.columns = nih_od.columns[types]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 266,
   "metadata": {},
   "outputs": [],
   "source": [
    "# gets rid of year as index\n",
    "# nih_new_df_females.reset_index(inplace=True)\n",
    "# nih_new_df_males.reset_index(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 267,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "# removes duplicates\n",
    "nih_new_df_males = nih_new_df_males.loc[:,~nih_new_df_males.columns.duplicated()]\n",
    "nih_new_df_females = nih_new_df_females.loc[:,~nih_new_df_females.columns.duplicated()] "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 268,
   "metadata": {},
   "outputs": [],
   "source": [
    "# changes index to 'year'\n",
    "nih_new_df_males.rename(columns = {'index': 'Year'}, inplace=True)\n",
    "nih_new_df_females.rename(columns = {'index': 'Year'}, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 269,
   "metadata": {},
   "outputs": [],
   "source": [
    "# get rid of the total overdose deaths\n",
    "nih_new_df_males.drop(columns=\"Total Overdose Deaths\", inplace=True)\n",
    "nih_new_df_females.drop(columns=\"Total Overdose Deaths\", inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 270,
   "metadata": {},
   "outputs": [],
   "source": [
    "# escape unwanted stuff so python can parse the string properly\n",
    "\n",
    "nih_new_df_males.columns = [c.lstrip() for c in nih_new_df_males.columns]\n",
    "nih_new_df_males.columns = [c.rstrip('0123456789') for c in nih_new_df_males.columns]\n",
    "\n",
    "# females\n",
    "\n",
    "nih_new_df_females.columns = [c.lstrip() for c in nih_new_df_females.columns]\n",
    "nih_new_df_females.columns = [c.rstrip('0123456789') for c in nih_new_df_females.columns]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 271,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "nih_new_df_males_series = nih_new_df_males.stack()\n",
    "type(df)\n",
    "nih_new_df_males = pd.DataFrame(data=nih_new_df_males_series) # multi-indexed\n",
    "nih_new_df_males = nih_new_df_males.reset_index() #flatten the indices"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 272,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "nih_new_df_males = nih_new_df_males.rename(columns={'level_0': 'Year', 'level_1': 'Drug Category', 0: \"Number of Overdose Deaths\"})\n",
    "nih_new_df_males[\"Gender\"] = \"Male\"\n",
    "nih_new_df_males\n",
    "\n",
    "def convert_df(df,gender):\n",
    "    df_series = df.stack()\n",
    "    df = pd.DataFrame(data = df_series)\n",
    "    df = df.reset_index()\n",
    "    df = df.rename(columns={'level_0': 'Year', 'level_1': 'Drug Category', 0: \"Number of Overdose Deaths\"})\n",
    "    df[\"Gender\"] = gender\n",
    "    return df\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 273,
   "metadata": {},
   "outputs": [],
   "source": [
    "nih_new_df_females = convert_df(nih_new_df_females,\"Female\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 274,
   "metadata": {},
   "outputs": [],
   "source": [
    "nih_data = pd.concat([nih_new_df_females,nih_new_df_males])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 275,
   "metadata": {},
   "outputs": [],
   "source": [
    "nih_data = nih_data.sort_values(['Year','Number of Overdose Deaths'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 276,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>Number of Overdose Deaths</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gender</th>\n",
       "      <th>Year</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"17\" valign=\"top\">Female</th>\n",
       "      <th>1999</th>\n",
       "      <td>11661</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000</th>\n",
       "      <td>12553</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2001</th>\n",
       "      <td>15072</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2002</th>\n",
       "      <td>19789</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2003</th>\n",
       "      <td>21921</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2004</th>\n",
       "      <td>24904</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2005</th>\n",
       "      <td>27460</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2006</th>\n",
       "      <td>31991</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007</th>\n",
       "      <td>34751</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2008</th>\n",
       "      <td>35133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2009</th>\n",
       "      <td>37604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010</th>\n",
       "      <td>39874</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011</th>\n",
       "      <td>42924</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012</th>\n",
       "      <td>43356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>47238</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014</th>\n",
       "      <td>54680</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015</th>\n",
       "      <td>62887</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"17\" valign=\"top\">Male</th>\n",
       "      <th>1999</th>\n",
       "      <td>30050</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000</th>\n",
       "      <td>29982</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2001</th>\n",
       "      <td>32974</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2002</th>\n",
       "      <td>40674</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2003</th>\n",
       "      <td>44485</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2004</th>\n",
       "      <td>46913</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2005</th>\n",
       "      <td>51488</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2006</th>\n",
       "      <td>62624</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007</th>\n",
       "      <td>62460</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2008</th>\n",
       "      <td>64270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2009</th>\n",
       "      <td>65845</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010</th>\n",
       "      <td>67783</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011</th>\n",
       "      <td>73058</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012</th>\n",
       "      <td>74187</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>82464</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014</th>\n",
       "      <td>97595</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015</th>\n",
       "      <td>119917</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             Number of Overdose Deaths\n",
       "Gender Year                           \n",
       "Female 1999                      11661\n",
       "       2000                      12553\n",
       "       2001                      15072\n",
       "       2002                      19789\n",
       "       2003                      21921\n",
       "       2004                      24904\n",
       "       2005                      27460\n",
       "       2006                      31991\n",
       "       2007                      34751\n",
       "       2008                      35133\n",
       "       2009                      37604\n",
       "       2010                      39874\n",
       "       2011                      42924\n",
       "       2012                      43356\n",
       "       2013                      47238\n",
       "       2014                      54680\n",
       "       2015                      62887\n",
       "Male   1999                      30050\n",
       "       2000                      29982\n",
       "       2001                      32974\n",
       "       2002                      40674\n",
       "       2003                      44485\n",
       "       2004                      46913\n",
       "       2005                      51488\n",
       "       2006                      62624\n",
       "       2007                      62460\n",
       "       2008                      64270\n",
       "       2009                      65845\n",
       "       2010                      67783\n",
       "       2011                      73058\n",
       "       2012                      74187\n",
       "       2013                      82464\n",
       "       2014                      97595\n",
       "       2015                     119917"
      ]
     },
     "execution_count": 276,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nih_data.groupby(by=['Gender','Year']).sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 281,
   "metadata": {},
   "outputs": [],
   "source": [
    "nih_data.to_csv(\"./csv's from jupyter/nih_data.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 282,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Year</th>\n",
       "      <th>Drug Category</th>\n",
       "      <th>Number of Overdose Deaths</th>\n",
       "      <th>Gender</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1999</td>\n",
       "      <td>Heroin</td>\n",
       "      <td>306</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1999</td>\n",
       "      <td>Synthetic Opioids other than Methadone</td>\n",
       "      <td>330</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1999</td>\n",
       "      <td>Synthetic Opioids other than Methadone</td>\n",
       "      <td>400</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1999</td>\n",
       "      <td>Benzodiazepines</td>\n",
       "      <td>420</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1999</td>\n",
       "      <td>Illicit Opioids (Heroin and Synthetic Opioids ...</td>\n",
       "      <td>632</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1999</td>\n",
       "      <td>Benzodiazepines</td>\n",
       "      <td>715</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1999</td>\n",
       "      <td>Cocaine</td>\n",
       "      <td>850</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1999</td>\n",
       "      <td>Illicit Drugs</td>\n",
       "      <td>1190</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1999</td>\n",
       "      <td>Opioid Pain Relievers</td>\n",
       "      <td>1287</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1999</td>\n",
       "      <td>Opioid Pain Relievers other than synthetic opi...</td>\n",
       "      <td>1578</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1999</td>\n",
       "      <td>Heroin</td>\n",
       "      <td>1654</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1999</td>\n",
       "      <td>Illicit Opioids (Heroin and Synthetic Opioids ...</td>\n",
       "      <td>2043</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1999</td>\n",
       "      <td>Opioids</td>\n",
       "      <td>2057</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1999</td>\n",
       "      <td>Opioid Pain Relievers</td>\n",
       "      <td>2743</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1999</td>\n",
       "      <td>Cocaine</td>\n",
       "      <td>2972</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1999</td>\n",
       "      <td>Prescription Drugs</td>\n",
       "      <td>3011</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1999</td>\n",
       "      <td>Illicit Drugs</td>\n",
       "      <td>4440</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1999</td>\n",
       "      <td>Prescription Drugs</td>\n",
       "      <td>4512</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1999</td>\n",
       "      <td>Opioid Pain Relievers other than synthetic opi...</td>\n",
       "      <td>4580</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1999</td>\n",
       "      <td>Opioids</td>\n",
       "      <td>5991</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2000</td>\n",
       "      <td>Heroin</td>\n",
       "      <td>279</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2000</td>\n",
       "      <td>Synthetic Opioids other than Methadone</td>\n",
       "      <td>374</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2000</td>\n",
       "      <td>Synthetic Opioids other than Methadone</td>\n",
       "      <td>408</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2000</td>\n",
       "      <td>Benzodiazepines</td>\n",
       "      <td>480</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2000</td>\n",
       "      <td>Illicit Opioids (Heroin and Synthetic Opioids ...</td>\n",
       "      <td>646</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2000</td>\n",
       "      <td>Benzodiazepines</td>\n",
       "      <td>818</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2000</td>\n",
       "      <td>Cocaine</td>\n",
       "      <td>843</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2000</td>\n",
       "      <td>Illicit Drugs</td>\n",
       "      <td>1164</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2000</td>\n",
       "      <td>Opioid Pain Relievers</td>\n",
       "      <td>1534</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2000</td>\n",
       "      <td>Heroin</td>\n",
       "      <td>1563</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>2014</td>\n",
       "      <td>Opioid Pain Relievers</td>\n",
       "      <td>7924</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>2014</td>\n",
       "      <td>Heroin</td>\n",
       "      <td>8160</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>2014</td>\n",
       "      <td>Opioid Pain Relievers other than synthetic opi...</td>\n",
       "      <td>9798</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>2014</td>\n",
       "      <td>Opioids</td>\n",
       "      <td>10227</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>2014</td>\n",
       "      <td>Illicit Opioids (Heroin and Synthetic Opioids ...</td>\n",
       "      <td>10873</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>2014</td>\n",
       "      <td>Opioid Pain Relievers</td>\n",
       "      <td>10969</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>2014</td>\n",
       "      <td>Prescription Drugs</td>\n",
       "      <td>11181</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>2014</td>\n",
       "      <td>Illicit Drugs</td>\n",
       "      <td>12993</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>2014</td>\n",
       "      <td>Prescription Drugs</td>\n",
       "      <td>14579</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>2014</td>\n",
       "      <td>Opioids</td>\n",
       "      <td>18420</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>2015</td>\n",
       "      <td>Cocaine</td>\n",
       "      <td>1899</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>2015</td>\n",
       "      <td>Synthetic Opioids other than Methadone</td>\n",
       "      <td>3020</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>2015</td>\n",
       "      <td>Heroin</td>\n",
       "      <td>3108</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>2015</td>\n",
       "      <td>Benzodiazepines</td>\n",
       "      <td>3779</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>2015</td>\n",
       "      <td>Cocaine</td>\n",
       "      <td>4885</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>2015</td>\n",
       "      <td>Benzodiazepines</td>\n",
       "      <td>5012</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>2015</td>\n",
       "      <td>Illicit Opioids (Heroin and Synthetic Opioids ...</td>\n",
       "      <td>5458</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>2015</td>\n",
       "      <td>Illicit Drugs</td>\n",
       "      <td>5770</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>2015</td>\n",
       "      <td>Synthetic Opioids other than Methadone</td>\n",
       "      <td>6560</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>2015</td>\n",
       "      <td>Opioid Pain Relievers other than synthetic opi...</td>\n",
       "      <td>7429</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>2015</td>\n",
       "      <td>Opioid Pain Relievers</td>\n",
       "      <td>8786</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>2015</td>\n",
       "      <td>Heroin</td>\n",
       "      <td>9881</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>2015</td>\n",
       "      <td>Opioid Pain Relievers other than synthetic opi...</td>\n",
       "      <td>10107</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>2015</td>\n",
       "      <td>Opioids</td>\n",
       "      <td>11420</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>2015</td>\n",
       "      <td>Prescription Drugs</td>\n",
       "      <td>12218</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>2015</td>\n",
       "      <td>Opioid Pain Relievers</td>\n",
       "      <td>13812</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>2015</td>\n",
       "      <td>Illicit Opioids (Heroin and Synthetic Opioids ...</td>\n",
       "      <td>14426</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>2015</td>\n",
       "      <td>Illicit Drugs</td>\n",
       "      <td>16053</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>2015</td>\n",
       "      <td>Prescription Drugs</td>\n",
       "      <td>17510</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>2015</td>\n",
       "      <td>Opioids</td>\n",
       "      <td>21671</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>340 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Year                                      Drug Category  \\\n",
       "5    1999                                             Heroin   \n",
       "8    1999             Synthetic Opioids other than Methadone   \n",
       "8    1999             Synthetic Opioids other than Methadone   \n",
       "2    1999                                    Benzodiazepines   \n",
       "9    1999  Illicit Opioids (Heroin and Synthetic Opioids ...   \n",
       "2    1999                                    Benzodiazepines   \n",
       "4    1999                                            Cocaine   \n",
       "3    1999                                      Illicit Drugs   \n",
       "1    1999                              Opioid Pain Relievers   \n",
       "7    1999  Opioid Pain Relievers other than synthetic opi...   \n",
       "5    1999                                             Heroin   \n",
       "9    1999  Illicit Opioids (Heroin and Synthetic Opioids ...   \n",
       "6    1999                                            Opioids   \n",
       "1    1999                              Opioid Pain Relievers   \n",
       "4    1999                                            Cocaine   \n",
       "0    1999                                 Prescription Drugs   \n",
       "3    1999                                      Illicit Drugs   \n",
       "0    1999                                 Prescription Drugs   \n",
       "7    1999  Opioid Pain Relievers other than synthetic opi...   \n",
       "6    1999                                            Opioids   \n",
       "15   2000                                             Heroin   \n",
       "18   2000             Synthetic Opioids other than Methadone   \n",
       "18   2000             Synthetic Opioids other than Methadone   \n",
       "12   2000                                    Benzodiazepines   \n",
       "19   2000  Illicit Opioids (Heroin and Synthetic Opioids ...   \n",
       "12   2000                                    Benzodiazepines   \n",
       "14   2000                                            Cocaine   \n",
       "13   2000                                      Illicit Drugs   \n",
       "11   2000                              Opioid Pain Relievers   \n",
       "15   2000                                             Heroin   \n",
       "..    ...                                                ...   \n",
       "151  2014                              Opioid Pain Relievers   \n",
       "155  2014                                             Heroin   \n",
       "157  2014  Opioid Pain Relievers other than synthetic opi...   \n",
       "156  2014                                            Opioids   \n",
       "159  2014  Illicit Opioids (Heroin and Synthetic Opioids ...   \n",
       "151  2014                              Opioid Pain Relievers   \n",
       "150  2014                                 Prescription Drugs   \n",
       "153  2014                                      Illicit Drugs   \n",
       "150  2014                                 Prescription Drugs   \n",
       "156  2014                                            Opioids   \n",
       "164  2015                                            Cocaine   \n",
       "168  2015             Synthetic Opioids other than Methadone   \n",
       "165  2015                                             Heroin   \n",
       "162  2015                                    Benzodiazepines   \n",
       "164  2015                                            Cocaine   \n",
       "162  2015                                    Benzodiazepines   \n",
       "169  2015  Illicit Opioids (Heroin and Synthetic Opioids ...   \n",
       "163  2015                                      Illicit Drugs   \n",
       "168  2015             Synthetic Opioids other than Methadone   \n",
       "167  2015  Opioid Pain Relievers other than synthetic opi...   \n",
       "161  2015                              Opioid Pain Relievers   \n",
       "165  2015                                             Heroin   \n",
       "167  2015  Opioid Pain Relievers other than synthetic opi...   \n",
       "166  2015                                            Opioids   \n",
       "160  2015                                 Prescription Drugs   \n",
       "161  2015                              Opioid Pain Relievers   \n",
       "169  2015  Illicit Opioids (Heroin and Synthetic Opioids ...   \n",
       "163  2015                                      Illicit Drugs   \n",
       "160  2015                                 Prescription Drugs   \n",
       "166  2015                                            Opioids   \n",
       "\n",
       "     Number of Overdose Deaths  Gender  \n",
       "5                          306  Female  \n",
       "8                          330  Female  \n",
       "8                          400    Male  \n",
       "2                          420  Female  \n",
       "9                          632  Female  \n",
       "2                          715    Male  \n",
       "4                          850  Female  \n",
       "3                         1190  Female  \n",
       "1                         1287  Female  \n",
       "7                         1578  Female  \n",
       "5                         1654    Male  \n",
       "9                         2043    Male  \n",
       "6                         2057  Female  \n",
       "1                         2743    Male  \n",
       "4                         2972    Male  \n",
       "0                         3011  Female  \n",
       "3                         4440    Male  \n",
       "0                         4512    Male  \n",
       "7                         4580    Male  \n",
       "6                         5991    Male  \n",
       "15                         279  Female  \n",
       "18                         374  Female  \n",
       "18                         408    Male  \n",
       "12                         480  Female  \n",
       "19                         646  Female  \n",
       "12                         818    Male  \n",
       "14                         843  Female  \n",
       "13                        1164  Female  \n",
       "11                        1534  Female  \n",
       "15                        1563    Male  \n",
       "..                         ...     ...  \n",
       "151                       7924  Female  \n",
       "155                       8160    Male  \n",
       "157                       9798    Male  \n",
       "156                      10227  Female  \n",
       "159                      10873    Male  \n",
       "151                      10969    Male  \n",
       "150                      11181  Female  \n",
       "153                      12993    Male  \n",
       "150                      14579    Male  \n",
       "156                      18420    Male  \n",
       "164                       1899  Female  \n",
       "168                       3020  Female  \n",
       "165                       3108  Female  \n",
       "162                       3779  Female  \n",
       "164                       4885    Male  \n",
       "162                       5012    Male  \n",
       "169                       5458  Female  \n",
       "163                       5770  Female  \n",
       "168                       6560    Male  \n",
       "167                       7429  Female  \n",
       "161                       8786  Female  \n",
       "165                       9881    Male  \n",
       "167                      10107    Male  \n",
       "166                      11420  Female  \n",
       "160                      12218  Female  \n",
       "161                      13812    Male  \n",
       "169                      14426    Male  \n",
       "163                      16053    Male  \n",
       "160                      17510    Male  \n",
       "166                      21671    Male  \n",
       "\n",
       "[340 rows x 4 columns]"
      ]
     },
     "execution_count": 282,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nih_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 278,
   "metadata": {},
   "outputs": [],
   "source": [
    "nys_gov = pd.read_excel(\"./NY.gov info/jan_2017_NYS_overdoses_etc.xlsx\", header=[0,1], index_col=[0,1], na_values=\"s\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 279,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>level_0</th>\n",
       "      <th>level_1</th>\n",
       "      <th colspan=\"2\" halign=\"left\">Apr-Jun, 2015</th>\n",
       "      <th colspan=\"2\" halign=\"left\">Jul-Sep, 2015</th>\n",
       "      <th colspan=\"2\" halign=\"left\">Oct-Dec, 2015</th>\n",
       "      <th colspan=\"2\" halign=\"left\">2015 Total</th>\n",
       "      <th colspan=\"2\" halign=\"left\">Jan-Mar, 2016</th>\n",
       "      <th colspan=\"2\" halign=\"left\">Apr-Jun, 2016</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Location</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>Number</th>\n",
       "      <th>Crude Rate</th>\n",
       "      <th>Number</th>\n",
       "      <th>Crude Rate</th>\n",
       "      <th>Number</th>\n",
       "      <th>Crude Rate</th>\n",
       "      <th>Number</th>\n",
       "      <th>Crude Rate</th>\n",
       "      <th>Number</th>\n",
       "      <th>Crude Rate</th>\n",
       "      <th>Number</th>\n",
       "      <th>Crude Rate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Albany</td>\n",
       "      <td>8.0</td>\n",
       "      <td>2.6</td>\n",
       "      <td>12.0</td>\n",
       "      <td>3.9</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.3</td>\n",
       "      <td>31.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Allegany</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.2</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10.5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Broome</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4.1</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.1</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.1</td>\n",
       "      <td>28.0</td>\n",
       "      <td>14.2</td>\n",
       "      <td>16.0</td>\n",
       "      <td>8.1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Cattaraugus</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.9</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>11.0</td>\n",
       "      <td>14.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Cayuga</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.8</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7.7</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.4</td>\n",
       "      <td>17.0</td>\n",
       "      <td>21.7</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Chautauqua</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.3</td>\n",
       "      <td>6.0</td>\n",
       "      <td>4.6</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>15.0</td>\n",
       "      <td>11.5</td>\n",
       "      <td>8.0</td>\n",
       "      <td>6.1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Chemung</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.6</td>\n",
       "      <td>10.0</td>\n",
       "      <td>11.5</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Chenango</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.1</td>\n",
       "      <td>7.0</td>\n",
       "      <td>14.3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Clinton</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.7</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.9</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.5</td>\n",
       "      <td>10.0</td>\n",
       "      <td>12.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Columbia</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.6</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Cortland</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.1</td>\n",
       "      <td>8.0</td>\n",
       "      <td>16.5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Delaware</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Dutchess</td>\n",
       "      <td>14.0</td>\n",
       "      <td>4.7</td>\n",
       "      <td>17.0</td>\n",
       "      <td>5.7</td>\n",
       "      <td>19.0</td>\n",
       "      <td>6.4</td>\n",
       "      <td>57.0</td>\n",
       "      <td>19.3</td>\n",
       "      <td>11.0</td>\n",
       "      <td>3.7</td>\n",
       "      <td>11.0</td>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Erie</td>\n",
       "      <td>75.0</td>\n",
       "      <td>8.1</td>\n",
       "      <td>53.0</td>\n",
       "      <td>5.7</td>\n",
       "      <td>58.0</td>\n",
       "      <td>6.3</td>\n",
       "      <td>237.0</td>\n",
       "      <td>25.7</td>\n",
       "      <td>95.0</td>\n",
       "      <td>10.3</td>\n",
       "      <td>27.0</td>\n",
       "      <td>2.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Essex</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.8</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.6</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.8</td>\n",
       "      <td>10.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Franklin</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.9</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.9</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>9.9</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Fulton</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.9</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>7.4</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Genesee</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.7</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8.5</td>\n",
       "      <td>10.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.7</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Greene</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.2</td>\n",
       "      <td>8.0</td>\n",
       "      <td>16.8</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Hamilton</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>21.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Herkimer</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>11.1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.8</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Jefferson</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.6</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.7</td>\n",
       "      <td>10.0</td>\n",
       "      <td>8.5</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Lewis</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.7</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.7</td>\n",
       "      <td>4.0</td>\n",
       "      <td>14.8</td>\n",
       "      <td>3.0</td>\n",
       "      <td>11.1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Livingston</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.5</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Madison</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.8</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.7</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.2</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Monroe</td>\n",
       "      <td>21.0</td>\n",
       "      <td>2.8</td>\n",
       "      <td>17.0</td>\n",
       "      <td>2.3</td>\n",
       "      <td>20.0</td>\n",
       "      <td>2.7</td>\n",
       "      <td>81.0</td>\n",
       "      <td>10.8</td>\n",
       "      <td>17.0</td>\n",
       "      <td>2.3</td>\n",
       "      <td>18.0</td>\n",
       "      <td>2.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Montgomery</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Nassau</td>\n",
       "      <td>48.0</td>\n",
       "      <td>3.5</td>\n",
       "      <td>29.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>39.0</td>\n",
       "      <td>2.9</td>\n",
       "      <td>166.0</td>\n",
       "      <td>12.2</td>\n",
       "      <td>34.0</td>\n",
       "      <td>2.5</td>\n",
       "      <td>16.0</td>\n",
       "      <td>1.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Niagara</td>\n",
       "      <td>14.0</td>\n",
       "      <td>6.6</td>\n",
       "      <td>7.0</td>\n",
       "      <td>3.3</td>\n",
       "      <td>14.0</td>\n",
       "      <td>6.6</td>\n",
       "      <td>44.0</td>\n",
       "      <td>20.7</td>\n",
       "      <td>12.0</td>\n",
       "      <td>5.6</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Oneida</td>\n",
       "      <td>11.0</td>\n",
       "      <td>4.7</td>\n",
       "      <td>7.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>3.9</td>\n",
       "      <td>36.0</td>\n",
       "      <td>15.5</td>\n",
       "      <td>7.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>5.6</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Niagara</td>\n",
       "      <td>16.0</td>\n",
       "      <td>7.5</td>\n",
       "      <td>12.0</td>\n",
       "      <td>5.6</td>\n",
       "      <td>14.0</td>\n",
       "      <td>6.6</td>\n",
       "      <td>55.0</td>\n",
       "      <td>25.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>4.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Oneida</td>\n",
       "      <td>7.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>7.7</td>\n",
       "      <td>7.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>502</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Onondaga</td>\n",
       "      <td>15.0</td>\n",
       "      <td>3.2</td>\n",
       "      <td>17.0</td>\n",
       "      <td>3.6</td>\n",
       "      <td>11.0</td>\n",
       "      <td>2.3</td>\n",
       "      <td>59.0</td>\n",
       "      <td>12.6</td>\n",
       "      <td>11.0</td>\n",
       "      <td>2.3</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>503</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Ontario</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>18.0</td>\n",
       "      <td>16.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>504</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Orange</td>\n",
       "      <td>13.0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>8.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.6</td>\n",
       "      <td>34.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>505</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Orleans</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>506</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Oswego</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>15.0</td>\n",
       "      <td>12.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>507</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Otsego</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>14.0</td>\n",
       "      <td>23.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>508</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Putnam</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>6.0</td>\n",
       "      <td>6.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>509</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Rensselaer</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>9.0</td>\n",
       "      <td>5.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>510</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Rockland</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>12.0</td>\n",
       "      <td>3.7</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>St. Lawrence</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>16.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>512</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Saratoga</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>513</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Schenectady</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>9.0</td>\n",
       "      <td>5.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>514</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Schoharie</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>515</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Schuyler</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Seneca</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",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>517</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Steuben</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.0</td>\n",
       "      <td>7.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16.0</td>\n",
       "      <td>16.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>518</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Suffolk</td>\n",
       "      <td>48.0</td>\n",
       "      <td>3.2</td>\n",
       "      <td>54.0</td>\n",
       "      <td>3.6</td>\n",
       "      <td>34.0</td>\n",
       "      <td>2.3</td>\n",
       "      <td>173.0</td>\n",
       "      <td>11.5</td>\n",
       "      <td>30.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>2.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>519</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Sullivan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>21.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>520</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Tioga</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</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>521</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Tompkins</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>9.0</td>\n",
       "      <td>8.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>522</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Ulster</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.3</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.3</td>\n",
       "      <td>11.0</td>\n",
       "      <td>6.1</td>\n",
       "      <td>31.0</td>\n",
       "      <td>17.2</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.3</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>523</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Warren</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>10.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>524</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Washington</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>6.0</td>\n",
       "      <td>9.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>525</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Wayne</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>8.0</td>\n",
       "      <td>8.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>526</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Westchester</td>\n",
       "      <td>21.0</td>\n",
       "      <td>2.2</td>\n",
       "      <td>29.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>70.0</td>\n",
       "      <td>7.2</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.6</td>\n",
       "      <td>14.0</td>\n",
       "      <td>1.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>527</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Wyoming</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>8.0</td>\n",
       "      <td>19.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>528</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Yates</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>529</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>ROS</td>\n",
       "      <td>353.0</td>\n",
       "      <td>3.1</td>\n",
       "      <td>352.0</td>\n",
       "      <td>3.1</td>\n",
       "      <td>224.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1192.0</td>\n",
       "      <td>10.6</td>\n",
       "      <td>213.0</td>\n",
       "      <td>1.9</td>\n",
       "      <td>232.0</td>\n",
       "      <td>2.1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>530 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    level_0       level_1  \\\n",
       "Location                                                                    \n",
       "0         All opioid overdose deaths and rates per 100,0...        Albany   \n",
       "1         All opioid overdose deaths and rates per 100,0...      Allegany   \n",
       "2         All opioid overdose deaths and rates per 100,0...        Broome   \n",
       "3         All opioid overdose deaths and rates per 100,0...   Cattaraugus   \n",
       "4         All opioid overdose deaths and rates per 100,0...        Cayuga   \n",
       "5         All opioid overdose deaths and rates per 100,0...    Chautauqua   \n",
       "6         All opioid overdose deaths and rates per 100,0...       Chemung   \n",
       "7         All opioid overdose deaths and rates per 100,0...      Chenango   \n",
       "8         All opioid overdose deaths and rates per 100,0...       Clinton   \n",
       "9         All opioid overdose deaths and rates per 100,0...      Columbia   \n",
       "10        All opioid overdose deaths and rates per 100,0...      Cortland   \n",
       "11        All opioid overdose deaths and rates per 100,0...      Delaware   \n",
       "12        All opioid overdose deaths and rates per 100,0...      Dutchess   \n",
       "13        All opioid overdose deaths and rates per 100,0...          Erie   \n",
       "14        All opioid overdose deaths and rates per 100,0...         Essex   \n",
       "15        All opioid overdose deaths and rates per 100,0...      Franklin   \n",
       "16        All opioid overdose deaths and rates per 100,0...        Fulton   \n",
       "17        All opioid overdose deaths and rates per 100,0...       Genesee   \n",
       "18        All opioid overdose deaths and rates per 100,0...        Greene   \n",
       "19        All opioid overdose deaths and rates per 100,0...      Hamilton   \n",
       "20        All opioid overdose deaths and rates per 100,0...      Herkimer   \n",
       "21        All opioid overdose deaths and rates per 100,0...     Jefferson   \n",
       "22        All opioid overdose deaths and rates per 100,0...         Lewis   \n",
       "23        All opioid overdose deaths and rates per 100,0...    Livingston   \n",
       "24        All opioid overdose deaths and rates per 100,0...       Madison   \n",
       "25        All opioid overdose deaths and rates per 100,0...        Monroe   \n",
       "26        All opioid overdose deaths and rates per 100,0...    Montgomery   \n",
       "27        All opioid overdose deaths and rates per 100,0...        Nassau   \n",
       "28        All opioid overdose deaths and rates per 100,0...       Niagara   \n",
       "29        All opioid overdose deaths and rates per 100,0...        Oneida   \n",
       "..                                                      ...           ...   \n",
       "500       Opioid overdose excluding heroin hospitalizati...       Niagara   \n",
       "501       Opioid overdose excluding heroin hospitalizati...        Oneida   \n",
       "502       Opioid overdose excluding heroin hospitalizati...      Onondaga   \n",
       "503       Opioid overdose excluding heroin hospitalizati...       Ontario   \n",
       "504       Opioid overdose excluding heroin hospitalizati...        Orange   \n",
       "505       Opioid overdose excluding heroin hospitalizati...       Orleans   \n",
       "506       Opioid overdose excluding heroin hospitalizati...        Oswego   \n",
       "507       Opioid overdose excluding heroin hospitalizati...        Otsego   \n",
       "508       Opioid overdose excluding heroin hospitalizati...        Putnam   \n",
       "509       Opioid overdose excluding heroin hospitalizati...    Rensselaer   \n",
       "510       Opioid overdose excluding heroin hospitalizati...      Rockland   \n",
       "511       Opioid overdose excluding heroin hospitalizati...  St. Lawrence   \n",
       "512       Opioid overdose excluding heroin hospitalizati...      Saratoga   \n",
       "513       Opioid overdose excluding heroin hospitalizati...   Schenectady   \n",
       "514       Opioid overdose excluding heroin hospitalizati...     Schoharie   \n",
       "515       Opioid overdose excluding heroin hospitalizati...      Schuyler   \n",
       "516       Opioid overdose excluding heroin hospitalizati...        Seneca   \n",
       "517       Opioid overdose excluding heroin hospitalizati...       Steuben   \n",
       "518       Opioid overdose excluding heroin hospitalizati...       Suffolk   \n",
       "519       Opioid overdose excluding heroin hospitalizati...      Sullivan   \n",
       "520       Opioid overdose excluding heroin hospitalizati...         Tioga   \n",
       "521       Opioid overdose excluding heroin hospitalizati...      Tompkins   \n",
       "522       Opioid overdose excluding heroin hospitalizati...        Ulster   \n",
       "523       Opioid overdose excluding heroin hospitalizati...        Warren   \n",
       "524       Opioid overdose excluding heroin hospitalizati...    Washington   \n",
       "525       Opioid overdose excluding heroin hospitalizati...         Wayne   \n",
       "526       Opioid overdose excluding heroin hospitalizati...   Westchester   \n",
       "527       Opioid overdose excluding heroin hospitalizati...       Wyoming   \n",
       "528       Opioid overdose excluding heroin hospitalizati...         Yates   \n",
       "529       Opioid overdose excluding heroin hospitalizati...           ROS   \n",
       "\n",
       "         Apr-Jun, 2015            Jul-Sep, 2015            Oct-Dec, 2015  \\\n",
       "Location        Number Crude Rate        Number Crude Rate        Number   \n",
       "0                  8.0        2.6          12.0        3.9           7.0   \n",
       "1                  0.0        0.0           1.0        2.1           2.0   \n",
       "2                  8.0        4.1           6.0        3.1           6.0   \n",
       "3                  4.0        5.1           3.0        3.9           1.0   \n",
       "4                  3.0        3.8           6.0        7.7           5.0   \n",
       "5                  3.0        2.3           6.0        4.6           1.0   \n",
       "6                  1.0        1.1           4.0        4.6           4.0   \n",
       "7                  1.0        2.0           2.0        4.1           3.0   \n",
       "8                  3.0        3.7           4.0        4.9           2.0   \n",
       "9                  1.0        1.6           2.0        3.3           1.0   \n",
       "10                 2.0        4.1           3.0        6.2           2.0   \n",
       "11                 1.0        2.2           2.0        4.3           0.0   \n",
       "12                14.0        4.7          17.0        5.7          19.0   \n",
       "13                75.0        8.1          53.0        5.7          58.0   \n",
       "14                 3.0        7.8           1.0        2.6           3.0   \n",
       "15                 2.0        3.9           2.0        3.9           0.0   \n",
       "16                 1.0        1.9           2.0        3.7           0.0   \n",
       "17                 1.0        1.7           1.0        1.7           5.0   \n",
       "18                 2.0        4.2           1.0        2.1           2.0   \n",
       "19                 0.0        0.0           0.0        0.0           0.0   \n",
       "20                 2.0        3.2           1.0        1.6           0.0   \n",
       "21                 3.0        2.6           3.0        2.6           2.0   \n",
       "22                 2.0        7.4           1.0        3.7           1.0   \n",
       "23                 0.0        0.0           2.0        3.1           1.0   \n",
       "24                 2.0        2.8           1.0        1.4           0.0   \n",
       "25                21.0        2.8          17.0        2.3          20.0   \n",
       "26                 2.0        4.0           0.0        0.0           2.0   \n",
       "27                48.0        3.5          29.0        2.1          39.0   \n",
       "28                14.0        6.6           7.0        3.3          14.0   \n",
       "29                11.0        4.7           7.0        3.0           9.0   \n",
       "..                 ...        ...           ...        ...           ...   \n",
       "500               16.0        7.5          12.0        5.6          14.0   \n",
       "501                7.0        3.0           8.0        3.4           0.0   \n",
       "502               15.0        3.2          17.0        3.6          11.0   \n",
       "503                NaN        NaN           NaN        NaN           NaN   \n",
       "504               13.0        3.4           8.0        2.1           6.0   \n",
       "505                0.0        0.0           0.0        0.0           0.0   \n",
       "506                NaN        NaN           NaN        NaN           NaN   \n",
       "507                NaN        NaN           NaN        NaN           NaN   \n",
       "508                NaN        NaN           NaN        NaN           NaN   \n",
       "509                NaN        NaN           NaN        NaN           NaN   \n",
       "510                NaN        NaN           NaN        NaN           NaN   \n",
       "511                NaN        NaN           NaN        NaN           0.0   \n",
       "512                NaN        NaN           0.0        0.0           0.0   \n",
       "513                NaN        NaN           NaN        NaN           NaN   \n",
       "514                0.0        0.0           0.0        0.0           0.0   \n",
       "515                0.0        0.0           0.0        0.0           0.0   \n",
       "516                NaN        NaN           NaN        NaN           NaN   \n",
       "517                NaN        NaN           7.0        7.2           NaN   \n",
       "518               48.0        3.2          54.0        3.6          34.0   \n",
       "519                NaN        NaN           NaN        NaN           6.0   \n",
       "520                NaN        NaN           0.0        0.0           0.0   \n",
       "521                NaN        NaN           NaN        NaN           NaN   \n",
       "522                6.0        3.3           6.0        3.3          11.0   \n",
       "523                NaN        NaN           NaN        NaN           0.0   \n",
       "524                NaN        NaN           NaN        NaN           NaN   \n",
       "525                NaN        NaN           NaN        NaN           NaN   \n",
       "526               21.0        2.2          29.0        3.0           9.0   \n",
       "527                NaN        NaN           NaN        NaN           NaN   \n",
       "528                NaN        NaN           NaN        NaN           0.0   \n",
       "529              353.0        3.1         352.0        3.1         224.0   \n",
       "\n",
       "                    2015 Total            Jan-Mar, 2016             \\\n",
       "Location Crude Rate     Number Crude Rate        Number Crude Rate   \n",
       "0               2.3       31.0       10.0           1.0        0.3   \n",
       "1               4.2        5.0       10.5           1.0        2.1   \n",
       "2               3.1       28.0       14.2          16.0        8.1   \n",
       "3               1.3       11.0       14.1           0.0        0.0   \n",
       "4               6.4       17.0       21.7           4.0        5.1   \n",
       "5               0.8       15.0       11.5           8.0        6.1   \n",
       "6               4.6       10.0       11.5           3.0        3.4   \n",
       "7               6.1        7.0       14.3           1.0        2.0   \n",
       "8               2.5       10.0       12.3           0.0        0.0   \n",
       "9               1.6        6.0        9.8           0.0        0.0   \n",
       "10              4.1        8.0       16.5           1.0        2.1   \n",
       "11              0.0        6.0       13.0           2.0        4.3   \n",
       "12              6.4       57.0       19.3          11.0        3.7   \n",
       "13              6.3      237.0       25.7          95.0       10.3   \n",
       "14              7.8       10.0       26.0           1.0        2.6   \n",
       "15              0.0        5.0        9.9           1.0        2.0   \n",
       "16              0.0        4.0        7.4           2.0        3.7   \n",
       "17              8.5       10.0       17.0           1.0        1.7   \n",
       "18              4.2        8.0       16.8           2.0        4.2   \n",
       "19              0.0        0.0        0.0           1.0       21.2   \n",
       "20              0.0        7.0       11.1           3.0        4.8   \n",
       "21              1.7       10.0        8.5           4.0        3.4   \n",
       "22              3.7        4.0       14.8           3.0       11.1   \n",
       "23              1.5        4.0        6.2           2.0        3.1   \n",
       "24              0.0        7.0        9.7           3.0        4.2   \n",
       "25              2.7       81.0       10.8          17.0        2.3   \n",
       "26              4.0        5.0       10.1           0.0        0.0   \n",
       "27              2.9      166.0       12.2          34.0        2.5   \n",
       "28              6.6       44.0       20.7          12.0        5.6   \n",
       "29              3.9       36.0       15.5           7.0        3.0   \n",
       "..              ...        ...        ...           ...        ...   \n",
       "500             6.6       55.0       25.9           NaN        NaN   \n",
       "501             0.0       18.0        7.7           7.0        3.0   \n",
       "502             2.3       59.0       12.6          11.0        2.3   \n",
       "503             NaN       18.0       16.4           NaN        NaN   \n",
       "504             1.6       34.0        9.0          10.0        2.6   \n",
       "505             0.0        0.0        0.0           0.0        0.0   \n",
       "506             NaN       15.0       12.5           0.0        0.0   \n",
       "507             NaN       14.0       23.1           NaN        NaN   \n",
       "508             NaN        6.0        6.1           NaN        NaN   \n",
       "509             NaN        9.0        5.6           NaN        NaN   \n",
       "510             NaN       12.0        3.7           7.0        2.1   \n",
       "511             0.0       18.0       16.2           NaN        NaN   \n",
       "512             0.0        6.0        2.7           NaN        NaN   \n",
       "513             NaN        9.0        5.8           NaN        NaN   \n",
       "514             0.0        0.0        0.0           0.0        0.0   \n",
       "515             0.0        NaN        NaN           0.0        0.0   \n",
       "516             NaN        NaN        NaN           NaN        NaN   \n",
       "517             NaN       16.0       16.4           NaN        NaN   \n",
       "518             2.3      173.0       11.5          30.0        2.0   \n",
       "519             8.0       16.0       21.4           0.0        0.0   \n",
       "520             0.0        NaN        NaN           NaN        NaN   \n",
       "521             NaN        9.0        8.6           NaN        NaN   \n",
       "522             6.1       31.0       17.2           6.0        3.3   \n",
       "523             0.0        7.0       10.8           NaN        NaN   \n",
       "524             NaN        6.0        9.6           NaN        NaN   \n",
       "525             NaN        8.0        8.7           NaN        NaN   \n",
       "526             0.9       70.0        7.2           6.0        0.6   \n",
       "527             NaN        8.0       19.5           NaN        NaN   \n",
       "528             0.0        NaN        NaN           0.0        0.0   \n",
       "529             2.0     1192.0       10.6         213.0        1.9   \n",
       "\n",
       "         Apr-Jun, 2016             \n",
       "Location        Number Crude Rate  \n",
       "0                  6.0        1.9  \n",
       "1                  1.0        2.1  \n",
       "2                  3.0        1.5  \n",
       "3                  3.0        3.9  \n",
       "4                  2.0        2.6  \n",
       "5                  2.0        1.5  \n",
       "6                  0.0        0.0  \n",
       "7                  0.0        0.0  \n",
       "8                  0.0        0.0  \n",
       "9                  4.0        6.5  \n",
       "10                 1.0        2.1  \n",
       "11                 2.0        4.3  \n",
       "12                11.0        3.7  \n",
       "13                27.0        2.9  \n",
       "14                 0.0        0.0  \n",
       "15                 0.0        0.0  \n",
       "16                 0.0        0.0  \n",
       "17                 2.0        3.4  \n",
       "18                 1.0        2.1  \n",
       "19                 0.0        0.0  \n",
       "20                 1.0        1.6  \n",
       "21                 2.0        1.7  \n",
       "22                 2.0        7.4  \n",
       "23                 1.0        1.5  \n",
       "24                 3.0        4.2  \n",
       "25                18.0        2.4  \n",
       "26                 0.0        0.0  \n",
       "27                16.0        1.2  \n",
       "28                 6.0        2.8  \n",
       "29                13.0        5.6  \n",
       "..                 ...        ...  \n",
       "500               10.0        4.7  \n",
       "501                NaN        NaN  \n",
       "502                7.0        1.5  \n",
       "503                NaN        NaN  \n",
       "504                NaN        NaN  \n",
       "505                NaN        NaN  \n",
       "506                NaN        NaN  \n",
       "507                NaN        NaN  \n",
       "508                NaN        NaN  \n",
       "509                NaN        NaN  \n",
       "510                NaN        NaN  \n",
       "511                NaN        NaN  \n",
       "512                NaN        NaN  \n",
       "513                0.0        0.0  \n",
       "514                NaN        NaN  \n",
       "515                0.0        0.0  \n",
       "516                0.0        0.0  \n",
       "517                NaN        NaN  \n",
       "518               43.0        2.9  \n",
       "519                NaN        NaN  \n",
       "520                NaN        NaN  \n",
       "521                NaN        NaN  \n",
       "522                8.0        4.4  \n",
       "523                NaN        NaN  \n",
       "524                0.0        0.0  \n",
       "525                NaN        NaN  \n",
       "526               14.0        1.4  \n",
       "527                0.0        0.0  \n",
       "528                NaN        NaN  \n",
       "529              232.0        2.1  \n",
       "\n",
       "[530 rows x 14 columns]"
      ]
     },
     "execution_count": 279,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nys_gov.reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 280,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>Location</th>\n",
       "      <th>level_0</th>\n",
       "      <th>level_1</th>\n",
       "      <th>level_2</th>\n",
       "      <th>Crude Rate</th>\n",
       "      <th>Number</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Albany</td>\n",
       "      <td>2015 Total</td>\n",
       "      <td>10.0</td>\n",
       "      <td>31.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Albany</td>\n",
       "      <td>Apr-Jun, 2015</td>\n",
       "      <td>2.6</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Albany</td>\n",
       "      <td>Apr-Jun, 2016</td>\n",
       "      <td>1.9</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Albany</td>\n",
       "      <td>Jan-Mar, 2016</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Albany</td>\n",
       "      <td>Jul-Sep, 2015</td>\n",
       "      <td>3.9</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Albany</td>\n",
       "      <td>Oct-Dec, 2015</td>\n",
       "      <td>2.3</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Allegany</td>\n",
       "      <td>2015 Total</td>\n",
       "      <td>10.5</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Allegany</td>\n",
       "      <td>Apr-Jun, 2015</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Allegany</td>\n",
       "      <td>Apr-Jun, 2016</td>\n",
       "      <td>2.1</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Allegany</td>\n",
       "      <td>Jan-Mar, 2016</td>\n",
       "      <td>2.1</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Allegany</td>\n",
       "      <td>Jul-Sep, 2015</td>\n",
       "      <td>2.1</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Allegany</td>\n",
       "      <td>Oct-Dec, 2015</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Broome</td>\n",
       "      <td>2015 Total</td>\n",
       "      <td>14.2</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Broome</td>\n",
       "      <td>Apr-Jun, 2015</td>\n",
       "      <td>4.1</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Broome</td>\n",
       "      <td>Apr-Jun, 2016</td>\n",
       "      <td>1.5</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Broome</td>\n",
       "      <td>Jan-Mar, 2016</td>\n",
       "      <td>8.1</td>\n",
       "      <td>16.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Broome</td>\n",
       "      <td>Jul-Sep, 2015</td>\n",
       "      <td>3.1</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Broome</td>\n",
       "      <td>Oct-Dec, 2015</td>\n",
       "      <td>3.1</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Cattaraugus</td>\n",
       "      <td>2015 Total</td>\n",
       "      <td>14.1</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Cattaraugus</td>\n",
       "      <td>Apr-Jun, 2015</td>\n",
       "      <td>5.1</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Cattaraugus</td>\n",
       "      <td>Apr-Jun, 2016</td>\n",
       "      <td>3.9</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Cattaraugus</td>\n",
       "      <td>Jan-Mar, 2016</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Cattaraugus</td>\n",
       "      <td>Jul-Sep, 2015</td>\n",
       "      <td>3.9</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Cattaraugus</td>\n",
       "      <td>Oct-Dec, 2015</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Cayuga</td>\n",
       "      <td>2015 Total</td>\n",
       "      <td>21.7</td>\n",
       "      <td>17.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Cayuga</td>\n",
       "      <td>Apr-Jun, 2015</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Cayuga</td>\n",
       "      <td>Apr-Jun, 2016</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Cayuga</td>\n",
       "      <td>Jan-Mar, 2016</td>\n",
       "      <td>5.1</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Cayuga</td>\n",
       "      <td>Jul-Sep, 2015</td>\n",
       "      <td>7.7</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>All opioid overdose deaths and rates per 100,0...</td>\n",
       "      <td>Cayuga</td>\n",
       "      <td>Oct-Dec, 2015</td>\n",
       "      <td>6.4</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2156</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Tioga</td>\n",
       "      <td>Jul-Sep, 2015</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2157</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Tioga</td>\n",
       "      <td>Oct-Dec, 2015</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2158</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Tompkins</td>\n",
       "      <td>2015 Total</td>\n",
       "      <td>8.6</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2159</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Ulster</td>\n",
       "      <td>2015 Total</td>\n",
       "      <td>17.2</td>\n",
       "      <td>31.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2160</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Ulster</td>\n",
       "      <td>Apr-Jun, 2015</td>\n",
       "      <td>3.3</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2161</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Ulster</td>\n",
       "      <td>Apr-Jun, 2016</td>\n",
       "      <td>4.4</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2162</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Ulster</td>\n",
       "      <td>Jan-Mar, 2016</td>\n",
       "      <td>3.3</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2163</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Ulster</td>\n",
       "      <td>Jul-Sep, 2015</td>\n",
       "      <td>3.3</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2164</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Ulster</td>\n",
       "      <td>Oct-Dec, 2015</td>\n",
       "      <td>6.1</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2165</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Warren</td>\n",
       "      <td>2015 Total</td>\n",
       "      <td>10.8</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2166</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Warren</td>\n",
       "      <td>Oct-Dec, 2015</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2167</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Washington</td>\n",
       "      <td>2015 Total</td>\n",
       "      <td>9.6</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2168</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Washington</td>\n",
       "      <td>Apr-Jun, 2016</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2169</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Wayne</td>\n",
       "      <td>2015 Total</td>\n",
       "      <td>8.7</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2170</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Westchester</td>\n",
       "      <td>2015 Total</td>\n",
       "      <td>7.2</td>\n",
       "      <td>70.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2171</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Westchester</td>\n",
       "      <td>Apr-Jun, 2015</td>\n",
       "      <td>2.2</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2172</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Westchester</td>\n",
       "      <td>Apr-Jun, 2016</td>\n",
       "      <td>1.4</td>\n",
       "      <td>14.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2173</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Westchester</td>\n",
       "      <td>Jan-Mar, 2016</td>\n",
       "      <td>0.6</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2174</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Westchester</td>\n",
       "      <td>Jul-Sep, 2015</td>\n",
       "      <td>3.0</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2175</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Westchester</td>\n",
       "      <td>Oct-Dec, 2015</td>\n",
       "      <td>0.9</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2176</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>2015 Total</td>\n",
       "      <td>19.5</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2177</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>Apr-Jun, 2016</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2178</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Yates</td>\n",
       "      <td>Jan-Mar, 2016</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2179</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>Yates</td>\n",
       "      <td>Oct-Dec, 2015</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2180</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>ROS</td>\n",
       "      <td>2015 Total</td>\n",
       "      <td>10.6</td>\n",
       "      <td>1192.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2181</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>ROS</td>\n",
       "      <td>Apr-Jun, 2015</td>\n",
       "      <td>3.1</td>\n",
       "      <td>353.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2182</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>ROS</td>\n",
       "      <td>Apr-Jun, 2016</td>\n",
       "      <td>2.1</td>\n",
       "      <td>232.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2183</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>ROS</td>\n",
       "      <td>Jan-Mar, 2016</td>\n",
       "      <td>1.9</td>\n",
       "      <td>213.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2184</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>ROS</td>\n",
       "      <td>Jul-Sep, 2015</td>\n",
       "      <td>3.1</td>\n",
       "      <td>352.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2185</th>\n",
       "      <td>Opioid overdose excluding heroin hospitalizati...</td>\n",
       "      <td>ROS</td>\n",
       "      <td>Oct-Dec, 2015</td>\n",
       "      <td>2.0</td>\n",
       "      <td>224.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2186 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Location                                            level_0      level_1  \\\n",
       "0         All opioid overdose deaths and rates per 100,0...       Albany   \n",
       "1         All opioid overdose deaths and rates per 100,0...       Albany   \n",
       "2         All opioid overdose deaths and rates per 100,0...       Albany   \n",
       "3         All opioid overdose deaths and rates per 100,0...       Albany   \n",
       "4         All opioid overdose deaths and rates per 100,0...       Albany   \n",
       "5         All opioid overdose deaths and rates per 100,0...       Albany   \n",
       "6         All opioid overdose deaths and rates per 100,0...     Allegany   \n",
       "7         All opioid overdose deaths and rates per 100,0...     Allegany   \n",
       "8         All opioid overdose deaths and rates per 100,0...     Allegany   \n",
       "9         All opioid overdose deaths and rates per 100,0...     Allegany   \n",
       "10        All opioid overdose deaths and rates per 100,0...     Allegany   \n",
       "11        All opioid overdose deaths and rates per 100,0...     Allegany   \n",
       "12        All opioid overdose deaths and rates per 100,0...       Broome   \n",
       "13        All opioid overdose deaths and rates per 100,0...       Broome   \n",
       "14        All opioid overdose deaths and rates per 100,0...       Broome   \n",
       "15        All opioid overdose deaths and rates per 100,0...       Broome   \n",
       "16        All opioid overdose deaths and rates per 100,0...       Broome   \n",
       "17        All opioid overdose deaths and rates per 100,0...       Broome   \n",
       "18        All opioid overdose deaths and rates per 100,0...  Cattaraugus   \n",
       "19        All opioid overdose deaths and rates per 100,0...  Cattaraugus   \n",
       "20        All opioid overdose deaths and rates per 100,0...  Cattaraugus   \n",
       "21        All opioid overdose deaths and rates per 100,0...  Cattaraugus   \n",
       "22        All opioid overdose deaths and rates per 100,0...  Cattaraugus   \n",
       "23        All opioid overdose deaths and rates per 100,0...  Cattaraugus   \n",
       "24        All opioid overdose deaths and rates per 100,0...       Cayuga   \n",
       "25        All opioid overdose deaths and rates per 100,0...       Cayuga   \n",
       "26        All opioid overdose deaths and rates per 100,0...       Cayuga   \n",
       "27        All opioid overdose deaths and rates per 100,0...       Cayuga   \n",
       "28        All opioid overdose deaths and rates per 100,0...       Cayuga   \n",
       "29        All opioid overdose deaths and rates per 100,0...       Cayuga   \n",
       "...                                                     ...          ...   \n",
       "2156      Opioid overdose excluding heroin hospitalizati...        Tioga   \n",
       "2157      Opioid overdose excluding heroin hospitalizati...        Tioga   \n",
       "2158      Opioid overdose excluding heroin hospitalizati...     Tompkins   \n",
       "2159      Opioid overdose excluding heroin hospitalizati...       Ulster   \n",
       "2160      Opioid overdose excluding heroin hospitalizati...       Ulster   \n",
       "2161      Opioid overdose excluding heroin hospitalizati...       Ulster   \n",
       "2162      Opioid overdose excluding heroin hospitalizati...       Ulster   \n",
       "2163      Opioid overdose excluding heroin hospitalizati...       Ulster   \n",
       "2164      Opioid overdose excluding heroin hospitalizati...       Ulster   \n",
       "2165      Opioid overdose excluding heroin hospitalizati...       Warren   \n",
       "2166      Opioid overdose excluding heroin hospitalizati...       Warren   \n",
       "2167      Opioid overdose excluding heroin hospitalizati...   Washington   \n",
       "2168      Opioid overdose excluding heroin hospitalizati...   Washington   \n",
       "2169      Opioid overdose excluding heroin hospitalizati...        Wayne   \n",
       "2170      Opioid overdose excluding heroin hospitalizati...  Westchester   \n",
       "2171      Opioid overdose excluding heroin hospitalizati...  Westchester   \n",
       "2172      Opioid overdose excluding heroin hospitalizati...  Westchester   \n",
       "2173      Opioid overdose excluding heroin hospitalizati...  Westchester   \n",
       "2174      Opioid overdose excluding heroin hospitalizati...  Westchester   \n",
       "2175      Opioid overdose excluding heroin hospitalizati...  Westchester   \n",
       "2176      Opioid overdose excluding heroin hospitalizati...      Wyoming   \n",
       "2177      Opioid overdose excluding heroin hospitalizati...      Wyoming   \n",
       "2178      Opioid overdose excluding heroin hospitalizati...        Yates   \n",
       "2179      Opioid overdose excluding heroin hospitalizati...        Yates   \n",
       "2180      Opioid overdose excluding heroin hospitalizati...          ROS   \n",
       "2181      Opioid overdose excluding heroin hospitalizati...          ROS   \n",
       "2182      Opioid overdose excluding heroin hospitalizati...          ROS   \n",
       "2183      Opioid overdose excluding heroin hospitalizati...          ROS   \n",
       "2184      Opioid overdose excluding heroin hospitalizati...          ROS   \n",
       "2185      Opioid overdose excluding heroin hospitalizati...          ROS   \n",
       "\n",
       "Location        level_2  Crude Rate  Number  \n",
       "0            2015 Total        10.0    31.0  \n",
       "1         Apr-Jun, 2015         2.6     8.0  \n",
       "2         Apr-Jun, 2016         1.9     6.0  \n",
       "3         Jan-Mar, 2016         0.3     1.0  \n",
       "4         Jul-Sep, 2015         3.9    12.0  \n",
       "5         Oct-Dec, 2015         2.3     7.0  \n",
       "6            2015 Total        10.5     5.0  \n",
       "7         Apr-Jun, 2015         0.0     0.0  \n",
       "8         Apr-Jun, 2016         2.1     1.0  \n",
       "9         Jan-Mar, 2016         2.1     1.0  \n",
       "10        Jul-Sep, 2015         2.1     1.0  \n",
       "11        Oct-Dec, 2015         4.2     2.0  \n",
       "12           2015 Total        14.2    28.0  \n",
       "13        Apr-Jun, 2015         4.1     8.0  \n",
       "14        Apr-Jun, 2016         1.5     3.0  \n",
       "15        Jan-Mar, 2016         8.1    16.0  \n",
       "16        Jul-Sep, 2015         3.1     6.0  \n",
       "17        Oct-Dec, 2015         3.1     6.0  \n",
       "18           2015 Total        14.1    11.0  \n",
       "19        Apr-Jun, 2015         5.1     4.0  \n",
       "20        Apr-Jun, 2016         3.9     3.0  \n",
       "21        Jan-Mar, 2016         0.0     0.0  \n",
       "22        Jul-Sep, 2015         3.9     3.0  \n",
       "23        Oct-Dec, 2015         1.3     1.0  \n",
       "24           2015 Total        21.7    17.0  \n",
       "25        Apr-Jun, 2015         3.8     3.0  \n",
       "26        Apr-Jun, 2016         2.6     2.0  \n",
       "27        Jan-Mar, 2016         5.1     4.0  \n",
       "28        Jul-Sep, 2015         7.7     6.0  \n",
       "29        Oct-Dec, 2015         6.4     5.0  \n",
       "...                 ...         ...     ...  \n",
       "2156      Jul-Sep, 2015         0.0     0.0  \n",
       "2157      Oct-Dec, 2015         0.0     0.0  \n",
       "2158         2015 Total         8.6     9.0  \n",
       "2159         2015 Total        17.2    31.0  \n",
       "2160      Apr-Jun, 2015         3.3     6.0  \n",
       "2161      Apr-Jun, 2016         4.4     8.0  \n",
       "2162      Jan-Mar, 2016         3.3     6.0  \n",
       "2163      Jul-Sep, 2015         3.3     6.0  \n",
       "2164      Oct-Dec, 2015         6.1    11.0  \n",
       "2165         2015 Total        10.8     7.0  \n",
       "2166      Oct-Dec, 2015         0.0     0.0  \n",
       "2167         2015 Total         9.6     6.0  \n",
       "2168      Apr-Jun, 2016         0.0     0.0  \n",
       "2169         2015 Total         8.7     8.0  \n",
       "2170         2015 Total         7.2    70.0  \n",
       "2171      Apr-Jun, 2015         2.2    21.0  \n",
       "2172      Apr-Jun, 2016         1.4    14.0  \n",
       "2173      Jan-Mar, 2016         0.6     6.0  \n",
       "2174      Jul-Sep, 2015         3.0    29.0  \n",
       "2175      Oct-Dec, 2015         0.9     9.0  \n",
       "2176         2015 Total        19.5     8.0  \n",
       "2177      Apr-Jun, 2016         0.0     0.0  \n",
       "2178      Jan-Mar, 2016         0.0     0.0  \n",
       "2179      Oct-Dec, 2015         0.0     0.0  \n",
       "2180         2015 Total        10.6  1192.0  \n",
       "2181      Apr-Jun, 2015         3.1   353.0  \n",
       "2182      Apr-Jun, 2016         2.1   232.0  \n",
       "2183      Jan-Mar, 2016         1.9   213.0  \n",
       "2184      Jul-Sep, 2015         3.1   352.0  \n",
       "2185      Oct-Dec, 2015         2.0   224.0  \n",
       "\n",
       "[2186 rows x 5 columns]"
      ]
     },
     "execution_count": 280,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nys_gov.stack(level=0).reset_index()"
   ]
  }
 ],
 "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.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}