emissions_totals_gut_check.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "pd.set_option('display.max_columns', None)\n",
    "\n",
    "emissions = pd.read_csv('charts/us_emissions_2000_2018.csv')\n",
    "\n",
    "sub_sectors = ['emission_sub_electric', 'emission_sub_commercial', 'emission_sub_residential', \n",
    "               'emission_sub_industrial', 'emission_sub_transportation', 'emission_sub_fugitive', \n",
    "               'emission_by_waste', 'emission_by_agriculture', 'emission_by_industrial']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1508 entries, 0 to 1507\n",
      "Data columns (total 23 columns):\n",
      " #   Column                          Non-Null Count  Dtype  \n",
      "---  ------                          --------------  -----  \n",
      " 0   State                           1508 non-null   object \n",
      " 1   Year                            1508 non-null   int64  \n",
      " 2   total_emissions_excluding_lucf  1508 non-null   float64\n",
      " 3   total_emissions_including_lucf  1508 non-null   float64\n",
      " 4   total_co2                       1508 non-null   float64\n",
      " 5   total_ch4                       1508 non-null   float64\n",
      " 6   total_n2o                       1508 non-null   float64\n",
      " 7   total_f_gas                     1508 non-null   float64\n",
      " 8   emission_by_energy              1508 non-null   float64\n",
      " 9   emission_by_industrial          1508 non-null   float64\n",
      " 10  emission_by_agriculture         1508 non-null   float64\n",
      " 11  emission_by_waste               1508 non-null   float64\n",
      " 12  emission_by_forestry            1508 non-null   float64\n",
      " 13  emission_by_bunker_fuel         1508 non-null   float64\n",
      " 14  emission_sub_electric           1508 non-null   float64\n",
      " 15  emission_sub_commercial         1508 non-null   float64\n",
      " 16  emission_sub_residential        1508 non-null   float64\n",
      " 17  emission_sub_industrial         1508 non-null   float64\n",
      " 18  emission_sub_transportation     1508 non-null   float64\n",
      " 19  emission_sub_fugitive           1508 non-null   float64\n",
      " 20  state_gdp                       1508 non-null   float64\n",
      " 21  population                      1508 non-null   int64  \n",
      " 22  total_energy_use                1508 non-null   float64\n",
      "dtypes: float64(20), int64(2), object(1)\n",
      "memory usage: 271.1+ KB\n"
     ]
    }
   ],
   "source": [
    "emissions.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [],
   "source": [
    "emissions['sub_sector_total'] = emissions.apply(lambda row: row[sub_sectors].sum(), axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [],
   "source": [
    "emissions['total_sub_difference'] = emissions['total_emissions_excluding_lucf'] - emissions['sub_sector_total']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [],
   "source": [
    "emissions['%_diff'] = round(emissions['total_sub_difference'] / emissions['total_emissions_excluding_lucf'], 3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "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>%_diff</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>State</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Alabama</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alaska</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nevada</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>New Hampshire</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>New Jersey</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>New Mexico</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>New York</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>North Carolina</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>North Dakota</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ohio</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Oklahoma</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Oregon</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pennsylvania</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rhode Island</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>South Carolina</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>South Dakota</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tennessee</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Texas</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>United States</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Utah</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Vermont</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Virginia</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Washington</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>West Virginia</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Wisconsin</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nebraska</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Montana</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Missouri</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Idaho</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Arizona</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Arkansas</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>California</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Colorado</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Connecticut</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Delaware</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>District Of Columbia</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Florida</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Georgia</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hawaii</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Illinois</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mississippi</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Indiana</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Iowa</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kansas</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kentucky</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Louisiana</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Maine</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Maryland</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Massachusetts</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Michigan</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Minnesota</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Wyoming</th>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      %_diff\n",
       "State                       \n",
       "Alabama                  0.0\n",
       "Alaska                   0.0\n",
       "Nevada                   0.0\n",
       "New Hampshire            0.0\n",
       "New Jersey               0.0\n",
       "New Mexico               0.0\n",
       "New York                 0.0\n",
       "North Carolina           0.0\n",
       "North Dakota             0.0\n",
       "Ohio                     0.0\n",
       "Oklahoma                 0.0\n",
       "Oregon                   0.0\n",
       "Pennsylvania             0.0\n",
       "Rhode Island             0.0\n",
       "South Carolina           0.0\n",
       "South Dakota             0.0\n",
       "Tennessee                0.0\n",
       "Texas                    0.0\n",
       "United States            0.0\n",
       "Utah                     0.0\n",
       "Vermont                  0.0\n",
       "Virginia                 0.0\n",
       "Washington               0.0\n",
       "West Virginia            0.0\n",
       "Wisconsin                0.0\n",
       "Nebraska                 0.0\n",
       "Montana                  0.0\n",
       "Missouri                 0.0\n",
       "Idaho                    0.0\n",
       "Arizona                  0.0\n",
       "Arkansas                 0.0\n",
       "California               0.0\n",
       "Colorado                 0.0\n",
       "Connecticut              0.0\n",
       "Delaware                 0.0\n",
       "District Of Columbia     0.0\n",
       "Florida                  0.0\n",
       "Georgia                  0.0\n",
       "Hawaii                   0.0\n",
       "Illinois                 0.0\n",
       "Mississippi              0.0\n",
       "Indiana                  0.0\n",
       "Iowa                     0.0\n",
       "Kansas                   0.0\n",
       "Kentucky                 0.0\n",
       "Louisiana                0.0\n",
       "Maine                    0.0\n",
       "Maryland                 0.0\n",
       "Massachusetts            0.0\n",
       "Michigan                 0.0\n",
       "Minnesota                0.0\n",
       "Wyoming                  0.0"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "emissions.groupby('State').agg({'%_diff':'mean'}).sort_values(by='%_diff', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "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>State</th>\n",
       "      <th>Year</th>\n",
       "      <th>total_emissions_excluding_lucf</th>\n",
       "      <th>total_emissions_including_lucf</th>\n",
       "      <th>total_co2</th>\n",
       "      <th>total_ch4</th>\n",
       "      <th>total_n2o</th>\n",
       "      <th>total_f_gas</th>\n",
       "      <th>emission_by_energy</th>\n",
       "      <th>emission_by_industrial</th>\n",
       "      <th>emission_by_agriculture</th>\n",
       "      <th>emission_by_waste</th>\n",
       "      <th>emission_by_forestry</th>\n",
       "      <th>emission_by_bunker_fuel</th>\n",
       "      <th>emission_sub_electric</th>\n",
       "      <th>emission_sub_commercial</th>\n",
       "      <th>emission_sub_residential</th>\n",
       "      <th>emission_sub_industrial</th>\n",
       "      <th>emission_sub_transportation</th>\n",
       "      <th>emission_sub_fugitive</th>\n",
       "      <th>state_gdp</th>\n",
       "      <th>population</th>\n",
       "      <th>total_energy_use</th>\n",
       "      <th>sub_sector_total</th>\n",
       "      <th>total_sub_difference</th>\n",
       "      <th>%_diff</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1189</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>1990</td>\n",
       "      <td>28.386372</td>\n",
       "      <td>24.913264</td>\n",
       "      <td>12.130215</td>\n",
       "      <td>6.999835</td>\n",
       "      <td>9.201620</td>\n",
       "      <td>0.054702</td>\n",
       "      <td>12.619985</td>\n",
       "      <td>0.076289</td>\n",
       "      <td>15.340</td>\n",
       "      <td>0.350098</td>\n",
       "      <td>-3.473107</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.112679</td>\n",
       "      <td>0.692023</td>\n",
       "      <td>1.383120</td>\n",
       "      <td>2.124677</td>\n",
       "      <td>4.916453</td>\n",
       "      <td>0.391034</td>\n",
       "      <td>14696.0</td>\n",
       "      <td>697101</td>\n",
       "      <td>5476.271319</td>\n",
       "      <td>28.386372</td>\n",
       "      <td>2.999997e-09</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1190</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>1991</td>\n",
       "      <td>29.067201</td>\n",
       "      <td>25.147528</td>\n",
       "      <td>12.300584</td>\n",
       "      <td>7.215336</td>\n",
       "      <td>9.496240</td>\n",
       "      <td>0.055041</td>\n",
       "      <td>12.507809</td>\n",
       "      <td>0.411759</td>\n",
       "      <td>15.788</td>\n",
       "      <td>0.359634</td>\n",
       "      <td>-3.919673</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.370617</td>\n",
       "      <td>0.687531</td>\n",
       "      <td>1.223648</td>\n",
       "      <td>2.030410</td>\n",
       "      <td>4.687325</td>\n",
       "      <td>0.508277</td>\n",
       "      <td>15411.0</td>\n",
       "      <td>703669</td>\n",
       "      <td>5383.209280</td>\n",
       "      <td>29.067201</td>\n",
       "      <td>-2.000000e-09</td>\n",
       "      <td>-0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1191</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>1992</td>\n",
       "      <td>29.151399</td>\n",
       "      <td>25.755961</td>\n",
       "      <td>12.441311</td>\n",
       "      <td>7.432485</td>\n",
       "      <td>9.220926</td>\n",
       "      <td>0.056677</td>\n",
       "      <td>12.673497</td>\n",
       "      <td>0.437148</td>\n",
       "      <td>15.665</td>\n",
       "      <td>0.375755</td>\n",
       "      <td>-3.395438</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.142018</td>\n",
       "      <td>0.683628</td>\n",
       "      <td>1.041918</td>\n",
       "      <td>1.951802</td>\n",
       "      <td>5.288593</td>\n",
       "      <td>0.565537</td>\n",
       "      <td>16279.0</td>\n",
       "      <td>712801</td>\n",
       "      <td>5454.146090</td>\n",
       "      <td>29.151399</td>\n",
       "      <td>4.000000e-09</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1192</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>1993</td>\n",
       "      <td>31.230628</td>\n",
       "      <td>29.480818</td>\n",
       "      <td>13.421714</td>\n",
       "      <td>7.910875</td>\n",
       "      <td>9.829761</td>\n",
       "      <td>0.068278</td>\n",
       "      <td>13.382653</td>\n",
       "      <td>0.734159</td>\n",
       "      <td>16.711</td>\n",
       "      <td>0.402816</td>\n",
       "      <td>-1.749811</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.071186</td>\n",
       "      <td>0.753094</td>\n",
       "      <td>1.262753</td>\n",
       "      <td>2.321105</td>\n",
       "      <td>5.384092</td>\n",
       "      <td>0.590423</td>\n",
       "      <td>17208.0</td>\n",
       "      <td>722159</td>\n",
       "      <td>5794.441181</td>\n",
       "      <td>31.230628</td>\n",
       "      <td>-4.999997e-09</td>\n",
       "      <td>-0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1193</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>1994</td>\n",
       "      <td>32.092279</td>\n",
       "      <td>28.006346</td>\n",
       "      <td>14.154573</td>\n",
       "      <td>8.006317</td>\n",
       "      <td>9.841240</td>\n",
       "      <td>0.090149</td>\n",
       "      <td>14.077378</td>\n",
       "      <td>0.821444</td>\n",
       "      <td>16.786</td>\n",
       "      <td>0.407457</td>\n",
       "      <td>-4.085933</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.346625</td>\n",
       "      <td>0.748646</td>\n",
       "      <td>1.179905</td>\n",
       "      <td>2.478764</td>\n",
       "      <td>5.724230</td>\n",
       "      <td>0.599208</td>\n",
       "      <td>18141.0</td>\n",
       "      <td>730790</td>\n",
       "      <td>5954.886889</td>\n",
       "      <td>32.092279</td>\n",
       "      <td>-9.999965e-10</td>\n",
       "      <td>-0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1194</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>1995</td>\n",
       "      <td>32.406297</td>\n",
       "      <td>29.826404</td>\n",
       "      <td>13.951333</td>\n",
       "      <td>8.480799</td>\n",
       "      <td>9.839173</td>\n",
       "      <td>0.134992</td>\n",
       "      <td>13.957122</td>\n",
       "      <td>0.842435</td>\n",
       "      <td>17.186</td>\n",
       "      <td>0.420740</td>\n",
       "      <td>-2.579893</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.087306</td>\n",
       "      <td>0.787630</td>\n",
       "      <td>1.239306</td>\n",
       "      <td>2.275036</td>\n",
       "      <td>5.841534</td>\n",
       "      <td>0.726310</td>\n",
       "      <td>18520.0</td>\n",
       "      <td>737925</td>\n",
       "      <td>6044.672982</td>\n",
       "      <td>32.406297</td>\n",
       "      <td>-4.000000e-09</td>\n",
       "      <td>-0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1195</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>1996</td>\n",
       "      <td>32.842451</td>\n",
       "      <td>28.364220</td>\n",
       "      <td>13.920831</td>\n",
       "      <td>8.321656</td>\n",
       "      <td>10.433702</td>\n",
       "      <td>0.166262</td>\n",
       "      <td>13.923210</td>\n",
       "      <td>0.903428</td>\n",
       "      <td>17.582</td>\n",
       "      <td>0.433813</td>\n",
       "      <td>-4.478231</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.643077</td>\n",
       "      <td>0.827068</td>\n",
       "      <td>1.482789</td>\n",
       "      <td>2.350906</td>\n",
       "      <td>5.838887</td>\n",
       "      <td>0.780483</td>\n",
       "      <td>19410.0</td>\n",
       "      <td>742213</td>\n",
       "      <td>6377.332601</td>\n",
       "      <td>32.842451</td>\n",
       "      <td>-9.999965e-10</td>\n",
       "      <td>-0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1196</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>1997</td>\n",
       "      <td>33.032510</td>\n",
       "      <td>29.788072</td>\n",
       "      <td>14.220960</td>\n",
       "      <td>7.883475</td>\n",
       "      <td>10.733751</td>\n",
       "      <td>0.194323</td>\n",
       "      <td>13.884299</td>\n",
       "      <td>0.976501</td>\n",
       "      <td>17.730</td>\n",
       "      <td>0.441710</td>\n",
       "      <td>-3.244438</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.541123</td>\n",
       "      <td>0.771005</td>\n",
       "      <td>1.352331</td>\n",
       "      <td>2.334321</td>\n",
       "      <td>5.688363</td>\n",
       "      <td>0.197155</td>\n",
       "      <td>22356.0</td>\n",
       "      <td>744223</td>\n",
       "      <td>6117.701357</td>\n",
       "      <td>33.032510</td>\n",
       "      <td>-4.000000e-09</td>\n",
       "      <td>-0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1197</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>1998</td>\n",
       "      <td>33.529395</td>\n",
       "      <td>29.704590</td>\n",
       "      <td>13.675462</td>\n",
       "      <td>7.723222</td>\n",
       "      <td>11.921785</td>\n",
       "      <td>0.208927</td>\n",
       "      <td>13.309288</td>\n",
       "      <td>1.004855</td>\n",
       "      <td>18.772</td>\n",
       "      <td>0.443251</td>\n",
       "      <td>-3.824805</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.297077</td>\n",
       "      <td>0.673627</td>\n",
       "      <td>1.143382</td>\n",
       "      <td>2.156288</td>\n",
       "      <td>5.854561</td>\n",
       "      <td>0.184353</td>\n",
       "      <td>23774.0</td>\n",
       "      <td>746058</td>\n",
       "      <td>6047.369337</td>\n",
       "      <td>33.529395</td>\n",
       "      <td>-2.000000e-09</td>\n",
       "      <td>-0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1198</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>1999</td>\n",
       "      <td>35.177335</td>\n",
       "      <td>30.655336</td>\n",
       "      <td>14.282818</td>\n",
       "      <td>8.149249</td>\n",
       "      <td>12.512923</td>\n",
       "      <td>0.232345</td>\n",
       "      <td>13.923750</td>\n",
       "      <td>1.015378</td>\n",
       "      <td>19.793</td>\n",
       "      <td>0.445207</td>\n",
       "      <td>-4.521999</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.705927</td>\n",
       "      <td>0.673347</td>\n",
       "      <td>1.115746</td>\n",
       "      <td>2.244750</td>\n",
       "      <td>5.997861</td>\n",
       "      <td>0.186118</td>\n",
       "      <td>25086.0</td>\n",
       "      <td>750412</td>\n",
       "      <td>6185.916612</td>\n",
       "      <td>35.177335</td>\n",
       "      <td>3.000004e-09</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1199</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>2000</td>\n",
       "      <td>36.078193</td>\n",
       "      <td>29.393032</td>\n",
       "      <td>15.022505</td>\n",
       "      <td>8.294892</td>\n",
       "      <td>12.511070</td>\n",
       "      <td>0.249726</td>\n",
       "      <td>14.658126</td>\n",
       "      <td>1.052979</td>\n",
       "      <td>19.918</td>\n",
       "      <td>0.449087</td>\n",
       "      <td>-6.685161</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.825430</td>\n",
       "      <td>0.741202</td>\n",
       "      <td>1.230651</td>\n",
       "      <td>2.561352</td>\n",
       "      <td>6.085023</td>\n",
       "      <td>0.214467</td>\n",
       "      <td>26878.0</td>\n",
       "      <td>755844</td>\n",
       "      <td>6530.117637</td>\n",
       "      <td>36.078193</td>\n",
       "      <td>2.000000e-09</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1200</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>2001</td>\n",
       "      <td>37.004302</td>\n",
       "      <td>30.755739</td>\n",
       "      <td>14.338067</td>\n",
       "      <td>8.706529</td>\n",
       "      <td>13.692910</td>\n",
       "      <td>0.266795</td>\n",
       "      <td>13.971856</td>\n",
       "      <td>1.072026</td>\n",
       "      <td>21.510</td>\n",
       "      <td>0.450420</td>\n",
       "      <td>-6.248563</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.841224</td>\n",
       "      <td>0.719141</td>\n",
       "      <td>1.150820</td>\n",
       "      <td>2.033885</td>\n",
       "      <td>5.989327</td>\n",
       "      <td>0.237459</td>\n",
       "      <td>27610.0</td>\n",
       "      <td>757972</td>\n",
       "      <td>6343.111575</td>\n",
       "      <td>37.004302</td>\n",
       "      <td>3.000004e-09</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1201</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>2002</td>\n",
       "      <td>35.926889</td>\n",
       "      <td>28.892098</td>\n",
       "      <td>14.623785</td>\n",
       "      <td>8.550918</td>\n",
       "      <td>12.473247</td>\n",
       "      <td>0.278939</td>\n",
       "      <td>14.190542</td>\n",
       "      <td>1.111247</td>\n",
       "      <td>20.168</td>\n",
       "      <td>0.457099</td>\n",
       "      <td>-7.034791</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.340997</td>\n",
       "      <td>0.710533</td>\n",
       "      <td>1.190345</td>\n",
       "      <td>2.232437</td>\n",
       "      <td>6.495304</td>\n",
       "      <td>0.220927</td>\n",
       "      <td>29734.0</td>\n",
       "      <td>760020</td>\n",
       "      <td>6830.496598</td>\n",
       "      <td>35.926889</td>\n",
       "      <td>2.000000e-09</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1202</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>2003</td>\n",
       "      <td>36.845653</td>\n",
       "      <td>30.411874</td>\n",
       "      <td>14.609438</td>\n",
       "      <td>8.297229</td>\n",
       "      <td>13.650121</td>\n",
       "      <td>0.288865</td>\n",
       "      <td>14.136959</td>\n",
       "      <td>1.154034</td>\n",
       "      <td>21.085</td>\n",
       "      <td>0.469660</td>\n",
       "      <td>-6.433780</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.594456</td>\n",
       "      <td>0.711354</td>\n",
       "      <td>1.217294</td>\n",
       "      <td>2.300946</td>\n",
       "      <td>6.072184</td>\n",
       "      <td>0.240725</td>\n",
       "      <td>30397.0</td>\n",
       "      <td>763729</td>\n",
       "      <td>6938.829580</td>\n",
       "      <td>36.845653</td>\n",
       "      <td>1.000004e-09</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1203</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>2004</td>\n",
       "      <td>37.026089</td>\n",
       "      <td>30.870042</td>\n",
       "      <td>14.628862</td>\n",
       "      <td>8.162657</td>\n",
       "      <td>13.936892</td>\n",
       "      <td>0.297679</td>\n",
       "      <td>14.183887</td>\n",
       "      <td>1.127482</td>\n",
       "      <td>21.233</td>\n",
       "      <td>0.481720</td>\n",
       "      <td>-6.156047</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.820740</td>\n",
       "      <td>0.674922</td>\n",
       "      <td>1.073312</td>\n",
       "      <td>2.195462</td>\n",
       "      <td>6.172237</td>\n",
       "      <td>0.247214</td>\n",
       "      <td>30958.0</td>\n",
       "      <td>770396</td>\n",
       "      <td>7179.107549</td>\n",
       "      <td>37.026089</td>\n",
       "      <td>-4.000000e-09</td>\n",
       "      <td>-0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1204</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>2005</td>\n",
       "      <td>36.593148</td>\n",
       "      <td>30.305293</td>\n",
       "      <td>14.202227</td>\n",
       "      <td>8.469205</td>\n",
       "      <td>13.613378</td>\n",
       "      <td>0.308338</td>\n",
       "      <td>13.680522</td>\n",
       "      <td>1.185300</td>\n",
       "      <td>21.235</td>\n",
       "      <td>0.492326</td>\n",
       "      <td>-6.287855</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.251324</td>\n",
       "      <td>0.666917</td>\n",
       "      <td>1.057845</td>\n",
       "      <td>2.203536</td>\n",
       "      <td>6.257833</td>\n",
       "      <td>0.243067</td>\n",
       "      <td>31549.0</td>\n",
       "      <td>775493</td>\n",
       "      <td>7630.305978</td>\n",
       "      <td>36.593148</td>\n",
       "      <td>-9.999965e-10</td>\n",
       "      <td>-0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1205</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>2006</td>\n",
       "      <td>35.865906</td>\n",
       "      <td>28.583471</td>\n",
       "      <td>14.300741</td>\n",
       "      <td>8.526693</td>\n",
       "      <td>12.714569</td>\n",
       "      <td>0.323903</td>\n",
       "      <td>13.743471</td>\n",
       "      <td>1.224812</td>\n",
       "      <td>20.391</td>\n",
       "      <td>0.506623</td>\n",
       "      <td>-7.282435</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.472360</td>\n",
       "      <td>0.633358</td>\n",
       "      <td>0.989938</td>\n",
       "      <td>2.141793</td>\n",
       "      <td>6.274758</td>\n",
       "      <td>0.231264</td>\n",
       "      <td>31643.0</td>\n",
       "      <td>783033</td>\n",
       "      <td>7762.603759</td>\n",
       "      <td>35.865906</td>\n",
       "      <td>-9.999965e-10</td>\n",
       "      <td>-0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1206</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>2007</td>\n",
       "      <td>37.347595</td>\n",
       "      <td>31.069136</td>\n",
       "      <td>14.809505</td>\n",
       "      <td>8.608946</td>\n",
       "      <td>13.586257</td>\n",
       "      <td>0.342886</td>\n",
       "      <td>14.258754</td>\n",
       "      <td>1.232337</td>\n",
       "      <td>21.335</td>\n",
       "      <td>0.521504</td>\n",
       "      <td>-6.278459</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.977505</td>\n",
       "      <td>0.730243</td>\n",
       "      <td>1.051544</td>\n",
       "      <td>2.749514</td>\n",
       "      <td>6.489634</td>\n",
       "      <td>0.260313</td>\n",
       "      <td>32816.0</td>\n",
       "      <td>791623</td>\n",
       "      <td>8378.027833</td>\n",
       "      <td>37.347595</td>\n",
       "      <td>2.000000e-09</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1207</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>2008</td>\n",
       "      <td>38.227478</td>\n",
       "      <td>32.335362</td>\n",
       "      <td>15.793596</td>\n",
       "      <td>8.492961</td>\n",
       "      <td>13.574864</td>\n",
       "      <td>0.366057</td>\n",
       "      <td>15.324416</td>\n",
       "      <td>1.159382</td>\n",
       "      <td>21.210</td>\n",
       "      <td>0.533680</td>\n",
       "      <td>-5.892116</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.883632</td>\n",
       "      <td>0.792365</td>\n",
       "      <td>1.235446</td>\n",
       "      <td>3.068662</td>\n",
       "      <td>6.093472</td>\n",
       "      <td>0.250840</td>\n",
       "      <td>34302.0</td>\n",
       "      <td>799124</td>\n",
       "      <td>8970.495093</td>\n",
       "      <td>38.227478</td>\n",
       "      <td>4.000007e-09</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1208</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>2009</td>\n",
       "      <td>38.582695</td>\n",
       "      <td>33.580401</td>\n",
       "      <td>15.365002</td>\n",
       "      <td>8.368961</td>\n",
       "      <td>14.456183</td>\n",
       "      <td>0.392549</td>\n",
       "      <td>15.078775</td>\n",
       "      <td>0.998025</td>\n",
       "      <td>22.104</td>\n",
       "      <td>0.401895</td>\n",
       "      <td>-5.002294</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.368948</td>\n",
       "      <td>0.816931</td>\n",
       "      <td>1.167637</td>\n",
       "      <td>3.175979</td>\n",
       "      <td>6.288773</td>\n",
       "      <td>0.260506</td>\n",
       "      <td>34354.0</td>\n",
       "      <td>807067</td>\n",
       "      <td>9211.428250</td>\n",
       "      <td>38.582695</td>\n",
       "      <td>-7.105427e-15</td>\n",
       "      <td>-0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1209</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>2010</td>\n",
       "      <td>39.263221</td>\n",
       "      <td>35.321546</td>\n",
       "      <td>15.717729</td>\n",
       "      <td>8.696008</td>\n",
       "      <td>14.438824</td>\n",
       "      <td>0.410659</td>\n",
       "      <td>15.429443</td>\n",
       "      <td>1.000054</td>\n",
       "      <td>22.429</td>\n",
       "      <td>0.404724</td>\n",
       "      <td>-3.941675</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.495182</td>\n",
       "      <td>0.784150</td>\n",
       "      <td>1.068660</td>\n",
       "      <td>3.319667</td>\n",
       "      <td>6.502886</td>\n",
       "      <td>0.258897</td>\n",
       "      <td>34371.0</td>\n",
       "      <td>816223</td>\n",
       "      <td>9572.336595</td>\n",
       "      <td>39.263221</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1210</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>2011</td>\n",
       "      <td>39.035394</td>\n",
       "      <td>33.439168</td>\n",
       "      <td>15.373723</td>\n",
       "      <td>8.515930</td>\n",
       "      <td>14.725596</td>\n",
       "      <td>0.420145</td>\n",
       "      <td>14.995860</td>\n",
       "      <td>1.104807</td>\n",
       "      <td>22.527</td>\n",
       "      <td>0.407728</td>\n",
       "      <td>-5.596227</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.818383</td>\n",
       "      <td>0.757000</td>\n",
       "      <td>1.060651</td>\n",
       "      <td>3.590808</td>\n",
       "      <td>6.489779</td>\n",
       "      <td>0.279238</td>\n",
       "      <td>35898.0</td>\n",
       "      <td>823593</td>\n",
       "      <td>9637.200306</td>\n",
       "      <td>39.035394</td>\n",
       "      <td>3.000004e-09</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1211</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>2012</td>\n",
       "      <td>38.073530</td>\n",
       "      <td>31.851139</td>\n",
       "      <td>15.710635</td>\n",
       "      <td>8.409228</td>\n",
       "      <td>13.528099</td>\n",
       "      <td>0.425568</td>\n",
       "      <td>15.136856</td>\n",
       "      <td>1.189955</td>\n",
       "      <td>21.335</td>\n",
       "      <td>0.411720</td>\n",
       "      <td>-6.222391</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.165771</td>\n",
       "      <td>0.642421</td>\n",
       "      <td>0.891016</td>\n",
       "      <td>3.495631</td>\n",
       "      <td>6.875894</td>\n",
       "      <td>0.066122</td>\n",
       "      <td>43550.7</td>\n",
       "      <td>833566</td>\n",
       "      <td>376640.000000</td>\n",
       "      <td>38.073530</td>\n",
       "      <td>-6.000000e-09</td>\n",
       "      <td>-0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1212</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>2013</td>\n",
       "      <td>41.705311</td>\n",
       "      <td>37.925633</td>\n",
       "      <td>16.137238</td>\n",
       "      <td>8.635467</td>\n",
       "      <td>16.500606</td>\n",
       "      <td>0.432001</td>\n",
       "      <td>15.544233</td>\n",
       "      <td>1.205784</td>\n",
       "      <td>24.540</td>\n",
       "      <td>0.415294</td>\n",
       "      <td>-3.779678</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.129264</td>\n",
       "      <td>0.796521</td>\n",
       "      <td>1.108457</td>\n",
       "      <td>3.851032</td>\n",
       "      <td>6.599205</td>\n",
       "      <td>0.059752</td>\n",
       "      <td>43737.7</td>\n",
       "      <td>842316</td>\n",
       "      <td>390343.000000</td>\n",
       "      <td>41.705311</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1213</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>2014</td>\n",
       "      <td>42.551761</td>\n",
       "      <td>39.920939</td>\n",
       "      <td>16.178903</td>\n",
       "      <td>8.240409</td>\n",
       "      <td>17.687281</td>\n",
       "      <td>0.445167</td>\n",
       "      <td>15.582228</td>\n",
       "      <td>1.211694</td>\n",
       "      <td>25.482</td>\n",
       "      <td>0.275839</td>\n",
       "      <td>-2.630822</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.998017</td>\n",
       "      <td>0.825192</td>\n",
       "      <td>1.115734</td>\n",
       "      <td>3.727253</td>\n",
       "      <td>6.860861</td>\n",
       "      <td>0.055170</td>\n",
       "      <td>44449.7</td>\n",
       "      <td>849129</td>\n",
       "      <td>393981.000000</td>\n",
       "      <td>42.551761</td>\n",
       "      <td>7.105427e-15</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1214</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>2015</td>\n",
       "      <td>42.886207</td>\n",
       "      <td>39.808289</td>\n",
       "      <td>15.579213</td>\n",
       "      <td>9.175849</td>\n",
       "      <td>17.677385</td>\n",
       "      <td>0.453760</td>\n",
       "      <td>15.703917</td>\n",
       "      <td>1.171104</td>\n",
       "      <td>25.732</td>\n",
       "      <td>0.279186</td>\n",
       "      <td>-3.077918</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.888777</td>\n",
       "      <td>0.732117</td>\n",
       "      <td>0.955124</td>\n",
       "      <td>3.750666</td>\n",
       "      <td>6.953502</td>\n",
       "      <td>1.423731</td>\n",
       "      <td>45371.8</td>\n",
       "      <td>853988</td>\n",
       "      <td>385859.000000</td>\n",
       "      <td>42.886207</td>\n",
       "      <td>1.999993e-09</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1215</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>2016</td>\n",
       "      <td>41.463840</td>\n",
       "      <td>36.801529</td>\n",
       "      <td>15.585012</td>\n",
       "      <td>8.933069</td>\n",
       "      <td>16.485443</td>\n",
       "      <td>0.460316</td>\n",
       "      <td>15.014499</td>\n",
       "      <td>1.176234</td>\n",
       "      <td>24.990</td>\n",
       "      <td>0.283107</td>\n",
       "      <td>-4.662312</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.601046</td>\n",
       "      <td>0.738659</td>\n",
       "      <td>0.969421</td>\n",
       "      <td>3.734954</td>\n",
       "      <td>6.927084</td>\n",
       "      <td>0.043334</td>\n",
       "      <td>45733.6</td>\n",
       "      <td>862996</td>\n",
       "      <td>382983.000000</td>\n",
       "      <td>41.463840</td>\n",
       "      <td>-9.999965e-10</td>\n",
       "      <td>-0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1216</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>2017</td>\n",
       "      <td>40.602473</td>\n",
       "      <td>36.058717</td>\n",
       "      <td>15.306616</td>\n",
       "      <td>8.950832</td>\n",
       "      <td>15.883095</td>\n",
       "      <td>0.461930</td>\n",
       "      <td>14.697301</td>\n",
       "      <td>1.204898</td>\n",
       "      <td>24.394</td>\n",
       "      <td>0.306274</td>\n",
       "      <td>-4.543756</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.430266</td>\n",
       "      <td>0.767476</td>\n",
       "      <td>0.973800</td>\n",
       "      <td>3.774712</td>\n",
       "      <td>6.711773</td>\n",
       "      <td>0.039274</td>\n",
       "      <td>46023.9</td>\n",
       "      <td>872868</td>\n",
       "      <td>384986.000000</td>\n",
       "      <td>40.602473</td>\n",
       "      <td>-4.000000e-09</td>\n",
       "      <td>-0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1217</th>\n",
       "      <td>South Dakota</td>\n",
       "      <td>2018</td>\n",
       "      <td>42.687138</td>\n",
       "      <td>38.637315</td>\n",
       "      <td>16.160010</td>\n",
       "      <td>9.283869</td>\n",
       "      <td>16.778220</td>\n",
       "      <td>0.465039</td>\n",
       "      <td>15.621569</td>\n",
       "      <td>1.142578</td>\n",
       "      <td>25.613</td>\n",
       "      <td>0.309991</td>\n",
       "      <td>-4.049823</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.841137</td>\n",
       "      <td>0.871226</td>\n",
       "      <td>1.175242</td>\n",
       "      <td>3.842051</td>\n",
       "      <td>6.856952</td>\n",
       "      <td>0.034960</td>\n",
       "      <td>47287.0</td>\n",
       "      <td>878698</td>\n",
       "      <td>396837.000000</td>\n",
       "      <td>42.687138</td>\n",
       "      <td>3.000004e-09</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             State  Year  total_emissions_excluding_lucf  \\\n",
       "1189  South Dakota  1990                       28.386372   \n",
       "1190  South Dakota  1991                       29.067201   \n",
       "1191  South Dakota  1992                       29.151399   \n",
       "1192  South Dakota  1993                       31.230628   \n",
       "1193  South Dakota  1994                       32.092279   \n",
       "1194  South Dakota  1995                       32.406297   \n",
       "1195  South Dakota  1996                       32.842451   \n",
       "1196  South Dakota  1997                       33.032510   \n",
       "1197  South Dakota  1998                       33.529395   \n",
       "1198  South Dakota  1999                       35.177335   \n",
       "1199  South Dakota  2000                       36.078193   \n",
       "1200  South Dakota  2001                       37.004302   \n",
       "1201  South Dakota  2002                       35.926889   \n",
       "1202  South Dakota  2003                       36.845653   \n",
       "1203  South Dakota  2004                       37.026089   \n",
       "1204  South Dakota  2005                       36.593148   \n",
       "1205  South Dakota  2006                       35.865906   \n",
       "1206  South Dakota  2007                       37.347595   \n",
       "1207  South Dakota  2008                       38.227478   \n",
       "1208  South Dakota  2009                       38.582695   \n",
       "1209  South Dakota  2010                       39.263221   \n",
       "1210  South Dakota  2011                       39.035394   \n",
       "1211  South Dakota  2012                       38.073530   \n",
       "1212  South Dakota  2013                       41.705311   \n",
       "1213  South Dakota  2014                       42.551761   \n",
       "1214  South Dakota  2015                       42.886207   \n",
       "1215  South Dakota  2016                       41.463840   \n",
       "1216  South Dakota  2017                       40.602473   \n",
       "1217  South Dakota  2018                       42.687138   \n",
       "\n",
       "      total_emissions_including_lucf  total_co2  total_ch4  total_n2o  \\\n",
       "1189                       24.913264  12.130215   6.999835   9.201620   \n",
       "1190                       25.147528  12.300584   7.215336   9.496240   \n",
       "1191                       25.755961  12.441311   7.432485   9.220926   \n",
       "1192                       29.480818  13.421714   7.910875   9.829761   \n",
       "1193                       28.006346  14.154573   8.006317   9.841240   \n",
       "1194                       29.826404  13.951333   8.480799   9.839173   \n",
       "1195                       28.364220  13.920831   8.321656  10.433702   \n",
       "1196                       29.788072  14.220960   7.883475  10.733751   \n",
       "1197                       29.704590  13.675462   7.723222  11.921785   \n",
       "1198                       30.655336  14.282818   8.149249  12.512923   \n",
       "1199                       29.393032  15.022505   8.294892  12.511070   \n",
       "1200                       30.755739  14.338067   8.706529  13.692910   \n",
       "1201                       28.892098  14.623785   8.550918  12.473247   \n",
       "1202                       30.411874  14.609438   8.297229  13.650121   \n",
       "1203                       30.870042  14.628862   8.162657  13.936892   \n",
       "1204                       30.305293  14.202227   8.469205  13.613378   \n",
       "1205                       28.583471  14.300741   8.526693  12.714569   \n",
       "1206                       31.069136  14.809505   8.608946  13.586257   \n",
       "1207                       32.335362  15.793596   8.492961  13.574864   \n",
       "1208                       33.580401  15.365002   8.368961  14.456183   \n",
       "1209                       35.321546  15.717729   8.696008  14.438824   \n",
       "1210                       33.439168  15.373723   8.515930  14.725596   \n",
       "1211                       31.851139  15.710635   8.409228  13.528099   \n",
       "1212                       37.925633  16.137238   8.635467  16.500606   \n",
       "1213                       39.920939  16.178903   8.240409  17.687281   \n",
       "1214                       39.808289  15.579213   9.175849  17.677385   \n",
       "1215                       36.801529  15.585012   8.933069  16.485443   \n",
       "1216                       36.058717  15.306616   8.950832  15.883095   \n",
       "1217                       38.637315  16.160010   9.283869  16.778220   \n",
       "\n",
       "      total_f_gas  emission_by_energy  emission_by_industrial  \\\n",
       "1189     0.054702           12.619985                0.076289   \n",
       "1190     0.055041           12.507809                0.411759   \n",
       "1191     0.056677           12.673497                0.437148   \n",
       "1192     0.068278           13.382653                0.734159   \n",
       "1193     0.090149           14.077378                0.821444   \n",
       "1194     0.134992           13.957122                0.842435   \n",
       "1195     0.166262           13.923210                0.903428   \n",
       "1196     0.194323           13.884299                0.976501   \n",
       "1197     0.208927           13.309288                1.004855   \n",
       "1198     0.232345           13.923750                1.015378   \n",
       "1199     0.249726           14.658126                1.052979   \n",
       "1200     0.266795           13.971856                1.072026   \n",
       "1201     0.278939           14.190542                1.111247   \n",
       "1202     0.288865           14.136959                1.154034   \n",
       "1203     0.297679           14.183887                1.127482   \n",
       "1204     0.308338           13.680522                1.185300   \n",
       "1205     0.323903           13.743471                1.224812   \n",
       "1206     0.342886           14.258754                1.232337   \n",
       "1207     0.366057           15.324416                1.159382   \n",
       "1208     0.392549           15.078775                0.998025   \n",
       "1209     0.410659           15.429443                1.000054   \n",
       "1210     0.420145           14.995860                1.104807   \n",
       "1211     0.425568           15.136856                1.189955   \n",
       "1212     0.432001           15.544233                1.205784   \n",
       "1213     0.445167           15.582228                1.211694   \n",
       "1214     0.453760           15.703917                1.171104   \n",
       "1215     0.460316           15.014499                1.176234   \n",
       "1216     0.461930           14.697301                1.204898   \n",
       "1217     0.465039           15.621569                1.142578   \n",
       "\n",
       "      emission_by_agriculture  emission_by_waste  emission_by_forestry  \\\n",
       "1189                   15.340           0.350098             -3.473107   \n",
       "1190                   15.788           0.359634             -3.919673   \n",
       "1191                   15.665           0.375755             -3.395438   \n",
       "1192                   16.711           0.402816             -1.749811   \n",
       "1193                   16.786           0.407457             -4.085933   \n",
       "1194                   17.186           0.420740             -2.579893   \n",
       "1195                   17.582           0.433813             -4.478231   \n",
       "1196                   17.730           0.441710             -3.244438   \n",
       "1197                   18.772           0.443251             -3.824805   \n",
       "1198                   19.793           0.445207             -4.521999   \n",
       "1199                   19.918           0.449087             -6.685161   \n",
       "1200                   21.510           0.450420             -6.248563   \n",
       "1201                   20.168           0.457099             -7.034791   \n",
       "1202                   21.085           0.469660             -6.433780   \n",
       "1203                   21.233           0.481720             -6.156047   \n",
       "1204                   21.235           0.492326             -6.287855   \n",
       "1205                   20.391           0.506623             -7.282435   \n",
       "1206                   21.335           0.521504             -6.278459   \n",
       "1207                   21.210           0.533680             -5.892116   \n",
       "1208                   22.104           0.401895             -5.002294   \n",
       "1209                   22.429           0.404724             -3.941675   \n",
       "1210                   22.527           0.407728             -5.596227   \n",
       "1211                   21.335           0.411720             -6.222391   \n",
       "1212                   24.540           0.415294             -3.779678   \n",
       "1213                   25.482           0.275839             -2.630822   \n",
       "1214                   25.732           0.279186             -3.077918   \n",
       "1215                   24.990           0.283107             -4.662312   \n",
       "1216                   24.394           0.306274             -4.543756   \n",
       "1217                   25.613           0.309991             -4.049823   \n",
       "\n",
       "      emission_by_bunker_fuel  emission_sub_electric  emission_sub_commercial  \\\n",
       "1189                      0.0               3.112679                 0.692023   \n",
       "1190                      0.0               3.370617                 0.687531   \n",
       "1191                      0.0               3.142018                 0.683628   \n",
       "1192                      0.0               3.071186                 0.753094   \n",
       "1193                      0.0               3.346625                 0.748646   \n",
       "1194                      0.0               3.087306                 0.787630   \n",
       "1195                      0.0               2.643077                 0.827068   \n",
       "1196                      0.0               3.541123                 0.771005   \n",
       "1197                      0.0               3.297077                 0.673627   \n",
       "1198                      0.0               3.705927                 0.673347   \n",
       "1199                      0.0               3.825430                 0.741202   \n",
       "1200                      0.0               3.841224                 0.719141   \n",
       "1201                      0.0               3.340997                 0.710533   \n",
       "1202                      0.0               3.594456                 0.711354   \n",
       "1203                      0.0               3.820740                 0.674922   \n",
       "1204                      0.0               3.251324                 0.666917   \n",
       "1205                      0.0               3.472360                 0.633358   \n",
       "1206                      0.0               2.977505                 0.730243   \n",
       "1207                      0.0               3.883632                 0.792365   \n",
       "1208                      0.0               3.368948                 0.816931   \n",
       "1209                      0.0               3.495182                 0.784150   \n",
       "1210                      0.0               2.818383                 0.757000   \n",
       "1211                      0.0               3.165771                 0.642421   \n",
       "1212                      0.0               3.129264                 0.796521   \n",
       "1213                      0.0               2.998017                 0.825192   \n",
       "1214                      0.0               1.888777                 0.732117   \n",
       "1215                      0.0               2.601046                 0.738659   \n",
       "1216                      0.0               2.430266                 0.767476   \n",
       "1217                      0.0               2.841137                 0.871226   \n",
       "\n",
       "      emission_sub_residential  emission_sub_industrial  \\\n",
       "1189                  1.383120                 2.124677   \n",
       "1190                  1.223648                 2.030410   \n",
       "1191                  1.041918                 1.951802   \n",
       "1192                  1.262753                 2.321105   \n",
       "1193                  1.179905                 2.478764   \n",
       "1194                  1.239306                 2.275036   \n",
       "1195                  1.482789                 2.350906   \n",
       "1196                  1.352331                 2.334321   \n",
       "1197                  1.143382                 2.156288   \n",
       "1198                  1.115746                 2.244750   \n",
       "1199                  1.230651                 2.561352   \n",
       "1200                  1.150820                 2.033885   \n",
       "1201                  1.190345                 2.232437   \n",
       "1202                  1.217294                 2.300946   \n",
       "1203                  1.073312                 2.195462   \n",
       "1204                  1.057845                 2.203536   \n",
       "1205                  0.989938                 2.141793   \n",
       "1206                  1.051544                 2.749514   \n",
       "1207                  1.235446                 3.068662   \n",
       "1208                  1.167637                 3.175979   \n",
       "1209                  1.068660                 3.319667   \n",
       "1210                  1.060651                 3.590808   \n",
       "1211                  0.891016                 3.495631   \n",
       "1212                  1.108457                 3.851032   \n",
       "1213                  1.115734                 3.727253   \n",
       "1214                  0.955124                 3.750666   \n",
       "1215                  0.969421                 3.734954   \n",
       "1216                  0.973800                 3.774712   \n",
       "1217                  1.175242                 3.842051   \n",
       "\n",
       "      emission_sub_transportation  emission_sub_fugitive  state_gdp  \\\n",
       "1189                     4.916453               0.391034    14696.0   \n",
       "1190                     4.687325               0.508277    15411.0   \n",
       "1191                     5.288593               0.565537    16279.0   \n",
       "1192                     5.384092               0.590423    17208.0   \n",
       "1193                     5.724230               0.599208    18141.0   \n",
       "1194                     5.841534               0.726310    18520.0   \n",
       "1195                     5.838887               0.780483    19410.0   \n",
       "1196                     5.688363               0.197155    22356.0   \n",
       "1197                     5.854561               0.184353    23774.0   \n",
       "1198                     5.997861               0.186118    25086.0   \n",
       "1199                     6.085023               0.214467    26878.0   \n",
       "1200                     5.989327               0.237459    27610.0   \n",
       "1201                     6.495304               0.220927    29734.0   \n",
       "1202                     6.072184               0.240725    30397.0   \n",
       "1203                     6.172237               0.247214    30958.0   \n",
       "1204                     6.257833               0.243067    31549.0   \n",
       "1205                     6.274758               0.231264    31643.0   \n",
       "1206                     6.489634               0.260313    32816.0   \n",
       "1207                     6.093472               0.250840    34302.0   \n",
       "1208                     6.288773               0.260506    34354.0   \n",
       "1209                     6.502886               0.258897    34371.0   \n",
       "1210                     6.489779               0.279238    35898.0   \n",
       "1211                     6.875894               0.066122    43550.7   \n",
       "1212                     6.599205               0.059752    43737.7   \n",
       "1213                     6.860861               0.055170    44449.7   \n",
       "1214                     6.953502               1.423731    45371.8   \n",
       "1215                     6.927084               0.043334    45733.6   \n",
       "1216                     6.711773               0.039274    46023.9   \n",
       "1217                     6.856952               0.034960    47287.0   \n",
       "\n",
       "      population  total_energy_use  sub_sector_total  total_sub_difference  \\\n",
       "1189      697101       5476.271319         28.386372          2.999997e-09   \n",
       "1190      703669       5383.209280         29.067201         -2.000000e-09   \n",
       "1191      712801       5454.146090         29.151399          4.000000e-09   \n",
       "1192      722159       5794.441181         31.230628         -4.999997e-09   \n",
       "1193      730790       5954.886889         32.092279         -9.999965e-10   \n",
       "1194      737925       6044.672982         32.406297         -4.000000e-09   \n",
       "1195      742213       6377.332601         32.842451         -9.999965e-10   \n",
       "1196      744223       6117.701357         33.032510         -4.000000e-09   \n",
       "1197      746058       6047.369337         33.529395         -2.000000e-09   \n",
       "1198      750412       6185.916612         35.177335          3.000004e-09   \n",
       "1199      755844       6530.117637         36.078193          2.000000e-09   \n",
       "1200      757972       6343.111575         37.004302          3.000004e-09   \n",
       "1201      760020       6830.496598         35.926889          2.000000e-09   \n",
       "1202      763729       6938.829580         36.845653          1.000004e-09   \n",
       "1203      770396       7179.107549         37.026089         -4.000000e-09   \n",
       "1204      775493       7630.305978         36.593148         -9.999965e-10   \n",
       "1205      783033       7762.603759         35.865906         -9.999965e-10   \n",
       "1206      791623       8378.027833         37.347595          2.000000e-09   \n",
       "1207      799124       8970.495093         38.227478          4.000007e-09   \n",
       "1208      807067       9211.428250         38.582695         -7.105427e-15   \n",
       "1209      816223       9572.336595         39.263221          0.000000e+00   \n",
       "1210      823593       9637.200306         39.035394          3.000004e-09   \n",
       "1211      833566     376640.000000         38.073530         -6.000000e-09   \n",
       "1212      842316     390343.000000         41.705311          0.000000e+00   \n",
       "1213      849129     393981.000000         42.551761          7.105427e-15   \n",
       "1214      853988     385859.000000         42.886207          1.999993e-09   \n",
       "1215      862996     382983.000000         41.463840         -9.999965e-10   \n",
       "1216      872868     384986.000000         40.602473         -4.000000e-09   \n",
       "1217      878698     396837.000000         42.687138          3.000004e-09   \n",
       "\n",
       "      %_diff  \n",
       "1189     0.0  \n",
       "1190    -0.0  \n",
       "1191     0.0  \n",
       "1192    -0.0  \n",
       "1193    -0.0  \n",
       "1194    -0.0  \n",
       "1195    -0.0  \n",
       "1196    -0.0  \n",
       "1197    -0.0  \n",
       "1198     0.0  \n",
       "1199     0.0  \n",
       "1200     0.0  \n",
       "1201     0.0  \n",
       "1202     0.0  \n",
       "1203    -0.0  \n",
       "1204    -0.0  \n",
       "1205    -0.0  \n",
       "1206     0.0  \n",
       "1207     0.0  \n",
       "1208    -0.0  \n",
       "1209     0.0  \n",
       "1210     0.0  \n",
       "1211    -0.0  \n",
       "1212     0.0  \n",
       "1213     0.0  \n",
       "1214     0.0  \n",
       "1215    -0.0  \n",
       "1216    -0.0  \n",
       "1217     0.0  "
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "emissions[emissions['State']=='South Dakota']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.8.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}