feature_cleaning.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Converting features into ones we can actually use, and moving the target value to the last column.\n",
    "This can get extended as we add more numerical/categorical features.\n",
    "\n",
    "Let's make the data (x) and target(Y) and then pickle it."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import julian\n",
    "from sklearn.preprocessing import OrdinalEncoder\n",
    "import datetime"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_pickle('data_with_target.pkl')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "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>Unnamed: 0</th>\n",
       "      <th>OBJECTID</th>\n",
       "      <th>FOD_ID</th>\n",
       "      <th>FPA_ID</th>\n",
       "      <th>SOURCE_SYSTEM_TYPE</th>\n",
       "      <th>SOURCE_SYSTEM</th>\n",
       "      <th>NWCG_REPORTING_AGENCY</th>\n",
       "      <th>NWCG_REPORTING_UNIT_ID</th>\n",
       "      <th>NWCG_REPORTING_UNIT_NAME</th>\n",
       "      <th>SOURCE_REPORTING_UNIT</th>\n",
       "      <th>...</th>\n",
       "      <th>OWNER_CODE</th>\n",
       "      <th>OWNER_DESCR</th>\n",
       "      <th>STATE</th>\n",
       "      <th>COUNTY</th>\n",
       "      <th>FIPS_CODE</th>\n",
       "      <th>FIPS_NAME</th>\n",
       "      <th>Shape</th>\n",
       "      <th>DISCOVERY_DATETIME</th>\n",
       "      <th>CONT_DATETIME</th>\n",
       "      <th>TIME_TO_CONT</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>FS-1418826</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAPNF</td>\n",
       "      <td>Plumas National Forest</td>\n",
       "      <td>511</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>63</td>\n",
       "      <td>63.0</td>\n",
       "      <td>Plumas</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xe8d\\xc2\\x92_@^\\xc0...</td>\n",
       "      <td>2005-02-02 13:00:00</td>\n",
       "      <td>2005-02-03 11:00:00</td>\n",
       "      <td>0 days 22:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>FS-1418827</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>503</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>61</td>\n",
       "      <td>61.0</td>\n",
       "      <td>Placer</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00T\\xb6\\xeej\\xe2\\x19^\\...</td>\n",
       "      <td>2004-05-12 08:45:00</td>\n",
       "      <td>2004-05-13 07:00:00</td>\n",
       "      <td>0 days 22:15:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>FS-1418835</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>503</td>\n",
       "      <td>...</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>17</td>\n",
       "      <td>17.0</td>\n",
       "      <td>El Dorado</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xd0\\xa5\\xa0W\\x13/^\\...</td>\n",
       "      <td>2004-05-31 19:21:00</td>\n",
       "      <td>2004-06-01 16:48:00</td>\n",
       "      <td>0 days 21:27:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>FS-1418845</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>503</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>3</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Alpine</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x94\\xac\\xa3\\rt\\xfa]...</td>\n",
       "      <td>2004-06-28 16:00:00</td>\n",
       "      <td>2004-07-04 04:00:00</td>\n",
       "      <td>5 days 12:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>FS-1418847</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>503</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>3</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Alpine</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00@\\xe3\\xaa.\\xb7\\xfb]\\...</td>\n",
       "      <td>2004-06-28 16:00:00</td>\n",
       "      <td>2004-07-04 00:00:00</td>\n",
       "      <td>5 days 08:00:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 43 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0  OBJECTID  FOD_ID      FPA_ID SOURCE_SYSTEM_TYPE SOURCE_SYSTEM  \\\n",
       "0           0         1       1  FS-1418826                FED   FS-FIRESTAT   \n",
       "1           1         2       2  FS-1418827                FED   FS-FIRESTAT   \n",
       "2           2         3       3  FS-1418835                FED   FS-FIRESTAT   \n",
       "3           3         4       4  FS-1418845                FED   FS-FIRESTAT   \n",
       "4           4         5       5  FS-1418847                FED   FS-FIRESTAT   \n",
       "\n",
       "  NWCG_REPORTING_AGENCY NWCG_REPORTING_UNIT_ID  NWCG_REPORTING_UNIT_NAME  \\\n",
       "0                    FS                USCAPNF    Plumas National Forest   \n",
       "1                    FS                USCAENF  Eldorado National Forest   \n",
       "2                    FS                USCAENF  Eldorado National Forest   \n",
       "3                    FS                USCAENF  Eldorado National Forest   \n",
       "4                    FS                USCAENF  Eldorado National Forest   \n",
       "\n",
       "  SOURCE_REPORTING_UNIT  ... OWNER_CODE       OWNER_DESCR STATE COUNTY  \\\n",
       "0                   511  ...        5.0              USFS    CA     63   \n",
       "1                   503  ...        5.0              USFS    CA     61   \n",
       "2                   503  ...       13.0  STATE OR PRIVATE    CA     17   \n",
       "3                   503  ...        5.0              USFS    CA      3   \n",
       "4                   503  ...        5.0              USFS    CA      3   \n",
       "\n",
       "  FIPS_CODE  FIPS_NAME                                              Shape  \\\n",
       "0      63.0     Plumas  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xe8d\\xc2\\x92_@^\\xc0...   \n",
       "1      61.0     Placer  b'\\x00\\x01\\xad\\x10\\x00\\x00T\\xb6\\xeej\\xe2\\x19^\\...   \n",
       "2      17.0  El Dorado  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xd0\\xa5\\xa0W\\x13/^\\...   \n",
       "3       3.0     Alpine  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x94\\xac\\xa3\\rt\\xfa]...   \n",
       "4       3.0     Alpine  b'\\x00\\x01\\xad\\x10\\x00\\x00@\\xe3\\xaa.\\xb7\\xfb]\\...   \n",
       "\n",
       "   DISCOVERY_DATETIME       CONT_DATETIME    TIME_TO_CONT  \n",
       "0 2005-02-02 13:00:00 2005-02-03 11:00:00 0 days 22:00:00  \n",
       "1 2004-05-12 08:45:00 2004-05-13 07:00:00 0 days 22:15:00  \n",
       "2 2004-05-31 19:21:00 2004-06-01 16:48:00 0 days 21:27:00  \n",
       "3 2004-06-28 16:00:00 2004-07-04 04:00:00 5 days 12:00:00  \n",
       "4 2004-06-28 16:00:00 2004-07-04 00:00:00 5 days 08:00:00  \n",
       "\n",
       "[5 rows x 43 columns]"
      ]
     },
     "execution_count": 91,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Unnamed: 0', 'OBJECTID', 'FOD_ID', 'FPA_ID', 'SOURCE_SYSTEM_TYPE',\n",
       "       'SOURCE_SYSTEM', 'NWCG_REPORTING_AGENCY', 'NWCG_REPORTING_UNIT_ID',\n",
       "       'NWCG_REPORTING_UNIT_NAME', 'SOURCE_REPORTING_UNIT',\n",
       "       'SOURCE_REPORTING_UNIT_NAME', 'LOCAL_FIRE_REPORT_ID',\n",
       "       'LOCAL_INCIDENT_ID', 'FIRE_CODE', 'FIRE_NAME',\n",
       "       'ICS_209_INCIDENT_NUMBER', 'ICS_209_NAME', 'MTBS_ID',\n",
       "       'MTBS_FIRE_NAME', 'COMPLEX_NAME', 'FIRE_YEAR', 'DISCOVERY_DATE',\n",
       "       'DISCOVERY_DOY', 'DISCOVERY_TIME', 'STAT_CAUSE_CODE',\n",
       "       'STAT_CAUSE_DESCR', 'CONT_DATE', 'CONT_DOY', 'CONT_TIME',\n",
       "       'FIRE_SIZE', 'FIRE_SIZE_CLASS', 'LATITUDE', 'LONGITUDE',\n",
       "       'OWNER_CODE', 'OWNER_DESCR', 'STATE', 'COUNTY', 'FIPS_CODE',\n",
       "       'FIPS_NAME', 'Shape', 'DISCOVERY_DATETIME', 'CONT_DATETIME',\n",
       "       'TIME_TO_CONT'], dtype=object)"
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns.values"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Out of the input values, what we can use as categorical values are probably 'state' and discovery date.  Let's drop everything except for the state (encode to categories) and the discovery month (encode to categories), and save the labels separately."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "metadata": {},
   "outputs": [],
   "source": [
    "x = df[['DISCOVERY_DATETIME', 'STATE']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "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>DISCOVERY_DATETIME</th>\n",
       "      <th>STATE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2005-02-02 13:00:00</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2004-05-12 08:45:00</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2004-05-31 19:21:00</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2004-06-28 16:00:00</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2004-06-28 16:00:00</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   DISCOVERY_DATETIME STATE\n",
       "0 2005-02-02 13:00:00    CA\n",
       "1 2004-05-12 08:45:00    CA\n",
       "2 2004-05-31 19:21:00    CA\n",
       "3 2004-06-28 16:00:00    CA\n",
       "4 2004-06-28 16:00:00    CA"
      ]
     },
     "execution_count": 94,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0   2005-02-02 13:00:00\n",
       "1   2004-05-12 08:45:00\n",
       "2   2004-05-31 19:21:00\n",
       "3   2004-06-28 16:00:00\n",
       "4   2004-06-28 16:00:00\n",
       "Name: DISCOVERY_DATETIME, dtype: datetime64[ns]"
      ]
     },
     "execution_count": 95,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Now encode the results:\n",
    "x['DISCOVERY_DATETIME'].head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Applications/anaconda3/lib/python3.6/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    }
   ],
   "source": [
    "x['DISCOVERY_DATETIME'] = x['DISCOVERY_DATETIME'].apply(lambda x: x.month)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "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>DISCOVERY_DATETIME</th>\n",
       "      <th>STATE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>6</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>6</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   DISCOVERY_DATETIME STATE\n",
       "0                   2    CA\n",
       "1                   5    CA\n",
       "2                   5    CA\n",
       "3                   6    CA\n",
       "4                   6    CA"
      ]
     },
     "execution_count": 97,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Encode the motnhs and the states ordinally.\n",
    "enc = OrdinalEncoder()\n",
    "st =  enc.fit_transform(np.array(x['STATE']).reshape(-1,1))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[array(['AK', 'AL', 'AR', 'AZ', 'CA', 'CO', 'CT', 'DC', 'DE', 'FL', 'GA',\n",
       "        'HI', 'IA', 'ID', 'IL', 'IN', 'KS', 'KY', 'LA', 'MA', 'MD', 'ME',\n",
       "        'MI', 'MN', 'MO', 'MS', 'MT', 'NC', 'ND', 'NE', 'NH', 'NJ', 'NM',\n",
       "        'NV', 'NY', 'OH', 'OK', 'OR', 'PA', 'PR', 'RI', 'SC', 'SD', 'TN',\n",
       "        'TX', 'UT', 'VA', 'VT', 'WA', 'WI', 'WV', 'WY'], dtype=object)]"
      ]
     },
     "execution_count": 99,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "enc.categories_"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Applications/anaconda3/lib/python3.6/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    }
   ],
   "source": [
    "x['STATE'] = pd.DataFrame(st)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "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>DISCOVERY_DATETIME</th>\n",
       "      <th>STATE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>6</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>6</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   DISCOVERY_DATETIME  STATE\n",
       "0                   2    4.0\n",
       "1                   5    4.0\n",
       "2                   5    4.0\n",
       "3                   6    4.0\n",
       "4                   6    4.0"
      ]
     },
     "execution_count": 101,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "metadata": {},
   "outputs": [],
   "source": [
    "#And then let's save it for analysis.\n",
    "x.to_pickle(\"wildfire_encoded_data.pkl\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 151,
   "metadata": {},
   "outputs": [
    {
     "ename": "KeyError",
     "evalue": "'TIME_TO_CONT'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
      "\u001b[0;32m/Applications/anaconda3/lib/python3.6/site-packages/pandas/core/indexes/base.py\u001b[0m in \u001b[0;36mget_loc\u001b[0;34m(self, key, method, tolerance)\u001b[0m\n\u001b[1;32m   2656\u001b[0m             \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2657\u001b[0;31m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_engine\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2658\u001b[0m             \u001b[0;32mexcept\u001b[0m \u001b[0mKeyError\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/index.pyx\u001b[0m in \u001b[0;36mpandas._libs.index.IndexEngine.get_loc\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/index.pyx\u001b[0m in \u001b[0;36mpandas._libs.index.IndexEngine.get_loc\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/hashtable_class_helper.pxi\u001b[0m in \u001b[0;36mpandas._libs.hashtable.PyObjectHashTable.get_item\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/hashtable_class_helper.pxi\u001b[0m in \u001b[0;36mpandas._libs.hashtable.PyObjectHashTable.get_item\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;31mKeyError\u001b[0m: 'TIME_TO_CONT'",
      "\nDuring handling of the above exception, another exception occurred:\n",
      "\u001b[0;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-151-aeff0f01be24>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[1;32m      1\u001b[0m \u001b[0;31m#As for the labels, let's convert those to hours\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 2\u001b[0;31m \u001b[0mY\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mdf\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'TIME_TO_CONT'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      3\u001b[0m \u001b[0mY\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mhead\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Applications/anaconda3/lib/python3.6/site-packages/pandas/core/frame.py\u001b[0m in \u001b[0;36m__getitem__\u001b[0;34m(self, key)\u001b[0m\n\u001b[1;32m   2925\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mnlevels\u001b[0m \u001b[0;34m>\u001b[0m \u001b[0;36m1\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2926\u001b[0m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_getitem_multilevel\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2927\u001b[0;31m             \u001b[0mindexer\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2928\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mis_integer\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mindexer\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2929\u001b[0m                 \u001b[0mindexer\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m[\u001b[0m\u001b[0mindexer\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Applications/anaconda3/lib/python3.6/site-packages/pandas/core/indexes/base.py\u001b[0m in \u001b[0;36mget_loc\u001b[0;34m(self, key, method, tolerance)\u001b[0m\n\u001b[1;32m   2657\u001b[0m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_engine\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2658\u001b[0m             \u001b[0;32mexcept\u001b[0m \u001b[0mKeyError\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2659\u001b[0;31m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_engine\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_maybe_cast_indexer\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2660\u001b[0m         \u001b[0mindexer\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_indexer\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mmethod\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mmethod\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mtolerance\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mtolerance\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2661\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mindexer\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mndim\u001b[0m \u001b[0;34m>\u001b[0m \u001b[0;36m1\u001b[0m \u001b[0;32mor\u001b[0m \u001b[0mindexer\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msize\u001b[0m \u001b[0;34m>\u001b[0m \u001b[0;36m1\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/index.pyx\u001b[0m in \u001b[0;36mpandas._libs.index.IndexEngine.get_loc\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/index.pyx\u001b[0m in \u001b[0;36mpandas._libs.index.IndexEngine.get_loc\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/hashtable_class_helper.pxi\u001b[0m in \u001b[0;36mpandas._libs.hashtable.PyObjectHashTable.get_item\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/hashtable_class_helper.pxi\u001b[0m in \u001b[0;36mpandas._libs.hashtable.PyObjectHashTable.get_item\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;31mKeyError\u001b[0m: 'TIME_TO_CONT'"
     ]
    }
   ],
   "source": [
    "#As for the labels, let's convert those to hours\n",
    "Y = df['TIME_TO_CONT']\n",
    "Y.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "metadata": {},
   "outputs": [],
   "source": [
    "Y = Y.apply(lambda x: x.total_seconds()/3600)\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 107,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     22.00\n",
       "1     22.25\n",
       "2     21.45\n",
       "3    132.00\n",
       "4    128.00\n",
       "Name: TIME_TO_CONT, dtype: float64"
      ]
     },
     "execution_count": 107,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Y.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "metadata": {},
   "outputs": [],
   "source": [
    "Y.to_pickle('wildfire_encoded_labels.pkl')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Let's do the same thing with the data using the area target instead of time"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 193,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_pickle('data_with_size_target.pkl')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 199,
   "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>OBJECTID</th>\n",
       "      <th>FOD_ID</th>\n",
       "      <th>FPA_ID</th>\n",
       "      <th>SOURCE_SYSTEM_TYPE</th>\n",
       "      <th>SOURCE_SYSTEM</th>\n",
       "      <th>NWCG_REPORTING_AGENCY</th>\n",
       "      <th>NWCG_REPORTING_UNIT_ID</th>\n",
       "      <th>NWCG_REPORTING_UNIT_NAME</th>\n",
       "      <th>SOURCE_REPORTING_UNIT</th>\n",
       "      <th>SOURCE_REPORTING_UNIT_NAME</th>\n",
       "      <th>...</th>\n",
       "      <th>LATITUDE</th>\n",
       "      <th>LONGITUDE</th>\n",
       "      <th>OWNER_CODE</th>\n",
       "      <th>OWNER_DESCR</th>\n",
       "      <th>STATE</th>\n",
       "      <th>COUNTY</th>\n",
       "      <th>FIPS_CODE</th>\n",
       "      <th>FIPS_NAME</th>\n",
       "      <th>Shape</th>\n",
       "      <th>DISCOVERY_DATETIME</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>FS-1418826</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAPNF</td>\n",
       "      <td>Plumas National Forest</td>\n",
       "      <td>0511</td>\n",
       "      <td>Plumas National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>40.036944</td>\n",
       "      <td>-121.005833</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>63</td>\n",
       "      <td>063</td>\n",
       "      <td>Plumas</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xe8d\\xc2\\x92_@^\\xc0...</td>\n",
       "      <td>2005-02-02 13:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>FS-1418827</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>38.933056</td>\n",
       "      <td>-120.404444</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>61</td>\n",
       "      <td>061</td>\n",
       "      <td>Placer</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00T\\xb6\\xeej\\xe2\\x19^\\...</td>\n",
       "      <td>2004-05-12 08:45:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>FS-1418835</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>38.984167</td>\n",
       "      <td>-120.735556</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>17</td>\n",
       "      <td>017</td>\n",
       "      <td>El Dorado</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xd0\\xa5\\xa0W\\x13/^\\...</td>\n",
       "      <td>2004-05-31 19:21:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>FS-1418845</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>38.559167</td>\n",
       "      <td>-119.913333</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>3</td>\n",
       "      <td>003</td>\n",
       "      <td>Alpine</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x94\\xac\\xa3\\rt\\xfa]...</td>\n",
       "      <td>2004-06-28 16:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>FS-1418847</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>38.559167</td>\n",
       "      <td>-119.933056</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>3</td>\n",
       "      <td>003</td>\n",
       "      <td>Alpine</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00@\\xe3\\xaa.\\xb7\\xfb]\\...</td>\n",
       "      <td>2004-06-28 16:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>FS-1418849</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>38.635278</td>\n",
       "      <td>-120.103611</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>5</td>\n",
       "      <td>005</td>\n",
       "      <td>Amador</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf0&lt;~\\x90\\xa1\\x06^\\...</td>\n",
       "      <td>2004-06-30 18:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>FS-1418851</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>38.688333</td>\n",
       "      <td>-120.153333</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>17</td>\n",
       "      <td>017</td>\n",
       "      <td>El Dorado</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00$o\\x996\\xd0\\t^\\xc0h\\...</td>\n",
       "      <td>2004-07-01 18:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>FS-1418854</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCASHF</td>\n",
       "      <td>Shasta-Trinity National Forest</td>\n",
       "      <td>0514</td>\n",
       "      <td>Shasta-Trinity National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>40.968056</td>\n",
       "      <td>-122.433889</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00t)\\xe8\\xd5\\xc4\\x9b^\\...</td>\n",
       "      <td>2005-03-08 13:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>FS-1418856</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCASHF</td>\n",
       "      <td>Shasta-Trinity National Forest</td>\n",
       "      <td>0514</td>\n",
       "      <td>Shasta-Trinity National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>41.233611</td>\n",
       "      <td>-122.283333</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xdc\\x8d\\x1e\"\"\\x92^\\...</td>\n",
       "      <td>2005-03-15 12:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>FS-1418859</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>38.548333</td>\n",
       "      <td>-120.149167</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>5</td>\n",
       "      <td>005</td>\n",
       "      <td>Amador</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00dS\\\\\\xf2\\x8b\\t^\\xc0\\...</td>\n",
       "      <td>2004-07-01 18:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>FS-1418861</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>38.691667</td>\n",
       "      <td>-120.159722</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>17</td>\n",
       "      <td>017</td>\n",
       "      <td>El Dorado</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x0c\\xd6\\x8b\\xe38\\n^...</td>\n",
       "      <td>2004-07-02 18:30:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>FS-1418863</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>38.527500</td>\n",
       "      <td>-120.106111</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>5</td>\n",
       "      <td>005</td>\n",
       "      <td>Amador</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00L\\xcc@\\x86\\xca\\x06^\\...</td>\n",
       "      <td>2004-07-02 17:30:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>FS-1418865</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>38.786667</td>\n",
       "      <td>-120.193333</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>17</td>\n",
       "      <td>017</td>\n",
       "      <td>El Dorado</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xe8d\\xc2\\x92_\\x0c^\\...</td>\n",
       "      <td>2004-09-03 16:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>FS-1418872</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>38.433333</td>\n",
       "      <td>-120.510000</td>\n",
       "      <td>14.0</td>\n",
       "      <td>MISSING/NOT SPECIFIED</td>\n",
       "      <td>CA</td>\n",
       "      <td>5</td>\n",
       "      <td>005</td>\n",
       "      <td>Amador</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00p=\\n\\xd7\\xa3 ^\\xc0\\x...</td>\n",
       "      <td>2004-09-28 12:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>FS-1418874</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>38.675833</td>\n",
       "      <td>-120.279722</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>17</td>\n",
       "      <td>017</td>\n",
       "      <td>El Dorado</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00P\\xb7\\x06\\xf8\\xe6\\x1...</td>\n",
       "      <td>2004-10-03 06:30:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>FS-1418876</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>38.564167</td>\n",
       "      <td>-120.542222</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>17</td>\n",
       "      <td>017</td>\n",
       "      <td>El Dorado</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00 \\x84\\xd3\\xc4\\xb3\"^\\...</td>\n",
       "      <td>2004-10-03 09:30:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "      <td>FS-1418878</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>38.523333</td>\n",
       "      <td>-120.211667</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>5</td>\n",
       "      <td>005</td>\n",
       "      <td>Amador</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00dS\\\\\\xf2\\x8b\\r^\\xc0\\...</td>\n",
       "      <td>2004-10-06 14:15:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>FS-1418881</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>38.780000</td>\n",
       "      <td>-120.260000</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>CA</td>\n",
       "      <td>17</td>\n",
       "      <td>017</td>\n",
       "      <td>El Dorado</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00p=\\n\\xd7\\xa3\\x10^\\xc...</td>\n",
       "      <td>2004-10-13 16:18:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>FS-1418884</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCAENF</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>0503</td>\n",
       "      <td>Eldorado National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>38.945000</td>\n",
       "      <td>-120.411667</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>17</td>\n",
       "      <td>017</td>\n",
       "      <td>El Dorado</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x004 )\\xbfX\\x1a^\\xc00\\\\...</td>\n",
       "      <td>2004-11-20 20:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>FS-1418887</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>33.440833</td>\n",
       "      <td>-105.720556</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xa8I\\x11\\x95\\x1dnZ\\...</td>\n",
       "      <td>2004-06-04 10:30:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>FS-1418888</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>33.307222</td>\n",
       "      <td>-105.628611</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x88\\xd6\\x17*;hZ\\xc0...</td>\n",
       "      <td>2004-06-19 15:30:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>22</td>\n",
       "      <td>FS-1418893</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>33.444444</td>\n",
       "      <td>-105.768056</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b\"\\x00\\x01\\xad\\x10\\x00\\x00|\\xed\\x81\\xd2'qZ\\xc0...</td>\n",
       "      <td>2004-06-21 14:40:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>FS-1418894</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>33.559444</td>\n",
       "      <td>-105.766111</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00T\\xa3\\xe4\\xf6\\x07qZ\\...</td>\n",
       "      <td>2004-06-25 19:10:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>24</td>\n",
       "      <td>FS-1418895</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>33.308056</td>\n",
       "      <td>-105.526111</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xc8\\xe0\\xee\\xcd\\xab...</td>\n",
       "      <td>2004-07-01 12:50:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>FS-1418896</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>33.545278</td>\n",
       "      <td>-105.229444</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00 \\x83\\xbb7\\xafNZ\\xc0...</td>\n",
       "      <td>2004-07-01 17:12:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "      <td>FS-1418897</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>33.315833</td>\n",
       "      <td>-105.512222</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xcc\\xcb\\xb4?\\xc8`Z\\...</td>\n",
       "      <td>2004-07-20 14:05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>FS-1418898</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>33.444444</td>\n",
       "      <td>-105.631111</td>\n",
       "      <td>14.0</td>\n",
       "      <td>MISSING/NOT SPECIFIED</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xe4e\\xda\\x1fdhZ\\xc0...</td>\n",
       "      <td>2004-03-18 11:45:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>FS-1418903</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>33.368056</td>\n",
       "      <td>-105.507222</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x14\\xad/Tv`Z\\xc0\\xd...</td>\n",
       "      <td>2004-08-05 09:45:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29</td>\n",
       "      <td>29</td>\n",
       "      <td>FS-1418904</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>33.385278</td>\n",
       "      <td>-105.638611</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf8\\x13\"\\x01\\xdfhZ\\...</td>\n",
       "      <td>2004-03-18 16:55:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>FS-1418905</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USNMLNF</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>0308</td>\n",
       "      <td>Lincoln National Forest</td>\n",
       "      <td>...</td>\n",
       "      <td>33.382778</td>\n",
       "      <td>-105.700278</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>NM</td>\n",
       "      <td>27</td>\n",
       "      <td>027</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xc8\\xcd\\xe4Y\\xd1lZ\\...</td>\n",
       "      <td>2004-05-11 15:15:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880435</th>\n",
       "      <td>1880436</td>\n",
       "      <td>300348217</td>\n",
       "      <td>2015CAIRS28664200</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCALNU</td>\n",
       "      <td>Sonoma-Lake Napa Unit</td>\n",
       "      <td>CALNU</td>\n",
       "      <td>Sonoma-Lake Napa Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>38.159780</td>\n",
       "      <td>-122.451750</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf0\\xfd\\xd4x\\xe9\\x9...</td>\n",
       "      <td>2015-06-28 12:02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880436</th>\n",
       "      <td>1880437</td>\n",
       "      <td>300348237</td>\n",
       "      <td>2015CAIRS26850166</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCANEU</td>\n",
       "      <td>Nevada-Yuba-Placer Unit</td>\n",
       "      <td>CANEU</td>\n",
       "      <td>Nevada-Yuba-Placer Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>39.143821</td>\n",
       "      <td>-121.036533</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00`\\x0e\\x82\\x8eVB^\\xc0...</td>\n",
       "      <td>2015-03-21 11:38:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880437</th>\n",
       "      <td>1880438</td>\n",
       "      <td>300348240</td>\n",
       "      <td>2015CAIRS27248589</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCAHUU</td>\n",
       "      <td>Humboldt-Del Norte Unit</td>\n",
       "      <td>CAHUU</td>\n",
       "      <td>Humboldt-Del Norte Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>41.224483</td>\n",
       "      <td>-123.763317</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xc4\\xde\\x8b/\\xda\\xf...</td>\n",
       "      <td>2015-05-11 16:45:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880438</th>\n",
       "      <td>1880439</td>\n",
       "      <td>300348242</td>\n",
       "      <td>2015CAIRS29017324</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCANEU</td>\n",
       "      <td>Nevada-Yuba-Placer Unit</td>\n",
       "      <td>CANEU</td>\n",
       "      <td>Nevada-Yuba-Placer Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>39.005712</td>\n",
       "      <td>-121.260759</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xccH\\x84F\\xb0P^\\xc0...</td>\n",
       "      <td>2015-09-26 16:25:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880439</th>\n",
       "      <td>1880440</td>\n",
       "      <td>300348247</td>\n",
       "      <td>2015CAIRS27699480</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCAKRN</td>\n",
       "      <td>Kern County Fire Department</td>\n",
       "      <td>CAKRN</td>\n",
       "      <td>Kern County Fire Department</td>\n",
       "      <td>...</td>\n",
       "      <td>34.933333</td>\n",
       "      <td>-118.883333</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x90\\x9e\"\\x87\\x88\\xb...</td>\n",
       "      <td>2015-01-27 12:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880440</th>\n",
       "      <td>1880441</td>\n",
       "      <td>300348248</td>\n",
       "      <td>2015CAIRS28587133</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCALAC</td>\n",
       "      <td>Los Angeles County Fire Department</td>\n",
       "      <td>CALAC</td>\n",
       "      <td>Los Angeles County Fire Department</td>\n",
       "      <td>...</td>\n",
       "      <td>34.716666</td>\n",
       "      <td>-118.800000</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x0003333\\xb3]\\xc0\\xe0\\x...</td>\n",
       "      <td>2015-07-04 23:11:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880441</th>\n",
       "      <td>1880442</td>\n",
       "      <td>300348249</td>\n",
       "      <td>2015CAIRS29152556</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCALAC</td>\n",
       "      <td>Los Angeles County Fire Department</td>\n",
       "      <td>CALAC</td>\n",
       "      <td>Los Angeles County Fire Department</td>\n",
       "      <td>...</td>\n",
       "      <td>34.450000</td>\n",
       "      <td>-118.583333</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\\\k\\xefSU\\xa5]\\xc0\\x...</td>\n",
       "      <td>2015-12-07 15:12:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880442</th>\n",
       "      <td>1880443</td>\n",
       "      <td>300348255</td>\n",
       "      <td>2015CAIRS26850725</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCACZU</td>\n",
       "      <td>San Mateo-Santa Cruz Unit</td>\n",
       "      <td>CACZU</td>\n",
       "      <td>San Mateo-Santa Cruz Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>37.090126</td>\n",
       "      <td>-122.074684</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x004bf\\x9f\\xc7\\x84^\\xc0...</td>\n",
       "      <td>2015-03-28 16:56:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880443</th>\n",
       "      <td>1880444</td>\n",
       "      <td>300348257</td>\n",
       "      <td>2015CAIRS28268055</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCALMU</td>\n",
       "      <td>Lassen-Modoc Unit</td>\n",
       "      <td>CALMU</td>\n",
       "      <td>Lassen-Modoc Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>40.297000</td>\n",
       "      <td>-120.528000</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00l\\x12\\x83\\xc0\\xca!^\\...</td>\n",
       "      <td>2015-09-27 05:36:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880444</th>\n",
       "      <td>1880445</td>\n",
       "      <td>300348258</td>\n",
       "      <td>2015CAIRS28291406</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCASCU</td>\n",
       "      <td>Santa Clara Unit</td>\n",
       "      <td>CASCU</td>\n",
       "      <td>Santa Clara Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>37.701111</td>\n",
       "      <td>-122.021111</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00|\\xa5\\xf3\\xe1Y\\x81^\\...</td>\n",
       "      <td>2015-10-30 15:45:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880445</th>\n",
       "      <td>1880446</td>\n",
       "      <td>300348259</td>\n",
       "      <td>2015CAIRS27092196</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCABDU</td>\n",
       "      <td>San Bernardino Unit</td>\n",
       "      <td>CABDU</td>\n",
       "      <td>CDF - San Bernardino Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>37.361417</td>\n",
       "      <td>-118.465150</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x00o\\x81\\x04\\xc5\\x9...</td>\n",
       "      <td>2015-02-22 12:33:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880446</th>\n",
       "      <td>1880447</td>\n",
       "      <td>300348260</td>\n",
       "      <td>2015CAIRS29015247</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCABDU</td>\n",
       "      <td>San Bernardino Unit</td>\n",
       "      <td>CABDU</td>\n",
       "      <td>CDF - San Bernardino Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>34.244444</td>\n",
       "      <td>-116.658889</td>\n",
       "      <td>15.0</td>\n",
       "      <td>UNDEFINED FEDERAL</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00l\\xac\\xc4&lt;+*]\\xc0\\x1...</td>\n",
       "      <td>2015-07-25 19:43:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880447</th>\n",
       "      <td>1880448</td>\n",
       "      <td>300348274</td>\n",
       "      <td>2015CAIRS26084391</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCAMVU</td>\n",
       "      <td>Monte Vista Unit</td>\n",
       "      <td>CAMVU</td>\n",
       "      <td>CDF - Monte Vista Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>32.576754</td>\n",
       "      <td>-116.627539</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xb8}V\\x99)(]\\xc00\\x...</td>\n",
       "      <td>2015-01-28 00:41:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880448</th>\n",
       "      <td>1880449</td>\n",
       "      <td>300348276</td>\n",
       "      <td>2015CAIRS27560317</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCALMU</td>\n",
       "      <td>Lassen-Modoc Unit</td>\n",
       "      <td>CALMU</td>\n",
       "      <td>Lassen-Modoc Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>40.443000</td>\n",
       "      <td>-120.664433</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x84X\\xfd\\x11\\x86*^\\...</td>\n",
       "      <td>2015-06-26 17:52:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880449</th>\n",
       "      <td>1880450</td>\n",
       "      <td>300348289</td>\n",
       "      <td>2015CAIRS28493610</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCAVNC</td>\n",
       "      <td>Ventura County Fire Department</td>\n",
       "      <td>CAVNC</td>\n",
       "      <td>Ventura County Fire Department</td>\n",
       "      <td>...</td>\n",
       "      <td>34.666666</td>\n",
       "      <td>-119.333333</td>\n",
       "      <td>15.0</td>\n",
       "      <td>UNDEFINED FEDERAL</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\\\k\\xefSU\\xd5]\\xc0\\x...</td>\n",
       "      <td>2015-08-27 17:37:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880450</th>\n",
       "      <td>1880451</td>\n",
       "      <td>300348290</td>\n",
       "      <td>2015CAIRS27653046</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCASCU</td>\n",
       "      <td>Santa Clara Unit</td>\n",
       "      <td>CASCU</td>\n",
       "      <td>Santa Clara Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>38.041150</td>\n",
       "      <td>-121.985283</td>\n",
       "      <td>15.0</td>\n",
       "      <td>UNDEFINED FEDERAL</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x80\\x93m\\xe0\\x0e\\x7...</td>\n",
       "      <td>2015-06-27 03:37:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880451</th>\n",
       "      <td>1880452</td>\n",
       "      <td>300348291</td>\n",
       "      <td>2015CAIRS27458005</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCAAEU</td>\n",
       "      <td>Amador-El Dorado Unit</td>\n",
       "      <td>CAAEU</td>\n",
       "      <td>Amador-El Dorado Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>38.644183</td>\n",
       "      <td>-120.863673</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x08\\\\\\x1ekF7^\\xc0\\x...</td>\n",
       "      <td>2015-06-06 12:08:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880452</th>\n",
       "      <td>1880453</td>\n",
       "      <td>300348293</td>\n",
       "      <td>2015CAIRS27587395</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCALAC</td>\n",
       "      <td>Los Angeles County Fire Department</td>\n",
       "      <td>CALAC</td>\n",
       "      <td>Los Angeles County Fire Department</td>\n",
       "      <td>...</td>\n",
       "      <td>34.163117</td>\n",
       "      <td>-118.693303</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf0A\\t\\x12_\\xac]\\xc...</td>\n",
       "      <td>2015-04-14 08:27:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880453</th>\n",
       "      <td>1880454</td>\n",
       "      <td>300348297</td>\n",
       "      <td>2015CAIRS28589435</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCALAC</td>\n",
       "      <td>Los Angeles County Fire Department</td>\n",
       "      <td>CALAC</td>\n",
       "      <td>Los Angeles County Fire Department</td>\n",
       "      <td>...</td>\n",
       "      <td>34.278180</td>\n",
       "      <td>-118.621180</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00h\\x0c\\xdfg\\xc1\\xa7]\\...</td>\n",
       "      <td>2015-07-07 07:23:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880454</th>\n",
       "      <td>1880455</td>\n",
       "      <td>300348310</td>\n",
       "      <td>2015CAIRS28424493</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>CATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>38.048577</td>\n",
       "      <td>-120.313090</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x18\\xad\\xa3\\xaa\\t\\x...</td>\n",
       "      <td>2015-09-12 06:38:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880455</th>\n",
       "      <td>1880456</td>\n",
       "      <td>300348311</td>\n",
       "      <td>2015CAIRS27458827</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>CATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>37.936253</td>\n",
       "      <td>-120.613743</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b\"\\x00\\x01\\xad\\x10\\x00\\x00\\x84I\\xb8\\x90G'^\\xc0...</td>\n",
       "      <td>2015-06-28 20:42:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880456</th>\n",
       "      <td>1880457</td>\n",
       "      <td>300348328</td>\n",
       "      <td>2015CAIRS27369138</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCATGU</td>\n",
       "      <td>Tehama-Glenn Unit</td>\n",
       "      <td>CATGU</td>\n",
       "      <td>Tehama-Glenn Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>40.019907</td>\n",
       "      <td>-122.391398</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x10n2\\xaa\\x0c\\x99^\\...</td>\n",
       "      <td>2015-06-14 17:14:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880457</th>\n",
       "      <td>1880458</td>\n",
       "      <td>300348354</td>\n",
       "      <td>2015CAIRS28234594</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCASHU</td>\n",
       "      <td>Shasta-Trinity Unit</td>\n",
       "      <td>CASHU</td>\n",
       "      <td>Shasta-Trinity Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>40.588583</td>\n",
       "      <td>-123.069617</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xb8\\x8f\\xdc\\x9at\\xc...</td>\n",
       "      <td>2015-09-30 23:57:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880458</th>\n",
       "      <td>1880459</td>\n",
       "      <td>300348361</td>\n",
       "      <td>2015CAIRS27957490</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCAHUU</td>\n",
       "      <td>Humboldt-Del Norte Unit</td>\n",
       "      <td>CAHUU</td>\n",
       "      <td>Humboldt-Del Norte Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>40.244833</td>\n",
       "      <td>-123.544167</td>\n",
       "      <td>15.0</td>\n",
       "      <td>UNDEFINED FEDERAL</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xfc#\\xd3\\xa1\\xd3\\xe...</td>\n",
       "      <td>2015-08-01 13:31:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880459</th>\n",
       "      <td>1880460</td>\n",
       "      <td>300348362</td>\n",
       "      <td>2015CAIRS28291374</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCALNU</td>\n",
       "      <td>Sonoma-Lake Napa Unit</td>\n",
       "      <td>CALNU</td>\n",
       "      <td>Sonoma-Lake Napa Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>38.415608</td>\n",
       "      <td>-122.660044</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf0z0)&gt;\\xaa^\\xc0h\\x...</td>\n",
       "      <td>2015-05-28 14:20:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880460</th>\n",
       "      <td>1880461</td>\n",
       "      <td>300348363</td>\n",
       "      <td>2015CAIRS29019636</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCASHU</td>\n",
       "      <td>Shasta-Trinity Unit</td>\n",
       "      <td>CASHU</td>\n",
       "      <td>Shasta-Trinity Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>40.481637</td>\n",
       "      <td>-122.389375</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00P\\xb8\\x1e\\x85\\xeb\\x9...</td>\n",
       "      <td>2015-09-26 17:26:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880461</th>\n",
       "      <td>1880462</td>\n",
       "      <td>300348373</td>\n",
       "      <td>2015CAIRS29217935</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>CATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>37.617619</td>\n",
       "      <td>-120.938570</td>\n",
       "      <td>12.0</td>\n",
       "      <td>MUNICIPAL/LOCAL</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x00\\x80\\xbe\\x88\\x11...</td>\n",
       "      <td>2015-10-05 01:26:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880462</th>\n",
       "      <td>1880463</td>\n",
       "      <td>300348375</td>\n",
       "      <td>2015CAIRS28364460</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>CATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>37.617619</td>\n",
       "      <td>-120.938570</td>\n",
       "      <td>12.0</td>\n",
       "      <td>MUNICIPAL/LOCAL</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x00\\x80\\xbe\\x88\\x11...</td>\n",
       "      <td>2015-05-02 20:52:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880463</th>\n",
       "      <td>1880464</td>\n",
       "      <td>300348377</td>\n",
       "      <td>2015CAIRS29218079</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>CATCU</td>\n",
       "      <td>Tuolumne-Calaveras Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>37.672235</td>\n",
       "      <td>-120.898356</td>\n",
       "      <td>12.0</td>\n",
       "      <td>MUNICIPAL/LOCAL</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00x\\xba_\\xaa~9^\\xc0\\xb...</td>\n",
       "      <td>2015-10-14 23:09:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880464</th>\n",
       "      <td>1880465</td>\n",
       "      <td>300348399</td>\n",
       "      <td>2015CAIRS26733926</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-CACDF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USCABDU</td>\n",
       "      <td>San Bernardino Unit</td>\n",
       "      <td>CABDU</td>\n",
       "      <td>CDF - San Bernardino Unit</td>\n",
       "      <td>...</td>\n",
       "      <td>34.263217</td>\n",
       "      <td>-116.830950</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x1c\\xa7\\xe8H.5]\\xc0...</td>\n",
       "      <td>2015-03-14 21:28:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>997827 rows × 40 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         OBJECTID     FOD_ID             FPA_ID SOURCE_SYSTEM_TYPE  \\\n",
       "0               1          1         FS-1418826                FED   \n",
       "1               2          2         FS-1418827                FED   \n",
       "2               3          3         FS-1418835                FED   \n",
       "3               4          4         FS-1418845                FED   \n",
       "4               5          5         FS-1418847                FED   \n",
       "5               6          6         FS-1418849                FED   \n",
       "6               7          7         FS-1418851                FED   \n",
       "7               8          8         FS-1418854                FED   \n",
       "8               9          9         FS-1418856                FED   \n",
       "9              10         10         FS-1418859                FED   \n",
       "10             11         11         FS-1418861                FED   \n",
       "11             12         12         FS-1418863                FED   \n",
       "12             13         13         FS-1418865                FED   \n",
       "13             14         14         FS-1418872                FED   \n",
       "14             15         15         FS-1418874                FED   \n",
       "15             16         16         FS-1418876                FED   \n",
       "16             17         17         FS-1418878                FED   \n",
       "17             18         18         FS-1418881                FED   \n",
       "18             19         19         FS-1418884                FED   \n",
       "19             20         20         FS-1418887                FED   \n",
       "20             21         21         FS-1418888                FED   \n",
       "21             22         22         FS-1418893                FED   \n",
       "22             23         23         FS-1418894                FED   \n",
       "23             24         24         FS-1418895                FED   \n",
       "24             25         25         FS-1418896                FED   \n",
       "25             26         26         FS-1418897                FED   \n",
       "26             27         27         FS-1418898                FED   \n",
       "27             28         28         FS-1418903                FED   \n",
       "28             29         29         FS-1418904                FED   \n",
       "29             30         30         FS-1418905                FED   \n",
       "...           ...        ...                ...                ...   \n",
       "1880435   1880436  300348217  2015CAIRS28664200             NONFED   \n",
       "1880436   1880437  300348237  2015CAIRS26850166             NONFED   \n",
       "1880437   1880438  300348240  2015CAIRS27248589             NONFED   \n",
       "1880438   1880439  300348242  2015CAIRS29017324             NONFED   \n",
       "1880439   1880440  300348247  2015CAIRS27699480             NONFED   \n",
       "1880440   1880441  300348248  2015CAIRS28587133             NONFED   \n",
       "1880441   1880442  300348249  2015CAIRS29152556             NONFED   \n",
       "1880442   1880443  300348255  2015CAIRS26850725             NONFED   \n",
       "1880443   1880444  300348257  2015CAIRS28268055             NONFED   \n",
       "1880444   1880445  300348258  2015CAIRS28291406             NONFED   \n",
       "1880445   1880446  300348259  2015CAIRS27092196             NONFED   \n",
       "1880446   1880447  300348260  2015CAIRS29015247             NONFED   \n",
       "1880447   1880448  300348274  2015CAIRS26084391             NONFED   \n",
       "1880448   1880449  300348276  2015CAIRS27560317             NONFED   \n",
       "1880449   1880450  300348289  2015CAIRS28493610             NONFED   \n",
       "1880450   1880451  300348290  2015CAIRS27653046             NONFED   \n",
       "1880451   1880452  300348291  2015CAIRS27458005             NONFED   \n",
       "1880452   1880453  300348293  2015CAIRS27587395             NONFED   \n",
       "1880453   1880454  300348297  2015CAIRS28589435             NONFED   \n",
       "1880454   1880455  300348310  2015CAIRS28424493             NONFED   \n",
       "1880455   1880456  300348311  2015CAIRS27458827             NONFED   \n",
       "1880456   1880457  300348328  2015CAIRS27369138             NONFED   \n",
       "1880457   1880458  300348354  2015CAIRS28234594             NONFED   \n",
       "1880458   1880459  300348361  2015CAIRS27957490             NONFED   \n",
       "1880459   1880460  300348362  2015CAIRS28291374             NONFED   \n",
       "1880460   1880461  300348363  2015CAIRS29019636             NONFED   \n",
       "1880461   1880462  300348373  2015CAIRS29217935             NONFED   \n",
       "1880462   1880463  300348375  2015CAIRS28364460             NONFED   \n",
       "1880463   1880464  300348377  2015CAIRS29218079             NONFED   \n",
       "1880464   1880465  300348399  2015CAIRS26733926             NONFED   \n",
       "\n",
       "        SOURCE_SYSTEM NWCG_REPORTING_AGENCY NWCG_REPORTING_UNIT_ID  \\\n",
       "0         FS-FIRESTAT                    FS                USCAPNF   \n",
       "1         FS-FIRESTAT                    FS                USCAENF   \n",
       "2         FS-FIRESTAT                    FS                USCAENF   \n",
       "3         FS-FIRESTAT                    FS                USCAENF   \n",
       "4         FS-FIRESTAT                    FS                USCAENF   \n",
       "5         FS-FIRESTAT                    FS                USCAENF   \n",
       "6         FS-FIRESTAT                    FS                USCAENF   \n",
       "7         FS-FIRESTAT                    FS                USCASHF   \n",
       "8         FS-FIRESTAT                    FS                USCASHF   \n",
       "9         FS-FIRESTAT                    FS                USCAENF   \n",
       "10        FS-FIRESTAT                    FS                USCAENF   \n",
       "11        FS-FIRESTAT                    FS                USCAENF   \n",
       "12        FS-FIRESTAT                    FS                USCAENF   \n",
       "13        FS-FIRESTAT                    FS                USCAENF   \n",
       "14        FS-FIRESTAT                    FS                USCAENF   \n",
       "15        FS-FIRESTAT                    FS                USCAENF   \n",
       "16        FS-FIRESTAT                    FS                USCAENF   \n",
       "17        FS-FIRESTAT                    FS                USCAENF   \n",
       "18        FS-FIRESTAT                    FS                USCAENF   \n",
       "19        FS-FIRESTAT                    FS                USNMLNF   \n",
       "20        FS-FIRESTAT                    FS                USNMLNF   \n",
       "21        FS-FIRESTAT                    FS                USNMLNF   \n",
       "22        FS-FIRESTAT                    FS                USNMLNF   \n",
       "23        FS-FIRESTAT                    FS                USNMLNF   \n",
       "24        FS-FIRESTAT                    FS                USNMLNF   \n",
       "25        FS-FIRESTAT                    FS                USNMLNF   \n",
       "26        FS-FIRESTAT                    FS                USNMLNF   \n",
       "27        FS-FIRESTAT                    FS                USNMLNF   \n",
       "28        FS-FIRESTAT                    FS                USNMLNF   \n",
       "29        FS-FIRESTAT                    FS                USNMLNF   \n",
       "...               ...                   ...                    ...   \n",
       "1880435      ST-CACDF                ST/C&L                USCALNU   \n",
       "1880436      ST-CACDF                ST/C&L                USCANEU   \n",
       "1880437      ST-CACDF                ST/C&L                USCAHUU   \n",
       "1880438      ST-CACDF                ST/C&L                USCANEU   \n",
       "1880439      ST-CACDF                ST/C&L                USCAKRN   \n",
       "1880440      ST-CACDF                ST/C&L                USCALAC   \n",
       "1880441      ST-CACDF                ST/C&L                USCALAC   \n",
       "1880442      ST-CACDF                ST/C&L                USCACZU   \n",
       "1880443      ST-CACDF                ST/C&L                USCALMU   \n",
       "1880444      ST-CACDF                ST/C&L                USCASCU   \n",
       "1880445      ST-CACDF                ST/C&L                USCABDU   \n",
       "1880446      ST-CACDF                ST/C&L                USCABDU   \n",
       "1880447      ST-CACDF                ST/C&L                USCAMVU   \n",
       "1880448      ST-CACDF                ST/C&L                USCALMU   \n",
       "1880449      ST-CACDF                ST/C&L                USCAVNC   \n",
       "1880450      ST-CACDF                ST/C&L                USCASCU   \n",
       "1880451      ST-CACDF                ST/C&L                USCAAEU   \n",
       "1880452      ST-CACDF                ST/C&L                USCALAC   \n",
       "1880453      ST-CACDF                ST/C&L                USCALAC   \n",
       "1880454      ST-CACDF                ST/C&L                USCATCU   \n",
       "1880455      ST-CACDF                ST/C&L                USCATCU   \n",
       "1880456      ST-CACDF                ST/C&L                USCATGU   \n",
       "1880457      ST-CACDF                ST/C&L                USCASHU   \n",
       "1880458      ST-CACDF                ST/C&L                USCAHUU   \n",
       "1880459      ST-CACDF                ST/C&L                USCALNU   \n",
       "1880460      ST-CACDF                ST/C&L                USCASHU   \n",
       "1880461      ST-CACDF                ST/C&L                USCATCU   \n",
       "1880462      ST-CACDF                ST/C&L                USCATCU   \n",
       "1880463      ST-CACDF                ST/C&L                USCATCU   \n",
       "1880464      ST-CACDF                ST/C&L                USCABDU   \n",
       "\n",
       "                   NWCG_REPORTING_UNIT_NAME SOURCE_REPORTING_UNIT  \\\n",
       "0                    Plumas National Forest                  0511   \n",
       "1                  Eldorado National Forest                  0503   \n",
       "2                  Eldorado National Forest                  0503   \n",
       "3                  Eldorado National Forest                  0503   \n",
       "4                  Eldorado National Forest                  0503   \n",
       "5                  Eldorado National Forest                  0503   \n",
       "6                  Eldorado National Forest                  0503   \n",
       "7            Shasta-Trinity National Forest                  0514   \n",
       "8            Shasta-Trinity National Forest                  0514   \n",
       "9                  Eldorado National Forest                  0503   \n",
       "10                 Eldorado National Forest                  0503   \n",
       "11                 Eldorado National Forest                  0503   \n",
       "12                 Eldorado National Forest                  0503   \n",
       "13                 Eldorado National Forest                  0503   \n",
       "14                 Eldorado National Forest                  0503   \n",
       "15                 Eldorado National Forest                  0503   \n",
       "16                 Eldorado National Forest                  0503   \n",
       "17                 Eldorado National Forest                  0503   \n",
       "18                 Eldorado National Forest                  0503   \n",
       "19                  Lincoln National Forest                  0308   \n",
       "20                  Lincoln National Forest                  0308   \n",
       "21                  Lincoln National Forest                  0308   \n",
       "22                  Lincoln National Forest                  0308   \n",
       "23                  Lincoln National Forest                  0308   \n",
       "24                  Lincoln National Forest                  0308   \n",
       "25                  Lincoln National Forest                  0308   \n",
       "26                  Lincoln National Forest                  0308   \n",
       "27                  Lincoln National Forest                  0308   \n",
       "28                  Lincoln National Forest                  0308   \n",
       "29                  Lincoln National Forest                  0308   \n",
       "...                                     ...                   ...   \n",
       "1880435               Sonoma-Lake Napa Unit                 CALNU   \n",
       "1880436             Nevada-Yuba-Placer Unit                 CANEU   \n",
       "1880437             Humboldt-Del Norte Unit                 CAHUU   \n",
       "1880438             Nevada-Yuba-Placer Unit                 CANEU   \n",
       "1880439         Kern County Fire Department                 CAKRN   \n",
       "1880440  Los Angeles County Fire Department                 CALAC   \n",
       "1880441  Los Angeles County Fire Department                 CALAC   \n",
       "1880442           San Mateo-Santa Cruz Unit                 CACZU   \n",
       "1880443                   Lassen-Modoc Unit                 CALMU   \n",
       "1880444                    Santa Clara Unit                 CASCU   \n",
       "1880445                 San Bernardino Unit                 CABDU   \n",
       "1880446                 San Bernardino Unit                 CABDU   \n",
       "1880447                    Monte Vista Unit                 CAMVU   \n",
       "1880448                   Lassen-Modoc Unit                 CALMU   \n",
       "1880449      Ventura County Fire Department                 CAVNC   \n",
       "1880450                    Santa Clara Unit                 CASCU   \n",
       "1880451               Amador-El Dorado Unit                 CAAEU   \n",
       "1880452  Los Angeles County Fire Department                 CALAC   \n",
       "1880453  Los Angeles County Fire Department                 CALAC   \n",
       "1880454             Tuolumne-Calaveras Unit                 CATCU   \n",
       "1880455             Tuolumne-Calaveras Unit                 CATCU   \n",
       "1880456                   Tehama-Glenn Unit                 CATGU   \n",
       "1880457                 Shasta-Trinity Unit                 CASHU   \n",
       "1880458             Humboldt-Del Norte Unit                 CAHUU   \n",
       "1880459               Sonoma-Lake Napa Unit                 CALNU   \n",
       "1880460                 Shasta-Trinity Unit                 CASHU   \n",
       "1880461             Tuolumne-Calaveras Unit                 CATCU   \n",
       "1880462             Tuolumne-Calaveras Unit                 CATCU   \n",
       "1880463             Tuolumne-Calaveras Unit                 CATCU   \n",
       "1880464                 San Bernardino Unit                 CABDU   \n",
       "\n",
       "                 SOURCE_REPORTING_UNIT_NAME  ...   LATITUDE   LONGITUDE  \\\n",
       "0                    Plumas National Forest  ...  40.036944 -121.005833   \n",
       "1                  Eldorado National Forest  ...  38.933056 -120.404444   \n",
       "2                  Eldorado National Forest  ...  38.984167 -120.735556   \n",
       "3                  Eldorado National Forest  ...  38.559167 -119.913333   \n",
       "4                  Eldorado National Forest  ...  38.559167 -119.933056   \n",
       "5                  Eldorado National Forest  ...  38.635278 -120.103611   \n",
       "6                  Eldorado National Forest  ...  38.688333 -120.153333   \n",
       "7            Shasta-Trinity National Forest  ...  40.968056 -122.433889   \n",
       "8            Shasta-Trinity National Forest  ...  41.233611 -122.283333   \n",
       "9                  Eldorado National Forest  ...  38.548333 -120.149167   \n",
       "10                 Eldorado National Forest  ...  38.691667 -120.159722   \n",
       "11                 Eldorado National Forest  ...  38.527500 -120.106111   \n",
       "12                 Eldorado National Forest  ...  38.786667 -120.193333   \n",
       "13                 Eldorado National Forest  ...  38.433333 -120.510000   \n",
       "14                 Eldorado National Forest  ...  38.675833 -120.279722   \n",
       "15                 Eldorado National Forest  ...  38.564167 -120.542222   \n",
       "16                 Eldorado National Forest  ...  38.523333 -120.211667   \n",
       "17                 Eldorado National Forest  ...  38.780000 -120.260000   \n",
       "18                 Eldorado National Forest  ...  38.945000 -120.411667   \n",
       "19                  Lincoln National Forest  ...  33.440833 -105.720556   \n",
       "20                  Lincoln National Forest  ...  33.307222 -105.628611   \n",
       "21                  Lincoln National Forest  ...  33.444444 -105.768056   \n",
       "22                  Lincoln National Forest  ...  33.559444 -105.766111   \n",
       "23                  Lincoln National Forest  ...  33.308056 -105.526111   \n",
       "24                  Lincoln National Forest  ...  33.545278 -105.229444   \n",
       "25                  Lincoln National Forest  ...  33.315833 -105.512222   \n",
       "26                  Lincoln National Forest  ...  33.444444 -105.631111   \n",
       "27                  Lincoln National Forest  ...  33.368056 -105.507222   \n",
       "28                  Lincoln National Forest  ...  33.385278 -105.638611   \n",
       "29                  Lincoln National Forest  ...  33.382778 -105.700278   \n",
       "...                                     ...  ...        ...         ...   \n",
       "1880435               Sonoma-Lake Napa Unit  ...  38.159780 -122.451750   \n",
       "1880436             Nevada-Yuba-Placer Unit  ...  39.143821 -121.036533   \n",
       "1880437             Humboldt-Del Norte Unit  ...  41.224483 -123.763317   \n",
       "1880438             Nevada-Yuba-Placer Unit  ...  39.005712 -121.260759   \n",
       "1880439         Kern County Fire Department  ...  34.933333 -118.883333   \n",
       "1880440  Los Angeles County Fire Department  ...  34.716666 -118.800000   \n",
       "1880441  Los Angeles County Fire Department  ...  34.450000 -118.583333   \n",
       "1880442           San Mateo-Santa Cruz Unit  ...  37.090126 -122.074684   \n",
       "1880443                   Lassen-Modoc Unit  ...  40.297000 -120.528000   \n",
       "1880444                    Santa Clara Unit  ...  37.701111 -122.021111   \n",
       "1880445           CDF - San Bernardino Unit  ...  37.361417 -118.465150   \n",
       "1880446           CDF - San Bernardino Unit  ...  34.244444 -116.658889   \n",
       "1880447              CDF - Monte Vista Unit  ...  32.576754 -116.627539   \n",
       "1880448                   Lassen-Modoc Unit  ...  40.443000 -120.664433   \n",
       "1880449      Ventura County Fire Department  ...  34.666666 -119.333333   \n",
       "1880450                    Santa Clara Unit  ...  38.041150 -121.985283   \n",
       "1880451               Amador-El Dorado Unit  ...  38.644183 -120.863673   \n",
       "1880452  Los Angeles County Fire Department  ...  34.163117 -118.693303   \n",
       "1880453  Los Angeles County Fire Department  ...  34.278180 -118.621180   \n",
       "1880454             Tuolumne-Calaveras Unit  ...  38.048577 -120.313090   \n",
       "1880455             Tuolumne-Calaveras Unit  ...  37.936253 -120.613743   \n",
       "1880456                   Tehama-Glenn Unit  ...  40.019907 -122.391398   \n",
       "1880457                 Shasta-Trinity Unit  ...  40.588583 -123.069617   \n",
       "1880458             Humboldt-Del Norte Unit  ...  40.244833 -123.544167   \n",
       "1880459               Sonoma-Lake Napa Unit  ...  38.415608 -122.660044   \n",
       "1880460                 Shasta-Trinity Unit  ...  40.481637 -122.389375   \n",
       "1880461             Tuolumne-Calaveras Unit  ...  37.617619 -120.938570   \n",
       "1880462             Tuolumne-Calaveras Unit  ...  37.617619 -120.938570   \n",
       "1880463             Tuolumne-Calaveras Unit  ...  37.672235 -120.898356   \n",
       "1880464           CDF - San Bernardino Unit  ...  34.263217 -116.830950   \n",
       "\n",
       "        OWNER_CODE            OWNER_DESCR STATE COUNTY FIPS_CODE  FIPS_NAME  \\\n",
       "0              5.0                   USFS    CA     63       063     Plumas   \n",
       "1              5.0                   USFS    CA     61       061     Placer   \n",
       "2             13.0       STATE OR PRIVATE    CA     17       017  El Dorado   \n",
       "3              5.0                   USFS    CA      3       003     Alpine   \n",
       "4              5.0                   USFS    CA      3       003     Alpine   \n",
       "5              5.0                   USFS    CA      5       005     Amador   \n",
       "6              5.0                   USFS    CA     17       017  El Dorado   \n",
       "7             13.0       STATE OR PRIVATE    CA   None      None       None   \n",
       "8             13.0       STATE OR PRIVATE    CA   None      None       None   \n",
       "9              5.0                   USFS    CA      5       005     Amador   \n",
       "10             5.0                   USFS    CA     17       017  El Dorado   \n",
       "11             5.0                   USFS    CA      5       005     Amador   \n",
       "12             5.0                   USFS    CA     17       017  El Dorado   \n",
       "13            14.0  MISSING/NOT SPECIFIED    CA      5       005     Amador   \n",
       "14             5.0                   USFS    CA     17       017  El Dorado   \n",
       "15             5.0                   USFS    CA     17       017  El Dorado   \n",
       "16             5.0                   USFS    CA      5       005     Amador   \n",
       "17             5.0                   USFS    CA     17       017  El Dorado   \n",
       "18            13.0       STATE OR PRIVATE    CA     17       017  El Dorado   \n",
       "19             5.0                   USFS    NM     27       027    Lincoln   \n",
       "20            13.0       STATE OR PRIVATE    NM     27       027    Lincoln   \n",
       "21             5.0                   USFS    NM     27       027    Lincoln   \n",
       "22             5.0                   USFS    NM     27       027    Lincoln   \n",
       "23             5.0                   USFS    NM     27       027    Lincoln   \n",
       "24             5.0                   USFS    NM     27       027    Lincoln   \n",
       "25             5.0                   USFS    NM     27       027    Lincoln   \n",
       "26            14.0  MISSING/NOT SPECIFIED    NM     27       027    Lincoln   \n",
       "27             5.0                   USFS    NM     27       027    Lincoln   \n",
       "28             5.0                   USFS    NM     27       027    Lincoln   \n",
       "29             5.0                   USFS    NM     27       027    Lincoln   \n",
       "...            ...                    ...   ...    ...       ...        ...   \n",
       "1880435       13.0       STATE OR PRIVATE    CA   None      None       None   \n",
       "1880436       13.0       STATE OR PRIVATE    CA   None      None       None   \n",
       "1880437       13.0       STATE OR PRIVATE    CA   None      None       None   \n",
       "1880438       13.0       STATE OR PRIVATE    CA   None      None       None   \n",
       "1880439       13.0       STATE OR PRIVATE    CA   None      None       None   \n",
       "1880440       13.0       STATE OR PRIVATE    CA   None      None       None   \n",
       "1880441       13.0       STATE OR PRIVATE    CA   None      None       None   \n",
       "1880442       13.0       STATE OR PRIVATE    CA   None      None       None   \n",
       "1880443       13.0       STATE OR PRIVATE    CA   None      None       None   \n",
       "1880444       13.0       STATE OR PRIVATE    CA   None      None       None   \n",
       "1880445       13.0       STATE OR PRIVATE    CA   None      None       None   \n",
       "1880446       15.0      UNDEFINED FEDERAL    CA   None      None       None   \n",
       "1880447       13.0       STATE OR PRIVATE    CA   None      None       None   \n",
       "1880448       13.0       STATE OR PRIVATE    CA   None      None       None   \n",
       "1880449       15.0      UNDEFINED FEDERAL    CA   None      None       None   \n",
       "1880450       15.0      UNDEFINED FEDERAL    CA   None      None       None   \n",
       "1880451       13.0       STATE OR PRIVATE    CA   None      None       None   \n",
       "1880452       13.0       STATE OR PRIVATE    CA   None      None       None   \n",
       "1880453       13.0       STATE OR PRIVATE    CA   None      None       None   \n",
       "1880454       13.0       STATE OR PRIVATE    CA   None      None       None   \n",
       "1880455       13.0       STATE OR PRIVATE    CA   None      None       None   \n",
       "1880456       13.0       STATE OR PRIVATE    CA   None      None       None   \n",
       "1880457       13.0       STATE OR PRIVATE    CA   None      None       None   \n",
       "1880458       15.0      UNDEFINED FEDERAL    CA   None      None       None   \n",
       "1880459       13.0       STATE OR PRIVATE    CA   None      None       None   \n",
       "1880460       13.0       STATE OR PRIVATE    CA   None      None       None   \n",
       "1880461       12.0        MUNICIPAL/LOCAL    CA   None      None       None   \n",
       "1880462       12.0        MUNICIPAL/LOCAL    CA   None      None       None   \n",
       "1880463       12.0        MUNICIPAL/LOCAL    CA   None      None       None   \n",
       "1880464       13.0       STATE OR PRIVATE    CA   None      None       None   \n",
       "\n",
       "                                                     Shape  DISCOVERY_DATETIME  \n",
       "0        b'\\x00\\x01\\xad\\x10\\x00\\x00\\xe8d\\xc2\\x92_@^\\xc0... 2005-02-02 13:00:00  \n",
       "1        b'\\x00\\x01\\xad\\x10\\x00\\x00T\\xb6\\xeej\\xe2\\x19^\\... 2004-05-12 08:45:00  \n",
       "2        b'\\x00\\x01\\xad\\x10\\x00\\x00\\xd0\\xa5\\xa0W\\x13/^\\... 2004-05-31 19:21:00  \n",
       "3        b'\\x00\\x01\\xad\\x10\\x00\\x00\\x94\\xac\\xa3\\rt\\xfa]... 2004-06-28 16:00:00  \n",
       "4        b'\\x00\\x01\\xad\\x10\\x00\\x00@\\xe3\\xaa.\\xb7\\xfb]\\... 2004-06-28 16:00:00  \n",
       "5        b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf0<~\\x90\\xa1\\x06^\\... 2004-06-30 18:00:00  \n",
       "6        b'\\x00\\x01\\xad\\x10\\x00\\x00$o\\x996\\xd0\\t^\\xc0h\\... 2004-07-01 18:00:00  \n",
       "7        b'\\x00\\x01\\xad\\x10\\x00\\x00t)\\xe8\\xd5\\xc4\\x9b^\\... 2005-03-08 13:00:00  \n",
       "8        b'\\x00\\x01\\xad\\x10\\x00\\x00\\xdc\\x8d\\x1e\"\"\\x92^\\... 2005-03-15 12:00:00  \n",
       "9        b'\\x00\\x01\\xad\\x10\\x00\\x00dS\\\\\\xf2\\x8b\\t^\\xc0\\... 2004-07-01 18:00:00  \n",
       "10       b'\\x00\\x01\\xad\\x10\\x00\\x00\\x0c\\xd6\\x8b\\xe38\\n^... 2004-07-02 18:30:00  \n",
       "11       b'\\x00\\x01\\xad\\x10\\x00\\x00L\\xcc@\\x86\\xca\\x06^\\... 2004-07-02 17:30:00  \n",
       "12       b'\\x00\\x01\\xad\\x10\\x00\\x00\\xe8d\\xc2\\x92_\\x0c^\\... 2004-09-03 16:00:00  \n",
       "13       b'\\x00\\x01\\xad\\x10\\x00\\x00p=\\n\\xd7\\xa3 ^\\xc0\\x... 2004-09-28 12:00:00  \n",
       "14       b'\\x00\\x01\\xad\\x10\\x00\\x00P\\xb7\\x06\\xf8\\xe6\\x1... 2004-10-03 06:30:00  \n",
       "15       b'\\x00\\x01\\xad\\x10\\x00\\x00 \\x84\\xd3\\xc4\\xb3\"^\\... 2004-10-03 09:30:00  \n",
       "16       b'\\x00\\x01\\xad\\x10\\x00\\x00dS\\\\\\xf2\\x8b\\r^\\xc0\\... 2004-10-06 14:15:00  \n",
       "17       b'\\x00\\x01\\xad\\x10\\x00\\x00p=\\n\\xd7\\xa3\\x10^\\xc... 2004-10-13 16:18:00  \n",
       "18       b'\\x00\\x01\\xad\\x10\\x00\\x004 )\\xbfX\\x1a^\\xc00\\\\... 2004-11-20 20:00:00  \n",
       "19       b'\\x00\\x01\\xad\\x10\\x00\\x00\\xa8I\\x11\\x95\\x1dnZ\\... 2004-06-04 10:30:00  \n",
       "20       b'\\x00\\x01\\xad\\x10\\x00\\x00\\x88\\xd6\\x17*;hZ\\xc0... 2004-06-19 15:30:00  \n",
       "21       b\"\\x00\\x01\\xad\\x10\\x00\\x00|\\xed\\x81\\xd2'qZ\\xc0... 2004-06-21 14:40:00  \n",
       "22       b'\\x00\\x01\\xad\\x10\\x00\\x00T\\xa3\\xe4\\xf6\\x07qZ\\... 2004-06-25 19:10:00  \n",
       "23       b'\\x00\\x01\\xad\\x10\\x00\\x00\\xc8\\xe0\\xee\\xcd\\xab... 2004-07-01 12:50:00  \n",
       "24       b'\\x00\\x01\\xad\\x10\\x00\\x00 \\x83\\xbb7\\xafNZ\\xc0... 2004-07-01 17:12:00  \n",
       "25       b'\\x00\\x01\\xad\\x10\\x00\\x00\\xcc\\xcb\\xb4?\\xc8`Z\\... 2004-07-20 14:05:00  \n",
       "26       b'\\x00\\x01\\xad\\x10\\x00\\x00\\xe4e\\xda\\x1fdhZ\\xc0... 2004-03-18 11:45:00  \n",
       "27       b'\\x00\\x01\\xad\\x10\\x00\\x00\\x14\\xad/Tv`Z\\xc0\\xd... 2004-08-05 09:45:00  \n",
       "28       b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf8\\x13\"\\x01\\xdfhZ\\... 2004-03-18 16:55:00  \n",
       "29       b'\\x00\\x01\\xad\\x10\\x00\\x00\\xc8\\xcd\\xe4Y\\xd1lZ\\... 2004-05-11 15:15:00  \n",
       "...                                                    ...                 ...  \n",
       "1880435  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf0\\xfd\\xd4x\\xe9\\x9... 2015-06-28 12:02:00  \n",
       "1880436  b'\\x00\\x01\\xad\\x10\\x00\\x00`\\x0e\\x82\\x8eVB^\\xc0... 2015-03-21 11:38:00  \n",
       "1880437  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xc4\\xde\\x8b/\\xda\\xf... 2015-05-11 16:45:00  \n",
       "1880438  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xccH\\x84F\\xb0P^\\xc0... 2015-09-26 16:25:00  \n",
       "1880439  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x90\\x9e\"\\x87\\x88\\xb... 2015-01-27 12:00:00  \n",
       "1880440  b'\\x00\\x01\\xad\\x10\\x00\\x0003333\\xb3]\\xc0\\xe0\\x... 2015-07-04 23:11:00  \n",
       "1880441  b'\\x00\\x01\\xad\\x10\\x00\\x00\\\\k\\xefSU\\xa5]\\xc0\\x... 2015-12-07 15:12:00  \n",
       "1880442  b'\\x00\\x01\\xad\\x10\\x00\\x004bf\\x9f\\xc7\\x84^\\xc0... 2015-03-28 16:56:00  \n",
       "1880443  b'\\x00\\x01\\xad\\x10\\x00\\x00l\\x12\\x83\\xc0\\xca!^\\... 2015-09-27 05:36:00  \n",
       "1880444  b'\\x00\\x01\\xad\\x10\\x00\\x00|\\xa5\\xf3\\xe1Y\\x81^\\... 2015-10-30 15:45:00  \n",
       "1880445  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x00o\\x81\\x04\\xc5\\x9... 2015-02-22 12:33:00  \n",
       "1880446  b'\\x00\\x01\\xad\\x10\\x00\\x00l\\xac\\xc4<+*]\\xc0\\x1... 2015-07-25 19:43:00  \n",
       "1880447  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xb8}V\\x99)(]\\xc00\\x... 2015-01-28 00:41:00  \n",
       "1880448  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x84X\\xfd\\x11\\x86*^\\... 2015-06-26 17:52:00  \n",
       "1880449  b'\\x00\\x01\\xad\\x10\\x00\\x00\\\\k\\xefSU\\xd5]\\xc0\\x... 2015-08-27 17:37:00  \n",
       "1880450  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x80\\x93m\\xe0\\x0e\\x7... 2015-06-27 03:37:00  \n",
       "1880451  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x08\\\\\\x1ekF7^\\xc0\\x... 2015-06-06 12:08:00  \n",
       "1880452  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf0A\\t\\x12_\\xac]\\xc... 2015-04-14 08:27:00  \n",
       "1880453  b'\\x00\\x01\\xad\\x10\\x00\\x00h\\x0c\\xdfg\\xc1\\xa7]\\... 2015-07-07 07:23:00  \n",
       "1880454  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x18\\xad\\xa3\\xaa\\t\\x... 2015-09-12 06:38:00  \n",
       "1880455  b\"\\x00\\x01\\xad\\x10\\x00\\x00\\x84I\\xb8\\x90G'^\\xc0... 2015-06-28 20:42:00  \n",
       "1880456  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x10n2\\xaa\\x0c\\x99^\\... 2015-06-14 17:14:00  \n",
       "1880457  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xb8\\x8f\\xdc\\x9at\\xc... 2015-09-30 23:57:00  \n",
       "1880458  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xfc#\\xd3\\xa1\\xd3\\xe... 2015-08-01 13:31:00  \n",
       "1880459  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xf0z0)>\\xaa^\\xc0h\\x... 2015-05-28 14:20:00  \n",
       "1880460  b'\\x00\\x01\\xad\\x10\\x00\\x00P\\xb8\\x1e\\x85\\xeb\\x9... 2015-09-26 17:26:00  \n",
       "1880461  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x00\\x80\\xbe\\x88\\x11... 2015-10-05 01:26:00  \n",
       "1880462  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x00\\x80\\xbe\\x88\\x11... 2015-05-02 20:52:00  \n",
       "1880463  b'\\x00\\x01\\xad\\x10\\x00\\x00x\\xba_\\xaa~9^\\xc0\\xb... 2015-10-14 23:09:00  \n",
       "1880464  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x1c\\xa7\\xe8H.5]\\xc0... 2015-03-14 21:28:00  \n",
       "\n",
       "[997827 rows x 40 columns]"
      ]
     },
     "execution_count": 199,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 208,
   "metadata": {},
   "outputs": [],
   "source": [
    "X = df[['DISCOVERY_DATETIME', 'STATE']]\n",
    "y = df['FIRE_SIZE_CLASS']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 209,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    A\n",
       "1    A\n",
       "2    A\n",
       "3    A\n",
       "4    A\n",
       "Name: FIRE_SIZE_CLASS, dtype: object"
      ]
     },
     "execution_count": 209,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "y.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 210,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Encode the motnhs and the states ordinally.\n",
    "enc = OrdinalEncoder()\n",
    "st =  enc.fit_transform(np.array(X['STATE']).reshape(-1,1))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 211,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Applications/anaconda3/lib/python3.6/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    }
   ],
   "source": [
    "X['STATE'] = pd.DataFrame(st);\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 212,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Applications/anaconda3/lib/python3.6/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    }
   ],
   "source": [
    "X['DISCOVERY_DATETIME'] = X['DISCOVERY_DATETIME'].apply(lambda x: x.month)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 213,
   "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>DISCOVERY_DATETIME</th>\n",
       "      <th>STATE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>6</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>6</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   DISCOVERY_DATETIME  STATE\n",
       "0                   2    4.0\n",
       "1                   5    4.0\n",
       "2                   5    4.0\n",
       "3                   6    4.0\n",
       "4                   6    4.0"
      ]
     },
     "execution_count": 213,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "X.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 214,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['A', 'B', 'C', 'D', 'E', 'F', 'G'], dtype=object)"
      ]
     },
     "execution_count": 214,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Different types of classes.\n",
    "np.unique(y.values)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 215,
   "metadata": {},
   "outputs": [],
   "source": [
    "#As to size of wildfire:\n",
    "#Class A - one-fourth acre or less;\n",
    "#Class B - more than one-fourth acre, but less than 10 acres;\n",
    "#Class C - 10 acres or more, but less than 100 acres;\n",
    "#Class D - 100 acres or more, but less than 300 acres;\n",
    "##Class E - 300 acres or more, but less than 1,000 acres;\n",
    "#Class F - 1,000 acres or more, but less than 5,000 acres;\n",
    "#Class G - 5,000 acres or more.\n",
    "#https://www.nwcg.gov/term/glossary/size-class-of-fire#:~:text=As%20to%20size%20of%20wildfire,one%2Dfourth%20acre%20or%20less%3B&text=Class%20G%20%2D%205%2C000%20acres%20or%20more."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 216,
   "metadata": {},
   "outputs": [],
   "source": [
    "di = {\"A\": 1, \"B\": 2, \"C\": 3, \"D\": 4, \"E\": 5, \"F\": 6, \"G\": 7}\n",
    "y = y.map(di)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 217,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    1\n",
       "1    1\n",
       "2    1\n",
       "3    1\n",
       "4    1\n",
       "Name: FIRE_SIZE_CLASS, dtype: int64"
      ]
     },
     "execution_count": 217,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "y.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 218,
   "metadata": {},
   "outputs": [],
   "source": [
    "X.to_pickle('wildfire_area_encoded_data.pkl')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 219,
   "metadata": {},
   "outputs": [],
   "source": [
    "y.to_pickle('wildfire_area_encoded_labels.pkl')"
   ]
  },
  {
   "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.6.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}