calc_cont_time.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Some exploratory work on the dataset.  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import sqlite3\n",
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(20000, 40)"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Take a look at all the fires.  This may take some time.\n",
    "df = pd.read_csv('20k_data.csv')\n",
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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>FIRE_SIZE_CLASS</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1026201</td>\n",
       "      <td>1026202</td>\n",
       "      <td>1155826</td>\n",
       "      <td>TFS_NC_204819</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-NCNCS</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USNCNCS</td>\n",
       "      <td>North Carolina Forest Service</td>\n",
       "      <td>NCNCS312</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>35.565000</td>\n",
       "      <td>-81.175000</td>\n",
       "      <td>14.0</td>\n",
       "      <td>MISSING/NOT SPECIFIED</td>\n",
       "      <td>NC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x0003333KT\\xc0\\xc0\\x1e\\...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>980661</td>\n",
       "      <td>980662</td>\n",
       "      <td>1109412</td>\n",
       "      <td>TFS_FL_64661</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-FLFLS</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USFLFLS</td>\n",
       "      <td>Florida Forest Service</td>\n",
       "      <td>FLFLS16</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>27.240000</td>\n",
       "      <td>-80.280000</td>\n",
       "      <td>14.0</td>\n",
       "      <td>MISSING/NOT SPECIFIED</td>\n",
       "      <td>FL</td>\n",
       "      <td>Martin</td>\n",
       "      <td>85.0</td>\n",
       "      <td>Martin</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00P\\xb8\\x1e\\x85\\xeb\\x1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>676917</td>\n",
       "      <td>676918</td>\n",
       "      <td>739922</td>\n",
       "      <td>SFO-WI058402192</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-NASF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USWIWIS</td>\n",
       "      <td>Wisconsin Department of Natural Resources</td>\n",
       "      <td>WI Woodruff</td>\n",
       "      <td>...</td>\n",
       "      <td>A</td>\n",
       "      <td>45.593872</td>\n",
       "      <td>-89.263800</td>\n",
       "      <td>14.0</td>\n",
       "      <td>MISSING/NOT SPECIFIED</td>\n",
       "      <td>WI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x08\\xcc\\xf9\\x18\\xe2...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1405562</td>\n",
       "      <td>1405563</td>\n",
       "      <td>19101556</td>\n",
       "      <td>SFO-GA-EAR-16-9/29/1993-1730</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-GAGAS</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USGAGAS</td>\n",
       "      <td>Georgia Forestry Commission</td>\n",
       "      <td>GAGAS</td>\n",
       "      <td>...</td>\n",
       "      <td>B</td>\n",
       "      <td>31.258900</td>\n",
       "      <td>-84.815600</td>\n",
       "      <td>14.0</td>\n",
       "      <td>MISSING/NOT SPECIFIED</td>\n",
       "      <td>GA</td>\n",
       "      <td>Early</td>\n",
       "      <td>99.0</td>\n",
       "      <td>Early</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x84\\xa7W\\xca24U\\xc0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1568120</td>\n",
       "      <td>1568121</td>\n",
       "      <td>201434414</td>\n",
       "      <td>FS-1502869</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>...</td>\n",
       "      <td>B</td>\n",
       "      <td>39.800278</td>\n",
       "      <td>-120.503056</td>\n",
       "      <td>14.0</td>\n",
       "      <td>MISSING/NOT SPECIFIED</td>\n",
       "      <td>CA</td>\n",
       "      <td>063</td>\n",
       "      <td>63.0</td>\n",
       "      <td>Plumas</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00T\\x91\\xf2\\x0f2 ^\\xc0...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 40 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0  OBJECTID     FOD_ID                        FPA_ID  \\\n",
       "0     1026201   1026202    1155826                 TFS_NC_204819   \n",
       "1      980661    980662    1109412                  TFS_FL_64661   \n",
       "2      676917    676918     739922               SFO-WI058402192   \n",
       "3     1405562   1405563   19101556  SFO-GA-EAR-16-9/29/1993-1730   \n",
       "4     1568120   1568121  201434414                    FS-1502869   \n",
       "\n",
       "  SOURCE_SYSTEM_TYPE SOURCE_SYSTEM NWCG_REPORTING_AGENCY  \\\n",
       "0             NONFED      ST-NCNCS                ST/C&L   \n",
       "1             NONFED      ST-FLFLS                ST/C&L   \n",
       "2             NONFED       ST-NASF                ST/C&L   \n",
       "3             NONFED      ST-GAGAS                ST/C&L   \n",
       "4                FED   FS-FIRESTAT                    FS   \n",
       "\n",
       "  NWCG_REPORTING_UNIT_ID                   NWCG_REPORTING_UNIT_NAME  \\\n",
       "0                USNCNCS              North Carolina Forest Service   \n",
       "1                USFLFLS                     Florida Forest Service   \n",
       "2                USWIWIS  Wisconsin Department of Natural Resources   \n",
       "3                USGAGAS                Georgia Forestry Commission   \n",
       "4                USCAPNF                     Plumas National Forest   \n",
       "\n",
       "  SOURCE_REPORTING_UNIT  ... FIRE_SIZE_CLASS   LATITUDE   LONGITUDE  \\\n",
       "0              NCNCS312  ...               A  35.565000  -81.175000   \n",
       "1               FLFLS16  ...               B  27.240000  -80.280000   \n",
       "2           WI Woodruff  ...               A  45.593872  -89.263800   \n",
       "3                 GAGAS  ...               B  31.258900  -84.815600   \n",
       "4                  0511  ...               B  39.800278 -120.503056   \n",
       "\n",
       "  OWNER_CODE            OWNER_DESCR STATE                COUNTY FIPS_CODE  \\\n",
       "0       14.0  MISSING/NOT SPECIFIED    NC                   NaN       NaN   \n",
       "1       14.0  MISSING/NOT SPECIFIED    FL                Martin      85.0   \n",
       "2       14.0  MISSING/NOT SPECIFIED    WI                   NaN       NaN   \n",
       "3       14.0  MISSING/NOT SPECIFIED    GA  Early                     99.0   \n",
       "4       14.0  MISSING/NOT SPECIFIED    CA                   063      63.0   \n",
       "\n",
       "  FIPS_NAME                                              Shape  \n",
       "0       NaN  b'\\x00\\x01\\xad\\x10\\x00\\x0003333KT\\xc0\\xc0\\x1e\\...  \n",
       "1    Martin  b'\\x00\\x01\\xad\\x10\\x00\\x00P\\xb8\\x1e\\x85\\xeb\\x1...  \n",
       "2       NaN  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x08\\xcc\\xf9\\x18\\xe2...  \n",
       "3     Early  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x84\\xa7W\\xca24U\\xc0...  \n",
       "4    Plumas  b'\\x00\\x01\\xad\\x10\\x00\\x00T\\x91\\xf2\\x0f2 ^\\xc0...  \n",
       "\n",
       "[5 rows x 40 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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'], dtype=object)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns.values"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Removing rows where discovery time and containment time are BOTH missing. However, this cuts the dataset in almost half. Better to use a technique to fill these NA values (either make a model to predict correct values, or stuff in the average as filler)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "# relevant columns to be able to compute time to containment\n",
    "time_cols = ['DISCOVERY_TIME', 'CONT_TIME', 'DISCOVERY_DATE', 'CONT_DATE']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(9560, 40)"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df.dropna(subset=time_cols) # remove rows where both of these are missing\n",
    "df.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "For some reason the dates are not in the mm/dd/yyyy format as the kaggle thing claims.\n",
    "According to: https://www.kaggle.com/rtatman/188-million-us-wildfires/discussion/39627 the dates are instead formatted in 'Julian time'. So these will need to be converted.\n",
    "\n",
    "Supposedly in the SQL query you can select the dates appropriately using: `SELECT datetime(DISCOVERY_DATE) as DISCOVERY_DATE from Fires` which may automatically convert these into a better format (like mm/dd/yyyy)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2440587.5"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from datetime import datetime\n",
    "\n",
    "# assign this globally so make_time() can use this without recalculating each call\n",
    "epoch = pd.to_datetime(0, unit='s').to_julian_date()\n",
    "epoch"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "# convert the 4 columns in time_cols into datetime objects\n",
    "# then calculate the timedelta \n",
    "def make_time(row):\n",
    "    # pad leading 0s to front of time so 438 = 0438, etc\n",
    "    disc_time = str(row['DISCOVERY_TIME']).zfill(4)\n",
    "    disc_time = datetime.strptime(disc_time, '%H%M.%S').time()\n",
    "    cont_time = str(row['CONT_TIME']).zfill(4)\n",
    "    cont_time = datetime.strptime(cont_time, '%H%M.%S').time()\n",
    "    # dates are formatted as Julian, convert to datetime\n",
    "    disc_date = pd.to_datetime(row['DISCOVERY_DATE'] - epoch, unit='D')\n",
    "    cont_date = pd.to_datetime(row['CONT_DATE'] - epoch, unit='D')\n",
    "    # combine the time and the date\n",
    "    disc = datetime.combine(disc_date, disc_time)\n",
    "    cont = datetime.combine(cont_date, cont_time)\n",
    "    delta = cont-disc \n",
    "    return delta\n",
    "\n",
    "df['TIME_TO_CONT'] = df.apply(lambda row: make_time(row), axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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>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>TIME_TO_CONT</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1405562</td>\n",
       "      <td>1405563</td>\n",
       "      <td>19101556</td>\n",
       "      <td>SFO-GA-EAR-16-9/29/1993-1730</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-GAGAS</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USGAGAS</td>\n",
       "      <td>Georgia Forestry Commission</td>\n",
       "      <td>GAGAS</td>\n",
       "      <td>...</td>\n",
       "      <td>31.258900</td>\n",
       "      <td>-84.815600</td>\n",
       "      <td>14.0</td>\n",
       "      <td>MISSING/NOT SPECIFIED</td>\n",
       "      <td>GA</td>\n",
       "      <td>Early</td>\n",
       "      <td>99.0</td>\n",
       "      <td>Early</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\x84\\xa7W\\xca24U\\xc0...</td>\n",
       "      <td>00:43:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1568120</td>\n",
       "      <td>1568121</td>\n",
       "      <td>201434414</td>\n",
       "      <td>FS-1502869</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>...</td>\n",
       "      <td>39.800278</td>\n",
       "      <td>-120.503056</td>\n",
       "      <td>14.0</td>\n",
       "      <td>MISSING/NOT SPECIFIED</td>\n",
       "      <td>CA</td>\n",
       "      <td>063</td>\n",
       "      <td>63.0</td>\n",
       "      <td>Plumas</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00T\\x91\\xf2\\x0f2 ^\\xc0...</td>\n",
       "      <td>02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1060555</td>\n",
       "      <td>1060556</td>\n",
       "      <td>1272887</td>\n",
       "      <td>FS-368027</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USCABDF</td>\n",
       "      <td>San Bernardino National Forest</td>\n",
       "      <td>0512</td>\n",
       "      <td>...</td>\n",
       "      <td>34.207500</td>\n",
       "      <td>-117.270000</td>\n",
       "      <td>13.0</td>\n",
       "      <td>STATE OR PRIVATE</td>\n",
       "      <td>CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xe0z\\x14\\xaeGQ]\\xc0...</td>\n",
       "      <td>01:37:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1245952</td>\n",
       "      <td>1245953</td>\n",
       "      <td>1649103</td>\n",
       "      <td>SFO-GA-FY2001-Hancock-005</td>\n",
       "      <td>NONFED</td>\n",
       "      <td>ST-NASF</td>\n",
       "      <td>ST/C&amp;L</td>\n",
       "      <td>USGAGAS</td>\n",
       "      <td>Georgia Forestry Commission</td>\n",
       "      <td>GAGAS</td>\n",
       "      <td>...</td>\n",
       "      <td>33.315300</td>\n",
       "      <td>-83.053600</td>\n",
       "      <td>8.0</td>\n",
       "      <td>PRIVATE</td>\n",
       "      <td>GA</td>\n",
       "      <td>Hancock</td>\n",
       "      <td>141.0</td>\n",
       "      <td>Hancock</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x000\\xc4\\xb1.n\\xc3T\\xc0...</td>\n",
       "      <td>00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>159742</td>\n",
       "      <td>159743</td>\n",
       "      <td>161311</td>\n",
       "      <td>FS-389259</td>\n",
       "      <td>FED</td>\n",
       "      <td>FS-FIRESTAT</td>\n",
       "      <td>FS</td>\n",
       "      <td>USWYBTF</td>\n",
       "      <td>Bridger-Teton National Forest</td>\n",
       "      <td>0403</td>\n",
       "      <td>...</td>\n",
       "      <td>43.439167</td>\n",
       "      <td>-110.998611</td>\n",
       "      <td>5.0</td>\n",
       "      <td>USFS</td>\n",
       "      <td>WY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b'\\x00\\x01\\xad\\x10\\x00\\x00\\xd0\\xb7\\x92&gt;\\xe9\\xb...</td>\n",
       "      <td>20:30:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 41 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0  OBJECTID     FOD_ID                        FPA_ID  \\\n",
       "3     1405562   1405563   19101556  SFO-GA-EAR-16-9/29/1993-1730   \n",
       "4     1568120   1568121  201434414                    FS-1502869   \n",
       "5     1060555   1060556    1272887                     FS-368027   \n",
       "6     1245952   1245953    1649103     SFO-GA-FY2001-Hancock-005   \n",
       "7      159742    159743     161311                     FS-389259   \n",
       "\n",
       "  SOURCE_SYSTEM_TYPE SOURCE_SYSTEM NWCG_REPORTING_AGENCY  \\\n",
       "3             NONFED      ST-GAGAS                ST/C&L   \n",
       "4                FED   FS-FIRESTAT                    FS   \n",
       "5                FED   FS-FIRESTAT                    FS   \n",
       "6             NONFED       ST-NASF                ST/C&L   \n",
       "7                FED   FS-FIRESTAT                    FS   \n",
       "\n",
       "  NWCG_REPORTING_UNIT_ID        NWCG_REPORTING_UNIT_NAME  \\\n",
       "3                USGAGAS     Georgia Forestry Commission   \n",
       "4                USCAPNF          Plumas National Forest   \n",
       "5                USCABDF  San Bernardino National Forest   \n",
       "6                USGAGAS     Georgia Forestry Commission   \n",
       "7                USWYBTF   Bridger-Teton National Forest   \n",
       "\n",
       "  SOURCE_REPORTING_UNIT  ...   LATITUDE   LONGITUDE OWNER_CODE  \\\n",
       "3                 GAGAS  ...  31.258900  -84.815600       14.0   \n",
       "4                  0511  ...  39.800278 -120.503056       14.0   \n",
       "5                  0512  ...  34.207500 -117.270000       13.0   \n",
       "6                 GAGAS  ...  33.315300  -83.053600        8.0   \n",
       "7                  0403  ...  43.439167 -110.998611        5.0   \n",
       "\n",
       "             OWNER_DESCR STATE                COUNTY FIPS_CODE FIPS_NAME  \\\n",
       "3  MISSING/NOT SPECIFIED    GA  Early                     99.0     Early   \n",
       "4  MISSING/NOT SPECIFIED    CA                   063      63.0    Plumas   \n",
       "5       STATE OR PRIVATE    CA                   NaN       NaN       NaN   \n",
       "6                PRIVATE    GA               Hancock     141.0   Hancock   \n",
       "7                   USFS    WY                   NaN       NaN       NaN   \n",
       "\n",
       "                                               Shape TIME_TO_CONT  \n",
       "3  b'\\x00\\x01\\xad\\x10\\x00\\x00\\x84\\xa7W\\xca24U\\xc0...     00:43:00  \n",
       "4  b'\\x00\\x01\\xad\\x10\\x00\\x00T\\x91\\xf2\\x0f2 ^\\xc0...     02:00:00  \n",
       "5  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xe0z\\x14\\xaeGQ]\\xc0...     01:37:00  \n",
       "6  b'\\x00\\x01\\xad\\x10\\x00\\x000\\xc4\\xb1.n\\xc3T\\xc0...     00:00:00  \n",
       "7  b'\\x00\\x01\\xad\\x10\\x00\\x00\\xd0\\xb7\\x92>\\xe9\\xb...     20:30:00  \n",
       "\n",
       "[5 rows x 41 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count                      9560\n",
       "mean     1 days 01:05:56.943514\n",
       "std      6 days 18:00:19.623580\n",
       "min           -1 days +04:46:00\n",
       "25%             0 days 00:28:00\n",
       "50%             0 days 01:26:00\n",
       "75%             0 days 04:56:00\n",
       "max           213 days 00:14:00\n",
       "Name: TIME_TO_CONT, dtype: object"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['TIME_TO_CONT'].describe()"
   ]
  }
 ],
 "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": 4
}