Processing.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd \n",
    "import json"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "with open('311-Complaints-in-NYC.json', 'r') as f:\n",
    "    project = json.load(f)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "datasets = project['datasets']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/opt/conda/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3057: DtypeWarning: Columns (18) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "/opt/conda/lib/python3.7/site-packages/pandas/core/frame.py:6692: FutureWarning: Sorting because non-concatenation axis is not aligned. A future version\n",
      "of pandas will change to not sort by default.\n",
      "\n",
      "To accept the future behavior, pass 'sort=False'.\n",
      "\n",
      "To retain the current behavior and silence the warning, pass 'sort=True'.\n",
      "\n",
      "  sort=sort)\n"
     ]
    }
   ],
   "source": [
    "all_data = pd.DataFrame()\n",
    "\n",
    "for dataset in datasets:\n",
    "    dataset_type = dataset['type']\n",
    "    if(dataset_type=='file'):\n",
    "        data = pd.read_csv('example_datasets/{}'.format(dataset['ref']['path']))\n",
    "    elif(dataset_type['type'] == 'url'):\n",
    "        data = pd.read_csv(data['ref']['url'])\n",
    "    elif(dataset_Type['type'] == 'open_data'):\n",
    "        data = pd.read_csv(data['ref']['url'])\n",
    "        \n",
    "    column_renames  = dataset['column_renames']\n",
    "    data = data.rename(columns=column_renames)\n",
    "\n",
    "    all_data = all_data.append(data, ignore_index=True)\n",
    "\n",
    "for column,mapping in project['mappings'].items():\n",
    "    map_dict = {}\n",
    "    for key, values in mapping.items():\n",
    "        for value in values:\n",
    "            map_dict[value] = key \n",
    "            \n",
    "    all_data[column] = all_data[column].map(lambda x: map_dict[x] if x in mapping else 'unknown')\n",
    " \n",
    "all_data.to_csv('output.csv')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'TRAFFIC INCIDENT': 'TRAFFIC',\n",
       " 'AUTO ACCIDENT POLICE VEHICLE': 'TRAFFIC',\n",
       " 'AUTO ACCIDENT WITH INJURY': 'TRAFFIC',\n",
       " 'SUSPICIOUS PERSON': 'SUSPICIOUS PERSON',\n",
       " 'PROWLER': 'SUSPICIOUS PERSON',\n",
       " 'BURGLAR ALARM, SILENT': 'BURGLAR ALARM, SILENT',\n",
       " 'HOLD UP ALARM': 'BURGLAR ALARM, SILENT',\n",
       " 'BURGLAR ALARM, SILENT, FAR NO RESPONSE': 'BURGLAR ALARM, SILENT',\n",
       " 'BURGLAR ALARM, LOCAL': 'BURGLAR ALARM, SILENT',\n",
       " 'ABANDONED VEHICLE': 'ABANDONED VEHICLE',\n",
       " 'FLOODED VEHICLE': 'ABANDONED VEHICLE'}"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "map_dict = {}\n",
    "for key, values in project['mappings']['InitialTypeText'].items():\n",
    "    for value in values:\n",
    "        map_dict[value] = key \n",
    "map_dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "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>BLOCK_ADDRESS</th>\n",
       "      <th>Beat</th>\n",
       "      <th>Disposition</th>\n",
       "      <th>DispositionText</th>\n",
       "      <th>InitialPriority</th>\n",
       "      <th>InitialType</th>\n",
       "      <th>InitialTypeText</th>\n",
       "      <th>Location</th>\n",
       "      <th>MapX</th>\n",
       "      <th>MapY</th>\n",
       "      <th>...</th>\n",
       "      <th>SelfInitiated</th>\n",
       "      <th>TimeArrival</th>\n",
       "      <th>TimeArrive</th>\n",
       "      <th>TimeClosed</th>\n",
       "      <th>TimeCreate</th>\n",
       "      <th>TimeDispatch</th>\n",
       "      <th>Type</th>\n",
       "      <th>TypeText</th>\n",
       "      <th>Type_</th>\n",
       "      <th>Zip</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>147XX Chef Menteur Hwy</td>\n",
       "      <td>7L03</td>\n",
       "      <td>GOA</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1G</td>\n",
       "      <td>62C</td>\n",
       "      <td>unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/18/2018 02:34:08 AM</td>\n",
       "      <td>01/18/2018 03:14:11 AM</td>\n",
       "      <td>01/17/2018 04:10:29 PM</td>\n",
       "      <td>01/18/2018 02:21:51 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>THEFT FROM EXTERIOR</td>\n",
       "      <td>67C</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>063XX Stratford Pl</td>\n",
       "      <td>4E03</td>\n",
       "      <td>RTF</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1F</td>\n",
       "      <td>35</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(29.9123282, -89.98715446)</td>\n",
       "      <td>3707306</td>\n",
       "      <td>516114</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/26/2018 12:10:34 AM</td>\n",
       "      <td>01/26/2018 01:23:50 AM</td>\n",
       "      <td>01/25/2018 08:26:48 PM</td>\n",
       "      <td>01/26/2018 12:07:09 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DISTURBANCE (OTHER)</td>\n",
       "      <td>103</td>\n",
       "      <td>70131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Bourbon St &amp; Iberville St</td>\n",
       "      <td>8D01</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1J</td>\n",
       "      <td>18</td>\n",
       "      <td>unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>Y</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/09/2018 01:00:19 AM</td>\n",
       "      <td>01/09/2018 01:13:35 AM</td>\n",
       "      <td>01/09/2018 01:00:19 AM</td>\n",
       "      <td>01/09/2018 01:01:47 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TRAFFIC INCIDENT</td>\n",
       "      <td>18</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>007XX Bourbon St</td>\n",
       "      <td>8D06</td>\n",
       "      <td>RTF</td>\n",
       "      <td>unknown</td>\n",
       "      <td>2A</td>\n",
       "      <td>103</td>\n",
       "      <td>unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/08/2018 01:28:28 AM</td>\n",
       "      <td>01/08/2018 04:00:50 AM</td>\n",
       "      <td>01/08/2018 01:24:10 AM</td>\n",
       "      <td>01/08/2018 01:25:23 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AGGRAVATED ASSAULT</td>\n",
       "      <td>37</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>006XX N Rampart St</td>\n",
       "      <td>1E03</td>\n",
       "      <td>DUP</td>\n",
       "      <td>unknown</td>\n",
       "      <td>2E</td>\n",
       "      <td>63</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(29.96024903, -90.06907651)</td>\n",
       "      <td>3681162</td>\n",
       "      <td>533244</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/25/2018 11:18:12 PM</td>\n",
       "      <td>01/25/2018 08:26:53 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PROWLER</td>\n",
       "      <td>63</td>\n",
       "      <td>70112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>016XX Pine St</td>\n",
       "      <td>2L04</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1B</td>\n",
       "      <td>29</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(0.0, 0.0)</td>\n",
       "      <td>37369000</td>\n",
       "      <td>3513814</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/06/2018 01:22:42 AM</td>\n",
       "      <td>01/06/2018 01:39:05 AM</td>\n",
       "      <td>01/06/2018 01:15:19 AM</td>\n",
       "      <td>01/06/2018 01:15:56 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MEDICAL</td>\n",
       "      <td>24</td>\n",
       "      <td>70118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>018XX Magnolia St</td>\n",
       "      <td>6J01</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>2C</td>\n",
       "      <td>103M</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(0.0, 0.0)</td>\n",
       "      <td>37369000</td>\n",
       "      <td>3513814</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>06/08/2018 02:55:53 AM</td>\n",
       "      <td>06/08/2018 03:58:49 AM</td>\n",
       "      <td>06/08/2018 02:53:47 AM</td>\n",
       "      <td>06/08/2018 02:54:30 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MENTAL PATIENT</td>\n",
       "      <td>103M</td>\n",
       "      <td>70113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>XX Dreyfous Dr</td>\n",
       "      <td>3I06</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>2D</td>\n",
       "      <td>24</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(0.0, 0.0)</td>\n",
       "      <td>37369000</td>\n",
       "      <td>3513814</td>\n",
       "      <td>...</td>\n",
       "      <td>Y</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/20/2018 02:36:24 AM</td>\n",
       "      <td>03/20/2018 03:32:27 AM</td>\n",
       "      <td>03/20/2018 02:36:24 AM</td>\n",
       "      <td>03/20/2018 02:36:24 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MEDICAL</td>\n",
       "      <td>24</td>\n",
       "      <td>70119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>007XX Iberville St</td>\n",
       "      <td>8D04</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>2B</td>\n",
       "      <td>24</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(0.0, 0.0)</td>\n",
       "      <td>37369000</td>\n",
       "      <td>3513814</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/01/2018 01:43:08 AM</td>\n",
       "      <td>01/01/2018 01:26:56 AM</td>\n",
       "      <td>01/01/2018 01:27:47 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MEDICAL</td>\n",
       "      <td>24</td>\n",
       "      <td>70130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Bourbon St &amp; Saint Peter St</td>\n",
       "      <td>8D06</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>2D</td>\n",
       "      <td>24</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(0.0, 0.0)</td>\n",
       "      <td>37369000</td>\n",
       "      <td>3513814</td>\n",
       "      <td>...</td>\n",
       "      <td>Y</td>\n",
       "      <td>NaN</td>\n",
       "      <td>08/04/2018 02:51:50 AM</td>\n",
       "      <td>08/04/2018 03:11:26 AM</td>\n",
       "      <td>08/04/2018 02:51:50 AM</td>\n",
       "      <td>08/04/2018 02:51:50 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MEDICAL</td>\n",
       "      <td>24</td>\n",
       "      <td>70112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>042XX Iris St</td>\n",
       "      <td>3Y03</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>2A</td>\n",
       "      <td>103</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(0.0, 0.0)</td>\n",
       "      <td>37369000</td>\n",
       "      <td>3513814</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>02/24/2018 10:05:22 AM</td>\n",
       "      <td>02/24/2018 12:38:53 PM</td>\n",
       "      <td>02/24/2018 07:20:59 AM</td>\n",
       "      <td>02/24/2018 09:57:49 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MENTAL PATIENT</td>\n",
       "      <td>103M</td>\n",
       "      <td>70122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>079XX Michigan St</td>\n",
       "      <td>7I14</td>\n",
       "      <td>DUP</td>\n",
       "      <td>unknown</td>\n",
       "      <td>2C</td>\n",
       "      <td>103M</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(0.0, 0.0)</td>\n",
       "      <td>37369000</td>\n",
       "      <td>3513814</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/27/2018 10:19:22 AM</td>\n",
       "      <td>01/27/2018 05:51:12 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MENTAL PATIENT</td>\n",
       "      <td>103M</td>\n",
       "      <td>70128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>066XX Lake Willow Dr</td>\n",
       "      <td>7O05</td>\n",
       "      <td>VOI</td>\n",
       "      <td>unknown</td>\n",
       "      <td>2D</td>\n",
       "      <td>24</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(0.0, 0.0)</td>\n",
       "      <td>37369000</td>\n",
       "      <td>3513814</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>05/24/2018 07:16:05 AM</td>\n",
       "      <td>05/24/2018 06:30:27 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MEDICAL</td>\n",
       "      <td>24</td>\n",
       "      <td>70126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Constance St &amp; Thalia St</td>\n",
       "      <td>6C01</td>\n",
       "      <td>GOA</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1D</td>\n",
       "      <td>29S</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(0.0, 0.0)</td>\n",
       "      <td>37369000</td>\n",
       "      <td>3513814</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/18/2018 09:21:22 AM</td>\n",
       "      <td>01/18/2018 09:25:19 AM</td>\n",
       "      <td>01/18/2018 09:11:46 AM</td>\n",
       "      <td>01/18/2018 09:16:27 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUICIDE</td>\n",
       "      <td>29S</td>\n",
       "      <td>70130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>City Park</td>\n",
       "      <td>3I05</td>\n",
       "      <td>VOI</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1C</td>\n",
       "      <td>103</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(0.0, 0.0)</td>\n",
       "      <td>37369000</td>\n",
       "      <td>3513814</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>08/26/2018 06:17:36 AM</td>\n",
       "      <td>08/26/2018 05:39:53 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DISTURBANCE (OTHER)</td>\n",
       "      <td>103</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>062XX Blk S Claiborne Ave</td>\n",
       "      <td>2P02</td>\n",
       "      <td>RTF</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1J</td>\n",
       "      <td>21</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(0.0, 0.0)</td>\n",
       "      <td>37369000</td>\n",
       "      <td>3513814</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>02/15/2018 10:20:07 AM</td>\n",
       "      <td>02/15/2018 02:00:30 PM</td>\n",
       "      <td>02/15/2018 09:12:46 AM</td>\n",
       "      <td>02/15/2018 10:13:22 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SEXUAL BATTERY</td>\n",
       "      <td>43B</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>I-10 W</td>\n",
       "      <td>3B04</td>\n",
       "      <td>DUP</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1E</td>\n",
       "      <td>20</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(29.9961132, -90.1223269)</td>\n",
       "      <td>3664163</td>\n",
       "      <td>546104</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03/07/2018 09:25:55 AM</td>\n",
       "      <td>03/07/2018 09:25:13 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AUTO ACCIDENT</td>\n",
       "      <td>20</td>\n",
       "      <td>70124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>070XX Canal Blvd</td>\n",
       "      <td>3J03</td>\n",
       "      <td>VOI</td>\n",
       "      <td>unknown</td>\n",
       "      <td>2A</td>\n",
       "      <td>26</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(0.0, 0.0)</td>\n",
       "      <td>37369000</td>\n",
       "      <td>3513814</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/29/2018 09:48:00 AM</td>\n",
       "      <td>01/29/2018 09:46:28 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MEDICAL</td>\n",
       "      <td>24</td>\n",
       "      <td>70124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Conti St &amp; Burgundy St</td>\n",
       "      <td>8D02</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1H</td>\n",
       "      <td>21</td>\n",
       "      <td>unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>Y</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/06/2018 10:55:10 AM</td>\n",
       "      <td>01/06/2018 11:02:07 AM</td>\n",
       "      <td>01/06/2018 10:55:10 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TRAFFIC INCIDENT</td>\n",
       "      <td>18</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>003XX Le Boeuf St</td>\n",
       "      <td>4G02</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>2C</td>\n",
       "      <td>103M</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(0.0, 0.0)</td>\n",
       "      <td>37369000</td>\n",
       "      <td>3513814</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/24/2018 11:56:02 AM</td>\n",
       "      <td>01/24/2018 01:01:12 PM</td>\n",
       "      <td>01/24/2018 11:38:27 AM</td>\n",
       "      <td>01/24/2018 11:43:23 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MENTAL PATIENT</td>\n",
       "      <td>103M</td>\n",
       "      <td>70114</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>057XX Saint Anthony Ave</td>\n",
       "      <td>3R01</td>\n",
       "      <td>RTF</td>\n",
       "      <td>unknown</td>\n",
       "      <td>2A</td>\n",
       "      <td>29S</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(0.0, 0.0)</td>\n",
       "      <td>37369000</td>\n",
       "      <td>3513814</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/24/2018 12:38:00 PM</td>\n",
       "      <td>01/24/2018 03:12:51 PM</td>\n",
       "      <td>01/24/2018 12:35:30 PM</td>\n",
       "      <td>01/24/2018 12:36:36 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SUICIDE</td>\n",
       "      <td>29S</td>\n",
       "      <td>70122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>062XX Providence Pl</td>\n",
       "      <td>3V01</td>\n",
       "      <td>RTF</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1D</td>\n",
       "      <td>67F</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(30.02386847, -90.04611467)</td>\n",
       "      <td>3688173</td>\n",
       "      <td>556460</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/24/2018 08:02:37 PM</td>\n",
       "      <td>01/25/2018 01:17:52 AM</td>\n",
       "      <td>01/24/2018 07:11:06 PM</td>\n",
       "      <td>01/24/2018 08:02:32 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>THEFT BY FRAUD</td>\n",
       "      <td>67F</td>\n",
       "      <td>70126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>037XX Iberville St</td>\n",
       "      <td>1M03</td>\n",
       "      <td>VOI</td>\n",
       "      <td>unknown</td>\n",
       "      <td>2E</td>\n",
       "      <td>62A</td>\n",
       "      <td>BURGLAR ALARM, SILENT</td>\n",
       "      <td>(29.97346599, -90.09652087)</td>\n",
       "      <td>3672420</td>\n",
       "      <td>537956</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/25/2018 01:33:11 PM</td>\n",
       "      <td>01/25/2018 01:23:59 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BURGLAR ALARM, SILENT</td>\n",
       "      <td>62A</td>\n",
       "      <td>70119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Esplanade Ave &amp; N Claiborne Ave</td>\n",
       "      <td>1A01</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1I</td>\n",
       "      <td>58</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(29.96932619, -90.06839956)</td>\n",
       "      <td>3681340</td>\n",
       "      <td>536548</td>\n",
       "      <td>...</td>\n",
       "      <td>Y</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/25/2018 05:09:16 PM</td>\n",
       "      <td>01/25/2018 06:08:52 PM</td>\n",
       "      <td>01/25/2018 05:09:16 PM</td>\n",
       "      <td>01/25/2018 05:09:16 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RETURN FOR ADDITIONAL INFO</td>\n",
       "      <td>58</td>\n",
       "      <td>70116</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>053XX Wickfield Dr</td>\n",
       "      <td>3R02</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1J</td>\n",
       "      <td>21</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(30.01221192, -90.06809815)</td>\n",
       "      <td>3681263</td>\n",
       "      <td>552144</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/25/2018 01:07:38 AM</td>\n",
       "      <td>01/25/2018 01:07:38 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>COMPLAINT OTHER</td>\n",
       "      <td>21</td>\n",
       "      <td>70122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>010XX Decatur St</td>\n",
       "      <td>8E03</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1J</td>\n",
       "      <td>21</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(29.95917297, -90.06051055)</td>\n",
       "      <td>3683878</td>\n",
       "      <td>532883</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/25/2018 07:03:35 PM</td>\n",
       "      <td>01/25/2018 07:11:03 PM</td>\n",
       "      <td>01/25/2018 07:03:25 PM</td>\n",
       "      <td>01/25/2018 07:03:25 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>COMPLAINT OTHER</td>\n",
       "      <td>21</td>\n",
       "      <td>70116</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Wales St &amp; Mercier St</td>\n",
       "      <td>7I14</td>\n",
       "      <td>GOA</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1I</td>\n",
       "      <td>58</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(30.05265934, -89.9736734)</td>\n",
       "      <td>3710971</td>\n",
       "      <td>567194</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/26/2018 12:32:15 AM</td>\n",
       "      <td>01/26/2018 12:34:06 AM</td>\n",
       "      <td>01/25/2018 03:59:28 PM</td>\n",
       "      <td>01/26/2018 12:32:13 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RECOVERY OF REPORTED STOLEN VEHICLE</td>\n",
       "      <td>58R</td>\n",
       "      <td>70128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>069XX Salem Dr</td>\n",
       "      <td>7O10</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1J</td>\n",
       "      <td>18</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(30.03372192, -89.98699302)</td>\n",
       "      <td>3706839</td>\n",
       "      <td>560258</td>\n",
       "      <td>...</td>\n",
       "      <td>Y</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/25/2018 01:07:03 PM</td>\n",
       "      <td>01/25/2018 01:10:41 PM</td>\n",
       "      <td>01/25/2018 01:07:03 PM</td>\n",
       "      <td>01/25/2018 01:07:03 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TRAFFIC INCIDENT</td>\n",
       "      <td>18</td>\n",
       "      <td>70127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>S Cortez St &amp; Ulloa St</td>\n",
       "      <td>1L03</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1K</td>\n",
       "      <td>22A</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(29.96738484, -90.10219622)</td>\n",
       "      <td>3670647</td>\n",
       "      <td>535725</td>\n",
       "      <td>...</td>\n",
       "      <td>Y</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/25/2018 06:51:25 PM</td>\n",
       "      <td>01/25/2018 07:16:07 PM</td>\n",
       "      <td>01/25/2018 06:51:25 PM</td>\n",
       "      <td>01/25/2018 06:51:25 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AREA CHECK</td>\n",
       "      <td>22A</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>012XX Blk Baronne St</td>\n",
       "      <td>6G03</td>\n",
       "      <td>RTF</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1E</td>\n",
       "      <td>20</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(29.94230001, -90.07660079)</td>\n",
       "      <td>3678851</td>\n",
       "      <td>526691</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01/25/2018 08:49:42 AM</td>\n",
       "      <td>01/25/2018 09:57:32 AM</td>\n",
       "      <td>01/25/2018 08:48:15 AM</td>\n",
       "      <td>01/25/2018 08:48:54 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AUTO ACCIDENT</td>\n",
       "      <td>20</td>\n",
       "      <td>70113</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>1185370</th>\n",
       "      <td>Nashville Ave &amp; Saint Charles Ave</td>\n",
       "      <td>2F02</td>\n",
       "      <td>GOA</td>\n",
       "      <td>unknown</td>\n",
       "      <td>0G</td>\n",
       "      <td>21P</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(29.93014055, -90.11660741)</td>\n",
       "      <td>3666228</td>\n",
       "      <td>522133</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>09/29/2019 02:27:34 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 02:37:09 PM</td>\n",
       "      <td>09/29/2019 02:22:36 PM</td>\n",
       "      <td>09/29/2019 02:27:27 PM</td>\n",
       "      <td>21P</td>\n",
       "      <td>LOST PROPERTY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70115</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185371</th>\n",
       "      <td>007XX Blk Queensway Dr</td>\n",
       "      <td>7K03</td>\n",
       "      <td>RTF</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1G</td>\n",
       "      <td>62C</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(30.05995477, -89.94877698)</td>\n",
       "      <td>3718815</td>\n",
       "      <td>569941</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>09/29/2019 08:19:55 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 09:04:43 AM</td>\n",
       "      <td>09/29/2019 06:27:23 AM</td>\n",
       "      <td>09/29/2019 08:06:35 AM</td>\n",
       "      <td>62C</td>\n",
       "      <td>SIMPLE BURGLARY VEHICLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185372</th>\n",
       "      <td>W Harrison Ave &amp; Fleur De Lis Dr</td>\n",
       "      <td>3B03</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1K</td>\n",
       "      <td>22A</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(30.00577313, -90.118836)</td>\n",
       "      <td>3665231</td>\n",
       "      <td>549628</td>\n",
       "      <td>...</td>\n",
       "      <td>Y</td>\n",
       "      <td>09/29/2019 01:31:47 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 01:59:39 AM</td>\n",
       "      <td>09/29/2019 01:31:47 AM</td>\n",
       "      <td>09/29/2019 01:31:47 AM</td>\n",
       "      <td>22A</td>\n",
       "      <td>AREA CHECK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185373</th>\n",
       "      <td>017XX Flood St</td>\n",
       "      <td>5I04</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1J</td>\n",
       "      <td>21</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(0.0, 0.0)</td>\n",
       "      <td>37369000</td>\n",
       "      <td>3513814</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>09/29/2019 10:03:32 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 11:18:53 AM</td>\n",
       "      <td>09/29/2019 09:57:59 AM</td>\n",
       "      <td>09/29/2019 09:59:19 AM</td>\n",
       "      <td>103M</td>\n",
       "      <td>MENTAL PATIENT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185374</th>\n",
       "      <td>015XX Poydras St</td>\n",
       "      <td>8J01</td>\n",
       "      <td>RTF</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1F</td>\n",
       "      <td>35</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(29.95104444, -90.08112589)</td>\n",
       "      <td>3677383</td>\n",
       "      <td>529855</td>\n",
       "      <td>...</td>\n",
       "      <td>Y</td>\n",
       "      <td>09/29/2019 11:07:20 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 11:08:02 PM</td>\n",
       "      <td>09/29/2019 11:07:20 PM</td>\n",
       "      <td>09/29/2019 11:07:20 PM</td>\n",
       "      <td>35</td>\n",
       "      <td>SIMPLE BATTERY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185375</th>\n",
       "      <td>015XX Sugar Bowl Dr</td>\n",
       "      <td>8J01</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1J</td>\n",
       "      <td>21</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(29.95138474, -90.07856751)</td>\n",
       "      <td>3678192</td>\n",
       "      <td>529988</td>\n",
       "      <td>...</td>\n",
       "      <td>Y</td>\n",
       "      <td>09/29/2019 05:55:08 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 09:42:08 PM</td>\n",
       "      <td>09/29/2019 05:55:08 PM</td>\n",
       "      <td>09/29/2019 05:55:08 PM</td>\n",
       "      <td>21</td>\n",
       "      <td>COMPLAINT OTHER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185376</th>\n",
       "      <td>040XX Tulane Ave</td>\n",
       "      <td>1L04</td>\n",
       "      <td>GOA</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1G</td>\n",
       "      <td>67</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(29.96866471, -90.10502183)</td>\n",
       "      <td>3669747</td>\n",
       "      <td>536181</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>09/29/2019 07:47:00 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 07:58:02 AM</td>\n",
       "      <td>09/29/2019 07:11:54 AM</td>\n",
       "      <td>09/29/2019 07:46:55 AM</td>\n",
       "      <td>67C</td>\n",
       "      <td>THEFT FROM EXTERIOR OF VEHICLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185377</th>\n",
       "      <td>Gentilly Blvd &amp; Lafaye St</td>\n",
       "      <td>3T02</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1J</td>\n",
       "      <td>TS</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(30.00308096, -90.04828807)</td>\n",
       "      <td>3687570</td>\n",
       "      <td>548893</td>\n",
       "      <td>...</td>\n",
       "      <td>Y</td>\n",
       "      <td>09/29/2019 12:57:57 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 01:46:02 AM</td>\n",
       "      <td>09/29/2019 12:57:57 AM</td>\n",
       "      <td>09/29/2019 12:57:57 AM</td>\n",
       "      <td>TS</td>\n",
       "      <td>TRAFFIC STOP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185378</th>\n",
       "      <td>012XX Saint Charles Ave</td>\n",
       "      <td>6G03</td>\n",
       "      <td>RTF</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1J</td>\n",
       "      <td>21</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(29.94073978, -90.07460938)</td>\n",
       "      <td>3679488</td>\n",
       "      <td>526131</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>09/29/2019 11:31:06 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 12:42:11 PM</td>\n",
       "      <td>09/29/2019 11:31:01 AM</td>\n",
       "      <td>09/29/2019 11:31:01 AM</td>\n",
       "      <td>67F</td>\n",
       "      <td>THEFT BY FRAUD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185379</th>\n",
       "      <td>063XX Louis Xiv St</td>\n",
       "      <td>3F01</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>2E</td>\n",
       "      <td>62A</td>\n",
       "      <td>BURGLAR ALARM, SILENT</td>\n",
       "      <td>(30.0065176, -90.10938404)</td>\n",
       "      <td>3668219</td>\n",
       "      <td>549931</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>09/29/2019 10:10:32 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 10:24:13 PM</td>\n",
       "      <td>09/29/2019 09:58:01 PM</td>\n",
       "      <td>09/29/2019 10:09:44 PM</td>\n",
       "      <td>62A</td>\n",
       "      <td>BURGLAR ALARM, SILENT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185380</th>\n",
       "      <td>034XX S Carrollton Ave</td>\n",
       "      <td>2U04</td>\n",
       "      <td>GOA</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1C</td>\n",
       "      <td>103</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(29.96302552, -90.11240704)</td>\n",
       "      <td>3667431</td>\n",
       "      <td>534105</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>09/29/2019 01:26:02 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 01:33:16 PM</td>\n",
       "      <td>09/29/2019 01:17:39 PM</td>\n",
       "      <td>09/29/2019 01:20:48 PM</td>\n",
       "      <td>103</td>\n",
       "      <td>DISTURBANCE (OTHER)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185381</th>\n",
       "      <td>009XX N Derbigny St</td>\n",
       "      <td>1J01</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1E</td>\n",
       "      <td>62R</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(29.96622512, -90.07280444)</td>\n",
       "      <td>3679958</td>\n",
       "      <td>535405</td>\n",
       "      <td>...</td>\n",
       "      <td>Y</td>\n",
       "      <td>09/29/2019 05:30:39 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 06:02:18 AM</td>\n",
       "      <td>09/29/2019 05:30:39 AM</td>\n",
       "      <td>09/29/2019 05:30:39 AM</td>\n",
       "      <td>21</td>\n",
       "      <td>COMPLAINT OTHER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70116</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185382</th>\n",
       "      <td>Treme St &amp; Canal St</td>\n",
       "      <td>1E02</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1J</td>\n",
       "      <td>TS</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(29.95698579, -90.07446366)</td>\n",
       "      <td>3679469</td>\n",
       "      <td>532039</td>\n",
       "      <td>...</td>\n",
       "      <td>Y</td>\n",
       "      <td>09/29/2019 03:13:45 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 03:20:36 AM</td>\n",
       "      <td>09/29/2019 03:13:45 AM</td>\n",
       "      <td>09/29/2019 03:13:45 AM</td>\n",
       "      <td>TS</td>\n",
       "      <td>TRAFFIC STOP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185383</th>\n",
       "      <td>008XX Poydras St</td>\n",
       "      <td>8H02</td>\n",
       "      <td>RTF</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1F</td>\n",
       "      <td>35</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(29.94971191, -90.07240479)</td>\n",
       "      <td>3680150</td>\n",
       "      <td>529401</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>09/29/2019 03:50:21 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 06:54:34 PM</td>\n",
       "      <td>09/29/2019 01:54:41 PM</td>\n",
       "      <td>09/29/2019 03:47:43 PM</td>\n",
       "      <td>65</td>\n",
       "      <td>SIMPLE ROBBERY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185384</th>\n",
       "      <td>Ulloa St &amp; S Pierce St</td>\n",
       "      <td>1L04</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1K</td>\n",
       "      <td>22A</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(29.96864508, -90.10406003)</td>\n",
       "      <td>3670052</td>\n",
       "      <td>536177</td>\n",
       "      <td>...</td>\n",
       "      <td>Y</td>\n",
       "      <td>09/29/2019 01:45:06 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 02:13:36 PM</td>\n",
       "      <td>09/29/2019 01:45:06 PM</td>\n",
       "      <td>09/29/2019 01:45:06 PM</td>\n",
       "      <td>22A</td>\n",
       "      <td>AREA CHECK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185385</th>\n",
       "      <td>Poland Ave &amp; Saint Claude Ave</td>\n",
       "      <td>5D02</td>\n",
       "      <td>GOA</td>\n",
       "      <td>unknown</td>\n",
       "      <td>2C</td>\n",
       "      <td>65J</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(29.96473251, -90.03159138)</td>\n",
       "      <td>3693013</td>\n",
       "      <td>535008</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>09/29/2019 06:13:55 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 06:27:12 PM</td>\n",
       "      <td>09/29/2019 06:07:51 PM</td>\n",
       "      <td>09/29/2019 06:10:43 PM</td>\n",
       "      <td>65J</td>\n",
       "      <td>CARJACKING- NO WEAPON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185386</th>\n",
       "      <td>N Claiborne Ave &amp; Poland Ave</td>\n",
       "      <td>5D03</td>\n",
       "      <td>DUP</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1J</td>\n",
       "      <td>21</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(29.96984712, -90.03005197)</td>\n",
       "      <td>3693479</td>\n",
       "      <td>536873</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 11:49:25 AM</td>\n",
       "      <td>09/29/2019 11:47:01 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18</td>\n",
       "      <td>TRAFFIC INCIDENT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185387</th>\n",
       "      <td>026XX Banks St</td>\n",
       "      <td>1H02</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1I</td>\n",
       "      <td>58</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(29.96199653, -90.08879943)</td>\n",
       "      <td>3674910</td>\n",
       "      <td>533812</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>09/29/2019 10:43:30 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 11:05:45 AM</td>\n",
       "      <td>09/29/2019 10:19:53 AM</td>\n",
       "      <td>09/29/2019 10:43:21 AM</td>\n",
       "      <td>58</td>\n",
       "      <td>RETURN FOR ADDITIONAL INFO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185388</th>\n",
       "      <td>007XX Saint Peter St</td>\n",
       "      <td>8D06</td>\n",
       "      <td>VOI</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1C</td>\n",
       "      <td>103</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(29.9582035, -90.06532318)</td>\n",
       "      <td>3682358</td>\n",
       "      <td>532514</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 03:26:31 AM</td>\n",
       "      <td>09/29/2019 03:23:17 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>103</td>\n",
       "      <td>DISTURBANCE (OTHER)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185389</th>\n",
       "      <td>072XX Queensway Dr</td>\n",
       "      <td>7K03</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>2D</td>\n",
       "      <td>103F</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(30.06108083, -89.95007442)</td>\n",
       "      <td>3718400</td>\n",
       "      <td>570346</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>09/29/2019 11:33:50 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 11:46:15 PM</td>\n",
       "      <td>09/29/2019 11:12:50 PM</td>\n",
       "      <td>09/29/2019 11:23:38 PM</td>\n",
       "      <td>103</td>\n",
       "      <td>DISTURBANCE (OTHER)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185390</th>\n",
       "      <td>10Blk Lakeshore Dr</td>\n",
       "      <td>3G01</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1J</td>\n",
       "      <td>18</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(30.02738944, -90.10926333)</td>\n",
       "      <td>3668176</td>\n",
       "      <td>557521</td>\n",
       "      <td>...</td>\n",
       "      <td>Y</td>\n",
       "      <td>09/29/2019 04:31:26 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 05:08:09 PM</td>\n",
       "      <td>09/29/2019 04:31:26 PM</td>\n",
       "      <td>09/29/2019 04:31:26 PM</td>\n",
       "      <td>18</td>\n",
       "      <td>TRAFFIC INCIDENT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185391</th>\n",
       "      <td>021XX Saint Andrew St</td>\n",
       "      <td>6H01</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1D</td>\n",
       "      <td>52F</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(29.93949929, -90.08254765)</td>\n",
       "      <td>3676979</td>\n",
       "      <td>525652</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>09/29/2019 10:28:22 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 11:08:39 AM</td>\n",
       "      <td>09/29/2019 10:23:36 AM</td>\n",
       "      <td>09/29/2019 10:24:13 AM</td>\n",
       "      <td>52F</td>\n",
       "      <td>FIRE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185392</th>\n",
       "      <td>Lakeshore Dr &amp; Leroy Johnson Dr</td>\n",
       "      <td>3S06</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1J</td>\n",
       "      <td>21</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(30.03144398, -90.03588352)</td>\n",
       "      <td>3691379</td>\n",
       "      <td>559251</td>\n",
       "      <td>...</td>\n",
       "      <td>Y</td>\n",
       "      <td>09/29/2019 07:35:34 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 07:35:52 PM</td>\n",
       "      <td>09/29/2019 07:35:34 PM</td>\n",
       "      <td>09/29/2019 07:35:34 PM</td>\n",
       "      <td>21</td>\n",
       "      <td>COMPLAINT OTHER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185393</th>\n",
       "      <td>016XX Treasure St</td>\n",
       "      <td>3X03</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>2E</td>\n",
       "      <td>62A</td>\n",
       "      <td>BURGLAR ALARM, SILENT</td>\n",
       "      <td>(29.98887963, -90.0723514)</td>\n",
       "      <td>3680010</td>\n",
       "      <td>543644</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>09/29/2019 09:49:39 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 10:02:42 AM</td>\n",
       "      <td>09/29/2019 09:37:14 AM</td>\n",
       "      <td>09/29/2019 09:38:23 AM</td>\n",
       "      <td>62A</td>\n",
       "      <td>BURGLAR ALARM, SILENT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185394</th>\n",
       "      <td>010XX Loyola Ave</td>\n",
       "      <td>6H05</td>\n",
       "      <td>VOI</td>\n",
       "      <td>unknown</td>\n",
       "      <td>2C</td>\n",
       "      <td>106</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(29.94619458, -90.07857132)</td>\n",
       "      <td>3678211</td>\n",
       "      <td>528101</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 07:26:41 AM</td>\n",
       "      <td>09/29/2019 07:20:24 AM</td>\n",
       "      <td>09/29/2019 07:26:15 AM</td>\n",
       "      <td>106</td>\n",
       "      <td>OBSCENITY, EXPOSING</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185395</th>\n",
       "      <td>044XX Saint Roch Ave</td>\n",
       "      <td>3T01</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>2E</td>\n",
       "      <td>62A</td>\n",
       "      <td>BURGLAR ALARM, SILENT</td>\n",
       "      <td>(30.00342604, -90.05470493)</td>\n",
       "      <td>3685537</td>\n",
       "      <td>548996</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>09/29/2019 11:39:17 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 11:49:46 AM</td>\n",
       "      <td>09/29/2019 11:27:23 AM</td>\n",
       "      <td>09/29/2019 11:30:10 AM</td>\n",
       "      <td>62A</td>\n",
       "      <td>BURGLAR ALARM, SILENT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185396</th>\n",
       "      <td>Aurora Oaks Dr &amp; Macarthur Blvd</td>\n",
       "      <td>4D01</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1K</td>\n",
       "      <td>22A</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(29.92368712, -90.00612279)</td>\n",
       "      <td>3701249</td>\n",
       "      <td>520175</td>\n",
       "      <td>...</td>\n",
       "      <td>Y</td>\n",
       "      <td>09/29/2019 03:28:54 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 05:36:14 AM</td>\n",
       "      <td>09/29/2019 03:28:54 AM</td>\n",
       "      <td>09/29/2019 03:28:54 AM</td>\n",
       "      <td>22A</td>\n",
       "      <td>AREA CHECK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185397</th>\n",
       "      <td>057XX Pasteur Blvd</td>\n",
       "      <td>3R01</td>\n",
       "      <td>NAT</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1C</td>\n",
       "      <td>103</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(30.01760099, -90.06344365)</td>\n",
       "      <td>3682714</td>\n",
       "      <td>554120</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>09/29/2019 05:04:32 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 05:12:53 PM</td>\n",
       "      <td>09/29/2019 04:54:08 PM</td>\n",
       "      <td>09/29/2019 04:57:01 PM</td>\n",
       "      <td>21</td>\n",
       "      <td>COMPLAINT OTHER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185398</th>\n",
       "      <td>041XX S Carrollton Ave</td>\n",
       "      <td>3D01</td>\n",
       "      <td>DUP</td>\n",
       "      <td>unknown</td>\n",
       "      <td>2C</td>\n",
       "      <td>64G</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(29.9699272, -90.10654572)</td>\n",
       "      <td>3669260</td>\n",
       "      <td>536635</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>09/29/2019 01:12:07 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 01:23:14 AM</td>\n",
       "      <td>09/29/2019 01:09:52 AM</td>\n",
       "      <td>09/29/2019 01:11:26 AM</td>\n",
       "      <td>64G</td>\n",
       "      <td>ARMED ROBBERY WITH GUN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185399</th>\n",
       "      <td>Downman Rd &amp; Chef Menteur Hwy</td>\n",
       "      <td>7A01</td>\n",
       "      <td>DUP</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1C</td>\n",
       "      <td>103</td>\n",
       "      <td>unknown</td>\n",
       "      <td>(30.00973449, -90.02090137)</td>\n",
       "      <td>3696210</td>\n",
       "      <td>551411</td>\n",
       "      <td>...</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>09/29/2019 06:48:56 PM</td>\n",
       "      <td>09/29/2019 06:46:34 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>103</td>\n",
       "      <td>DISTURBANCE (OTHER)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70126</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1185400 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             BLOCK_ADDRESS  Beat Disposition DispositionText  \\\n",
       "0                   147XX Chef Menteur Hwy  7L03         GOA         unknown   \n",
       "1                       063XX Stratford Pl  4E03         RTF         unknown   \n",
       "2                Bourbon St & Iberville St  8D01         NAT         unknown   \n",
       "3                         007XX Bourbon St  8D06         RTF         unknown   \n",
       "4                       006XX N Rampart St  1E03         DUP         unknown   \n",
       "5                            016XX Pine St  2L04         NAT         unknown   \n",
       "6                        018XX Magnolia St  6J01         NAT         unknown   \n",
       "7                           XX Dreyfous Dr  3I06         NAT         unknown   \n",
       "8                       007XX Iberville St  8D04         NAT         unknown   \n",
       "9              Bourbon St & Saint Peter St  8D06         NAT         unknown   \n",
       "10                           042XX Iris St  3Y03         NAT         unknown   \n",
       "11                       079XX Michigan St  7I14         DUP         unknown   \n",
       "12                    066XX Lake Willow Dr  7O05         VOI         unknown   \n",
       "13                Constance St & Thalia St  6C01         GOA         unknown   \n",
       "14                               City Park  3I05         VOI         unknown   \n",
       "15               062XX Blk S Claiborne Ave  2P02         RTF         unknown   \n",
       "16                                  I-10 W  3B04         DUP         unknown   \n",
       "17                        070XX Canal Blvd  3J03         VOI         unknown   \n",
       "18                  Conti St & Burgundy St  8D02         NAT         unknown   \n",
       "19                       003XX Le Boeuf St  4G02         NAT         unknown   \n",
       "20                 057XX Saint Anthony Ave  3R01         RTF         unknown   \n",
       "21                     062XX Providence Pl  3V01         RTF         unknown   \n",
       "22                      037XX Iberville St  1M03         VOI         unknown   \n",
       "23         Esplanade Ave & N Claiborne Ave  1A01         NAT         unknown   \n",
       "24                      053XX Wickfield Dr  3R02         NAT         unknown   \n",
       "25                        010XX Decatur St  8E03         NAT         unknown   \n",
       "26                   Wales St & Mercier St  7I14         GOA         unknown   \n",
       "27                          069XX Salem Dr  7O10         NAT         unknown   \n",
       "28                  S Cortez St & Ulloa St  1L03         NAT         unknown   \n",
       "29                    012XX Blk Baronne St  6G03         RTF         unknown   \n",
       "...                                    ...   ...         ...             ...   \n",
       "1185370  Nashville Ave & Saint Charles Ave  2F02         GOA         unknown   \n",
       "1185371             007XX Blk Queensway Dr  7K03         RTF         unknown   \n",
       "1185372   W Harrison Ave & Fleur De Lis Dr  3B03         NAT         unknown   \n",
       "1185373                     017XX Flood St  5I04         NAT         unknown   \n",
       "1185374                   015XX Poydras St  8J01         RTF         unknown   \n",
       "1185375                015XX Sugar Bowl Dr  8J01         NAT         unknown   \n",
       "1185376                   040XX Tulane Ave  1L04         GOA         unknown   \n",
       "1185377          Gentilly Blvd & Lafaye St  3T02         NAT         unknown   \n",
       "1185378            012XX Saint Charles Ave  6G03         RTF         unknown   \n",
       "1185379                 063XX Louis Xiv St  3F01         NAT         unknown   \n",
       "1185380             034XX S Carrollton Ave  2U04         GOA         unknown   \n",
       "1185381                009XX N Derbigny St  1J01         NAT         unknown   \n",
       "1185382                Treme St & Canal St  1E02         NAT         unknown   \n",
       "1185383                   008XX Poydras St  8H02         RTF         unknown   \n",
       "1185384             Ulloa St & S Pierce St  1L04         NAT         unknown   \n",
       "1185385      Poland Ave & Saint Claude Ave  5D02         GOA         unknown   \n",
       "1185386       N Claiborne Ave & Poland Ave  5D03         DUP         unknown   \n",
       "1185387                     026XX Banks St  1H02         NAT         unknown   \n",
       "1185388               007XX Saint Peter St  8D06         VOI         unknown   \n",
       "1185389                 072XX Queensway Dr  7K03         NAT         unknown   \n",
       "1185390                 10Blk Lakeshore Dr  3G01         NAT         unknown   \n",
       "1185391              021XX Saint Andrew St  6H01         NAT         unknown   \n",
       "1185392    Lakeshore Dr & Leroy Johnson Dr  3S06         NAT         unknown   \n",
       "1185393                  016XX Treasure St  3X03         NAT         unknown   \n",
       "1185394                   010XX Loyola Ave  6H05         VOI         unknown   \n",
       "1185395               044XX Saint Roch Ave  3T01         NAT         unknown   \n",
       "1185396    Aurora Oaks Dr & Macarthur Blvd  4D01         NAT         unknown   \n",
       "1185397                 057XX Pasteur Blvd  3R01         NAT         unknown   \n",
       "1185398             041XX S Carrollton Ave  3D01         DUP         unknown   \n",
       "1185399      Downman Rd & Chef Menteur Hwy  7A01         DUP         unknown   \n",
       "\n",
       "        InitialPriority InitialType        InitialTypeText  \\\n",
       "0                    1G         62C                unknown   \n",
       "1                    1F          35                unknown   \n",
       "2                    1J          18                unknown   \n",
       "3                    2A         103                unknown   \n",
       "4                    2E          63                unknown   \n",
       "5                    1B          29                unknown   \n",
       "6                    2C        103M                unknown   \n",
       "7                    2D          24                unknown   \n",
       "8                    2B          24                unknown   \n",
       "9                    2D          24                unknown   \n",
       "10                   2A         103                unknown   \n",
       "11                   2C        103M                unknown   \n",
       "12                   2D          24                unknown   \n",
       "13                   1D         29S                unknown   \n",
       "14                   1C         103                unknown   \n",
       "15                   1J          21                unknown   \n",
       "16                   1E          20                unknown   \n",
       "17                   2A          26                unknown   \n",
       "18                   1H          21                unknown   \n",
       "19                   2C        103M                unknown   \n",
       "20                   2A         29S                unknown   \n",
       "21                   1D         67F                unknown   \n",
       "22                   2E         62A  BURGLAR ALARM, SILENT   \n",
       "23                   1I          58                unknown   \n",
       "24                   1J          21                unknown   \n",
       "25                   1J          21                unknown   \n",
       "26                   1I          58                unknown   \n",
       "27                   1J          18                unknown   \n",
       "28                   1K         22A                unknown   \n",
       "29                   1E          20                unknown   \n",
       "...                 ...         ...                    ...   \n",
       "1185370              0G         21P                unknown   \n",
       "1185371              1G         62C                unknown   \n",
       "1185372              1K         22A                unknown   \n",
       "1185373              1J          21                unknown   \n",
       "1185374              1F          35                unknown   \n",
       "1185375              1J          21                unknown   \n",
       "1185376              1G          67                unknown   \n",
       "1185377              1J          TS                unknown   \n",
       "1185378              1J          21                unknown   \n",
       "1185379              2E         62A  BURGLAR ALARM, SILENT   \n",
       "1185380              1C         103                unknown   \n",
       "1185381              1E         62R                unknown   \n",
       "1185382              1J          TS                unknown   \n",
       "1185383              1F          35                unknown   \n",
       "1185384              1K         22A                unknown   \n",
       "1185385              2C         65J                unknown   \n",
       "1185386              1J          21                unknown   \n",
       "1185387              1I          58                unknown   \n",
       "1185388              1C         103                unknown   \n",
       "1185389              2D        103F                unknown   \n",
       "1185390              1J          18                unknown   \n",
       "1185391              1D         52F                unknown   \n",
       "1185392              1J          21                unknown   \n",
       "1185393              2E         62A  BURGLAR ALARM, SILENT   \n",
       "1185394              2C         106                unknown   \n",
       "1185395              2E         62A  BURGLAR ALARM, SILENT   \n",
       "1185396              1K         22A                unknown   \n",
       "1185397              1C         103                unknown   \n",
       "1185398              2C         64G                unknown   \n",
       "1185399              1C         103                unknown   \n",
       "\n",
       "                            Location      MapX     MapY  ... SelfInitiated  \\\n",
       "0                                NaN         0        0  ...             N   \n",
       "1         (29.9123282, -89.98715446)   3707306   516114  ...             N   \n",
       "2                                NaN         0        0  ...             Y   \n",
       "3                                NaN         0        0  ...             N   \n",
       "4        (29.96024903, -90.06907651)   3681162   533244  ...             N   \n",
       "5                         (0.0, 0.0)  37369000  3513814  ...             N   \n",
       "6                         (0.0, 0.0)  37369000  3513814  ...             N   \n",
       "7                         (0.0, 0.0)  37369000  3513814  ...             Y   \n",
       "8                         (0.0, 0.0)  37369000  3513814  ...             N   \n",
       "9                         (0.0, 0.0)  37369000  3513814  ...             Y   \n",
       "10                        (0.0, 0.0)  37369000  3513814  ...             N   \n",
       "11                        (0.0, 0.0)  37369000  3513814  ...             N   \n",
       "12                        (0.0, 0.0)  37369000  3513814  ...             N   \n",
       "13                        (0.0, 0.0)  37369000  3513814  ...             N   \n",
       "14                        (0.0, 0.0)  37369000  3513814  ...             N   \n",
       "15                        (0.0, 0.0)  37369000  3513814  ...             N   \n",
       "16         (29.9961132, -90.1223269)   3664163   546104  ...             N   \n",
       "17                        (0.0, 0.0)  37369000  3513814  ...             N   \n",
       "18                               NaN         0        0  ...             Y   \n",
       "19                        (0.0, 0.0)  37369000  3513814  ...             N   \n",
       "20                        (0.0, 0.0)  37369000  3513814  ...             N   \n",
       "21       (30.02386847, -90.04611467)   3688173   556460  ...             N   \n",
       "22       (29.97346599, -90.09652087)   3672420   537956  ...             N   \n",
       "23       (29.96932619, -90.06839956)   3681340   536548  ...             Y   \n",
       "24       (30.01221192, -90.06809815)   3681263   552144  ...             N   \n",
       "25       (29.95917297, -90.06051055)   3683878   532883  ...             N   \n",
       "26        (30.05265934, -89.9736734)   3710971   567194  ...             N   \n",
       "27       (30.03372192, -89.98699302)   3706839   560258  ...             Y   \n",
       "28       (29.96738484, -90.10219622)   3670647   535725  ...             Y   \n",
       "29       (29.94230001, -90.07660079)   3678851   526691  ...             N   \n",
       "...                              ...       ...      ...  ...           ...   \n",
       "1185370  (29.93014055, -90.11660741)   3666228   522133  ...             N   \n",
       "1185371  (30.05995477, -89.94877698)   3718815   569941  ...             N   \n",
       "1185372    (30.00577313, -90.118836)   3665231   549628  ...             Y   \n",
       "1185373                   (0.0, 0.0)  37369000  3513814  ...             N   \n",
       "1185374  (29.95104444, -90.08112589)   3677383   529855  ...             Y   \n",
       "1185375  (29.95138474, -90.07856751)   3678192   529988  ...             Y   \n",
       "1185376  (29.96866471, -90.10502183)   3669747   536181  ...             N   \n",
       "1185377  (30.00308096, -90.04828807)   3687570   548893  ...             Y   \n",
       "1185378  (29.94073978, -90.07460938)   3679488   526131  ...             N   \n",
       "1185379   (30.0065176, -90.10938404)   3668219   549931  ...             N   \n",
       "1185380  (29.96302552, -90.11240704)   3667431   534105  ...             N   \n",
       "1185381  (29.96622512, -90.07280444)   3679958   535405  ...             Y   \n",
       "1185382  (29.95698579, -90.07446366)   3679469   532039  ...             Y   \n",
       "1185383  (29.94971191, -90.07240479)   3680150   529401  ...             N   \n",
       "1185384  (29.96864508, -90.10406003)   3670052   536177  ...             Y   \n",
       "1185385  (29.96473251, -90.03159138)   3693013   535008  ...             N   \n",
       "1185386  (29.96984712, -90.03005197)   3693479   536873  ...             N   \n",
       "1185387  (29.96199653, -90.08879943)   3674910   533812  ...             N   \n",
       "1185388   (29.9582035, -90.06532318)   3682358   532514  ...             N   \n",
       "1185389  (30.06108083, -89.95007442)   3718400   570346  ...             N   \n",
       "1185390  (30.02738944, -90.10926333)   3668176   557521  ...             Y   \n",
       "1185391  (29.93949929, -90.08254765)   3676979   525652  ...             N   \n",
       "1185392  (30.03144398, -90.03588352)   3691379   559251  ...             Y   \n",
       "1185393   (29.98887963, -90.0723514)   3680010   543644  ...             N   \n",
       "1185394  (29.94619458, -90.07857132)   3678211   528101  ...             N   \n",
       "1185395  (30.00342604, -90.05470493)   3685537   548996  ...             N   \n",
       "1185396  (29.92368712, -90.00612279)   3701249   520175  ...             Y   \n",
       "1185397  (30.01760099, -90.06344365)   3682714   554120  ...             N   \n",
       "1185398   (29.9699272, -90.10654572)   3669260   536635  ...             N   \n",
       "1185399  (30.00973449, -90.02090137)   3696210   551411  ...             N   \n",
       "\n",
       "                    TimeArrival              TimeArrive  \\\n",
       "0                           NaN  01/18/2018 02:34:08 AM   \n",
       "1                           NaN  01/26/2018 12:10:34 AM   \n",
       "2                           NaN  01/09/2018 01:00:19 AM   \n",
       "3                           NaN  01/08/2018 01:28:28 AM   \n",
       "4                           NaN                     NaN   \n",
       "5                           NaN  01/06/2018 01:22:42 AM   \n",
       "6                           NaN  06/08/2018 02:55:53 AM   \n",
       "7                           NaN  03/20/2018 02:36:24 AM   \n",
       "8                           NaN                     NaN   \n",
       "9                           NaN  08/04/2018 02:51:50 AM   \n",
       "10                          NaN  02/24/2018 10:05:22 AM   \n",
       "11                          NaN                     NaN   \n",
       "12                          NaN                     NaN   \n",
       "13                          NaN  01/18/2018 09:21:22 AM   \n",
       "14                          NaN                     NaN   \n",
       "15                          NaN  02/15/2018 10:20:07 AM   \n",
       "16                          NaN                     NaN   \n",
       "17                          NaN                     NaN   \n",
       "18                          NaN  01/06/2018 10:55:10 AM   \n",
       "19                          NaN  01/24/2018 11:56:02 AM   \n",
       "20                          NaN  01/24/2018 12:38:00 PM   \n",
       "21                          NaN  01/24/2018 08:02:37 PM   \n",
       "22                          NaN                     NaN   \n",
       "23                          NaN  01/25/2018 05:09:16 PM   \n",
       "24                          NaN                     NaN   \n",
       "25                          NaN  01/25/2018 07:03:35 PM   \n",
       "26                          NaN  01/26/2018 12:32:15 AM   \n",
       "27                          NaN  01/25/2018 01:07:03 PM   \n",
       "28                          NaN  01/25/2018 06:51:25 PM   \n",
       "29                          NaN  01/25/2018 08:49:42 AM   \n",
       "...                         ...                     ...   \n",
       "1185370  09/29/2019 02:27:34 PM                     NaN   \n",
       "1185371  09/29/2019 08:19:55 AM                     NaN   \n",
       "1185372  09/29/2019 01:31:47 AM                     NaN   \n",
       "1185373  09/29/2019 10:03:32 AM                     NaN   \n",
       "1185374  09/29/2019 11:07:20 PM                     NaN   \n",
       "1185375  09/29/2019 05:55:08 PM                     NaN   \n",
       "1185376  09/29/2019 07:47:00 AM                     NaN   \n",
       "1185377  09/29/2019 12:57:57 AM                     NaN   \n",
       "1185378  09/29/2019 11:31:06 AM                     NaN   \n",
       "1185379  09/29/2019 10:10:32 PM                     NaN   \n",
       "1185380  09/29/2019 01:26:02 PM                     NaN   \n",
       "1185381  09/29/2019 05:30:39 AM                     NaN   \n",
       "1185382  09/29/2019 03:13:45 AM                     NaN   \n",
       "1185383  09/29/2019 03:50:21 PM                     NaN   \n",
       "1185384  09/29/2019 01:45:06 PM                     NaN   \n",
       "1185385  09/29/2019 06:13:55 PM                     NaN   \n",
       "1185386                     NaN                     NaN   \n",
       "1185387  09/29/2019 10:43:30 AM                     NaN   \n",
       "1185388                     NaN                     NaN   \n",
       "1185389  09/29/2019 11:33:50 PM                     NaN   \n",
       "1185390  09/29/2019 04:31:26 PM                     NaN   \n",
       "1185391  09/29/2019 10:28:22 AM                     NaN   \n",
       "1185392  09/29/2019 07:35:34 PM                     NaN   \n",
       "1185393  09/29/2019 09:49:39 AM                     NaN   \n",
       "1185394                     NaN                     NaN   \n",
       "1185395  09/29/2019 11:39:17 AM                     NaN   \n",
       "1185396  09/29/2019 03:28:54 AM                     NaN   \n",
       "1185397  09/29/2019 05:04:32 PM                     NaN   \n",
       "1185398  09/29/2019 01:12:07 AM                     NaN   \n",
       "1185399                     NaN                     NaN   \n",
       "\n",
       "                     TimeClosed              TimeCreate  \\\n",
       "0        01/18/2018 03:14:11 AM  01/17/2018 04:10:29 PM   \n",
       "1        01/26/2018 01:23:50 AM  01/25/2018 08:26:48 PM   \n",
       "2        01/09/2018 01:13:35 AM  01/09/2018 01:00:19 AM   \n",
       "3        01/08/2018 04:00:50 AM  01/08/2018 01:24:10 AM   \n",
       "4        01/25/2018 11:18:12 PM  01/25/2018 08:26:53 PM   \n",
       "5        01/06/2018 01:39:05 AM  01/06/2018 01:15:19 AM   \n",
       "6        06/08/2018 03:58:49 AM  06/08/2018 02:53:47 AM   \n",
       "7        03/20/2018 03:32:27 AM  03/20/2018 02:36:24 AM   \n",
       "8        01/01/2018 01:43:08 AM  01/01/2018 01:26:56 AM   \n",
       "9        08/04/2018 03:11:26 AM  08/04/2018 02:51:50 AM   \n",
       "10       02/24/2018 12:38:53 PM  02/24/2018 07:20:59 AM   \n",
       "11       01/27/2018 10:19:22 AM  01/27/2018 05:51:12 AM   \n",
       "12       05/24/2018 07:16:05 AM  05/24/2018 06:30:27 AM   \n",
       "13       01/18/2018 09:25:19 AM  01/18/2018 09:11:46 AM   \n",
       "14       08/26/2018 06:17:36 AM  08/26/2018 05:39:53 AM   \n",
       "15       02/15/2018 02:00:30 PM  02/15/2018 09:12:46 AM   \n",
       "16       03/07/2018 09:25:55 AM  03/07/2018 09:25:13 AM   \n",
       "17       01/29/2018 09:48:00 AM  01/29/2018 09:46:28 AM   \n",
       "18       01/06/2018 11:02:07 AM  01/06/2018 10:55:10 AM   \n",
       "19       01/24/2018 01:01:12 PM  01/24/2018 11:38:27 AM   \n",
       "20       01/24/2018 03:12:51 PM  01/24/2018 12:35:30 PM   \n",
       "21       01/25/2018 01:17:52 AM  01/24/2018 07:11:06 PM   \n",
       "22       01/25/2018 01:33:11 PM  01/25/2018 01:23:59 PM   \n",
       "23       01/25/2018 06:08:52 PM  01/25/2018 05:09:16 PM   \n",
       "24       01/25/2018 01:07:38 AM  01/25/2018 01:07:38 AM   \n",
       "25       01/25/2018 07:11:03 PM  01/25/2018 07:03:25 PM   \n",
       "26       01/26/2018 12:34:06 AM  01/25/2018 03:59:28 PM   \n",
       "27       01/25/2018 01:10:41 PM  01/25/2018 01:07:03 PM   \n",
       "28       01/25/2018 07:16:07 PM  01/25/2018 06:51:25 PM   \n",
       "29       01/25/2018 09:57:32 AM  01/25/2018 08:48:15 AM   \n",
       "...                         ...                     ...   \n",
       "1185370  09/29/2019 02:37:09 PM  09/29/2019 02:22:36 PM   \n",
       "1185371  09/29/2019 09:04:43 AM  09/29/2019 06:27:23 AM   \n",
       "1185372  09/29/2019 01:59:39 AM  09/29/2019 01:31:47 AM   \n",
       "1185373  09/29/2019 11:18:53 AM  09/29/2019 09:57:59 AM   \n",
       "1185374  09/29/2019 11:08:02 PM  09/29/2019 11:07:20 PM   \n",
       "1185375  09/29/2019 09:42:08 PM  09/29/2019 05:55:08 PM   \n",
       "1185376  09/29/2019 07:58:02 AM  09/29/2019 07:11:54 AM   \n",
       "1185377  09/29/2019 01:46:02 AM  09/29/2019 12:57:57 AM   \n",
       "1185378  09/29/2019 12:42:11 PM  09/29/2019 11:31:01 AM   \n",
       "1185379  09/29/2019 10:24:13 PM  09/29/2019 09:58:01 PM   \n",
       "1185380  09/29/2019 01:33:16 PM  09/29/2019 01:17:39 PM   \n",
       "1185381  09/29/2019 06:02:18 AM  09/29/2019 05:30:39 AM   \n",
       "1185382  09/29/2019 03:20:36 AM  09/29/2019 03:13:45 AM   \n",
       "1185383  09/29/2019 06:54:34 PM  09/29/2019 01:54:41 PM   \n",
       "1185384  09/29/2019 02:13:36 PM  09/29/2019 01:45:06 PM   \n",
       "1185385  09/29/2019 06:27:12 PM  09/29/2019 06:07:51 PM   \n",
       "1185386  09/29/2019 11:49:25 AM  09/29/2019 11:47:01 AM   \n",
       "1185387  09/29/2019 11:05:45 AM  09/29/2019 10:19:53 AM   \n",
       "1185388  09/29/2019 03:26:31 AM  09/29/2019 03:23:17 AM   \n",
       "1185389  09/29/2019 11:46:15 PM  09/29/2019 11:12:50 PM   \n",
       "1185390  09/29/2019 05:08:09 PM  09/29/2019 04:31:26 PM   \n",
       "1185391  09/29/2019 11:08:39 AM  09/29/2019 10:23:36 AM   \n",
       "1185392  09/29/2019 07:35:52 PM  09/29/2019 07:35:34 PM   \n",
       "1185393  09/29/2019 10:02:42 AM  09/29/2019 09:37:14 AM   \n",
       "1185394  09/29/2019 07:26:41 AM  09/29/2019 07:20:24 AM   \n",
       "1185395  09/29/2019 11:49:46 AM  09/29/2019 11:27:23 AM   \n",
       "1185396  09/29/2019 05:36:14 AM  09/29/2019 03:28:54 AM   \n",
       "1185397  09/29/2019 05:12:53 PM  09/29/2019 04:54:08 PM   \n",
       "1185398  09/29/2019 01:23:14 AM  09/29/2019 01:09:52 AM   \n",
       "1185399  09/29/2019 06:48:56 PM  09/29/2019 06:46:34 PM   \n",
       "\n",
       "                   TimeDispatch  Type                             TypeText  \\\n",
       "0        01/18/2018 02:21:51 AM   NaN                  THEFT FROM EXTERIOR   \n",
       "1        01/26/2018 12:07:09 AM   NaN                  DISTURBANCE (OTHER)   \n",
       "2        01/09/2018 01:01:47 AM   NaN                     TRAFFIC INCIDENT   \n",
       "3        01/08/2018 01:25:23 AM   NaN                   AGGRAVATED ASSAULT   \n",
       "4                           NaN   NaN                              PROWLER   \n",
       "5        01/06/2018 01:15:56 AM   NaN                              MEDICAL   \n",
       "6        06/08/2018 02:54:30 AM   NaN                       MENTAL PATIENT   \n",
       "7        03/20/2018 02:36:24 AM   NaN                              MEDICAL   \n",
       "8        01/01/2018 01:27:47 AM   NaN                              MEDICAL   \n",
       "9        08/04/2018 02:51:50 AM   NaN                              MEDICAL   \n",
       "10       02/24/2018 09:57:49 AM   NaN                       MENTAL PATIENT   \n",
       "11                          NaN   NaN                       MENTAL PATIENT   \n",
       "12                          NaN   NaN                              MEDICAL   \n",
       "13       01/18/2018 09:16:27 AM   NaN                              SUICIDE   \n",
       "14                          NaN   NaN                  DISTURBANCE (OTHER)   \n",
       "15       02/15/2018 10:13:22 AM   NaN                       SEXUAL BATTERY   \n",
       "16                          NaN   NaN                        AUTO ACCIDENT   \n",
       "17                          NaN   NaN                              MEDICAL   \n",
       "18                          NaN   NaN                     TRAFFIC INCIDENT   \n",
       "19       01/24/2018 11:43:23 AM   NaN                       MENTAL PATIENT   \n",
       "20       01/24/2018 12:36:36 PM   NaN                              SUICIDE   \n",
       "21       01/24/2018 08:02:32 PM   NaN                       THEFT BY FRAUD   \n",
       "22                          NaN   NaN                BURGLAR ALARM, SILENT   \n",
       "23       01/25/2018 05:09:16 PM   NaN           RETURN FOR ADDITIONAL INFO   \n",
       "24                          NaN   NaN                      COMPLAINT OTHER   \n",
       "25       01/25/2018 07:03:25 PM   NaN                      COMPLAINT OTHER   \n",
       "26       01/26/2018 12:32:13 AM   NaN  RECOVERY OF REPORTED STOLEN VEHICLE   \n",
       "27       01/25/2018 01:07:03 PM   NaN                     TRAFFIC INCIDENT   \n",
       "28       01/25/2018 06:51:25 PM   NaN                           AREA CHECK   \n",
       "29       01/25/2018 08:48:54 AM   NaN                        AUTO ACCIDENT   \n",
       "...                         ...   ...                                  ...   \n",
       "1185370  09/29/2019 02:27:27 PM   21P                        LOST PROPERTY   \n",
       "1185371  09/29/2019 08:06:35 AM   62C              SIMPLE BURGLARY VEHICLE   \n",
       "1185372  09/29/2019 01:31:47 AM   22A                           AREA CHECK   \n",
       "1185373  09/29/2019 09:59:19 AM  103M                       MENTAL PATIENT   \n",
       "1185374  09/29/2019 11:07:20 PM    35                       SIMPLE BATTERY   \n",
       "1185375  09/29/2019 05:55:08 PM    21                      COMPLAINT OTHER   \n",
       "1185376  09/29/2019 07:46:55 AM   67C       THEFT FROM EXTERIOR OF VEHICLE   \n",
       "1185377  09/29/2019 12:57:57 AM    TS                         TRAFFIC STOP   \n",
       "1185378  09/29/2019 11:31:01 AM   67F                       THEFT BY FRAUD   \n",
       "1185379  09/29/2019 10:09:44 PM   62A                BURGLAR ALARM, SILENT   \n",
       "1185380  09/29/2019 01:20:48 PM   103                  DISTURBANCE (OTHER)   \n",
       "1185381  09/29/2019 05:30:39 AM    21                      COMPLAINT OTHER   \n",
       "1185382  09/29/2019 03:13:45 AM    TS                         TRAFFIC STOP   \n",
       "1185383  09/29/2019 03:47:43 PM    65                       SIMPLE ROBBERY   \n",
       "1185384  09/29/2019 01:45:06 PM   22A                           AREA CHECK   \n",
       "1185385  09/29/2019 06:10:43 PM   65J                CARJACKING- NO WEAPON   \n",
       "1185386                     NaN    18                     TRAFFIC INCIDENT   \n",
       "1185387  09/29/2019 10:43:21 AM    58           RETURN FOR ADDITIONAL INFO   \n",
       "1185388                     NaN   103                  DISTURBANCE (OTHER)   \n",
       "1185389  09/29/2019 11:23:38 PM   103                  DISTURBANCE (OTHER)   \n",
       "1185390  09/29/2019 04:31:26 PM    18                     TRAFFIC INCIDENT   \n",
       "1185391  09/29/2019 10:24:13 AM   52F                                 FIRE   \n",
       "1185392  09/29/2019 07:35:34 PM    21                      COMPLAINT OTHER   \n",
       "1185393  09/29/2019 09:38:23 AM   62A                BURGLAR ALARM, SILENT   \n",
       "1185394  09/29/2019 07:26:15 AM   106                  OBSCENITY, EXPOSING   \n",
       "1185395  09/29/2019 11:30:10 AM   62A                BURGLAR ALARM, SILENT   \n",
       "1185396  09/29/2019 03:28:54 AM   22A                           AREA CHECK   \n",
       "1185397  09/29/2019 04:57:01 PM    21                      COMPLAINT OTHER   \n",
       "1185398  09/29/2019 01:11:26 AM   64G               ARMED ROBBERY WITH GUN   \n",
       "1185399                     NaN   103                  DISTURBANCE (OTHER)   \n",
       "\n",
       "        Type_    Zip  \n",
       "0         67C    NaN  \n",
       "1         103  70131  \n",
       "2          18    NaN  \n",
       "3          37    NaN  \n",
       "4          63  70112  \n",
       "5          24  70118  \n",
       "6        103M  70113  \n",
       "7          24  70119  \n",
       "8          24  70130  \n",
       "9          24  70112  \n",
       "10       103M  70122  \n",
       "11       103M  70128  \n",
       "12         24  70126  \n",
       "13        29S  70130  \n",
       "14        103    NaN  \n",
       "15        43B    NaN  \n",
       "16         20  70124  \n",
       "17         24  70124  \n",
       "18         18    NaN  \n",
       "19       103M  70114  \n",
       "20        29S  70122  \n",
       "21        67F  70126  \n",
       "22        62A  70119  \n",
       "23         58  70116  \n",
       "24         21  70122  \n",
       "25         21  70116  \n",
       "26        58R  70128  \n",
       "27         18  70127  \n",
       "28        22A    NaN  \n",
       "29         20  70113  \n",
       "...       ...    ...  \n",
       "1185370   NaN  70115  \n",
       "1185371   NaN  70128  \n",
       "1185372   NaN  70124  \n",
       "1185373   NaN  70117  \n",
       "1185374   NaN  70113  \n",
       "1185375   NaN  70113  \n",
       "1185376   NaN  70119  \n",
       "1185377   NaN  70122  \n",
       "1185378   NaN  70130  \n",
       "1185379   NaN  70124  \n",
       "1185380   NaN  70125  \n",
       "1185381   NaN  70116  \n",
       "1185382   NaN  70112  \n",
       "1185383   NaN  70113  \n",
       "1185384   NaN  70119  \n",
       "1185385   NaN  70117  \n",
       "1185386   NaN  70117  \n",
       "1185387   NaN  70119  \n",
       "1185388   NaN  70130  \n",
       "1185389   NaN  70128  \n",
       "1185390   NaN   None  \n",
       "1185391   NaN  70113  \n",
       "1185392   NaN  70126  \n",
       "1185393   NaN  70119  \n",
       "1185394   NaN  70113  \n",
       "1185395   NaN  70122  \n",
       "1185396   NaN  70131  \n",
       "1185397   NaN  70122  \n",
       "1185398   NaN  70119  \n",
       "1185399   NaN  70126  \n",
       "\n",
       "[1185400 rows x 23 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_data"
   ]
  },
  {
   "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.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}