data_extraction.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Dependencies and Setup\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "from data_extraction import drought_data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Store Part I results into DataFrame\n",
    "* Load the csv exported in Part I to a DataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "input_file = \"drought_data/us-droughts.csv\"\n",
    "droughts_df=pd.read_csv(input_file)\n",
    "droughts_df = droughts_df.drop(droughts_df[['validStart', 'validEnd', 'domStatisticFormatID']], axis=1)\n",
    "droughts_df.releaseDate = pd.to_datetime(droughts_df.releaseDate, format='%Y-%m-%d')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>releaseDate</th>\n",
       "      <th>FIPS</th>\n",
       "      <th>county</th>\n",
       "      <th>state</th>\n",
       "      <th>NONE</th>\n",
       "      <th>D0</th>\n",
       "      <th>D1</th>\n",
       "      <th>D2</th>\n",
       "      <th>D3</th>\n",
       "      <th>D4</th>\n",
       "      <th>Level</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2000-11-07</td>\n",
       "      <td>2013</td>\n",
       "      <td>Aleutians East Borough</td>\n",
       "      <td>AK</td>\n",
       "      <td>100.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2000-10-31</td>\n",
       "      <td>2013</td>\n",
       "      <td>Aleutians East Borough</td>\n",
       "      <td>AK</td>\n",
       "      <td>100.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2000-10-24</td>\n",
       "      <td>2013</td>\n",
       "      <td>Aleutians East Borough</td>\n",
       "      <td>AK</td>\n",
       "      <td>100.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2000-10-17</td>\n",
       "      <td>2013</td>\n",
       "      <td>Aleutians East Borough</td>\n",
       "      <td>AK</td>\n",
       "      <td>100.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2000-10-10</td>\n",
       "      <td>2013</td>\n",
       "      <td>Aleutians East Borough</td>\n",
       "      <td>AK</td>\n",
       "      <td>100.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2829496</th>\n",
       "      <td>2015-12-08</td>\n",
       "      <td>56045</td>\n",
       "      <td>Weston County</td>\n",
       "      <td>WY</td>\n",
       "      <td>29.45</td>\n",
       "      <td>70.55</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.7055</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2829497</th>\n",
       "      <td>2015-12-01</td>\n",
       "      <td>56045</td>\n",
       "      <td>Weston County</td>\n",
       "      <td>WY</td>\n",
       "      <td>29.45</td>\n",
       "      <td>70.55</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.7055</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2829498</th>\n",
       "      <td>2015-11-24</td>\n",
       "      <td>56045</td>\n",
       "      <td>Weston County</td>\n",
       "      <td>WY</td>\n",
       "      <td>29.45</td>\n",
       "      <td>70.55</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.7055</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2829499</th>\n",
       "      <td>2015-11-17</td>\n",
       "      <td>56045</td>\n",
       "      <td>Weston County</td>\n",
       "      <td>WY</td>\n",
       "      <td>29.45</td>\n",
       "      <td>70.55</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.7055</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2829500</th>\n",
       "      <td>2015-11-10</td>\n",
       "      <td>56045</td>\n",
       "      <td>Weston County</td>\n",
       "      <td>WY</td>\n",
       "      <td>30.70</td>\n",
       "      <td>69.30</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.6930</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2829501 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        releaseDate   FIPS                  county state    NONE     D0   D1  \\\n",
       "0        2000-11-07   2013  Aleutians East Borough    AK  100.00   0.00  0.0   \n",
       "1        2000-10-31   2013  Aleutians East Borough    AK  100.00   0.00  0.0   \n",
       "2        2000-10-24   2013  Aleutians East Borough    AK  100.00   0.00  0.0   \n",
       "3        2000-10-17   2013  Aleutians East Borough    AK  100.00   0.00  0.0   \n",
       "4        2000-10-10   2013  Aleutians East Borough    AK  100.00   0.00  0.0   \n",
       "...             ...    ...                     ...   ...     ...    ...  ...   \n",
       "2829496  2015-12-08  56045           Weston County    WY   29.45  70.55  0.0   \n",
       "2829497  2015-12-01  56045           Weston County    WY   29.45  70.55  0.0   \n",
       "2829498  2015-11-24  56045           Weston County    WY   29.45  70.55  0.0   \n",
       "2829499  2015-11-17  56045           Weston County    WY   29.45  70.55  0.0   \n",
       "2829500  2015-11-10  56045           Weston County    WY   30.70  69.30  0.0   \n",
       "\n",
       "          D2   D3   D4   Level  \n",
       "0        0.0  0.0  0.0  0.0000  \n",
       "1        0.0  0.0  0.0  0.0000  \n",
       "2        0.0  0.0  0.0  0.0000  \n",
       "3        0.0  0.0  0.0  0.0000  \n",
       "4        0.0  0.0  0.0  0.0000  \n",
       "...      ...  ...  ...     ...  \n",
       "2829496  0.0  0.0  0.0  0.7055  \n",
       "2829497  0.0  0.0  0.0  0.7055  \n",
       "2829498  0.0  0.0  0.0  0.7055  \n",
       "2829499  0.0  0.0  0.0  0.7055  \n",
       "2829500  0.0  0.0  0.0  0.6930  \n",
       "\n",
       "[2829501 rows x 11 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "droughts_df[\"D0\"]=droughts_df[\"D0\"]-droughts_df[\"D1\"]\n",
    "droughts_df[\"D1\"]=droughts_df[\"D1\"]-droughts_df[\"D2\"]\n",
    "droughts_df[\"D2\"]=droughts_df[\"D2\"]-droughts_df[\"D3\"]\n",
    "droughts_df[\"D3\"]=droughts_df[\"D3\"]-droughts_df[\"D4\"]\n",
    "#adding a drought level based on https://www.kaggle.com/balagpdy/heatmap-animation-us-drought-map\n",
    "### Calculate drought level (when NONE is 100% => 0, if D4 is 100% => 5, and linearly between 0 and 5)\n",
    "droughts_df[\"Level\"]=(droughts_df[\"D0\"]+droughts_df[\"D1\"]*2+droughts_df[\"D2\"]*3+droughts_df[\"D3\"]*4+droughts_df[\"D4\"]*5)/100\n",
    "droughts_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>USPS</th>\n",
       "      <th>GEOID</th>\n",
       "      <th>ANSICODE</th>\n",
       "      <th>NAME</th>\n",
       "      <th>ALAND</th>\n",
       "      <th>AWATER</th>\n",
       "      <th>ALAND_SQMI</th>\n",
       "      <th>AWATER_SQMI</th>\n",
       "      <th>INTPTLAT</th>\n",
       "      <th>INTPTLONG</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AL</td>\n",
       "      <td>1001</td>\n",
       "      <td>161526</td>\n",
       "      <td>Autauga County</td>\n",
       "      <td>1.539609e+09</td>\n",
       "      <td>25749942</td>\n",
       "      <td>594.446</td>\n",
       "      <td>9.942</td>\n",
       "      <td>32.532237</td>\n",
       "      <td>-86.646440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AL</td>\n",
       "      <td>1003</td>\n",
       "      <td>161527</td>\n",
       "      <td>Baldwin County</td>\n",
       "      <td>4.117584e+09</td>\n",
       "      <td>1133130502</td>\n",
       "      <td>1589.808</td>\n",
       "      <td>437.504</td>\n",
       "      <td>30.659218</td>\n",
       "      <td>-87.746067</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AL</td>\n",
       "      <td>1005</td>\n",
       "      <td>161528</td>\n",
       "      <td>Barbour County</td>\n",
       "      <td>2.291819e+09</td>\n",
       "      <td>50864677</td>\n",
       "      <td>884.876</td>\n",
       "      <td>19.639</td>\n",
       "      <td>31.870253</td>\n",
       "      <td>-85.405104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AL</td>\n",
       "      <td>1007</td>\n",
       "      <td>161529</td>\n",
       "      <td>Bibb County</td>\n",
       "      <td>1.612482e+09</td>\n",
       "      <td>9287974</td>\n",
       "      <td>622.583</td>\n",
       "      <td>3.586</td>\n",
       "      <td>33.015893</td>\n",
       "      <td>-87.127148</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AL</td>\n",
       "      <td>1009</td>\n",
       "      <td>161530</td>\n",
       "      <td>Blount County</td>\n",
       "      <td>1.670042e+09</td>\n",
       "      <td>15077458</td>\n",
       "      <td>644.807</td>\n",
       "      <td>5.821</td>\n",
       "      <td>33.977358</td>\n",
       "      <td>-86.566440</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3215</th>\n",
       "      <td>PR</td>\n",
       "      <td>72145</td>\n",
       "      <td>1804553</td>\n",
       "      <td>Vega Baja Municipio</td>\n",
       "      <td>1.187668e+08</td>\n",
       "      <td>57805868</td>\n",
       "      <td>45.856</td>\n",
       "      <td>22.319</td>\n",
       "      <td>18.455027</td>\n",
       "      <td>-66.397773</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3216</th>\n",
       "      <td>PR</td>\n",
       "      <td>72147</td>\n",
       "      <td>1804554</td>\n",
       "      <td>Vieques Municipio</td>\n",
       "      <td>1.315278e+08</td>\n",
       "      <td>552206400</td>\n",
       "      <td>50.783</td>\n",
       "      <td>213.208</td>\n",
       "      <td>18.125418</td>\n",
       "      <td>-65.432474</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3217</th>\n",
       "      <td>PR</td>\n",
       "      <td>72149</td>\n",
       "      <td>1804555</td>\n",
       "      <td>Villalba Municipio</td>\n",
       "      <td>9.229857e+07</td>\n",
       "      <td>3622637</td>\n",
       "      <td>35.637</td>\n",
       "      <td>1.399</td>\n",
       "      <td>18.130718</td>\n",
       "      <td>-66.472244</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3218</th>\n",
       "      <td>PR</td>\n",
       "      <td>72151</td>\n",
       "      <td>1804556</td>\n",
       "      <td>Yabucoa Municipio</td>\n",
       "      <td>1.430052e+08</td>\n",
       "      <td>72592521</td>\n",
       "      <td>55.215</td>\n",
       "      <td>28.028</td>\n",
       "      <td>18.059858</td>\n",
       "      <td>-65.859871</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3219</th>\n",
       "      <td>PR</td>\n",
       "      <td>72153</td>\n",
       "      <td>1804557</td>\n",
       "      <td>Yauco Municipio</td>\n",
       "      <td>1.753719e+08</td>\n",
       "      <td>1625260</td>\n",
       "      <td>67.711</td>\n",
       "      <td>0.628</td>\n",
       "      <td>18.085669</td>\n",
       "      <td>-66.857901</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3220 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     USPS  GEOID  ANSICODE                 NAME         ALAND      AWATER  \\\n",
       "0      AL   1001    161526       Autauga County  1.539609e+09    25749942   \n",
       "1      AL   1003    161527       Baldwin County  4.117584e+09  1133130502   \n",
       "2      AL   1005    161528       Barbour County  2.291819e+09    50864677   \n",
       "3      AL   1007    161529          Bibb County  1.612482e+09     9287974   \n",
       "4      AL   1009    161530        Blount County  1.670042e+09    15077458   \n",
       "...   ...    ...       ...                  ...           ...         ...   \n",
       "3215   PR  72145   1804553  Vega Baja Municipio  1.187668e+08    57805868   \n",
       "3216   PR  72147   1804554    Vieques Municipio  1.315278e+08   552206400   \n",
       "3217   PR  72149   1804555   Villalba Municipio  9.229857e+07     3622637   \n",
       "3218   PR  72151   1804556    Yabucoa Municipio  1.430052e+08    72592521   \n",
       "3219   PR  72153   1804557      Yauco Municipio  1.753719e+08     1625260   \n",
       "\n",
       "      ALAND_SQMI  AWATER_SQMI   INTPTLAT  \\\n",
       "0        594.446        9.942  32.532237   \n",
       "1       1589.808      437.504  30.659218   \n",
       "2        884.876       19.639  31.870253   \n",
       "3        622.583        3.586  33.015893   \n",
       "4        644.807        5.821  33.977358   \n",
       "...          ...          ...        ...   \n",
       "3215      45.856       22.319  18.455027   \n",
       "3216      50.783      213.208  18.125418   \n",
       "3217      35.637        1.399  18.130718   \n",
       "3218      55.215       28.028  18.059858   \n",
       "3219      67.711        0.628  18.085669   \n",
       "\n",
       "      INTPTLONG                                                                                                                 \n",
       "0                                            -86.646440                                                                         \n",
       "1                                            -87.746067                                                                         \n",
       "2                                            -85.405104                                                                         \n",
       "3                                            -87.127148                                                                         \n",
       "4                                            -86.566440                                                                         \n",
       "...                                                 ...                                                                         \n",
       "3215                                         -66.397773                                                                         \n",
       "3216                                         -65.432474                                                                         \n",
       "3217                                         -66.472244                                                                         \n",
       "3218                                         -65.859871                                                                         \n",
       "3219                                         -66.857901                                                                         \n",
       "\n",
       "[3220 rows x 10 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "input_file = \"drought_data/county_info_2016.csv\"\n",
    "\n",
    "#To read this file properly, due to the format it is recommended that you copy its contents to a new excel file.\n",
    "#There seems to be a format issue.\n",

    "county_df=pd.read_csv(input_file)\n",
    "county_df\n",
    "\n"


   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "droughtwcount_df=pd.merge(droughts_df,county_df,how='inner',left_on=\"FIPS\",right_on=\"GEOID\",sort=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "droughtwcount_dfm = droughtwcount_df.set_index('releaseDate').groupby(['FIPS']).resample('M').mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>FIPS</th>\n",
       "      <th>NONE</th>\n",
       "      <th>D0</th>\n",
       "      <th>D1</th>\n",
       "      <th>D2</th>\n",
       "      <th>D3</th>\n",
       "      <th>D4</th>\n",
       "      <th>Level</th>\n",
       "      <th>GEOID</th>\n",
       "      <th>ANSICODE</th>\n",
       "      <th>ALAND</th>\n",
       "      <th>AWATER</th>\n",
       "      <th>ALAND_SQMI</th>\n",
       "      <th>AWATER_SQMI</th>\n",
       "      <th>INTPTLAT</th>\n",
       "      <th>INTPTLONG</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FIPS</th>\n",
       "      <th>releaseDate</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">1001</th>\n",
       "      <th>2000-01-31</th>\n",
       "      <td>1001</td>\n",
       "      <td>0.000</td>\n",
       "      <td>25.000</td>\n",
       "      <td>75.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.75000</td>\n",
       "      <td>1001</td>\n",
       "      <td>161526</td>\n",
       "      <td>1.539609e+09</td>\n",
       "      <td>25749942</td>\n",
       "      <td>594.446</td>\n",
       "      <td>9.942</td>\n",
       "      <td>32.532237</td>\n",
       "      <td>-86.646440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-02-29</th>\n",
       "      <td>1001</td>\n",
       "      <td>0.000</td>\n",
       "      <td>100.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.00000</td>\n",
       "      <td>1001</td>\n",
       "      <td>161526</td>\n",
       "      <td>1.539609e+09</td>\n",
       "      <td>25749942</td>\n",
       "      <td>594.446</td>\n",
       "      <td>9.942</td>\n",
       "      <td>32.532237</td>\n",
       "      <td>-86.646440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-03-31</th>\n",
       "      <td>1001</td>\n",
       "      <td>0.000</td>\n",
       "      <td>68.145</td>\n",
       "      <td>31.855</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.31855</td>\n",
       "      <td>1001</td>\n",
       "      <td>161526</td>\n",
       "      <td>1.539609e+09</td>\n",
       "      <td>25749942</td>\n",
       "      <td>594.446</td>\n",
       "      <td>9.942</td>\n",
       "      <td>32.532237</td>\n",
       "      <td>-86.646440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-04-30</th>\n",
       "      <td>1001</td>\n",
       "      <td>1.775</td>\n",
       "      <td>98.225</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.98225</td>\n",
       "      <td>1001</td>\n",
       "      <td>161526</td>\n",
       "      <td>1.539609e+09</td>\n",
       "      <td>25749942</td>\n",
       "      <td>594.446</td>\n",
       "      <td>9.942</td>\n",
       "      <td>32.532237</td>\n",
       "      <td>-86.646440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-05-31</th>\n",
       "      <td>1001</td>\n",
       "      <td>0.000</td>\n",
       "      <td>19.048</td>\n",
       "      <td>78.608</td>\n",
       "      <td>2.344</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.83296</td>\n",
       "      <td>1001</td>\n",
       "      <td>161526</td>\n",
       "      <td>1.539609e+09</td>\n",
       "      <td>25749942</td>\n",
       "      <td>594.446</td>\n",
       "      <td>9.942</td>\n",
       "      <td>32.532237</td>\n",
       "      <td>-86.646440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">72153</th>\n",
       "      <th>2016-07-31</th>\n",
       "      <td>72153</td>\n",
       "      <td>100.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>72153</td>\n",
       "      <td>1804557</td>\n",
       "      <td>1.753719e+08</td>\n",
       "      <td>1625260</td>\n",
       "      <td>67.711</td>\n",
       "      <td>0.628</td>\n",
       "      <td>18.085669</td>\n",
       "      <td>-66.857901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-08-31</th>\n",
       "      <td>72153</td>\n",
       "      <td>100.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>72153</td>\n",
       "      <td>1804557</td>\n",
       "      <td>1.753719e+08</td>\n",
       "      <td>1625260</td>\n",
       "      <td>67.711</td>\n",
       "      <td>0.628</td>\n",
       "      <td>18.085669</td>\n",
       "      <td>-66.857901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-09-30</th>\n",
       "      <td>72153</td>\n",
       "      <td>100.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>72153</td>\n",
       "      <td>1804557</td>\n",
       "      <td>1.753719e+08</td>\n",
       "      <td>1625260</td>\n",
       "      <td>67.711</td>\n",
       "      <td>0.628</td>\n",
       "      <td>18.085669</td>\n",
       "      <td>-66.857901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-10-31</th>\n",
       "      <td>72153</td>\n",
       "      <td>100.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>72153</td>\n",
       "      <td>1804557</td>\n",
       "      <td>1.753719e+08</td>\n",
       "      <td>1625260</td>\n",
       "      <td>67.711</td>\n",
       "      <td>0.628</td>\n",
       "      <td>18.085669</td>\n",
       "      <td>-66.857901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-11-30</th>\n",
       "      <td>72153</td>\n",
       "      <td>100.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>72153</td>\n",
       "      <td>1804557</td>\n",
       "      <td>1.753719e+08</td>\n",
       "      <td>1625260</td>\n",
       "      <td>67.711</td>\n",
       "      <td>0.628</td>\n",
       "      <td>18.085669</td>\n",
       "      <td>-66.857901</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>652239 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    FIPS     NONE       D0      D1     D2   D3   D4    Level  \\\n",
       "FIPS  releaseDate                                                              \n",
       "1001  2000-01-31    1001    0.000   25.000  75.000  0.000  0.0  0.0  1.75000   \n",
       "      2000-02-29    1001    0.000  100.000   0.000  0.000  0.0  0.0  1.00000   \n",
       "      2000-03-31    1001    0.000   68.145  31.855  0.000  0.0  0.0  1.31855   \n",
       "      2000-04-30    1001    1.775   98.225   0.000  0.000  0.0  0.0  0.98225   \n",
       "      2000-05-31    1001    0.000   19.048  78.608  2.344  0.0  0.0  1.83296   \n",
       "...                  ...      ...      ...     ...    ...  ...  ...      ...   \n",
       "72153 2016-07-31   72153  100.000    0.000   0.000  0.000  0.0  0.0  0.00000   \n",
       "      2016-08-31   72153  100.000    0.000   0.000  0.000  0.0  0.0  0.00000   \n",
       "      2016-09-30   72153  100.000    0.000   0.000  0.000  0.0  0.0  0.00000   \n",
       "      2016-10-31   72153  100.000    0.000   0.000  0.000  0.0  0.0  0.00000   \n",
       "      2016-11-30   72153  100.000    0.000   0.000  0.000  0.0  0.0  0.00000   \n",
       "\n",
       "                   GEOID  ANSICODE         ALAND    AWATER  ALAND_SQMI  \\\n",
       "FIPS  releaseDate                                                        \n",
       "1001  2000-01-31    1001    161526  1.539609e+09  25749942     594.446   \n",
       "      2000-02-29    1001    161526  1.539609e+09  25749942     594.446   \n",
       "      2000-03-31    1001    161526  1.539609e+09  25749942     594.446   \n",
       "      2000-04-30    1001    161526  1.539609e+09  25749942     594.446   \n",
       "      2000-05-31    1001    161526  1.539609e+09  25749942     594.446   \n",
       "...                  ...       ...           ...       ...         ...   \n",
       "72153 2016-07-31   72153   1804557  1.753719e+08   1625260      67.711   \n",
       "      2016-08-31   72153   1804557  1.753719e+08   1625260      67.711   \n",
       "      2016-09-30   72153   1804557  1.753719e+08   1625260      67.711   \n",
       "      2016-10-31   72153   1804557  1.753719e+08   1625260      67.711   \n",
       "      2016-11-30   72153   1804557  1.753719e+08   1625260      67.711   \n",
       "\n",
       "                   AWATER_SQMI   INTPTLAT  \\\n",
       "FIPS  releaseDate                           \n",
       "1001  2000-01-31         9.942  32.532237   \n",
       "      2000-02-29         9.942  32.532237   \n",
       "      2000-03-31         9.942  32.532237   \n",
       "      2000-04-30         9.942  32.532237   \n",
       "      2000-05-31         9.942  32.532237   \n",
       "...                        ...        ...   \n",
       "72153 2016-07-31         0.628  18.085669   \n",
       "      2016-08-31         0.628  18.085669   \n",
       "      2016-09-30         0.628  18.085669   \n",
       "      2016-10-31         0.628  18.085669   \n",
       "      2016-11-30         0.628  18.085669   \n",
       "\n",
       "                   INTPTLONG                                                                                                                 \n",
       "FIPS  releaseDate                                                                                                                            \n",
       "1001  2000-01-31                                          -86.646440                                                                         \n",
       "      2000-02-29                                          -86.646440                                                                         \n",
       "      2000-03-31                                          -86.646440                                                                         \n",
       "      2000-04-30                                          -86.646440                                                                         \n",
       "      2000-05-31                                          -86.646440                                                                         \n",
       "...                                                              ...                                                                         \n",
       "72153 2016-07-31                                          -66.857901                                                                         \n",
       "      2016-08-31                                          -66.857901                                                                         \n",
       "      2016-09-30                                          -66.857901                                                                         \n",
       "      2016-10-31                                          -66.857901                                                                         \n",
       "      2016-11-30                                          -66.857901                                                                         \n",
       "\n",
       "[652239 rows x 16 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#droughtwcount_dfm = droughtwcount_df.set_index('releaseDate').groupby(['FIPS']).resample('M').mean()\n",
    "droughtwcount_dfm"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>FIPS</th>\n",
       "      <th>NONE</th>\n",
       "      <th>D0</th>\n",
       "      <th>D1</th>\n",
       "      <th>D2</th>\n",
       "      <th>D3</th>\n",
       "      <th>D4</th>\n",
       "      <th>Level</th>\n",
       "      <th>ALAND_SQMI</th>\n",
       "      <th>AWATER_SQMI</th>\n",
       "      <th>INTPTLAT</th>\n",
       "      <th>INTPTLONG</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FIPS</th>\n",
       "      <th>releaseDate</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">1001</th>\n",
       "      <th>2000-01-31</th>\n",
       "      <td>1001</td>\n",
       "      <td>0.000</td>\n",
       "      <td>25.000</td>\n",
       "      <td>75.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.75000</td>\n",
       "      <td>594.446</td>\n",
       "      <td>9.942</td>\n",
       "      <td>32.532237</td>\n",
       "      <td>-86.646440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-02-29</th>\n",
       "      <td>1001</td>\n",
       "      <td>0.000</td>\n",
       "      <td>100.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.00000</td>\n",
       "      <td>594.446</td>\n",
       "      <td>9.942</td>\n",
       "      <td>32.532237</td>\n",
       "      <td>-86.646440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-03-31</th>\n",
       "      <td>1001</td>\n",
       "      <td>0.000</td>\n",
       "      <td>68.145</td>\n",
       "      <td>31.855</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.31855</td>\n",
       "      <td>594.446</td>\n",
       "      <td>9.942</td>\n",
       "      <td>32.532237</td>\n",
       "      <td>-86.646440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-04-30</th>\n",
       "      <td>1001</td>\n",
       "      <td>1.775</td>\n",
       "      <td>98.225</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.98225</td>\n",
       "      <td>594.446</td>\n",
       "      <td>9.942</td>\n",
       "      <td>32.532237</td>\n",
       "      <td>-86.646440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-05-31</th>\n",
       "      <td>1001</td>\n",
       "      <td>0.000</td>\n",
       "      <td>19.048</td>\n",
       "      <td>78.608</td>\n",
       "      <td>2.344</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.83296</td>\n",
       "      <td>594.446</td>\n",
       "      <td>9.942</td>\n",
       "      <td>32.532237</td>\n",
       "      <td>-86.646440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">72153</th>\n",
       "      <th>2016-07-31</th>\n",
       "      <td>72153</td>\n",
       "      <td>100.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>67.711</td>\n",
       "      <td>0.628</td>\n",
       "      <td>18.085669</td>\n",
       "      <td>-66.857901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-08-31</th>\n",
       "      <td>72153</td>\n",
       "      <td>100.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>67.711</td>\n",
       "      <td>0.628</td>\n",
       "      <td>18.085669</td>\n",
       "      <td>-66.857901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-09-30</th>\n",
       "      <td>72153</td>\n",
       "      <td>100.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>67.711</td>\n",
       "      <td>0.628</td>\n",
       "      <td>18.085669</td>\n",
       "      <td>-66.857901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-10-31</th>\n",
       "      <td>72153</td>\n",
       "      <td>100.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>67.711</td>\n",
       "      <td>0.628</td>\n",
       "      <td>18.085669</td>\n",
       "      <td>-66.857901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-11-30</th>\n",
       "      <td>72153</td>\n",
       "      <td>100.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>67.711</td>\n",
       "      <td>0.628</td>\n",
       "      <td>18.085669</td>\n",
       "      <td>-66.857901</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>652239 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    FIPS     NONE       D0      D1     D2   D3   D4    Level  \\\n",
       "FIPS  releaseDate                                                              \n",
       "1001  2000-01-31    1001    0.000   25.000  75.000  0.000  0.0  0.0  1.75000   \n",
       "      2000-02-29    1001    0.000  100.000   0.000  0.000  0.0  0.0  1.00000   \n",
       "      2000-03-31    1001    0.000   68.145  31.855  0.000  0.0  0.0  1.31855   \n",
       "      2000-04-30    1001    1.775   98.225   0.000  0.000  0.0  0.0  0.98225   \n",
       "      2000-05-31    1001    0.000   19.048  78.608  2.344  0.0  0.0  1.83296   \n",
       "...                  ...      ...      ...     ...    ...  ...  ...      ...   \n",
       "72153 2016-07-31   72153  100.000    0.000   0.000  0.000  0.0  0.0  0.00000   \n",
       "      2016-08-31   72153  100.000    0.000   0.000  0.000  0.0  0.0  0.00000   \n",
       "      2016-09-30   72153  100.000    0.000   0.000  0.000  0.0  0.0  0.00000   \n",
       "      2016-10-31   72153  100.000    0.000   0.000  0.000  0.0  0.0  0.00000   \n",
       "      2016-11-30   72153  100.000    0.000   0.000  0.000  0.0  0.0  0.00000   \n",
       "\n",
       "                   ALAND_SQMI  AWATER_SQMI   INTPTLAT  INTPTLONG  \n",
       "FIPS  releaseDate                                                 \n",
       "1001  2000-01-31      594.446        9.942  32.532237 -86.646440  \n",
       "      2000-02-29      594.446        9.942  32.532237 -86.646440  \n",
       "      2000-03-31      594.446        9.942  32.532237 -86.646440  \n",
       "      2000-04-30      594.446        9.942  32.532237 -86.646440  \n",
       "      2000-05-31      594.446        9.942  32.532237 -86.646440  \n",
       "...                       ...          ...        ...        ...  \n",
       "72153 2016-07-31       67.711        0.628  18.085669 -66.857901  \n",
       "      2016-08-31       67.711        0.628  18.085669 -66.857901  \n",
       "      2016-09-30       67.711        0.628  18.085669 -66.857901  \n",
       "      2016-10-31       67.711        0.628  18.085669 -66.857901  \n",
       "      2016-11-30       67.711        0.628  18.085669 -66.857901  \n",
       "\n",
       "[652239 rows x 12 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "#droughtwcount_df.rename(columns={\"INTPTLONG                                                                                                               \":\"INTPTLONG\"})\n",
    "droughtwcount_dfm2=droughtwcount_dfm[[\"FIPS\",\"NONE\",\"D0\",\"D1\",\"D2\",\"D3\",\"D4\",\"Level\",\"ALAND_SQMI\",\"AWATER_SQMI\",\"INTPTLAT\",\"INTPTLONG                                                                                                               \"]]\n",
    "droughtwcount_dfm2.rename(columns={\"INTPTLONG                                                                                                               \":\"INTPTLONG\"})\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>FIPS</th>\n",
       "      <th>releaseDate</th>\n",
       "      <th>NONE</th>\n",
       "      <th>D0</th>\n",
       "      <th>D1</th>\n",
       "      <th>D2</th>\n",
       "      <th>D3</th>\n",
       "      <th>D4</th>\n",
       "      <th>Level</th>\n",
       "      <th>ALAND_SQMI</th>\n",
       "      <th>AWATER_SQMI</th>\n",
       "      <th>INTPTLAT</th>\n",
       "      <th>INTPTLONG</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1001</td>\n",
       "      <td>2000-01-31</td>\n",
       "      <td>0.000</td>\n",
       "      <td>25.000</td>\n",
       "      <td>75.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.75000</td>\n",
       "      <td>594.446</td>\n",
       "      <td>9.942</td>\n",
       "      <td>32.532237</td>\n",
       "      <td>-86.646440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1001</td>\n",
       "      <td>2000-02-29</td>\n",
       "      <td>0.000</td>\n",
       "      <td>100.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.00000</td>\n",
       "      <td>594.446</td>\n",
       "      <td>9.942</td>\n",
       "      <td>32.532237</td>\n",
       "      <td>-86.646440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1001</td>\n",
       "      <td>2000-03-31</td>\n",
       "      <td>0.000</td>\n",
       "      <td>68.145</td>\n",
       "      <td>31.855</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.31855</td>\n",
       "      <td>594.446</td>\n",
       "      <td>9.942</td>\n",
       "      <td>32.532237</td>\n",
       "      <td>-86.646440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1001</td>\n",
       "      <td>2000-04-30</td>\n",
       "      <td>1.775</td>\n",
       "      <td>98.225</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.98225</td>\n",
       "      <td>594.446</td>\n",
       "      <td>9.942</td>\n",
       "      <td>32.532237</td>\n",
       "      <td>-86.646440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1001</td>\n",
       "      <td>2000-05-31</td>\n",
       "      <td>0.000</td>\n",
       "      <td>19.048</td>\n",
       "      <td>78.608</td>\n",
       "      <td>2.344</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.83296</td>\n",
       "      <td>594.446</td>\n",
       "      <td>9.942</td>\n",
       "      <td>32.532237</td>\n",
       "      <td>-86.646440</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>652234</th>\n",
       "      <td>72153</td>\n",
       "      <td>2016-07-31</td>\n",
       "      <td>100.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>67.711</td>\n",
       "      <td>0.628</td>\n",
       "      <td>18.085669</td>\n",
       "      <td>-66.857901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>652235</th>\n",
       "      <td>72153</td>\n",
       "      <td>2016-08-31</td>\n",
       "      <td>100.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>67.711</td>\n",
       "      <td>0.628</td>\n",
       "      <td>18.085669</td>\n",
       "      <td>-66.857901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>652236</th>\n",
       "      <td>72153</td>\n",
       "      <td>2016-09-30</td>\n",
       "      <td>100.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>67.711</td>\n",
       "      <td>0.628</td>\n",
       "      <td>18.085669</td>\n",
       "      <td>-66.857901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>652237</th>\n",
       "      <td>72153</td>\n",
       "      <td>2016-10-31</td>\n",
       "      <td>100.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>67.711</td>\n",
       "      <td>0.628</td>\n",
       "      <td>18.085669</td>\n",
       "      <td>-66.857901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>652238</th>\n",
       "      <td>72153</td>\n",
       "      <td>2016-11-30</td>\n",
       "      <td>100.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>67.711</td>\n",
       "      <td>0.628</td>\n",
       "      <td>18.085669</td>\n",
       "      <td>-66.857901</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>652239 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         FIPS releaseDate     NONE       D0      D1     D2   D3   D4    Level  \\\n",
       "0        1001  2000-01-31    0.000   25.000  75.000  0.000  0.0  0.0  1.75000   \n",
       "1        1001  2000-02-29    0.000  100.000   0.000  0.000  0.0  0.0  1.00000   \n",
       "2        1001  2000-03-31    0.000   68.145  31.855  0.000  0.0  0.0  1.31855   \n",
       "3        1001  2000-04-30    1.775   98.225   0.000  0.000  0.0  0.0  0.98225   \n",
       "4        1001  2000-05-31    0.000   19.048  78.608  2.344  0.0  0.0  1.83296   \n",
       "...       ...         ...      ...      ...     ...    ...  ...  ...      ...   \n",
       "652234  72153  2016-07-31  100.000    0.000   0.000  0.000  0.0  0.0  0.00000   \n",
       "652235  72153  2016-08-31  100.000    0.000   0.000  0.000  0.0  0.0  0.00000   \n",
       "652236  72153  2016-09-30  100.000    0.000   0.000  0.000  0.0  0.0  0.00000   \n",
       "652237  72153  2016-10-31  100.000    0.000   0.000  0.000  0.0  0.0  0.00000   \n",
       "652238  72153  2016-11-30  100.000    0.000   0.000  0.000  0.0  0.0  0.00000   \n",
       "\n",
       "        ALAND_SQMI  AWATER_SQMI   INTPTLAT  \\\n",
       "0          594.446        9.942  32.532237   \n",
       "1          594.446        9.942  32.532237   \n",
       "2          594.446        9.942  32.532237   \n",
       "3          594.446        9.942  32.532237   \n",
       "4          594.446        9.942  32.532237   \n",
       "...            ...          ...        ...   \n",
       "652234      67.711        0.628  18.085669   \n",
       "652235      67.711        0.628  18.085669   \n",
       "652236      67.711        0.628  18.085669   \n",
       "652237      67.711        0.628  18.085669   \n",
       "652238      67.711        0.628  18.085669   \n",
       "\n",
       "        INTPTLONG                                                                                                                 \n",
       "0                                              -86.646440                                                                         \n",
       "1                                              -86.646440                                                                         \n",
       "2                                              -86.646440                                                                         \n",
       "3                                              -86.646440                                                                         \n",
       "4                                              -86.646440                                                                         \n",
       "...                                                   ...                                                                         \n",
       "652234                                         -66.857901                                                                         \n",
       "652235                                         -66.857901                                                                         \n",
       "652236                                         -66.857901                                                                         \n",
       "652237                                         -66.857901                                                                         \n",
       "652238                                         -66.857901                                                                         \n",
       "\n",
       "[652239 rows x 13 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "droughtwcount_dfm2=droughtwcount_dfm2.dropna()\n",
    "droughtwcount_dfm2=droughtwcount_dfm2.reset_index(level=1)\n",
    "droughtwcount_dfm2=droughtwcount_dfm2.drop(\"FIPS\",axis=1)\n",
    "droughtwcount_dfm2.reset_index(inplace=True)\n",
    "droughtwcount_dfm2\n",
    "#dr_m.reset_index(level=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>FIPS</th>\n",
       "      <th>releaseDate</th>\n",
       "      <th>NONE</th>\n",
       "      <th>D0</th>\n",
       "      <th>D1</th>\n",
       "      <th>D2</th>\n",
       "      <th>D3</th>\n",
       "      <th>D4</th>\n",
       "      <th>Level</th>\n",
       "      <th>ALAND_SQMI</th>\n",
       "      <th>AWATER_SQMI</th>\n",
       "      <th>INTPTLAT</th>\n",
       "      <th>INTPTLONG</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1001</td>\n",
       "      <td>2000-01-31</td>\n",
       "      <td>0.000</td>\n",
       "      <td>25.000</td>\n",
       "      <td>75.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.75000</td>\n",
       "      <td>594.446</td>\n",
       "      <td>9.942</td>\n",
       "      <td>32.532237</td>\n",
       "      <td>-86.646440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1001</td>\n",
       "      <td>2000-02-29</td>\n",
       "      <td>0.000</td>\n",
       "      <td>100.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.00000</td>\n",
       "      <td>594.446</td>\n",
       "      <td>9.942</td>\n",
       "      <td>32.532237</td>\n",
       "      <td>-86.646440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1001</td>\n",
       "      <td>2000-03-31</td>\n",
       "      <td>0.000</td>\n",
       "      <td>68.145</td>\n",
       "      <td>31.855</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.31855</td>\n",
       "      <td>594.446</td>\n",
       "      <td>9.942</td>\n",
       "      <td>32.532237</td>\n",
       "      <td>-86.646440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1001</td>\n",
       "      <td>2000-04-30</td>\n",
       "      <td>1.775</td>\n",
       "      <td>98.225</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.98225</td>\n",
       "      <td>594.446</td>\n",
       "      <td>9.942</td>\n",
       "      <td>32.532237</td>\n",
       "      <td>-86.646440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1001</td>\n",
       "      <td>2000-05-31</td>\n",
       "      <td>0.000</td>\n",
       "      <td>19.048</td>\n",
       "      <td>78.608</td>\n",
       "      <td>2.344</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.83296</td>\n",
       "      <td>594.446</td>\n",
       "      <td>9.942</td>\n",
       "      <td>32.532237</td>\n",
       "      <td>-86.646440</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>652234</th>\n",
       "      <td>72153</td>\n",
       "      <td>2016-07-31</td>\n",
       "      <td>100.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>67.711</td>\n",
       "      <td>0.628</td>\n",
       "      <td>18.085669</td>\n",
       "      <td>-66.857901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>652235</th>\n",
       "      <td>72153</td>\n",
       "      <td>2016-08-31</td>\n",
       "      <td>100.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>67.711</td>\n",
       "      <td>0.628</td>\n",
       "      <td>18.085669</td>\n",
       "      <td>-66.857901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>652236</th>\n",
       "      <td>72153</td>\n",
       "      <td>2016-09-30</td>\n",
       "      <td>100.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>67.711</td>\n",
       "      <td>0.628</td>\n",
       "      <td>18.085669</td>\n",
       "      <td>-66.857901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>652237</th>\n",
       "      <td>72153</td>\n",
       "      <td>2016-10-31</td>\n",
       "      <td>100.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>67.711</td>\n",
       "      <td>0.628</td>\n",
       "      <td>18.085669</td>\n",
       "      <td>-66.857901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>652238</th>\n",
       "      <td>72153</td>\n",
       "      <td>2016-11-30</td>\n",
       "      <td>100.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>67.711</td>\n",
       "      <td>0.628</td>\n",
       "      <td>18.085669</td>\n",
       "      <td>-66.857901</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>652239 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         FIPS releaseDate     NONE       D0      D1     D2   D3   D4    Level  \\\n",
       "0        1001  2000-01-31    0.000   25.000  75.000  0.000  0.0  0.0  1.75000   \n",
       "1        1001  2000-02-29    0.000  100.000   0.000  0.000  0.0  0.0  1.00000   \n",
       "2        1001  2000-03-31    0.000   68.145  31.855  0.000  0.0  0.0  1.31855   \n",
       "3        1001  2000-04-30    1.775   98.225   0.000  0.000  0.0  0.0  0.98225   \n",
       "4        1001  2000-05-31    0.000   19.048  78.608  2.344  0.0  0.0  1.83296   \n",
       "...       ...         ...      ...      ...     ...    ...  ...  ...      ...   \n",
       "652234  72153  2016-07-31  100.000    0.000   0.000  0.000  0.0  0.0  0.00000   \n",
       "652235  72153  2016-08-31  100.000    0.000   0.000  0.000  0.0  0.0  0.00000   \n",
       "652236  72153  2016-09-30  100.000    0.000   0.000  0.000  0.0  0.0  0.00000   \n",
       "652237  72153  2016-10-31  100.000    0.000   0.000  0.000  0.0  0.0  0.00000   \n",
       "652238  72153  2016-11-30  100.000    0.000   0.000  0.000  0.0  0.0  0.00000   \n",
       "\n",
       "        ALAND_SQMI  AWATER_SQMI   INTPTLAT  \\\n",
       "0          594.446        9.942  32.532237   \n",
       "1          594.446        9.942  32.532237   \n",
       "2          594.446        9.942  32.532237   \n",
       "3          594.446        9.942  32.532237   \n",
       "4          594.446        9.942  32.532237   \n",
       "...            ...          ...        ...   \n",
       "652234      67.711        0.628  18.085669   \n",
       "652235      67.711        0.628  18.085669   \n",
       "652236      67.711        0.628  18.085669   \n",
       "652237      67.711        0.628  18.085669   \n",
       "652238      67.711        0.628  18.085669   \n",
       "\n",
       "        INTPTLONG                                                                                                                 \n",
       "0                                              -86.646440                                                                         \n",
       "1                                              -86.646440                                                                         \n",
       "2                                              -86.646440                                                                         \n",
       "3                                              -86.646440                                                                         \n",
       "4                                              -86.646440                                                                         \n",
       "...                                                   ...                                                                         \n",
       "652234                                         -66.857901                                                                         \n",
       "652235                                         -66.857901                                                                         \n",
       "652236                                         -66.857901                                                                         \n",
       "652237                                         -66.857901                                                                         \n",
       "652238                                         -66.857901                                                                         \n",
       "\n",
       "[652239 rows x 13 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test=drought_data()\n",
    "test\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>FIPS</th>\n",
       "      <th>releaseDate</th>\n",
       "      <th>NONE</th>\n",
       "      <th>D0</th>\n",
       "      <th>D1</th>\n",
       "      <th>D2</th>\n",
       "      <th>D3</th>\n",
       "      <th>D4</th>\n",
       "      <th>Level</th>\n",
       "      <th>ALAND_SQMI</th>\n",
       "      <th>AWATER_SQMI</th>\n",
       "      <th>INTPTLAT</th>\n",
       "      <th>INTPTLONG</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1001</td>\n",
       "      <td>2000-07-31</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.5125</td>\n",
       "      <td>31.6525</td>\n",
       "      <td>42.8350</td>\n",
       "      <td>4.173225</td>\n",
       "      <td>594.446</td>\n",
       "      <td>9.942</td>\n",
       "      <td>32.532237</td>\n",
       "      <td>-86.64644</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1001</td>\n",
       "      <td>2000-08-31</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>100.0000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>594.446</td>\n",
       "      <td>9.942</td>\n",
       "      <td>32.532237</td>\n",
       "      <td>-86.64644</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1001</td>\n",
       "      <td>2000-09-30</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>6.9825</td>\n",
       "      <td>93.0175</td>\n",
       "      <td>4.930175</td>\n",
       "      <td>594.446</td>\n",
       "      <td>9.942</td>\n",
       "      <td>32.532237</td>\n",
       "      <td>-86.64644</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1001</td>\n",
       "      <td>2000-10-31</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>11.1740</td>\n",
       "      <td>88.8260</td>\n",
       "      <td>4.888260</td>\n",
       "      <td>594.446</td>\n",
       "      <td>9.942</td>\n",
       "      <td>32.532237</td>\n",
       "      <td>-86.64644</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>1001</td>\n",
       "      <td>2007-08-31</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.2625</td>\n",
       "      <td>99.7375</td>\n",
       "      <td>4.997375</td>\n",
       "      <td>594.446</td>\n",
       "      <td>9.942</td>\n",
       "      <td>32.532237</td>\n",
       "      <td>-86.64644</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>636357</th>\n",
       "      <td>56045</td>\n",
       "      <td>2012-12-31</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>20.3700</td>\n",
       "      <td>79.6300</td>\n",
       "      <td>4.796300</td>\n",
       "      <td>2398.091</td>\n",
       "      <td>1.931</td>\n",
       "      <td>43.846213</td>\n",
       "      <td>-104.57002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>636358</th>\n",
       "      <td>56045</td>\n",
       "      <td>2013-01-31</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>20.3700</td>\n",
       "      <td>79.6300</td>\n",
       "      <td>4.796300</td>\n",
       "      <td>2398.091</td>\n",
       "      <td>1.931</td>\n",
       "      <td>43.846213</td>\n",
       "      <td>-104.57002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>636359</th>\n",
       "      <td>56045</td>\n",
       "      <td>2013-02-28</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>20.3700</td>\n",
       "      <td>79.6300</td>\n",
       "      <td>4.796300</td>\n",
       "      <td>2398.091</td>\n",
       "      <td>1.931</td>\n",
       "      <td>43.846213</td>\n",
       "      <td>-104.57002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>636360</th>\n",
       "      <td>56045</td>\n",
       "      <td>2013-03-31</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>20.3700</td>\n",
       "      <td>79.6300</td>\n",
       "      <td>4.796300</td>\n",
       "      <td>2398.091</td>\n",
       "      <td>1.931</td>\n",
       "      <td>43.846213</td>\n",
       "      <td>-104.57002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>636361</th>\n",
       "      <td>56045</td>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>23.6140</td>\n",
       "      <td>44.5340</td>\n",
       "      <td>31.8520</td>\n",
       "      <td>4.082380</td>\n",
       "      <td>2398.091</td>\n",
       "      <td>1.931</td>\n",
       "      <td>43.846213</td>\n",
       "      <td>-104.57002</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>14193 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         FIPS releaseDate  NONE   D0   D1       D2       D3        D4  \\\n",
       "6        1001  2000-07-31   0.0  0.0  0.0  25.5125  31.6525   42.8350   \n",
       "7        1001  2000-08-31   0.0  0.0  0.0   0.0000   0.0000  100.0000   \n",
       "8        1001  2000-09-30   0.0  0.0  0.0   0.0000   6.9825   93.0175   \n",
       "9        1001  2000-10-31   0.0  0.0  0.0   0.0000  11.1740   88.8260   \n",
       "91       1001  2007-08-31   0.0  0.0  0.0   0.0000   0.2625   99.7375   \n",
       "...       ...         ...   ...  ...  ...      ...      ...       ...   \n",
       "636357  56045  2012-12-31   0.0  0.0  0.0   0.0000  20.3700   79.6300   \n",
       "636358  56045  2013-01-31   0.0  0.0  0.0   0.0000  20.3700   79.6300   \n",
       "636359  56045  2013-02-28   0.0  0.0  0.0   0.0000  20.3700   79.6300   \n",
       "636360  56045  2013-03-31   0.0  0.0  0.0   0.0000  20.3700   79.6300   \n",
       "636361  56045  2013-04-30   0.0  0.0  0.0  23.6140  44.5340   31.8520   \n",
       "\n",
       "           Level  ALAND_SQMI  AWATER_SQMI   INTPTLAT  \\\n",
       "6       4.173225     594.446        9.942  32.532237   \n",
       "7       5.000000     594.446        9.942  32.532237   \n",
       "8       4.930175     594.446        9.942  32.532237   \n",
       "9       4.888260     594.446        9.942  32.532237   \n",
       "91      4.997375     594.446        9.942  32.532237   \n",
       "...          ...         ...          ...        ...   \n",
       "636357  4.796300    2398.091        1.931  43.846213   \n",
       "636358  4.796300    2398.091        1.931  43.846213   \n",
       "636359  4.796300    2398.091        1.931  43.846213   \n",
       "636360  4.796300    2398.091        1.931  43.846213   \n",
       "636361  4.082380    2398.091        1.931  43.846213   \n",
       "\n",
       "        INTPTLONG                                                                                                                 \n",
       "6                                               -86.64644                                                                         \n",
       "7                                               -86.64644                                                                         \n",
       "8                                               -86.64644                                                                         \n",
       "9                                               -86.64644                                                                         \n",
       "91                                              -86.64644                                                                         \n",
       "...                                                   ...                                                                         \n",
       "636357                                         -104.57002                                                                         \n",
       "636358                                         -104.57002                                                                         \n",
       "636359                                         -104.57002                                                                         \n",
       "636360                                         -104.57002                                                                         \n",
       "636361                                         -104.57002                                                                         \n",
       "\n",
       "[14193 rows x 13 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test1 = test.loc[test[\"Level\"] > 4, :]\n",
    "test1"
   ]
  },
  {
   "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.5"
  },
  "latex_envs": {
   "LaTeX_envs_menu_present": true,
   "autoclose": false,
   "autocomplete": true,
   "bibliofile": "biblio.bib",
   "cite_by": "apalike",
   "current_citInitial": 1,
   "eqLabelWithNumbers": true,
   "eqNumInitial": 1,
   "hotkeys": {
    "equation": "Ctrl-E",
    "itemize": "Ctrl-I"
   },
   "labels_anchors": false,
   "latex_user_defs": false,
   "report_style_numbering": false,
   "user_envs_cfg": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}