1.DC crime Data set up shared.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Project 5: The Lab @ DC Consulting Project"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The[Lab @ DC](http://thelab.dc.gov/) is an organization within [DC Mayor Muriel Bowser's](https://mayor.dc.gov/biography/muriel-bowser) office that is responsible for testing and evaluating policies and providing analysis to agencies within the DC government. In a word, The Lab is DC's own data science shop.\n",
    "\n",
    "[Eric Foster-Moore](http://thelab.dc.gov/eric.html), a data scientist at The Lab, will help us kick off this project on Thursday, June 14th. He will speak about the types of problems that The Lab seeks to address for the city, the specific questions which are formulated and answered by data scientists at The Lab, and the ways in which their findings are communicated to stakeholders."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Project Title: Washington DC Crime Prediction"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Authors: Eric  Plog, James Linek, Awab Idris,Kiros Gebremariam\n",
    "- Cohorts of the Data Science Immersive, General Assembly @ Washington DC campus"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "In this notebook, we pull the raw data from Open Data DC and the Metropolitan Police Department (MPD) and transform and clean them for our analysis. **This is notebook 1 of 5.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Import the libraries we will need\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "%matplotlib inline\n",
    "\n",
    "import matplotlib.pyplot as plt\n",
    "import math\n",
    "\n",
    "import seaborn as sns\n",
    "sns.set(font_scale=2)\n",
    "cmap = sns.diverging_palette(220, 10, as_cmap=True) # one of the many color mappings"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    " The Data set chosen for this  DC lab project is the 2008-2017 Washington DC crime incident  report inspired from opendataset found at http://opendata.dc.gov/datasets/crime-incidents-in-2017. The dataset was obrained following the steps found in the opendataDc.gov. This site allowed us to download data by year which has been organized by PSA,political wards,ANC for all the Eight wards as csv files. These individual yearly CSVs were the concatenated together in to a single file for use. this data set contains 378,845 entries and 25 attributes that are both continuos and discrete.  The crime dataset is published by the Washington DC Metropolitant Police Department to inform the DC residents with crime trends."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Read in the crime data from the each single year CSV file\n",
    "df1 = pd.read_csv('./input/Crime_Incidents_in_2012.csv')\n",
    "df2 = pd.read_csv('./input/Crime_Incidents_in_2013.csv')\n",
    "df3 = pd.read_csv('./input/Crime_Incidents_in_2014.csv')\n",
    "df4 = pd.read_csv('./input/Crime_Incidents_in_2015.csv')\n",
    "df5 = pd.read_csv('./input/Crime_Incidents_in_2016.csv')\n",
    "df6 = pd.read_csv('./input/Crime_Incidents_in_2017.csv')\n",
    "df7 = pd.read_csv('./input/Crime_Incidents_in_2018.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Index(['X', 'Y', 'CCN', 'REPORT_DAT', 'SHIFT', 'METHOD', 'OFFENSE', 'BLOCK',\n",
      "       'XBLOCK', 'YBLOCK', 'WARD', 'ANC', 'DISTRICT', 'PSA',\n",
      "       'NEIGHBORHOOD_CLUSTER', 'BLOCK_GROUP', 'CENSUS_TRACT',\n",
      "       'VOTING_PRECINCT', 'LATITUDE', 'LONGITUDE', 'BID', 'START_DATE',\n",
      "       'END_DATE', 'OBJECTID'],\n",
      "      dtype='object')\n",
      "Index(['X', 'Y', 'CCN', 'REPORT_DAT', 'SHIFT', 'METHOD', 'OFFENSE', 'BLOCK',\n",
      "       'XBLOCK', 'YBLOCK', 'WARD', 'ANC', 'DISTRICT', 'PSA',\n",
      "       'NEIGHBORHOOD_CLUSTER', 'BLOCK_GROUP', 'CENSUS_TRACT',\n",
      "       'VOTING_PRECINCT', 'LATITUDE', 'LONGITUDE', 'BID', 'START_DATE',\n",
      "       'END_DATE', 'OBJECTID'],\n",
      "      dtype='object')\n",
      "Index(['X', 'Y', 'CCN', 'REPORT_DAT', 'SHIFT', 'METHOD', 'OFFENSE', 'BLOCK',\n",
      "       'XBLOCK', 'YBLOCK', 'WARD', 'ANC', 'DISTRICT', 'PSA',\n",
      "       'NEIGHBORHOOD_CLUSTER', 'BLOCK_GROUP', 'CENSUS_TRACT',\n",
      "       'VOTING_PRECINCT', 'LATITUDE', 'LONGITUDE', 'BID', 'START_DATE',\n",
      "       'END_DATE', 'OBJECTID'],\n",
      "      dtype='object')\n",
      "Index(['X', 'Y', 'CCN', 'REPORT_DAT', 'SHIFT', 'METHOD', 'OFFENSE', 'BLOCK',\n",
      "       'XBLOCK', 'YBLOCK', 'WARD', 'ANC', 'DISTRICT', 'PSA',\n",
      "       'NEIGHBORHOOD_CLUSTER', 'BLOCK_GROUP', 'CENSUS_TRACT',\n",
      "       'VOTING_PRECINCT', 'LATITUDE', 'LONGITUDE', 'BID', 'START_DATE',\n",
      "       'END_DATE', 'OBJECTID'],\n",
      "      dtype='object')\n",
      "Index(['X', 'Y', 'CCN', 'REPORT_DAT', 'SHIFT', 'METHOD', 'OFFENSE', 'BLOCK',\n",
      "       'XBLOCK', 'YBLOCK', 'WARD', 'ANC', 'DISTRICT', 'PSA',\n",
      "       'NEIGHBORHOOD_CLUSTER', 'BLOCK_GROUP', 'CENSUS_TRACT',\n",
      "       'VOTING_PRECINCT', 'LATITUDE', 'LONGITUDE', 'BID', 'START_DATE',\n",
      "       'END_DATE', 'OBJECTID'],\n",
      "      dtype='object')\n",
      "Index(['X', 'Y', 'CCN', 'REPORT_DAT', 'SHIFT', 'METHOD', 'OFFENSE', 'BLOCK',\n",
      "       'XBLOCK', 'YBLOCK', 'WARD', 'ANC', 'DISTRICT', 'PSA',\n",
      "       'NEIGHBORHOOD_CLUSTER', 'BLOCK_GROUP', 'CENSUS_TRACT',\n",
      "       'VOTING_PRECINCT', 'LATITUDE', 'LONGITUDE', 'BID', 'START_DATE',\n",
      "       'END_DATE', 'OBJECTID'],\n",
      "      dtype='object')\n",
      "Index(['X', 'Y', 'CCN', 'REPORT_DAT', 'SHIFT', 'METHOD', 'OFFENSE', 'BLOCK',\n",
      "       'XBLOCK', 'YBLOCK', 'WARD', 'ANC', 'DISTRICT', 'PSA',\n",
      "       'NEIGHBORHOOD_CLUSTER', 'BLOCK_GROUP', 'CENSUS_TRACT',\n",
      "       'VOTING_PRECINCT', 'LATITUDE', 'LONGITUDE', 'BID', 'START_DATE',\n",
      "       'END_DATE', 'OBJECTID'],\n",
      "      dtype='object')\n",
      "Index(['X', 'Y', 'CCN', 'REPORT_DAT', 'SHIFT', 'METHOD', 'OFFENSE', 'BLOCK',\n",
      "       'XBLOCK', 'YBLOCK', 'WARD', 'ANC', 'DISTRICT', 'PSA',\n",
      "       'NEIGHBORHOOD_CLUSTER', 'BLOCK_GROUP', 'CENSUS_TRACT',\n",
      "       'VOTING_PRECINCT', 'LATITUDE', 'LONGITUDE', 'BID', 'START_DATE',\n",
      "       'END_DATE', 'OBJECTID'],\n",
      "      dtype='object')\n"
     ]
    },
    {
     "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>X</th>\n",
       "      <th>Y</th>\n",
       "      <th>CCN</th>\n",
       "      <th>REPORT_DAT</th>\n",
       "      <th>SHIFT</th>\n",
       "      <th>METHOD</th>\n",
       "      <th>OFFENSE</th>\n",
       "      <th>BLOCK</th>\n",
       "      <th>XBLOCK</th>\n",
       "      <th>YBLOCK</th>\n",
       "      <th>...</th>\n",
       "      <th>NEIGHBORHOOD_CLUSTER</th>\n",
       "      <th>BLOCK_GROUP</th>\n",
       "      <th>CENSUS_TRACT</th>\n",
       "      <th>VOTING_PRECINCT</th>\n",
       "      <th>LATITUDE</th>\n",
       "      <th>LONGITUDE</th>\n",
       "      <th>BID</th>\n",
       "      <th>START_DATE</th>\n",
       "      <th>END_DATE</th>\n",
       "      <th>OBJECTID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>-76.999518</td>\n",
       "      <td>38.901924</td>\n",
       "      <td>9074624</td>\n",
       "      <td>2012-04-25T00:00:00.000Z</td>\n",
       "      <td>MIDNIGHT</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>SEX ABUSE</td>\n",
       "      <td>900 - 999 BLOCK OF 5TH STREET NE</td>\n",
       "      <td>400042.0</td>\n",
       "      <td>137118.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 25</td>\n",
       "      <td>010600 2</td>\n",
       "      <td>10600.0</td>\n",
       "      <td>Precinct 83</td>\n",
       "      <td>38.901916</td>\n",
       "      <td>-76.999516</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2009-05-31T23:00:00.000Z</td>\n",
       "      <td>2009-06-01T06:00:00.000Z</td>\n",
       "      <td>167253019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>-76.995541</td>\n",
       "      <td>38.905032</td>\n",
       "      <td>10123633</td>\n",
       "      <td>2012-02-29T00:00:00.000Z</td>\n",
       "      <td>MIDNIGHT</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>SEX ABUSE</td>\n",
       "      <td>700 - 799 BLOCK OF FLORIDA AVENUE NE</td>\n",
       "      <td>400387.0</td>\n",
       "      <td>137463.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 25</td>\n",
       "      <td>010600 1</td>\n",
       "      <td>10600.0</td>\n",
       "      <td>Precinct 83</td>\n",
       "      <td>38.905024</td>\n",
       "      <td>-76.995538</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010-08-27T02:30:00.000Z</td>\n",
       "      <td>2010-08-27T07:15:00.000Z</td>\n",
       "      <td>167274031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>-76.948897</td>\n",
       "      <td>38.885680</td>\n",
       "      <td>11102619</td>\n",
       "      <td>2012-05-14T00:00:00.000Z</td>\n",
       "      <td>MIDNIGHT</td>\n",
       "      <td>GUN</td>\n",
       "      <td>HOMICIDE</td>\n",
       "      <td>153 - 399 BLOCK OF RIDGE ROAD SE</td>\n",
       "      <td>404434.0</td>\n",
       "      <td>135316.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 32</td>\n",
       "      <td>007703 3</td>\n",
       "      <td>7703.0</td>\n",
       "      <td>Precinct 107</td>\n",
       "      <td>38.885672</td>\n",
       "      <td>-76.948894</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2011-07-17T02:28:00.000Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>167293017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>-76.967571</td>\n",
       "      <td>38.855724</td>\n",
       "      <td>11141272</td>\n",
       "      <td>2012-06-25T00:00:00.000Z</td>\n",
       "      <td>MIDNIGHT</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>HOMICIDE</td>\n",
       "      <td>2800 - 2899 BLOCK OF BUENA VISTA TERRACE SE</td>\n",
       "      <td>402815.0</td>\n",
       "      <td>131990.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 36</td>\n",
       "      <td>007502 2</td>\n",
       "      <td>7502.0</td>\n",
       "      <td>Precinct 134</td>\n",
       "      <td>38.855717</td>\n",
       "      <td>-76.967568</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2011-09-26T06:45:00.000Z</td>\n",
       "      <td>2011-09-26T06:55:00.000Z</td>\n",
       "      <td>167296016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>-76.939620</td>\n",
       "      <td>38.910718</td>\n",
       "      <td>11158196</td>\n",
       "      <td>2012-01-05T00:00:00.000Z</td>\n",
       "      <td>MIDNIGHT</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>HOMICIDE</td>\n",
       "      <td>4280 - 4499 BLOCK OF DOUGLAS STREET NE</td>\n",
       "      <td>405237.0</td>\n",
       "      <td>138096.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 29</td>\n",
       "      <td>009601 1</td>\n",
       "      <td>9601.0</td>\n",
       "      <td>Precinct 92</td>\n",
       "      <td>38.910711</td>\n",
       "      <td>-76.939618</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2011-10-27T18:35:00.000Z</td>\n",
       "      <td>2011-10-27T00:00:00.000Z</td>\n",
       "      <td>167299077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>-77.063647</td>\n",
       "      <td>38.909852</td>\n",
       "      <td>12005414</td>\n",
       "      <td>2012-01-11T18:52:00.000Z</td>\n",
       "      <td>EVENING</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT/OTHER</td>\n",
       "      <td>1500 - 1599 BLOCK OF 32ND STREET NW</td>\n",
       "      <td>394480.0</td>\n",
       "      <td>138000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 4</td>\n",
       "      <td>000100 3</td>\n",
       "      <td>100.0</td>\n",
       "      <td>Precinct 5</td>\n",
       "      <td>38.909844</td>\n",
       "      <td>-77.063644</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-01-11T13:00:00.000Z</td>\n",
       "      <td>2012-01-11T13:46:00.000Z</td>\n",
       "      <td>167301753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>-76.948812</td>\n",
       "      <td>38.890886</td>\n",
       "      <td>12005415</td>\n",
       "      <td>2012-01-11T19:05:00.000Z</td>\n",
       "      <td>EVENING</td>\n",
       "      <td>GUN</td>\n",
       "      <td>ASSAULT W/DANGEROUS WEAPON</td>\n",
       "      <td>3900 - 3999 BLOCK OF AMES STREET NE</td>\n",
       "      <td>404441.0</td>\n",
       "      <td>135894.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 32</td>\n",
       "      <td>009603 2</td>\n",
       "      <td>9603.0</td>\n",
       "      <td>Precinct 102</td>\n",
       "      <td>38.890879</td>\n",
       "      <td>-76.948810</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-01-11T19:00:00.000Z</td>\n",
       "      <td>2012-01-11T19:05:00.000Z</td>\n",
       "      <td>167301754</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>-77.001491</td>\n",
       "      <td>38.953424</td>\n",
       "      <td>12005419</td>\n",
       "      <td>2012-01-11T19:27:00.000Z</td>\n",
       "      <td>EVENING</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT/OTHER</td>\n",
       "      <td>5200 - 5299 BLOCK OF 3RD STREET NE</td>\n",
       "      <td>399871.0</td>\n",
       "      <td>142835.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 19</td>\n",
       "      <td>009508 1</td>\n",
       "      <td>9508.0</td>\n",
       "      <td>Precinct 66</td>\n",
       "      <td>38.953417</td>\n",
       "      <td>-77.001488</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-01-11T19:25:00.000Z</td>\n",
       "      <td>2012-01-11T19:27:00.000Z</td>\n",
       "      <td>167301755</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>-77.017293</td>\n",
       "      <td>38.939974</td>\n",
       "      <td>12005430</td>\n",
       "      <td>2012-01-11T19:13:00.000Z</td>\n",
       "      <td>EVENING</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>ROBBERY</td>\n",
       "      <td>SHEPHERD STREET NW AND ILLINOIS AVENUE NW</td>\n",
       "      <td>398501.0</td>\n",
       "      <td>141342.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 18</td>\n",
       "      <td>002301 1</td>\n",
       "      <td>2301.0</td>\n",
       "      <td>Precinct 45</td>\n",
       "      <td>38.939966</td>\n",
       "      <td>-77.017290</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-01-11T16:54:00.000Z</td>\n",
       "      <td>2012-01-11T19:13:00.000Z</td>\n",
       "      <td>167301756</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>-77.042201</td>\n",
       "      <td>38.909213</td>\n",
       "      <td>12005431</td>\n",
       "      <td>2012-01-11T19:03:00.000Z</td>\n",
       "      <td>EVENING</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT F/AUTO</td>\n",
       "      <td>1800 - 1899 BLOCK OF MASSACHUSETTS AVENUE NW</td>\n",
       "      <td>396340.0</td>\n",
       "      <td>137928.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 6</td>\n",
       "      <td>010700 2</td>\n",
       "      <td>10700.0</td>\n",
       "      <td>Precinct 14</td>\n",
       "      <td>38.909205</td>\n",
       "      <td>-77.042199</td>\n",
       "      <td>GOLDEN TRIANGLE</td>\n",
       "      <td>2012-01-11T19:00:00.000Z</td>\n",
       "      <td>2012-01-11T19:01:00.000Z</td>\n",
       "      <td>167301757</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>-76.983794</td>\n",
       "      <td>38.846854</td>\n",
       "      <td>12005442</td>\n",
       "      <td>2012-01-11T17:38:00.000Z</td>\n",
       "      <td>EVENING</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>MOTOR VEHICLE THEFT</td>\n",
       "      <td>1400 - 1499 BLOCK OF CONGRESS PLACE SE</td>\n",
       "      <td>401407.0</td>\n",
       "      <td>131005.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 38</td>\n",
       "      <td>007404 2</td>\n",
       "      <td>7404.0</td>\n",
       "      <td>Precinct 117</td>\n",
       "      <td>38.846847</td>\n",
       "      <td>-76.983792</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-01-11T12:00:00.000Z</td>\n",
       "      <td>2012-01-11T17:30:00.000Z</td>\n",
       "      <td>167301758</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>-77.046228</td>\n",
       "      <td>38.914607</td>\n",
       "      <td>12005450</td>\n",
       "      <td>2012-01-11T20:04:00.000Z</td>\n",
       "      <td>EVENING</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT F/AUTO</td>\n",
       "      <td>1800 - 1818 BLOCK OF CONNECTICUT AVENUE NW</td>\n",
       "      <td>395991.0</td>\n",
       "      <td>138527.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 1</td>\n",
       "      <td>004100 1</td>\n",
       "      <td>4100.0</td>\n",
       "      <td>Precinct 13</td>\n",
       "      <td>38.914600</td>\n",
       "      <td>-77.046226</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-01-11T16:00:00.000Z</td>\n",
       "      <td>2012-01-11T20:04:00.000Z</td>\n",
       "      <td>167301759</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>-76.953854</td>\n",
       "      <td>38.883628</td>\n",
       "      <td>12005453</td>\n",
       "      <td>2012-01-11T20:18:00.000Z</td>\n",
       "      <td>EVENING</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT F/AUTO</td>\n",
       "      <td>3500 - 3699 BLOCK OF ELY PLACE SE</td>\n",
       "      <td>404004.0</td>\n",
       "      <td>135088.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 32</td>\n",
       "      <td>009901 2</td>\n",
       "      <td>9901.0</td>\n",
       "      <td>Precinct 107</td>\n",
       "      <td>38.883620</td>\n",
       "      <td>-76.953852</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-01-11T07:00:00.000Z</td>\n",
       "      <td>2012-01-11T19:00:00.000Z</td>\n",
       "      <td>167301760</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>-77.021263</td>\n",
       "      <td>38.949162</td>\n",
       "      <td>12005488</td>\n",
       "      <td>2012-01-11T19:50:00.000Z</td>\n",
       "      <td>EVENING</td>\n",
       "      <td>GUN</td>\n",
       "      <td>ROBBERY</td>\n",
       "      <td>600  - 699 BLOCK OF DELAFIELD PLACE NW</td>\n",
       "      <td>398157.0</td>\n",
       "      <td>142362.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 18</td>\n",
       "      <td>002201 1</td>\n",
       "      <td>2201.0</td>\n",
       "      <td>Precinct 55</td>\n",
       "      <td>38.949154</td>\n",
       "      <td>-77.021261</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-01-11T19:45:00.000Z</td>\n",
       "      <td>2012-01-11T19:55:00.000Z</td>\n",
       "      <td>167301761</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>-76.981503</td>\n",
       "      <td>38.886248</td>\n",
       "      <td>12005514</td>\n",
       "      <td>2012-01-11T23:05:00.000Z</td>\n",
       "      <td>MIDNIGHT</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT/OTHER</td>\n",
       "      <td>1600 - 1699 BLOCK OF MASSACHUSETTS AVENUE SE</td>\n",
       "      <td>401605.0</td>\n",
       "      <td>135378.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 26</td>\n",
       "      <td>006802 1</td>\n",
       "      <td>6802.0</td>\n",
       "      <td>Precinct 87</td>\n",
       "      <td>38.886240</td>\n",
       "      <td>-76.981501</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-01-11T23:00:00.000Z</td>\n",
       "      <td>2012-01-11T23:05:00.000Z</td>\n",
       "      <td>167301762</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>-76.959487</td>\n",
       "      <td>38.868919</td>\n",
       "      <td>12005529</td>\n",
       "      <td>2012-01-11T23:25:00.000Z</td>\n",
       "      <td>MIDNIGHT</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT/OTHER</td>\n",
       "      <td>3200 - 3299 BLOCK OF PENNSYLVANIA AVENUE SE</td>\n",
       "      <td>403516.0</td>\n",
       "      <td>133455.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 34</td>\n",
       "      <td>007604 2</td>\n",
       "      <td>7604.0</td>\n",
       "      <td>Precinct 109</td>\n",
       "      <td>38.868911</td>\n",
       "      <td>-76.959485</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-01-11T23:20:00.000Z</td>\n",
       "      <td>2012-01-11T23:25:00.000Z</td>\n",
       "      <td>167301763</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>-77.085302</td>\n",
       "      <td>38.959915</td>\n",
       "      <td>12005538</td>\n",
       "      <td>2012-01-11T23:09:00.000Z</td>\n",
       "      <td>MIDNIGHT</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT/OTHER</td>\n",
       "      <td>5300 - 5399 BLOCK OF WISCONSIN AVENUE NW</td>\n",
       "      <td>392607.0</td>\n",
       "      <td>143559.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 11</td>\n",
       "      <td>001001 1</td>\n",
       "      <td>1001.0</td>\n",
       "      <td>Precinct 31</td>\n",
       "      <td>38.959907</td>\n",
       "      <td>-77.085300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-01-11T21:00:00.000Z</td>\n",
       "      <td>2012-01-11T23:15:00.000Z</td>\n",
       "      <td>167301764</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>-76.979876</td>\n",
       "      <td>38.894040</td>\n",
       "      <td>12005568</td>\n",
       "      <td>2012-01-12T02:56:00.000Z</td>\n",
       "      <td>MIDNIGHT</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>MOTOR VEHICLE THEFT</td>\n",
       "      <td>300 - 399 BLOCK OF 17TH PLACE NE</td>\n",
       "      <td>401746.0</td>\n",
       "      <td>136243.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 25</td>\n",
       "      <td>007901 2</td>\n",
       "      <td>7901.0</td>\n",
       "      <td>Precinct 81</td>\n",
       "      <td>38.894032</td>\n",
       "      <td>-76.979873</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-01-11T22:00:00.000Z</td>\n",
       "      <td>2012-01-12T02:30:00.000Z</td>\n",
       "      <td>167301765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>-77.028860</td>\n",
       "      <td>38.905650</td>\n",
       "      <td>12005583</td>\n",
       "      <td>2012-01-12T06:47:00.000Z</td>\n",
       "      <td>MIDNIGHT</td>\n",
       "      <td>GUN</td>\n",
       "      <td>ROBBERY</td>\n",
       "      <td>1200 - 1299 BLOCK OF M STREET NW</td>\n",
       "      <td>397497.0</td>\n",
       "      <td>137532.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 8</td>\n",
       "      <td>005002 1</td>\n",
       "      <td>5002.0</td>\n",
       "      <td>Precinct 17</td>\n",
       "      <td>38.905642</td>\n",
       "      <td>-77.028857</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-01-12T06:44:00.000Z</td>\n",
       "      <td>2012-01-12T06:47:00.000Z</td>\n",
       "      <td>167301766</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>-76.987147</td>\n",
       "      <td>38.907770</td>\n",
       "      <td>12005611</td>\n",
       "      <td>2012-01-12T08:20:00.000Z</td>\n",
       "      <td>DAY</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>BURGLARY</td>\n",
       "      <td>1110 - 1199 BLOCK OF HOLBROOK TERRACE NE</td>\n",
       "      <td>401115.0</td>\n",
       "      <td>137767.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 23</td>\n",
       "      <td>008804 1</td>\n",
       "      <td>8804.0</td>\n",
       "      <td>Precinct 76</td>\n",
       "      <td>38.907762</td>\n",
       "      <td>-76.987145</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-01-12T08:20:00.000Z</td>\n",
       "      <td>2012-01-12T08:20:00.000Z</td>\n",
       "      <td>167301767</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>-77.016283</td>\n",
       "      <td>38.914291</td>\n",
       "      <td>12005618</td>\n",
       "      <td>2012-01-12T09:05:00.000Z</td>\n",
       "      <td>DAY</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT F/AUTO</td>\n",
       "      <td>300 - 399 BLOCK OF RHODE ISLAND AVENUE NW</td>\n",
       "      <td>398588.0</td>\n",
       "      <td>138491.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 21</td>\n",
       "      <td>003400 2</td>\n",
       "      <td>3400.0</td>\n",
       "      <td>Precinct 19</td>\n",
       "      <td>38.914283</td>\n",
       "      <td>-77.016281</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-01-12T09:00:00.000Z</td>\n",
       "      <td>2012-01-12T09:05:00.000Z</td>\n",
       "      <td>167301768</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>-76.999518</td>\n",
       "      <td>38.884907</td>\n",
       "      <td>12005620</td>\n",
       "      <td>2012-01-12T08:34:00.000Z</td>\n",
       "      <td>DAY</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT F/AUTO</td>\n",
       "      <td>300 - 399 BLOCK OF 5TH STREET SE</td>\n",
       "      <td>400042.0</td>\n",
       "      <td>135229.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 26</td>\n",
       "      <td>006500 1</td>\n",
       "      <td>6500.0</td>\n",
       "      <td>Precinct 89</td>\n",
       "      <td>38.884899</td>\n",
       "      <td>-76.999516</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-01-11T19:00:00.000Z</td>\n",
       "      <td>2012-01-12T08:15:00.000Z</td>\n",
       "      <td>167301769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>-76.975118</td>\n",
       "      <td>38.917289</td>\n",
       "      <td>12005626</td>\n",
       "      <td>2012-01-12T09:23:00.000Z</td>\n",
       "      <td>DAY</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT F/AUTO</td>\n",
       "      <td>1800 - 2299 BLOCK OF NEW YORK AVENUE NE</td>\n",
       "      <td>402158.0</td>\n",
       "      <td>138824.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 22</td>\n",
       "      <td>011100 3</td>\n",
       "      <td>11100.0</td>\n",
       "      <td>Precinct 72</td>\n",
       "      <td>38.917282</td>\n",
       "      <td>-76.975116</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-01-12T09:00:00.000Z</td>\n",
       "      <td>2012-01-12T09:20:00.000Z</td>\n",
       "      <td>167301770</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>-77.037252</td>\n",
       "      <td>38.969714</td>\n",
       "      <td>12005634</td>\n",
       "      <td>2012-01-12T09:23:00.000Z</td>\n",
       "      <td>DAY</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT F/AUTO</td>\n",
       "      <td>1600  - 1699 BLOCK OF VAN BUREN STREET NW</td>\n",
       "      <td>396772.0</td>\n",
       "      <td>144644.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 17</td>\n",
       "      <td>001803 1</td>\n",
       "      <td>1803.0</td>\n",
       "      <td>Precinct 61</td>\n",
       "      <td>38.969707</td>\n",
       "      <td>-77.037249</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-01-11T19:15:00.000Z</td>\n",
       "      <td>2012-01-12T07:00:00.000Z</td>\n",
       "      <td>167301771</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>-77.042756</td>\n",
       "      <td>38.911132</td>\n",
       "      <td>12005637</td>\n",
       "      <td>2012-01-12T09:24:00.000Z</td>\n",
       "      <td>DAY</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT F/AUTO</td>\n",
       "      <td>1810 - 1899 BLOCK OF Q STREET NW</td>\n",
       "      <td>396292.0</td>\n",
       "      <td>138141.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 6</td>\n",
       "      <td>004202 1</td>\n",
       "      <td>4202.0</td>\n",
       "      <td>Precinct 14</td>\n",
       "      <td>38.911124</td>\n",
       "      <td>-77.042753</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-01-11T21:00:00.000Z</td>\n",
       "      <td>2012-01-12T08:00:00.000Z</td>\n",
       "      <td>167301772</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>-77.086221</td>\n",
       "      <td>38.956491</td>\n",
       "      <td>12005647</td>\n",
       "      <td>2012-01-12T10:05:00.000Z</td>\n",
       "      <td>DAY</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT F/AUTO</td>\n",
       "      <td>5100 - 5199 BLOCK OF 44TH STREET NW</td>\n",
       "      <td>392527.0</td>\n",
       "      <td>143179.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 11</td>\n",
       "      <td>001001 1</td>\n",
       "      <td>1001.0</td>\n",
       "      <td>Precinct 31</td>\n",
       "      <td>38.956484</td>\n",
       "      <td>-77.086218</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-01-12T07:00:00.000Z</td>\n",
       "      <td>2012-01-12T09:00:00.000Z</td>\n",
       "      <td>167301773</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>-76.988201</td>\n",
       "      <td>38.879240</td>\n",
       "      <td>12005651</td>\n",
       "      <td>2012-01-12T10:07:00.000Z</td>\n",
       "      <td>DAY</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>ROBBERY</td>\n",
       "      <td>1300 - 1307 BLOCK OF POTOMAC AVENUE SE</td>\n",
       "      <td>401024.0</td>\n",
       "      <td>134600.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 26</td>\n",
       "      <td>007100 2</td>\n",
       "      <td>7100.0</td>\n",
       "      <td>Precinct 91</td>\n",
       "      <td>38.879232</td>\n",
       "      <td>-76.988199</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-01-11T15:30:00.000Z</td>\n",
       "      <td>2012-01-11T15:31:00.000Z</td>\n",
       "      <td>167301774</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>-77.026005</td>\n",
       "      <td>38.917559</td>\n",
       "      <td>12005653</td>\n",
       "      <td>2012-01-12T12:00:00.000Z</td>\n",
       "      <td>DAY</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT/OTHER</td>\n",
       "      <td>2000 - 2099 BLOCK OF 10TH STREET NW</td>\n",
       "      <td>397745.0</td>\n",
       "      <td>138854.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 3</td>\n",
       "      <td>004400 1</td>\n",
       "      <td>4400.0</td>\n",
       "      <td>Precinct 22</td>\n",
       "      <td>38.917552</td>\n",
       "      <td>-77.026002</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-01-11T15:10:00.000Z</td>\n",
       "      <td>2012-01-11T15:20:00.000Z</td>\n",
       "      <td>167301775</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>-76.984899</td>\n",
       "      <td>38.907742</td>\n",
       "      <td>12005658</td>\n",
       "      <td>2012-01-12T10:11:00.000Z</td>\n",
       "      <td>DAY</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>BURGLARY</td>\n",
       "      <td>1200 - 1299 BLOCK OF MEIGS PLACE NE</td>\n",
       "      <td>401310.0</td>\n",
       "      <td>137764.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 23</td>\n",
       "      <td>008804 1</td>\n",
       "      <td>8804.0</td>\n",
       "      <td>Precinct 78</td>\n",
       "      <td>38.907734</td>\n",
       "      <td>-76.984896</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-01-12T10:00:00.000Z</td>\n",
       "      <td>2012-01-12T10:03:00.000Z</td>\n",
       "      <td>167301776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>-76.976231</td>\n",
       "      <td>38.934595</td>\n",
       "      <td>12005664</td>\n",
       "      <td>2012-01-12T10:37:00.000Z</td>\n",
       "      <td>DAY</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>MOTOR VEHICLE THEFT</td>\n",
       "      <td>3600 - 3699 BLOCK OF 20TH STREET NE</td>\n",
       "      <td>402061.0</td>\n",
       "      <td>140745.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 22</td>\n",
       "      <td>009400 2</td>\n",
       "      <td>9400.0</td>\n",
       "      <td>Precinct 69</td>\n",
       "      <td>38.934587</td>\n",
       "      <td>-76.976229</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-01-11T21:00:00.000Z</td>\n",
       "      <td>2012-01-12T09:00:00.000Z</td>\n",
       "      <td>167301777</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>231472</th>\n",
       "      <td>-76.949566</td>\n",
       "      <td>38.884842</td>\n",
       "      <td>18027507</td>\n",
       "      <td>2018-02-18T10:36:23.000Z</td>\n",
       "      <td>DAY</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT F/AUTO</td>\n",
       "      <td>3700 - 3899 BLOCK OF D STREET SE</td>\n",
       "      <td>404376.0</td>\n",
       "      <td>135223.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 32</td>\n",
       "      <td>007703 3</td>\n",
       "      <td>7703.0</td>\n",
       "      <td>Precinct 107</td>\n",
       "      <td>38.884834</td>\n",
       "      <td>-76.949563</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-02-17T17:00:10.000Z</td>\n",
       "      <td>2018-02-18T08:30:18.000Z</td>\n",
       "      <td>167949196</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231473</th>\n",
       "      <td>-77.030203</td>\n",
       "      <td>38.946754</td>\n",
       "      <td>18027519</td>\n",
       "      <td>2018-02-18T12:06:20.000Z</td>\n",
       "      <td>DAY</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT F/AUTO</td>\n",
       "      <td>4600  - 4699 BLOCK OF IOWA AVENUE NW</td>\n",
       "      <td>397382.0</td>\n",
       "      <td>142095.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 18</td>\n",
       "      <td>002501 1</td>\n",
       "      <td>2501.0</td>\n",
       "      <td>Precinct 48</td>\n",
       "      <td>38.946747</td>\n",
       "      <td>-77.030201</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-02-18T05:30:42.000Z</td>\n",
       "      <td>2018-02-18T07:00:13.000Z</td>\n",
       "      <td>167949197</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231474</th>\n",
       "      <td>-76.997558</td>\n",
       "      <td>38.909410</td>\n",
       "      <td>18027579</td>\n",
       "      <td>2018-02-18T13:16:42.000Z</td>\n",
       "      <td>DAY</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT F/AUTO</td>\n",
       "      <td>1300 - 1399 BLOCK OF 5TH STREET NE</td>\n",
       "      <td>400212.0</td>\n",
       "      <td>137949.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 23</td>\n",
       "      <td>008803 1</td>\n",
       "      <td>8803.0</td>\n",
       "      <td>Precinct 76</td>\n",
       "      <td>38.909402</td>\n",
       "      <td>-76.997556</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-02-18T12:40:09.000Z</td>\n",
       "      <td>2018-02-18T12:50:11.000Z</td>\n",
       "      <td>167949198</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231475</th>\n",
       "      <td>-77.033266</td>\n",
       "      <td>38.909657</td>\n",
       "      <td>18027601</td>\n",
       "      <td>2018-02-18T14:11:46.000Z</td>\n",
       "      <td>DAY</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT F/AUTO</td>\n",
       "      <td>1400 - 1499 BLOCK OF P STREET NW</td>\n",
       "      <td>397115.0</td>\n",
       "      <td>137977.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 7</td>\n",
       "      <td>005201 3</td>\n",
       "      <td>5201.0</td>\n",
       "      <td>Precinct 16</td>\n",
       "      <td>38.909650</td>\n",
       "      <td>-77.033263</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-02-18T13:23:12.000Z</td>\n",
       "      <td>2018-02-18T13:32:14.000Z</td>\n",
       "      <td>167949199</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231476</th>\n",
       "      <td>-77.032735</td>\n",
       "      <td>38.933719</td>\n",
       "      <td>18027609</td>\n",
       "      <td>2018-02-18T14:32:28.000Z</td>\n",
       "      <td>DAY</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT F/AUTO</td>\n",
       "      <td>3455 - 3474 BLOCK OF 14TH STREET NW</td>\n",
       "      <td>397162.0</td>\n",
       "      <td>140648.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 2</td>\n",
       "      <td>002801 1</td>\n",
       "      <td>2801.0</td>\n",
       "      <td>Precinct 41</td>\n",
       "      <td>38.933711</td>\n",
       "      <td>-77.032732</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-02-17T22:00:10.000Z</td>\n",
       "      <td>2018-02-18T14:00:24.000Z</td>\n",
       "      <td>167949200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231477</th>\n",
       "      <td>-76.954957</td>\n",
       "      <td>38.888790</td>\n",
       "      <td>18027617</td>\n",
       "      <td>2018-02-18T16:44:27.000Z</td>\n",
       "      <td>EVENING</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>BURGLARY</td>\n",
       "      <td>3500 - 3599 BLOCK OF A STREET SE</td>\n",
       "      <td>403908.0</td>\n",
       "      <td>135661.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 32</td>\n",
       "      <td>007708 1</td>\n",
       "      <td>7708.0</td>\n",
       "      <td>Precinct 132</td>\n",
       "      <td>38.888782</td>\n",
       "      <td>-76.954955</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-02-18T13:53:21.000Z</td>\n",
       "      <td>2018-02-18T14:30:20.000Z</td>\n",
       "      <td>167949201</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231478</th>\n",
       "      <td>-76.972198</td>\n",
       "      <td>38.895489</td>\n",
       "      <td>18027623</td>\n",
       "      <td>2018-02-18T17:12:00.000Z</td>\n",
       "      <td>EVENING</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT/OTHER</td>\n",
       "      <td>400 498  BLOCK OF OKLAHOMA AVENUE NE</td>\n",
       "      <td>402412.0</td>\n",
       "      <td>136404.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 25</td>\n",
       "      <td>007903 1</td>\n",
       "      <td>7903.0</td>\n",
       "      <td>Precinct 80</td>\n",
       "      <td>38.895481</td>\n",
       "      <td>-76.972196</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-02-18T13:28:05.000Z</td>\n",
       "      <td>2018-02-18T15:23:26.000Z</td>\n",
       "      <td>167949202</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231479</th>\n",
       "      <td>-76.999472</td>\n",
       "      <td>38.907644</td>\n",
       "      <td>18027641</td>\n",
       "      <td>2018-02-18T18:14:45.000Z</td>\n",
       "      <td>EVENING</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT F/AUTO</td>\n",
       "      <td>400 - 499 BLOCK OF MORSE STREET NE</td>\n",
       "      <td>400046.0</td>\n",
       "      <td>137753.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 23</td>\n",
       "      <td>008803 1</td>\n",
       "      <td>8803.0</td>\n",
       "      <td>Precinct 76</td>\n",
       "      <td>38.907636</td>\n",
       "      <td>-76.999470</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-02-18T14:53:58.000Z</td>\n",
       "      <td>2018-02-18T16:10:07.000Z</td>\n",
       "      <td>167949203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231480</th>\n",
       "      <td>-77.034956</td>\n",
       "      <td>38.948266</td>\n",
       "      <td>18034585</td>\n",
       "      <td>2018-03-02T09:54:16.000Z</td>\n",
       "      <td>DAY</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT F/AUTO</td>\n",
       "      <td>1500  - 1513 BLOCK OF DECATUR STREET NW</td>\n",
       "      <td>396970.0</td>\n",
       "      <td>142263.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 18</td>\n",
       "      <td>002501 2</td>\n",
       "      <td>2501.0</td>\n",
       "      <td>Precinct 48</td>\n",
       "      <td>38.948259</td>\n",
       "      <td>-77.034954</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-03-01T17:45:12.000Z</td>\n",
       "      <td>2018-03-02T08:00:06.000Z</td>\n",
       "      <td>167949204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231481</th>\n",
       "      <td>-77.001710</td>\n",
       "      <td>38.957802</td>\n",
       "      <td>18034595</td>\n",
       "      <td>2018-03-02T10:24:20.000Z</td>\n",
       "      <td>DAY</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT/OTHER</td>\n",
       "      <td>300  - 399 BLOCK OF RIGGS ROAD NE</td>\n",
       "      <td>399852.0</td>\n",
       "      <td>143321.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 19</td>\n",
       "      <td>009505 3</td>\n",
       "      <td>9505.0</td>\n",
       "      <td>Precinct 65</td>\n",
       "      <td>38.957795</td>\n",
       "      <td>-77.001708</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-03-02T09:45:05.000Z</td>\n",
       "      <td>2018-03-02T10:24:10.000Z</td>\n",
       "      <td>167949205</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231482</th>\n",
       "      <td>-77.024938</td>\n",
       "      <td>38.900372</td>\n",
       "      <td>18034625</td>\n",
       "      <td>2018-03-02T20:32:21.000Z</td>\n",
       "      <td>EVENING</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT/OTHER</td>\n",
       "      <td>900 - 999 BLOCK OF PALMER ALLEY NW</td>\n",
       "      <td>397837.0</td>\n",
       "      <td>136946.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 8</td>\n",
       "      <td>005800 1</td>\n",
       "      <td>5800.0</td>\n",
       "      <td>Precinct 129</td>\n",
       "      <td>38.900364</td>\n",
       "      <td>-77.024936</td>\n",
       "      <td>DOWNTOWN</td>\n",
       "      <td>2018-03-01T11:33:13.000Z</td>\n",
       "      <td>2018-03-01T11:34:31.000Z</td>\n",
       "      <td>167949206</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231483</th>\n",
       "      <td>-77.027042</td>\n",
       "      <td>38.916289</td>\n",
       "      <td>18035447</td>\n",
       "      <td>2018-03-03T19:59:06.000Z</td>\n",
       "      <td>EVENING</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT/OTHER</td>\n",
       "      <td>1900 - 1999 BLOCK OF 11TH STREET NW</td>\n",
       "      <td>397655.0</td>\n",
       "      <td>138713.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 3</td>\n",
       "      <td>004400 2</td>\n",
       "      <td>4400.0</td>\n",
       "      <td>Precinct 22</td>\n",
       "      <td>38.916281</td>\n",
       "      <td>-77.027040</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-02-23T14:42:18.000Z</td>\n",
       "      <td>2018-03-03T19:59:05.000Z</td>\n",
       "      <td>167949207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231484</th>\n",
       "      <td>-76.992588</td>\n",
       "      <td>38.918256</td>\n",
       "      <td>18035460</td>\n",
       "      <td>2018-03-03T20:19:20.000Z</td>\n",
       "      <td>EVENING</td>\n",
       "      <td>KNIFE</td>\n",
       "      <td>ROBBERY</td>\n",
       "      <td>901 - 999 BLOCK OF BRENTWOOD ROAD NE</td>\n",
       "      <td>400643.0</td>\n",
       "      <td>138931.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 22</td>\n",
       "      <td>009102 2</td>\n",
       "      <td>9102.0</td>\n",
       "      <td>Precinct 72</td>\n",
       "      <td>38.918248</td>\n",
       "      <td>-76.992585</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-03-03T17:01:17.000Z</td>\n",
       "      <td>2018-03-03T20:19:18.000Z</td>\n",
       "      <td>167949208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231485</th>\n",
       "      <td>-76.962141</td>\n",
       "      <td>38.925988</td>\n",
       "      <td>18035480</td>\n",
       "      <td>2018-03-03T20:17:31.000Z</td>\n",
       "      <td>EVENING</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT/OTHER</td>\n",
       "      <td>3152 - 3195 BLOCK OF BERRY ROAD NE</td>\n",
       "      <td>403283.0</td>\n",
       "      <td>139790.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 24</td>\n",
       "      <td>009000 2</td>\n",
       "      <td>9000.0</td>\n",
       "      <td>Precinct 139</td>\n",
       "      <td>38.925980</td>\n",
       "      <td>-76.962139</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-03-03T19:28:23.000Z</td>\n",
       "      <td>2018-03-03T20:17:29.000Z</td>\n",
       "      <td>167949209</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231486</th>\n",
       "      <td>-77.003758</td>\n",
       "      <td>38.848531</td>\n",
       "      <td>18035504</td>\n",
       "      <td>2018-03-03T21:28:10.000Z</td>\n",
       "      <td>EVENING</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>MOTOR VEHICLE THEFT</td>\n",
       "      <td>225 399  BLOCK OF NEWCOMB STREET SE</td>\n",
       "      <td>399674.0</td>\n",
       "      <td>131191.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 39</td>\n",
       "      <td>010400 2</td>\n",
       "      <td>10400.0</td>\n",
       "      <td>Precinct 123</td>\n",
       "      <td>38.848523</td>\n",
       "      <td>-77.003755</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-03-03T19:30:38.000Z</td>\n",
       "      <td>2018-03-03T20:00:30.000Z</td>\n",
       "      <td>167949210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231487</th>\n",
       "      <td>-77.027565</td>\n",
       "      <td>38.897353</td>\n",
       "      <td>18035531</td>\n",
       "      <td>2018-03-04T02:07:34.000Z</td>\n",
       "      <td>MIDNIGHT</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT/OTHER</td>\n",
       "      <td>1100 - 1199 BLOCK OF F STREET NW</td>\n",
       "      <td>397609.0</td>\n",
       "      <td>136611.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 8</td>\n",
       "      <td>005800 1</td>\n",
       "      <td>5800.0</td>\n",
       "      <td>Precinct 129</td>\n",
       "      <td>38.897346</td>\n",
       "      <td>-77.027563</td>\n",
       "      <td>DOWNTOWN</td>\n",
       "      <td>2018-03-03T21:25:55.000Z</td>\n",
       "      <td>2018-03-03T22:00:22.000Z</td>\n",
       "      <td>167949211</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231488</th>\n",
       "      <td>-76.994212</td>\n",
       "      <td>38.938696</td>\n",
       "      <td>18035584</td>\n",
       "      <td>2018-03-04T00:03:45.000Z</td>\n",
       "      <td>MIDNIGHT</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>ROBBERY</td>\n",
       "      <td>3900 - 3999 BLOCK OF 9TH STREET NE</td>\n",
       "      <td>400502.0</td>\n",
       "      <td>141200.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 20</td>\n",
       "      <td>009504 1</td>\n",
       "      <td>9504.0</td>\n",
       "      <td>Precinct 68</td>\n",
       "      <td>38.938688</td>\n",
       "      <td>-76.994210</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-03-03T22:53:45.000Z</td>\n",
       "      <td>2018-03-03T22:54:26.000Z</td>\n",
       "      <td>167949212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231489</th>\n",
       "      <td>-76.985515</td>\n",
       "      <td>38.883474</td>\n",
       "      <td>18035601</td>\n",
       "      <td>2018-03-04T00:54:24.000Z</td>\n",
       "      <td>MIDNIGHT</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>THEFT/OTHER</td>\n",
       "      <td>400 - 499 BLOCK OF 14TH STREET SE</td>\n",
       "      <td>401257.0</td>\n",
       "      <td>135070.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 26</td>\n",
       "      <td>006900 2</td>\n",
       "      <td>6900.0</td>\n",
       "      <td>Precinct 91</td>\n",
       "      <td>38.883466</td>\n",
       "      <td>-76.985512</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-03-03T22:38:03.000Z</td>\n",
       "      <td>2018-03-04T00:44:09.000Z</td>\n",
       "      <td>167949213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231490</th>\n",
       "      <td>-76.947655</td>\n",
       "      <td>38.896660</td>\n",
       "      <td>18001724</td>\n",
       "      <td>2018-01-04T01:03:43.000Z</td>\n",
       "      <td>MIDNIGHT</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>SEX ABUSE</td>\n",
       "      <td>4000 - 4121 BLOCK OF MINNESOTA AVENUE NE</td>\n",
       "      <td>404541.0</td>\n",
       "      <td>136535.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 30</td>\n",
       "      <td>007803 1</td>\n",
       "      <td>7803.0</td>\n",
       "      <td>Precinct 99</td>\n",
       "      <td>38.896652</td>\n",
       "      <td>-76.947653</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-12-29T20:00:01.000Z</td>\n",
       "      <td>2017-12-30T12:00:56.000Z</td>\n",
       "      <td>167953512</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231491</th>\n",
       "      <td>-76.947655</td>\n",
       "      <td>38.896660</td>\n",
       "      <td>18001724</td>\n",
       "      <td>2018-01-04T01:03:43.000Z</td>\n",
       "      <td>MIDNIGHT</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>SEX ABUSE</td>\n",
       "      <td>4000 - 4121 BLOCK OF MINNESOTA AVENUE NE</td>\n",
       "      <td>404541.0</td>\n",
       "      <td>136535.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 30</td>\n",
       "      <td>007803 1</td>\n",
       "      <td>7803.0</td>\n",
       "      <td>Precinct 99</td>\n",
       "      <td>38.896652</td>\n",
       "      <td>-76.947653</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-12-29T20:00:01.000Z</td>\n",
       "      <td>2017-12-30T12:00:56.000Z</td>\n",
       "      <td>167953513</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231492</th>\n",
       "      <td>-77.004828</td>\n",
       "      <td>38.835153</td>\n",
       "      <td>18067093</td>\n",
       "      <td>2018-05-04T00:00:00.000Z</td>\n",
       "      <td>MIDNIGHT</td>\n",
       "      <td>GUN</td>\n",
       "      <td>HOMICIDE</td>\n",
       "      <td>100 - 147 BLOCK OF WAYNE PLACE SE</td>\n",
       "      <td>399581.0</td>\n",
       "      <td>129706.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 39</td>\n",
       "      <td>009803 3</td>\n",
       "      <td>9803.0</td>\n",
       "      <td>Precinct 124</td>\n",
       "      <td>38.835146</td>\n",
       "      <td>-77.004826</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-04-25T15:24:04.000Z</td>\n",
       "      <td>2018-04-27T18:29:28.000Z</td>\n",
       "      <td>167953514</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231493</th>\n",
       "      <td>-77.004828</td>\n",
       "      <td>38.835153</td>\n",
       "      <td>18067093</td>\n",
       "      <td>2018-05-04T00:00:00.000Z</td>\n",
       "      <td>MIDNIGHT</td>\n",
       "      <td>GUN</td>\n",
       "      <td>HOMICIDE</td>\n",
       "      <td>100 - 147 BLOCK OF WAYNE PLACE SE</td>\n",
       "      <td>399581.0</td>\n",
       "      <td>129706.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 39</td>\n",
       "      <td>009803 3</td>\n",
       "      <td>9803.0</td>\n",
       "      <td>Precinct 124</td>\n",
       "      <td>38.835146</td>\n",
       "      <td>-77.004826</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-04-25T15:24:04.000Z</td>\n",
       "      <td>2018-04-27T18:29:28.000Z</td>\n",
       "      <td>167953515</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231494</th>\n",
       "      <td>-77.020268</td>\n",
       "      <td>38.938811</td>\n",
       "      <td>18067757</td>\n",
       "      <td>2018-04-28T14:58:51.000Z</td>\n",
       "      <td>DAY</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>SEX ABUSE</td>\n",
       "      <td>500  - 699 BLOCK OF RANDOLPH STREET NW</td>\n",
       "      <td>398243.0</td>\n",
       "      <td>141213.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 18</td>\n",
       "      <td>002400 1</td>\n",
       "      <td>2400.0</td>\n",
       "      <td>Precinct 45</td>\n",
       "      <td>38.938803</td>\n",
       "      <td>-77.020266</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-04-27T20:00:18.000Z</td>\n",
       "      <td>2018-04-28T07:00:05.000Z</td>\n",
       "      <td>167954249</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231495</th>\n",
       "      <td>-77.020268</td>\n",
       "      <td>38.938811</td>\n",
       "      <td>18067757</td>\n",
       "      <td>2018-04-28T14:58:51.000Z</td>\n",
       "      <td>DAY</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>SEX ABUSE</td>\n",
       "      <td>500  - 699 BLOCK OF RANDOLPH STREET NW</td>\n",
       "      <td>398243.0</td>\n",
       "      <td>141213.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 18</td>\n",
       "      <td>002400 1</td>\n",
       "      <td>2400.0</td>\n",
       "      <td>Precinct 45</td>\n",
       "      <td>38.938803</td>\n",
       "      <td>-77.020266</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-04-27T20:00:18.000Z</td>\n",
       "      <td>2018-04-28T07:00:05.000Z</td>\n",
       "      <td>167954250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231496</th>\n",
       "      <td>-77.010264</td>\n",
       "      <td>38.911860</td>\n",
       "      <td>85017166</td>\n",
       "      <td>2018-02-27T00:00:00.000Z</td>\n",
       "      <td>MIDNIGHT</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>HOMICIDE</td>\n",
       "      <td>1 - 99 BLOCK OF QUINCY PLACE NW</td>\n",
       "      <td>399110.0</td>\n",
       "      <td>138221.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 21</td>\n",
       "      <td>003302 2</td>\n",
       "      <td>3302.0</td>\n",
       "      <td>Precinct 19</td>\n",
       "      <td>38.911852</td>\n",
       "      <td>-77.010262</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1985-01-11T03:56:21.000Z</td>\n",
       "      <td>1985-01-11T04:00:39.000Z</td>\n",
       "      <td>167954251</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231497</th>\n",
       "      <td>-77.010264</td>\n",
       "      <td>38.911860</td>\n",
       "      <td>85017166</td>\n",
       "      <td>2018-02-27T00:00:00.000Z</td>\n",
       "      <td>MIDNIGHT</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>HOMICIDE</td>\n",
       "      <td>1 - 99 BLOCK OF QUINCY PLACE NW</td>\n",
       "      <td>399110.0</td>\n",
       "      <td>138221.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 21</td>\n",
       "      <td>003302 2</td>\n",
       "      <td>3302.0</td>\n",
       "      <td>Precinct 19</td>\n",
       "      <td>38.911852</td>\n",
       "      <td>-77.010262</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1985-01-11T03:56:21.000Z</td>\n",
       "      <td>1985-01-11T04:00:39.000Z</td>\n",
       "      <td>167954252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231498</th>\n",
       "      <td>-77.005900</td>\n",
       "      <td>38.837613</td>\n",
       "      <td>18070920</td>\n",
       "      <td>2018-05-03T00:00:00.000Z</td>\n",
       "      <td>MIDNIGHT</td>\n",
       "      <td>GUN</td>\n",
       "      <td>HOMICIDE</td>\n",
       "      <td>3700 - 3719 BLOCK OF 1ST STREET SE</td>\n",
       "      <td>399488.0</td>\n",
       "      <td>129979.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 39</td>\n",
       "      <td>009803 3</td>\n",
       "      <td>9803.0</td>\n",
       "      <td>Precinct 124</td>\n",
       "      <td>38.837605</td>\n",
       "      <td>-77.005897</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-05-03T17:04:26.000Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>167954253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231499</th>\n",
       "      <td>-77.005900</td>\n",
       "      <td>38.837613</td>\n",
       "      <td>18070920</td>\n",
       "      <td>2018-05-03T00:00:00.000Z</td>\n",
       "      <td>MIDNIGHT</td>\n",
       "      <td>GUN</td>\n",
       "      <td>HOMICIDE</td>\n",
       "      <td>3700 - 3719 BLOCK OF 1ST STREET SE</td>\n",
       "      <td>399488.0</td>\n",
       "      <td>129979.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 39</td>\n",
       "      <td>009803 3</td>\n",
       "      <td>9803.0</td>\n",
       "      <td>Precinct 124</td>\n",
       "      <td>38.837605</td>\n",
       "      <td>-77.005897</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-05-03T17:04:26.000Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>167954254</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231500</th>\n",
       "      <td>-76.913673</td>\n",
       "      <td>38.895145</td>\n",
       "      <td>18066272</td>\n",
       "      <td>2018-04-26T00:00:00.000Z</td>\n",
       "      <td>MIDNIGHT</td>\n",
       "      <td>GUN</td>\n",
       "      <td>HOMICIDE</td>\n",
       "      <td>400 - 499 BLOCK OF 61ST STREET NE</td>\n",
       "      <td>407489.0</td>\n",
       "      <td>136369.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 31</td>\n",
       "      <td>007808 2</td>\n",
       "      <td>7808.0</td>\n",
       "      <td>Precinct 95</td>\n",
       "      <td>38.895137</td>\n",
       "      <td>-76.913671</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-04-25T23:34:49.000Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>167954255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231501</th>\n",
       "      <td>-76.913673</td>\n",
       "      <td>38.895145</td>\n",
       "      <td>18066272</td>\n",
       "      <td>2018-04-26T00:00:00.000Z</td>\n",
       "      <td>MIDNIGHT</td>\n",
       "      <td>GUN</td>\n",
       "      <td>HOMICIDE</td>\n",
       "      <td>400 - 499 BLOCK OF 61ST STREET NE</td>\n",
       "      <td>407489.0</td>\n",
       "      <td>136369.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 31</td>\n",
       "      <td>007808 2</td>\n",
       "      <td>7808.0</td>\n",
       "      <td>Precinct 95</td>\n",
       "      <td>38.895137</td>\n",
       "      <td>-76.913671</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-04-25T23:34:49.000Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>167954256</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>231502 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                X          Y       CCN                REPORT_DAT     SHIFT  \\\n",
       "0      -76.999518  38.901924   9074624  2012-04-25T00:00:00.000Z  MIDNIGHT   \n",
       "1      -76.995541  38.905032  10123633  2012-02-29T00:00:00.000Z  MIDNIGHT   \n",
       "2      -76.948897  38.885680  11102619  2012-05-14T00:00:00.000Z  MIDNIGHT   \n",
       "3      -76.967571  38.855724  11141272  2012-06-25T00:00:00.000Z  MIDNIGHT   \n",
       "4      -76.939620  38.910718  11158196  2012-01-05T00:00:00.000Z  MIDNIGHT   \n",
       "5      -77.063647  38.909852  12005414  2012-01-11T18:52:00.000Z   EVENING   \n",
       "6      -76.948812  38.890886  12005415  2012-01-11T19:05:00.000Z   EVENING   \n",
       "7      -77.001491  38.953424  12005419  2012-01-11T19:27:00.000Z   EVENING   \n",
       "8      -77.017293  38.939974  12005430  2012-01-11T19:13:00.000Z   EVENING   \n",
       "9      -77.042201  38.909213  12005431  2012-01-11T19:03:00.000Z   EVENING   \n",
       "10     -76.983794  38.846854  12005442  2012-01-11T17:38:00.000Z   EVENING   \n",
       "11     -77.046228  38.914607  12005450  2012-01-11T20:04:00.000Z   EVENING   \n",
       "12     -76.953854  38.883628  12005453  2012-01-11T20:18:00.000Z   EVENING   \n",
       "13     -77.021263  38.949162  12005488  2012-01-11T19:50:00.000Z   EVENING   \n",
       "14     -76.981503  38.886248  12005514  2012-01-11T23:05:00.000Z  MIDNIGHT   \n",
       "15     -76.959487  38.868919  12005529  2012-01-11T23:25:00.000Z  MIDNIGHT   \n",
       "16     -77.085302  38.959915  12005538  2012-01-11T23:09:00.000Z  MIDNIGHT   \n",
       "17     -76.979876  38.894040  12005568  2012-01-12T02:56:00.000Z  MIDNIGHT   \n",
       "18     -77.028860  38.905650  12005583  2012-01-12T06:47:00.000Z  MIDNIGHT   \n",
       "19     -76.987147  38.907770  12005611  2012-01-12T08:20:00.000Z       DAY   \n",
       "20     -77.016283  38.914291  12005618  2012-01-12T09:05:00.000Z       DAY   \n",
       "21     -76.999518  38.884907  12005620  2012-01-12T08:34:00.000Z       DAY   \n",
       "22     -76.975118  38.917289  12005626  2012-01-12T09:23:00.000Z       DAY   \n",
       "23     -77.037252  38.969714  12005634  2012-01-12T09:23:00.000Z       DAY   \n",
       "24     -77.042756  38.911132  12005637  2012-01-12T09:24:00.000Z       DAY   \n",
       "25     -77.086221  38.956491  12005647  2012-01-12T10:05:00.000Z       DAY   \n",
       "26     -76.988201  38.879240  12005651  2012-01-12T10:07:00.000Z       DAY   \n",
       "27     -77.026005  38.917559  12005653  2012-01-12T12:00:00.000Z       DAY   \n",
       "28     -76.984899  38.907742  12005658  2012-01-12T10:11:00.000Z       DAY   \n",
       "29     -76.976231  38.934595  12005664  2012-01-12T10:37:00.000Z       DAY   \n",
       "...           ...        ...       ...                       ...       ...   \n",
       "231472 -76.949566  38.884842  18027507  2018-02-18T10:36:23.000Z       DAY   \n",
       "231473 -77.030203  38.946754  18027519  2018-02-18T12:06:20.000Z       DAY   \n",
       "231474 -76.997558  38.909410  18027579  2018-02-18T13:16:42.000Z       DAY   \n",
       "231475 -77.033266  38.909657  18027601  2018-02-18T14:11:46.000Z       DAY   \n",
       "231476 -77.032735  38.933719  18027609  2018-02-18T14:32:28.000Z       DAY   \n",
       "231477 -76.954957  38.888790  18027617  2018-02-18T16:44:27.000Z   EVENING   \n",
       "231478 -76.972198  38.895489  18027623  2018-02-18T17:12:00.000Z   EVENING   \n",
       "231479 -76.999472  38.907644  18027641  2018-02-18T18:14:45.000Z   EVENING   \n",
       "231480 -77.034956  38.948266  18034585  2018-03-02T09:54:16.000Z       DAY   \n",
       "231481 -77.001710  38.957802  18034595  2018-03-02T10:24:20.000Z       DAY   \n",
       "231482 -77.024938  38.900372  18034625  2018-03-02T20:32:21.000Z   EVENING   \n",
       "231483 -77.027042  38.916289  18035447  2018-03-03T19:59:06.000Z   EVENING   \n",
       "231484 -76.992588  38.918256  18035460  2018-03-03T20:19:20.000Z   EVENING   \n",
       "231485 -76.962141  38.925988  18035480  2018-03-03T20:17:31.000Z   EVENING   \n",
       "231486 -77.003758  38.848531  18035504  2018-03-03T21:28:10.000Z   EVENING   \n",
       "231487 -77.027565  38.897353  18035531  2018-03-04T02:07:34.000Z  MIDNIGHT   \n",
       "231488 -76.994212  38.938696  18035584  2018-03-04T00:03:45.000Z  MIDNIGHT   \n",
       "231489 -76.985515  38.883474  18035601  2018-03-04T00:54:24.000Z  MIDNIGHT   \n",
       "231490 -76.947655  38.896660  18001724  2018-01-04T01:03:43.000Z  MIDNIGHT   \n",
       "231491 -76.947655  38.896660  18001724  2018-01-04T01:03:43.000Z  MIDNIGHT   \n",
       "231492 -77.004828  38.835153  18067093  2018-05-04T00:00:00.000Z  MIDNIGHT   \n",
       "231493 -77.004828  38.835153  18067093  2018-05-04T00:00:00.000Z  MIDNIGHT   \n",
       "231494 -77.020268  38.938811  18067757  2018-04-28T14:58:51.000Z       DAY   \n",
       "231495 -77.020268  38.938811  18067757  2018-04-28T14:58:51.000Z       DAY   \n",
       "231496 -77.010264  38.911860  85017166  2018-02-27T00:00:00.000Z  MIDNIGHT   \n",
       "231497 -77.010264  38.911860  85017166  2018-02-27T00:00:00.000Z  MIDNIGHT   \n",
       "231498 -77.005900  38.837613  18070920  2018-05-03T00:00:00.000Z  MIDNIGHT   \n",
       "231499 -77.005900  38.837613  18070920  2018-05-03T00:00:00.000Z  MIDNIGHT   \n",
       "231500 -76.913673  38.895145  18066272  2018-04-26T00:00:00.000Z  MIDNIGHT   \n",
       "231501 -76.913673  38.895145  18066272  2018-04-26T00:00:00.000Z  MIDNIGHT   \n",
       "\n",
       "        METHOD                     OFFENSE  \\\n",
       "0       OTHERS                   SEX ABUSE   \n",
       "1       OTHERS                   SEX ABUSE   \n",
       "2          GUN                    HOMICIDE   \n",
       "3       OTHERS                    HOMICIDE   \n",
       "4       OTHERS                    HOMICIDE   \n",
       "5       OTHERS                 THEFT/OTHER   \n",
       "6          GUN  ASSAULT W/DANGEROUS WEAPON   \n",
       "7       OTHERS                 THEFT/OTHER   \n",
       "8       OTHERS                     ROBBERY   \n",
       "9       OTHERS                THEFT F/AUTO   \n",
       "10      OTHERS         MOTOR VEHICLE THEFT   \n",
       "11      OTHERS                THEFT F/AUTO   \n",
       "12      OTHERS                THEFT F/AUTO   \n",
       "13         GUN                     ROBBERY   \n",
       "14      OTHERS                 THEFT/OTHER   \n",
       "15      OTHERS                 THEFT/OTHER   \n",
       "16      OTHERS                 THEFT/OTHER   \n",
       "17      OTHERS         MOTOR VEHICLE THEFT   \n",
       "18         GUN                     ROBBERY   \n",
       "19      OTHERS                    BURGLARY   \n",
       "20      OTHERS                THEFT F/AUTO   \n",
       "21      OTHERS                THEFT F/AUTO   \n",
       "22      OTHERS                THEFT F/AUTO   \n",
       "23      OTHERS                THEFT F/AUTO   \n",
       "24      OTHERS                THEFT F/AUTO   \n",
       "25      OTHERS                THEFT F/AUTO   \n",
       "26      OTHERS                     ROBBERY   \n",
       "27      OTHERS                 THEFT/OTHER   \n",
       "28      OTHERS                    BURGLARY   \n",
       "29      OTHERS         MOTOR VEHICLE THEFT   \n",
       "...        ...                         ...   \n",
       "231472  OTHERS                THEFT F/AUTO   \n",
       "231473  OTHERS                THEFT F/AUTO   \n",
       "231474  OTHERS                THEFT F/AUTO   \n",
       "231475  OTHERS                THEFT F/AUTO   \n",
       "231476  OTHERS                THEFT F/AUTO   \n",
       "231477  OTHERS                    BURGLARY   \n",
       "231478  OTHERS                 THEFT/OTHER   \n",
       "231479  OTHERS                THEFT F/AUTO   \n",
       "231480  OTHERS                THEFT F/AUTO   \n",
       "231481  OTHERS                 THEFT/OTHER   \n",
       "231482  OTHERS                 THEFT/OTHER   \n",
       "231483  OTHERS                 THEFT/OTHER   \n",
       "231484   KNIFE                     ROBBERY   \n",
       "231485  OTHERS                 THEFT/OTHER   \n",
       "231486  OTHERS         MOTOR VEHICLE THEFT   \n",
       "231487  OTHERS                 THEFT/OTHER   \n",
       "231488  OTHERS                     ROBBERY   \n",
       "231489  OTHERS                 THEFT/OTHER   \n",
       "231490  OTHERS                   SEX ABUSE   \n",
       "231491  OTHERS                   SEX ABUSE   \n",
       "231492     GUN                    HOMICIDE   \n",
       "231493     GUN                    HOMICIDE   \n",
       "231494  OTHERS                   SEX ABUSE   \n",
       "231495  OTHERS                   SEX ABUSE   \n",
       "231496  OTHERS                    HOMICIDE   \n",
       "231497  OTHERS                    HOMICIDE   \n",
       "231498     GUN                    HOMICIDE   \n",
       "231499     GUN                    HOMICIDE   \n",
       "231500     GUN                    HOMICIDE   \n",
       "231501     GUN                    HOMICIDE   \n",
       "\n",
       "                                               BLOCK    XBLOCK    YBLOCK  \\\n",
       "0                   900 - 999 BLOCK OF 5TH STREET NE  400042.0  137118.0   \n",
       "1               700 - 799 BLOCK OF FLORIDA AVENUE NE  400387.0  137463.0   \n",
       "2                   153 - 399 BLOCK OF RIDGE ROAD SE  404434.0  135316.0   \n",
       "3        2800 - 2899 BLOCK OF BUENA VISTA TERRACE SE  402815.0  131990.0   \n",
       "4             4280 - 4499 BLOCK OF DOUGLAS STREET NE  405237.0  138096.0   \n",
       "5                1500 - 1599 BLOCK OF 32ND STREET NW  394480.0  138000.0   \n",
       "6                3900 - 3999 BLOCK OF AMES STREET NE  404441.0  135894.0   \n",
       "7                 5200 - 5299 BLOCK OF 3RD STREET NE  399871.0  142835.0   \n",
       "8          SHEPHERD STREET NW AND ILLINOIS AVENUE NW  398501.0  141342.0   \n",
       "9       1800 - 1899 BLOCK OF MASSACHUSETTS AVENUE NW  396340.0  137928.0   \n",
       "10            1400 - 1499 BLOCK OF CONGRESS PLACE SE  401407.0  131005.0   \n",
       "11        1800 - 1818 BLOCK OF CONNECTICUT AVENUE NW  395991.0  138527.0   \n",
       "12                 3500 - 3699 BLOCK OF ELY PLACE SE  404004.0  135088.0   \n",
       "13            600  - 699 BLOCK OF DELAFIELD PLACE NW  398157.0  142362.0   \n",
       "14      1600 - 1699 BLOCK OF MASSACHUSETTS AVENUE SE  401605.0  135378.0   \n",
       "15       3200 - 3299 BLOCK OF PENNSYLVANIA AVENUE SE  403516.0  133455.0   \n",
       "16          5300 - 5399 BLOCK OF WISCONSIN AVENUE NW  392607.0  143559.0   \n",
       "17                  300 - 399 BLOCK OF 17TH PLACE NE  401746.0  136243.0   \n",
       "18                  1200 - 1299 BLOCK OF M STREET NW  397497.0  137532.0   \n",
       "19          1110 - 1199 BLOCK OF HOLBROOK TERRACE NE  401115.0  137767.0   \n",
       "20         300 - 399 BLOCK OF RHODE ISLAND AVENUE NW  398588.0  138491.0   \n",
       "21                  300 - 399 BLOCK OF 5TH STREET SE  400042.0  135229.0   \n",
       "22           1800 - 2299 BLOCK OF NEW YORK AVENUE NE  402158.0  138824.0   \n",
       "23         1600  - 1699 BLOCK OF VAN BUREN STREET NW  396772.0  144644.0   \n",
       "24                  1810 - 1899 BLOCK OF Q STREET NW  396292.0  138141.0   \n",
       "25               5100 - 5199 BLOCK OF 44TH STREET NW  392527.0  143179.0   \n",
       "26            1300 - 1307 BLOCK OF POTOMAC AVENUE SE  401024.0  134600.0   \n",
       "27               2000 - 2099 BLOCK OF 10TH STREET NW  397745.0  138854.0   \n",
       "28               1200 - 1299 BLOCK OF MEIGS PLACE NE  401310.0  137764.0   \n",
       "29               3600 - 3699 BLOCK OF 20TH STREET NE  402061.0  140745.0   \n",
       "...                                              ...       ...       ...   \n",
       "231472              3700 - 3899 BLOCK OF D STREET SE  404376.0  135223.0   \n",
       "231473          4600  - 4699 BLOCK OF IOWA AVENUE NW  397382.0  142095.0   \n",
       "231474            1300 - 1399 BLOCK OF 5TH STREET NE  400212.0  137949.0   \n",
       "231475              1400 - 1499 BLOCK OF P STREET NW  397115.0  137977.0   \n",
       "231476           3455 - 3474 BLOCK OF 14TH STREET NW  397162.0  140648.0   \n",
       "231477              3500 - 3599 BLOCK OF A STREET SE  403908.0  135661.0   \n",
       "231478          400 498  BLOCK OF OKLAHOMA AVENUE NE  402412.0  136404.0   \n",
       "231479            400 - 499 BLOCK OF MORSE STREET NE  400046.0  137753.0   \n",
       "231480       1500  - 1513 BLOCK OF DECATUR STREET NW  396970.0  142263.0   \n",
       "231481             300  - 399 BLOCK OF RIGGS ROAD NE  399852.0  143321.0   \n",
       "231482            900 - 999 BLOCK OF PALMER ALLEY NW  397837.0  136946.0   \n",
       "231483           1900 - 1999 BLOCK OF 11TH STREET NW  397655.0  138713.0   \n",
       "231484          901 - 999 BLOCK OF BRENTWOOD ROAD NE  400643.0  138931.0   \n",
       "231485            3152 - 3195 BLOCK OF BERRY ROAD NE  403283.0  139790.0   \n",
       "231486           225 399  BLOCK OF NEWCOMB STREET SE  399674.0  131191.0   \n",
       "231487              1100 - 1199 BLOCK OF F STREET NW  397609.0  136611.0   \n",
       "231488            3900 - 3999 BLOCK OF 9TH STREET NE  400502.0  141200.0   \n",
       "231489             400 - 499 BLOCK OF 14TH STREET SE  401257.0  135070.0   \n",
       "231490      4000 - 4121 BLOCK OF MINNESOTA AVENUE NE  404541.0  136535.0   \n",
       "231491      4000 - 4121 BLOCK OF MINNESOTA AVENUE NE  404541.0  136535.0   \n",
       "231492             100 - 147 BLOCK OF WAYNE PLACE SE  399581.0  129706.0   \n",
       "231493             100 - 147 BLOCK OF WAYNE PLACE SE  399581.0  129706.0   \n",
       "231494        500  - 699 BLOCK OF RANDOLPH STREET NW  398243.0  141213.0   \n",
       "231495        500  - 699 BLOCK OF RANDOLPH STREET NW  398243.0  141213.0   \n",
       "231496               1 - 99 BLOCK OF QUINCY PLACE NW  399110.0  138221.0   \n",
       "231497               1 - 99 BLOCK OF QUINCY PLACE NW  399110.0  138221.0   \n",
       "231498            3700 - 3719 BLOCK OF 1ST STREET SE  399488.0  129979.0   \n",
       "231499            3700 - 3719 BLOCK OF 1ST STREET SE  399488.0  129979.0   \n",
       "231500             400 - 499 BLOCK OF 61ST STREET NE  407489.0  136369.0   \n",
       "231501             400 - 499 BLOCK OF 61ST STREET NE  407489.0  136369.0   \n",
       "\n",
       "          ...      NEIGHBORHOOD_CLUSTER BLOCK_GROUP  CENSUS_TRACT  \\\n",
       "0         ...                Cluster 25    010600 2       10600.0   \n",
       "1         ...                Cluster 25    010600 1       10600.0   \n",
       "2         ...                Cluster 32    007703 3        7703.0   \n",
       "3         ...                Cluster 36    007502 2        7502.0   \n",
       "4         ...                Cluster 29    009601 1        9601.0   \n",
       "5         ...                 Cluster 4    000100 3         100.0   \n",
       "6         ...                Cluster 32    009603 2        9603.0   \n",
       "7         ...                Cluster 19    009508 1        9508.0   \n",
       "8         ...                Cluster 18    002301 1        2301.0   \n",
       "9         ...                 Cluster 6    010700 2       10700.0   \n",
       "10        ...                Cluster 38    007404 2        7404.0   \n",
       "11        ...                 Cluster 1    004100 1        4100.0   \n",
       "12        ...                Cluster 32    009901 2        9901.0   \n",
       "13        ...                Cluster 18    002201 1        2201.0   \n",
       "14        ...                Cluster 26    006802 1        6802.0   \n",
       "15        ...                Cluster 34    007604 2        7604.0   \n",
       "16        ...                Cluster 11    001001 1        1001.0   \n",
       "17        ...                Cluster 25    007901 2        7901.0   \n",
       "18        ...                 Cluster 8    005002 1        5002.0   \n",
       "19        ...                Cluster 23    008804 1        8804.0   \n",
       "20        ...                Cluster 21    003400 2        3400.0   \n",
       "21        ...                Cluster 26    006500 1        6500.0   \n",
       "22        ...                Cluster 22    011100 3       11100.0   \n",
       "23        ...                Cluster 17    001803 1        1803.0   \n",
       "24        ...                 Cluster 6    004202 1        4202.0   \n",
       "25        ...                Cluster 11    001001 1        1001.0   \n",
       "26        ...                Cluster 26    007100 2        7100.0   \n",
       "27        ...                 Cluster 3    004400 1        4400.0   \n",
       "28        ...                Cluster 23    008804 1        8804.0   \n",
       "29        ...                Cluster 22    009400 2        9400.0   \n",
       "...       ...                       ...         ...           ...   \n",
       "231472    ...                Cluster 32    007703 3        7703.0   \n",
       "231473    ...                Cluster 18    002501 1        2501.0   \n",
       "231474    ...                Cluster 23    008803 1        8803.0   \n",
       "231475    ...                 Cluster 7    005201 3        5201.0   \n",
       "231476    ...                 Cluster 2    002801 1        2801.0   \n",
       "231477    ...                Cluster 32    007708 1        7708.0   \n",
       "231478    ...                Cluster 25    007903 1        7903.0   \n",
       "231479    ...                Cluster 23    008803 1        8803.0   \n",
       "231480    ...                Cluster 18    002501 2        2501.0   \n",
       "231481    ...                Cluster 19    009505 3        9505.0   \n",
       "231482    ...                 Cluster 8    005800 1        5800.0   \n",
       "231483    ...                 Cluster 3    004400 2        4400.0   \n",
       "231484    ...                Cluster 22    009102 2        9102.0   \n",
       "231485    ...                Cluster 24    009000 2        9000.0   \n",
       "231486    ...                Cluster 39    010400 2       10400.0   \n",
       "231487    ...                 Cluster 8    005800 1        5800.0   \n",
       "231488    ...                Cluster 20    009504 1        9504.0   \n",
       "231489    ...                Cluster 26    006900 2        6900.0   \n",
       "231490    ...                Cluster 30    007803 1        7803.0   \n",
       "231491    ...                Cluster 30    007803 1        7803.0   \n",
       "231492    ...                Cluster 39    009803 3        9803.0   \n",
       "231493    ...                Cluster 39    009803 3        9803.0   \n",
       "231494    ...                Cluster 18    002400 1        2400.0   \n",
       "231495    ...                Cluster 18    002400 1        2400.0   \n",
       "231496    ...                Cluster 21    003302 2        3302.0   \n",
       "231497    ...                Cluster 21    003302 2        3302.0   \n",
       "231498    ...                Cluster 39    009803 3        9803.0   \n",
       "231499    ...                Cluster 39    009803 3        9803.0   \n",
       "231500    ...                Cluster 31    007808 2        7808.0   \n",
       "231501    ...                Cluster 31    007808 2        7808.0   \n",
       "\n",
       "        VOTING_PRECINCT   LATITUDE  LONGITUDE              BID  \\\n",
       "0           Precinct 83  38.901916 -76.999516              NaN   \n",
       "1           Precinct 83  38.905024 -76.995538              NaN   \n",
       "2          Precinct 107  38.885672 -76.948894              NaN   \n",
       "3          Precinct 134  38.855717 -76.967568              NaN   \n",
       "4           Precinct 92  38.910711 -76.939618              NaN   \n",
       "5            Precinct 5  38.909844 -77.063644              NaN   \n",
       "6          Precinct 102  38.890879 -76.948810              NaN   \n",
       "7           Precinct 66  38.953417 -77.001488              NaN   \n",
       "8           Precinct 45  38.939966 -77.017290              NaN   \n",
       "9           Precinct 14  38.909205 -77.042199  GOLDEN TRIANGLE   \n",
       "10         Precinct 117  38.846847 -76.983792              NaN   \n",
       "11          Precinct 13  38.914600 -77.046226              NaN   \n",
       "12         Precinct 107  38.883620 -76.953852              NaN   \n",
       "13          Precinct 55  38.949154 -77.021261              NaN   \n",
       "14          Precinct 87  38.886240 -76.981501              NaN   \n",
       "15         Precinct 109  38.868911 -76.959485              NaN   \n",
       "16          Precinct 31  38.959907 -77.085300              NaN   \n",
       "17          Precinct 81  38.894032 -76.979873              NaN   \n",
       "18          Precinct 17  38.905642 -77.028857              NaN   \n",
       "19          Precinct 76  38.907762 -76.987145              NaN   \n",
       "20          Precinct 19  38.914283 -77.016281              NaN   \n",
       "21          Precinct 89  38.884899 -76.999516              NaN   \n",
       "22          Precinct 72  38.917282 -76.975116              NaN   \n",
       "23          Precinct 61  38.969707 -77.037249              NaN   \n",
       "24          Precinct 14  38.911124 -77.042753              NaN   \n",
       "25          Precinct 31  38.956484 -77.086218              NaN   \n",
       "26          Precinct 91  38.879232 -76.988199              NaN   \n",
       "27          Precinct 22  38.917552 -77.026002              NaN   \n",
       "28          Precinct 78  38.907734 -76.984896              NaN   \n",
       "29          Precinct 69  38.934587 -76.976229              NaN   \n",
       "...                 ...        ...        ...              ...   \n",
       "231472     Precinct 107  38.884834 -76.949563              NaN   \n",
       "231473      Precinct 48  38.946747 -77.030201              NaN   \n",
       "231474      Precinct 76  38.909402 -76.997556              NaN   \n",
       "231475      Precinct 16  38.909650 -77.033263              NaN   \n",
       "231476      Precinct 41  38.933711 -77.032732              NaN   \n",
       "231477     Precinct 132  38.888782 -76.954955              NaN   \n",
       "231478      Precinct 80  38.895481 -76.972196              NaN   \n",
       "231479      Precinct 76  38.907636 -76.999470              NaN   \n",
       "231480      Precinct 48  38.948259 -77.034954              NaN   \n",
       "231481      Precinct 65  38.957795 -77.001708              NaN   \n",
       "231482     Precinct 129  38.900364 -77.024936         DOWNTOWN   \n",
       "231483      Precinct 22  38.916281 -77.027040              NaN   \n",
       "231484      Precinct 72  38.918248 -76.992585              NaN   \n",
       "231485     Precinct 139  38.925980 -76.962139              NaN   \n",
       "231486     Precinct 123  38.848523 -77.003755              NaN   \n",
       "231487     Precinct 129  38.897346 -77.027563         DOWNTOWN   \n",
       "231488      Precinct 68  38.938688 -76.994210              NaN   \n",
       "231489      Precinct 91  38.883466 -76.985512              NaN   \n",
       "231490      Precinct 99  38.896652 -76.947653              NaN   \n",
       "231491      Precinct 99  38.896652 -76.947653              NaN   \n",
       "231492     Precinct 124  38.835146 -77.004826              NaN   \n",
       "231493     Precinct 124  38.835146 -77.004826              NaN   \n",
       "231494      Precinct 45  38.938803 -77.020266              NaN   \n",
       "231495      Precinct 45  38.938803 -77.020266              NaN   \n",
       "231496      Precinct 19  38.911852 -77.010262              NaN   \n",
       "231497      Precinct 19  38.911852 -77.010262              NaN   \n",
       "231498     Precinct 124  38.837605 -77.005897              NaN   \n",
       "231499     Precinct 124  38.837605 -77.005897              NaN   \n",
       "231500      Precinct 95  38.895137 -76.913671              NaN   \n",
       "231501      Precinct 95  38.895137 -76.913671              NaN   \n",
       "\n",
       "                      START_DATE                  END_DATE   OBJECTID  \n",
       "0       2009-05-31T23:00:00.000Z  2009-06-01T06:00:00.000Z  167253019  \n",
       "1       2010-08-27T02:30:00.000Z  2010-08-27T07:15:00.000Z  167274031  \n",
       "2       2011-07-17T02:28:00.000Z                       NaN  167293017  \n",
       "3       2011-09-26T06:45:00.000Z  2011-09-26T06:55:00.000Z  167296016  \n",
       "4       2011-10-27T18:35:00.000Z  2011-10-27T00:00:00.000Z  167299077  \n",
       "5       2012-01-11T13:00:00.000Z  2012-01-11T13:46:00.000Z  167301753  \n",
       "6       2012-01-11T19:00:00.000Z  2012-01-11T19:05:00.000Z  167301754  \n",
       "7       2012-01-11T19:25:00.000Z  2012-01-11T19:27:00.000Z  167301755  \n",
       "8       2012-01-11T16:54:00.000Z  2012-01-11T19:13:00.000Z  167301756  \n",
       "9       2012-01-11T19:00:00.000Z  2012-01-11T19:01:00.000Z  167301757  \n",
       "10      2012-01-11T12:00:00.000Z  2012-01-11T17:30:00.000Z  167301758  \n",
       "11      2012-01-11T16:00:00.000Z  2012-01-11T20:04:00.000Z  167301759  \n",
       "12      2012-01-11T07:00:00.000Z  2012-01-11T19:00:00.000Z  167301760  \n",
       "13      2012-01-11T19:45:00.000Z  2012-01-11T19:55:00.000Z  167301761  \n",
       "14      2012-01-11T23:00:00.000Z  2012-01-11T23:05:00.000Z  167301762  \n",
       "15      2012-01-11T23:20:00.000Z  2012-01-11T23:25:00.000Z  167301763  \n",
       "16      2012-01-11T21:00:00.000Z  2012-01-11T23:15:00.000Z  167301764  \n",
       "17      2012-01-11T22:00:00.000Z  2012-01-12T02:30:00.000Z  167301765  \n",
       "18      2012-01-12T06:44:00.000Z  2012-01-12T06:47:00.000Z  167301766  \n",
       "19      2012-01-12T08:20:00.000Z  2012-01-12T08:20:00.000Z  167301767  \n",
       "20      2012-01-12T09:00:00.000Z  2012-01-12T09:05:00.000Z  167301768  \n",
       "21      2012-01-11T19:00:00.000Z  2012-01-12T08:15:00.000Z  167301769  \n",
       "22      2012-01-12T09:00:00.000Z  2012-01-12T09:20:00.000Z  167301770  \n",
       "23      2012-01-11T19:15:00.000Z  2012-01-12T07:00:00.000Z  167301771  \n",
       "24      2012-01-11T21:00:00.000Z  2012-01-12T08:00:00.000Z  167301772  \n",
       "25      2012-01-12T07:00:00.000Z  2012-01-12T09:00:00.000Z  167301773  \n",
       "26      2012-01-11T15:30:00.000Z  2012-01-11T15:31:00.000Z  167301774  \n",
       "27      2012-01-11T15:10:00.000Z  2012-01-11T15:20:00.000Z  167301775  \n",
       "28      2012-01-12T10:00:00.000Z  2012-01-12T10:03:00.000Z  167301776  \n",
       "29      2012-01-11T21:00:00.000Z  2012-01-12T09:00:00.000Z  167301777  \n",
       "...                          ...                       ...        ...  \n",
       "231472  2018-02-17T17:00:10.000Z  2018-02-18T08:30:18.000Z  167949196  \n",
       "231473  2018-02-18T05:30:42.000Z  2018-02-18T07:00:13.000Z  167949197  \n",
       "231474  2018-02-18T12:40:09.000Z  2018-02-18T12:50:11.000Z  167949198  \n",
       "231475  2018-02-18T13:23:12.000Z  2018-02-18T13:32:14.000Z  167949199  \n",
       "231476  2018-02-17T22:00:10.000Z  2018-02-18T14:00:24.000Z  167949200  \n",
       "231477  2018-02-18T13:53:21.000Z  2018-02-18T14:30:20.000Z  167949201  \n",
       "231478  2018-02-18T13:28:05.000Z  2018-02-18T15:23:26.000Z  167949202  \n",
       "231479  2018-02-18T14:53:58.000Z  2018-02-18T16:10:07.000Z  167949203  \n",
       "231480  2018-03-01T17:45:12.000Z  2018-03-02T08:00:06.000Z  167949204  \n",
       "231481  2018-03-02T09:45:05.000Z  2018-03-02T10:24:10.000Z  167949205  \n",
       "231482  2018-03-01T11:33:13.000Z  2018-03-01T11:34:31.000Z  167949206  \n",
       "231483  2018-02-23T14:42:18.000Z  2018-03-03T19:59:05.000Z  167949207  \n",
       "231484  2018-03-03T17:01:17.000Z  2018-03-03T20:19:18.000Z  167949208  \n",
       "231485  2018-03-03T19:28:23.000Z  2018-03-03T20:17:29.000Z  167949209  \n",
       "231486  2018-03-03T19:30:38.000Z  2018-03-03T20:00:30.000Z  167949210  \n",
       "231487  2018-03-03T21:25:55.000Z  2018-03-03T22:00:22.000Z  167949211  \n",
       "231488  2018-03-03T22:53:45.000Z  2018-03-03T22:54:26.000Z  167949212  \n",
       "231489  2018-03-03T22:38:03.000Z  2018-03-04T00:44:09.000Z  167949213  \n",
       "231490  2017-12-29T20:00:01.000Z  2017-12-30T12:00:56.000Z  167953512  \n",
       "231491  2017-12-29T20:00:01.000Z  2017-12-30T12:00:56.000Z  167953513  \n",
       "231492  2018-04-25T15:24:04.000Z  2018-04-27T18:29:28.000Z  167953514  \n",
       "231493  2018-04-25T15:24:04.000Z  2018-04-27T18:29:28.000Z  167953515  \n",
       "231494  2018-04-27T20:00:18.000Z  2018-04-28T07:00:05.000Z  167954249  \n",
       "231495  2018-04-27T20:00:18.000Z  2018-04-28T07:00:05.000Z  167954250  \n",
       "231496  1985-01-11T03:56:21.000Z  1985-01-11T04:00:39.000Z  167954251  \n",
       "231497  1985-01-11T03:56:21.000Z  1985-01-11T04:00:39.000Z  167954252  \n",
       "231498  2018-05-03T17:04:26.000Z                       NaN  167954253  \n",
       "231499  2018-05-03T17:04:26.000Z                       NaN  167954254  \n",
       "231500  2018-04-25T23:34:49.000Z                       NaN  167954255  \n",
       "231501  2018-04-25T23:34:49.000Z                       NaN  167954256  \n",
       "\n",
       "[231502 rows x 24 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# # compiling all the CSV's in to a single pandas DF\n",
    "COLUMN_NAMES = ['X', 'Y', 'CCN', 'REPORT_DAT', 'SHIFT', 'METHOD', 'OFFENSE', 'BLOCK', 'XBLOCK',\n",
    "                 'YBLOCK', 'WARD', 'ANC', 'DISTRICT', 'PSA','NEIGHBORHOOD_CLUSTER', 'BLOCK_GROUP', 'CENSUS_TRACT',\n",
    "                 'VOTING_PRECINCT', 'LATITUDE', 'LONGITUDE', 'BID', 'START_DATE','END_DATE', 'OBJECTID']\n",
    "df = pd.DataFrame(columns=COLUMN_NAMES)\n",
    "print(df.columns)   # checking consistency of column names\n",
    "print(df1.columns)\n",
    "print(df2.columns)\n",
    "print(df3.columns)\n",
    "print(df4.columns)\n",
    "print(df5.columns)\n",
    "print(df6.columns)\n",
    "print(df7.columns)\n",
    "df =pd.concat([df1,df2, df3,df4,df5,df6,df7],ignore_index =True)  # put the  DataFrames together\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['X', 'Y', 'CCN', 'REPORT_DAT', 'SHIFT', 'METHOD', 'OFFENSE', 'BLOCK',\n",
       "       'XBLOCK', 'YBLOCK', 'WARD', 'ANC', 'DISTRICT', 'PSA',\n",
       "       'NEIGHBORHOOD_CLUSTER', 'BLOCK_GROUP', 'CENSUS_TRACT',\n",
       "       'VOTING_PRECINCT', 'LATITUDE', 'LONGITUDE', 'BID', 'START_DATE',\n",
       "       'END_DATE', 'OBJECTID'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>X</th>\n",
       "      <th>Y</th>\n",
       "      <th>CCN</th>\n",
       "      <th>REPORT_DAT</th>\n",
       "      <th>SHIFT</th>\n",
       "      <th>METHOD</th>\n",
       "      <th>OFFENSE</th>\n",
       "      <th>BLOCK</th>\n",
       "      <th>XBLOCK</th>\n",
       "      <th>YBLOCK</th>\n",
       "      <th>...</th>\n",
       "      <th>NEIGHBORHOOD_CLUSTER</th>\n",
       "      <th>BLOCK_GROUP</th>\n",
       "      <th>CENSUS_TRACT</th>\n",
       "      <th>VOTING_PRECINCT</th>\n",
       "      <th>LATITUDE</th>\n",
       "      <th>LONGITUDE</th>\n",
       "      <th>BID</th>\n",
       "      <th>START_DATE</th>\n",
       "      <th>END_DATE</th>\n",
       "      <th>OBJECTID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>-76.999518</td>\n",
       "      <td>38.901924</td>\n",
       "      <td>9074624</td>\n",
       "      <td>2012-04-25T00:00:00.000Z</td>\n",
       "      <td>MIDNIGHT</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>SEX ABUSE</td>\n",
       "      <td>900 - 999 BLOCK OF 5TH STREET NE</td>\n",
       "      <td>400042.0</td>\n",
       "      <td>137118.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 25</td>\n",
       "      <td>010600 2</td>\n",
       "      <td>10600.0</td>\n",
       "      <td>Precinct 83</td>\n",
       "      <td>38.901916</td>\n",
       "      <td>-76.999516</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2009-05-31T23:00:00.000Z</td>\n",
       "      <td>2009-06-01T06:00:00.000Z</td>\n",
       "      <td>167253019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>-76.995541</td>\n",
       "      <td>38.905032</td>\n",
       "      <td>10123633</td>\n",
       "      <td>2012-02-29T00:00:00.000Z</td>\n",
       "      <td>MIDNIGHT</td>\n",
       "      <td>OTHERS</td>\n",
       "      <td>SEX ABUSE</td>\n",
       "      <td>700 - 799 BLOCK OF FLORIDA AVENUE NE</td>\n",
       "      <td>400387.0</td>\n",
       "      <td>137463.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Cluster 25</td>\n",
       "      <td>010600 1</td>\n",
       "      <td>10600.0</td>\n",
       "      <td>Precinct 83</td>\n",
       "      <td>38.905024</td>\n",
       "      <td>-76.995538</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010-08-27T02:30:00.000Z</td>\n",
       "      <td>2010-08-27T07:15:00.000Z</td>\n",
       "      <td>167274031</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           X          Y       CCN                REPORT_DAT     SHIFT  METHOD  \\\n",
       "0 -76.999518  38.901924   9074624  2012-04-25T00:00:00.000Z  MIDNIGHT  OTHERS   \n",
       "1 -76.995541  38.905032  10123633  2012-02-29T00:00:00.000Z  MIDNIGHT  OTHERS   \n",
       "\n",
       "     OFFENSE                                 BLOCK    XBLOCK    YBLOCK  \\\n",
       "0  SEX ABUSE      900 - 999 BLOCK OF 5TH STREET NE  400042.0  137118.0   \n",
       "1  SEX ABUSE  700 - 799 BLOCK OF FLORIDA AVENUE NE  400387.0  137463.0   \n",
       "\n",
       "     ...      NEIGHBORHOOD_CLUSTER BLOCK_GROUP  CENSUS_TRACT  VOTING_PRECINCT  \\\n",
       "0    ...                Cluster 25    010600 2       10600.0      Precinct 83   \n",
       "1    ...                Cluster 25    010600 1       10600.0      Precinct 83   \n",
       "\n",
       "    LATITUDE  LONGITUDE  BID                START_DATE  \\\n",
       "0  38.901916 -76.999516  NaN  2009-05-31T23:00:00.000Z   \n",
       "1  38.905024 -76.995538  NaN  2010-08-27T02:30:00.000Z   \n",
       "\n",
       "                   END_DATE   OBJECTID  \n",
       "0  2009-06-01T06:00:00.000Z  167253019  \n",
       "1  2010-08-27T07:15:00.000Z  167274031  \n",
       "\n",
       "[2 rows x 24 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 231502 entries, 0 to 231501\n",
      "Data columns (total 24 columns):\n",
      "X                       231502 non-null float64\n",
      "Y                       231502 non-null float64\n",
      "CCN                     231502 non-null int64\n",
      "REPORT_DAT              231502 non-null object\n",
      "SHIFT                   231502 non-null object\n",
      "METHOD                  231502 non-null object\n",
      "OFFENSE                 231502 non-null object\n",
      "BLOCK                   231502 non-null object\n",
      "XBLOCK                  231502 non-null float64\n",
      "YBLOCK                  231502 non-null float64\n",
      "WARD                    231494 non-null float64\n",
      "ANC                     231502 non-null object\n",
      "DISTRICT                231373 non-null float64\n",
      "PSA                     231367 non-null float64\n",
      "NEIGHBORHOOD_CLUSTER    228659 non-null object\n",
      "BLOCK_GROUP             230826 non-null object\n",
      "CENSUS_TRACT            230826 non-null float64\n",
      "VOTING_PRECINCT         231455 non-null object\n",
      "LATITUDE                231502 non-null float64\n",
      "LONGITUDE               231502 non-null float64\n",
      "BID                     38549 non-null object\n",
      "START_DATE              231498 non-null object\n",
      "END_DATE                225855 non-null object\n",
      "OBJECTID                231502 non-null int64\n",
      "dtypes: float64(10), int64(2), object(12)\n",
      "memory usage: 42.4+ MB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('./input/dcrime.csv')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python [default]",
   "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.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}