NYPD_spatial_parser.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd, numpy as np, matplotlib.pyplot as plt, datetime, statsmodels.formula.api as smf, matplotlib.dates as mdates\n",
    "%matplotlib inline\n",
    "plt.style.use('ggplot')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def convertDate(d):\n",
    "    dt = datetime.datetime.strptime(d, '%m/%d/%Y')\n",
    "    return dt\n",
    "\n",
    "df = pd.read_csv('data/NYPD_Motor_Vehicle_Collisions.csv', converters={'DATE': convertDate})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "c_inj_agg = df.groupby('DATE').sum()['NUMBER OF CYCLIST INJURED']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "716227 14340\n"
     ]
    }
   ],
   "source": [
    "df_ = df[(df['NUMBER OF CYCLIST INJURED']>0)|(df['NUMBER OF CYCLIST KILLED']>0)]\n",
    "print len(df),len(df_)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>DATE</th>\n",
       "      <th>TIME</th>\n",
       "      <th>BOROUGH</th>\n",
       "      <th>ZIP CODE</th>\n",
       "      <th>LATITUDE</th>\n",
       "      <th>LONGITUDE</th>\n",
       "      <th>LOCATION</th>\n",
       "      <th>ON STREET NAME</th>\n",
       "      <th>CROSS STREET NAME</th>\n",
       "      <th>OFF STREET NAME</th>\n",
       "      <th>...</th>\n",
       "      <th>CONTRIBUTING FACTOR VEHICLE 2</th>\n",
       "      <th>CONTRIBUTING FACTOR VEHICLE 3</th>\n",
       "      <th>CONTRIBUTING FACTOR VEHICLE 4</th>\n",
       "      <th>CONTRIBUTING FACTOR VEHICLE 5</th>\n",
       "      <th>UNIQUE KEY</th>\n",
       "      <th>VEHICLE TYPE CODE 1</th>\n",
       "      <th>VEHICLE TYPE CODE 2</th>\n",
       "      <th>VEHICLE TYPE CODE 3</th>\n",
       "      <th>VEHICLE TYPE CODE 4</th>\n",
       "      <th>VEHICLE TYPE CODE 5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2015-12-12</td>\n",
       "      <td>15:20</td>\n",
       "      <td>QUEENS</td>\n",
       "      <td>11435</td>\n",
       "      <td>40.693590</td>\n",
       "      <td>-73.800189</td>\n",
       "      <td>(40.6935895, -73.8001891)</td>\n",
       "      <td>LAKEWOOD AVENUE</td>\n",
       "      <td>SUTPHIN BOULEVARD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3352234</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>2015-12-12</td>\n",
       "      <td>16:29</td>\n",
       "      <td>BROOKLYN</td>\n",
       "      <td>11226</td>\n",
       "      <td>40.644852</td>\n",
       "      <td>-73.960016</td>\n",
       "      <td>(40.6448523, -73.9600159)</td>\n",
       "      <td>OCEAN AVENUE</td>\n",
       "      <td>BEVERLEY ROAD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Passenger Distraction</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3352139</td>\n",
       "      <td>LARGE COM VEH(6 OR MORE TIRES)</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>2015-12-12</td>\n",
       "      <td>17:37</td>\n",
       "      <td>MANHATTAN</td>\n",
       "      <td>10002</td>\n",
       "      <td>40.715855</td>\n",
       "      <td>-73.994953</td>\n",
       "      <td>(40.7158555, -73.9949534)</td>\n",
       "      <td>CHRYSTIE STREET</td>\n",
       "      <td>CANAL STREET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3351802</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>2015-12-12</td>\n",
       "      <td>17:40</td>\n",
       "      <td>BROOKLYN</td>\n",
       "      <td>11221</td>\n",
       "      <td>40.686649</td>\n",
       "      <td>-73.920739</td>\n",
       "      <td>(40.6866487, -73.9207388)</td>\n",
       "      <td>JEFFERSON AVENUE</td>\n",
       "      <td>HOWARD AVENUE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3352195</td>\n",
       "      <td>SPORT UTILITY / STATION WAGON</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>2015-12-12</td>\n",
       "      <td>18:29</td>\n",
       "      <td>MANHATTAN</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.732854</td>\n",
       "      <td>-74.007523</td>\n",
       "      <td>(40.7328536, -74.0075232)</td>\n",
       "      <td>CHRISTOPHER STREET</td>\n",
       "      <td>GREENWICH STREET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3351814</td>\n",
       "      <td>TAXI</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          DATE   TIME    BOROUGH  ZIP CODE   LATITUDE  LONGITUDE  \\\n",
       "17  2015-12-12  15:20     QUEENS     11435  40.693590 -73.800189   \n",
       "44  2015-12-12  16:29   BROOKLYN     11226  40.644852 -73.960016   \n",
       "87  2015-12-12  17:37  MANHATTAN     10002  40.715855 -73.994953   \n",
       "91  2015-12-12  17:40   BROOKLYN     11221  40.686649 -73.920739   \n",
       "128 2015-12-12  18:29  MANHATTAN     10014  40.732854 -74.007523   \n",
       "\n",
       "                      LOCATION      ON STREET NAME  CROSS STREET NAME  \\\n",
       "17   (40.6935895, -73.8001891)     LAKEWOOD AVENUE  SUTPHIN BOULEVARD   \n",
       "44   (40.6448523, -73.9600159)        OCEAN AVENUE      BEVERLEY ROAD   \n",
       "87   (40.7158555, -73.9949534)     CHRYSTIE STREET       CANAL STREET   \n",
       "91   (40.6866487, -73.9207388)    JEFFERSON AVENUE      HOWARD AVENUE   \n",
       "128  (40.7328536, -74.0075232)  CHRISTOPHER STREET   GREENWICH STREET   \n",
       "\n",
       "    OFF STREET NAME         ...          CONTRIBUTING FACTOR VEHICLE 2  \\\n",
       "17              NaN         ...                            Unspecified   \n",
       "44              NaN         ...                  Passenger Distraction   \n",
       "87              NaN         ...                            Unspecified   \n",
       "91              NaN         ...                            Unspecified   \n",
       "128             NaN         ...                            Unspecified   \n",
       "\n",
       "     CONTRIBUTING FACTOR VEHICLE 3  CONTRIBUTING FACTOR VEHICLE 4  \\\n",
       "17                             NaN                            NaN   \n",
       "44                             NaN                            NaN   \n",
       "87                             NaN                            NaN   \n",
       "91                             NaN                            NaN   \n",
       "128                            NaN                            NaN   \n",
       "\n",
       "     CONTRIBUTING FACTOR VEHICLE 5  UNIQUE KEY  \\\n",
       "17                             NaN     3352234   \n",
       "44                             NaN     3352139   \n",
       "87                             NaN     3351802   \n",
       "91                             NaN     3352195   \n",
       "128                            NaN     3351814   \n",
       "\n",
       "                VEHICLE TYPE CODE 1  VEHICLE TYPE CODE 2  VEHICLE TYPE CODE 3  \\\n",
       "17                PASSENGER VEHICLE              BICYCLE                  NaN   \n",
       "44   LARGE COM VEH(6 OR MORE TIRES)              BICYCLE                  NaN   \n",
       "87                PASSENGER VEHICLE              BICYCLE                  NaN   \n",
       "91    SPORT UTILITY / STATION WAGON              BICYCLE                  NaN   \n",
       "128                            TAXI              BICYCLE                  NaN   \n",
       "\n",
       "    VEHICLE TYPE CODE 4 VEHICLE TYPE CODE 5  \n",
       "17                  NaN                 NaN  \n",
       "44                  NaN                 NaN  \n",
       "87                  NaN                 NaN  \n",
       "91                  NaN                 NaN  \n",
       "128                 NaN                 NaN  \n",
       "\n",
       "[5 rows x 29 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df_.to_csv('data/Bicycle_Collisions.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df__ = df[df['NUMBER OF CYCLIST KILLED']>0]\n",
    "df__.to_csv('data_/Bicycle_Deaths.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "d = pd.Timestamp(datetime.datetime(2013, 7, 1))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "d1 = df_[df_['DATE']<d]\n",
    "d2 = df_[df_['DATE']>=d]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "3914 10426\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>DATE</th>\n",
       "      <th>TIME</th>\n",
       "      <th>BOROUGH</th>\n",
       "      <th>ZIP CODE</th>\n",
       "      <th>LATITUDE</th>\n",
       "      <th>LONGITUDE</th>\n",
       "      <th>LOCATION</th>\n",
       "      <th>ON STREET NAME</th>\n",
       "      <th>CROSS STREET NAME</th>\n",
       "      <th>OFF STREET NAME</th>\n",
       "      <th>...</th>\n",
       "      <th>CONTRIBUTING FACTOR VEHICLE 2</th>\n",
       "      <th>CONTRIBUTING FACTOR VEHICLE 3</th>\n",
       "      <th>CONTRIBUTING FACTOR VEHICLE 4</th>\n",
       "      <th>CONTRIBUTING FACTOR VEHICLE 5</th>\n",
       "      <th>UNIQUE KEY</th>\n",
       "      <th>VEHICLE TYPE CODE 1</th>\n",
       "      <th>VEHICLE TYPE CODE 2</th>\n",
       "      <th>VEHICLE TYPE CODE 3</th>\n",
       "      <th>VEHICLE TYPE CODE 4</th>\n",
       "      <th>VEHICLE TYPE CODE 5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>516048</th>\n",
       "      <td>2013-06-30</td>\n",
       "      <td>0:10</td>\n",
       "      <td>BROOKLYN</td>\n",
       "      <td>11221</td>\n",
       "      <td>40.691624</td>\n",
       "      <td>-73.942661</td>\n",
       "      <td>(40.6916242, -73.942661)</td>\n",
       "      <td>KOSCIUSKO STREET</td>\n",
       "      <td>THROOP AVENUE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>181326</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516077</th>\n",
       "      <td>2013-06-30</td>\n",
       "      <td>10:57</td>\n",
       "      <td>BROOKLYN</td>\n",
       "      <td>11205</td>\n",
       "      <td>40.692778</td>\n",
       "      <td>-73.957679</td>\n",
       "      <td>(40.692778, -73.9576793)</td>\n",
       "      <td>FRANKLIN AVENUE</td>\n",
       "      <td>WILLOUGHBY AVENUE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>181325</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516100</th>\n",
       "      <td>2013-06-30</td>\n",
       "      <td>12:00</td>\n",
       "      <td>QUEENS</td>\n",
       "      <td>11368</td>\n",
       "      <td>40.742845</td>\n",
       "      <td>-73.851210</td>\n",
       "      <td>(40.7428447, -73.8512103)</td>\n",
       "      <td>111 STREET</td>\n",
       "      <td>54 AVENUE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>257535</td>\n",
       "      <td>SPORT UTILITY / STATION WAGON</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516130</th>\n",
       "      <td>2013-06-30</td>\n",
       "      <td>13:09</td>\n",
       "      <td>QUEENS</td>\n",
       "      <td>11354</td>\n",
       "      <td>40.776627</td>\n",
       "      <td>-73.839054</td>\n",
       "      <td>(40.7766272, -73.8390537)</td>\n",
       "      <td>ULMER STREET</td>\n",
       "      <td>25 AVENUE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>251041</td>\n",
       "      <td>SPORT UTILITY / STATION WAGON</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516187</th>\n",
       "      <td>2013-06-30</td>\n",
       "      <td>15:20</td>\n",
       "      <td>QUEENS</td>\n",
       "      <td>11372</td>\n",
       "      <td>40.749940</td>\n",
       "      <td>-73.882450</td>\n",
       "      <td>(40.7499403, -73.8824498)</td>\n",
       "      <td>37 AVENUE</td>\n",
       "      <td>84 STREET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>282512</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516262</th>\n",
       "      <td>2013-06-30</td>\n",
       "      <td>17:50</td>\n",
       "      <td>QUEENS</td>\n",
       "      <td>11366</td>\n",
       "      <td>40.735604</td>\n",
       "      <td>-73.775154</td>\n",
       "      <td>(40.7356042, -73.7751544)</td>\n",
       "      <td>73 AVENUE</td>\n",
       "      <td>197 STREET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>236201</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516331</th>\n",
       "      <td>2013-06-30</td>\n",
       "      <td>1:30</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CORONA AVENUE</td>\n",
       "      <td>91 PLACE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>257531</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516354</th>\n",
       "      <td>2013-06-30</td>\n",
       "      <td>21:35</td>\n",
       "      <td>BRONX</td>\n",
       "      <td>10472</td>\n",
       "      <td>40.830078</td>\n",
       "      <td>-73.853762</td>\n",
       "      <td>(40.8300784, -73.8537615)</td>\n",
       "      <td>HAVILAND AVENUE</td>\n",
       "      <td>OLMSTEAD AVENUE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>83334</td>\n",
       "      <td>LIVERY VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516362</th>\n",
       "      <td>2013-06-30</td>\n",
       "      <td>22:00</td>\n",
       "      <td>QUEENS</td>\n",
       "      <td>11105</td>\n",
       "      <td>40.779747</td>\n",
       "      <td>-73.915819</td>\n",
       "      <td>(40.7797473, -73.9158185)</td>\n",
       "      <td>DITMARS BOULEVARD</td>\n",
       "      <td>23 STREET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>276543</td>\n",
       "      <td>SPORT UTILITY / STATION WAGON</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516363</th>\n",
       "      <td>2013-06-30</td>\n",
       "      <td>22:00</td>\n",
       "      <td>QUEENS</td>\n",
       "      <td>11354</td>\n",
       "      <td>40.772790</td>\n",
       "      <td>-73.837124</td>\n",
       "      <td>(40.7727901, -73.8371242)</td>\n",
       "      <td>28 AVENUE</td>\n",
       "      <td>ULMER STREET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>251044</td>\n",
       "      <td>SPORT UTILITY / STATION WAGON</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516391</th>\n",
       "      <td>2013-06-30</td>\n",
       "      <td>2:20</td>\n",
       "      <td>BRONX</td>\n",
       "      <td>10457</td>\n",
       "      <td>40.838875</td>\n",
       "      <td>-73.902647</td>\n",
       "      <td>(40.8388747, -73.9026466)</td>\n",
       "      <td>WASHINGTON AVENUE</td>\n",
       "      <td>CLAREMONT PARKWAY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>79857</td>\n",
       "      <td>OTHER</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516406</th>\n",
       "      <td>2013-06-30</td>\n",
       "      <td>3:30</td>\n",
       "      <td>BRONX</td>\n",
       "      <td>10452</td>\n",
       "      <td>40.843823</td>\n",
       "      <td>-73.916554</td>\n",
       "      <td>(40.8438234, -73.9165542)</td>\n",
       "      <td>INWOOD AVENUE</td>\n",
       "      <td>GOBLE PLACE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>87192</td>\n",
       "      <td>LIVERY VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516442</th>\n",
       "      <td>2013-06-30</td>\n",
       "      <td>6:45</td>\n",
       "      <td>BROOKLYN</td>\n",
       "      <td>11215</td>\n",
       "      <td>40.675437</td>\n",
       "      <td>-73.977958</td>\n",
       "      <td>(40.6754368, -73.9779583)</td>\n",
       "      <td>6 AVENUE</td>\n",
       "      <td>UNION STREET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>177896</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516492</th>\n",
       "      <td>2013-06-29</td>\n",
       "      <td>10:30</td>\n",
       "      <td>QUEENS</td>\n",
       "      <td>11101</td>\n",
       "      <td>40.754807</td>\n",
       "      <td>-73.916871</td>\n",
       "      <td>(40.7548066, -73.9168715)</td>\n",
       "      <td>34 AVENUE</td>\n",
       "      <td>45 STREET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>276526</td>\n",
       "      <td>SPORT UTILITY / STATION WAGON</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516508</th>\n",
       "      <td>2013-06-29</td>\n",
       "      <td>11:10</td>\n",
       "      <td>MANHATTAN</td>\n",
       "      <td>10016</td>\n",
       "      <td>40.742706</td>\n",
       "      <td>-73.984526</td>\n",
       "      <td>(40.7427065, -73.9845256)</td>\n",
       "      <td>PARK AVENUE SOUTH</td>\n",
       "      <td>EAST 27 STREET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24263</td>\n",
       "      <td>TAXI</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516558</th>\n",
       "      <td>2013-06-29</td>\n",
       "      <td>12:30</td>\n",
       "      <td>BROOKLYN</td>\n",
       "      <td>11238</td>\n",
       "      <td>40.673588</td>\n",
       "      <td>-73.962955</td>\n",
       "      <td>(40.6735884, -73.9629548)</td>\n",
       "      <td>WASHINGTON AVENUE</td>\n",
       "      <td>SAINT JOHNS PLACE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>174369</td>\n",
       "      <td>SPORT UTILITY / STATION WAGON</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516601</th>\n",
       "      <td>2013-06-29</td>\n",
       "      <td>13:30</td>\n",
       "      <td>MANHATTAN</td>\n",
       "      <td>10040</td>\n",
       "      <td>40.856715</td>\n",
       "      <td>-73.932632</td>\n",
       "      <td>(40.8567148, -73.9326318)</td>\n",
       "      <td>BROADWAY</td>\n",
       "      <td>FAIRVIEW AVENUE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>71530</td>\n",
       "      <td>BUS</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516638</th>\n",
       "      <td>2013-06-29</td>\n",
       "      <td>14:41</td>\n",
       "      <td>BROOKLYN</td>\n",
       "      <td>11236</td>\n",
       "      <td>40.635508</td>\n",
       "      <td>-73.913277</td>\n",
       "      <td>(40.635508, -73.9132766)</td>\n",
       "      <td>EAST 80 STREET</td>\n",
       "      <td>FLATLANDS AVENUE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>146317</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516644</th>\n",
       "      <td>2013-06-29</td>\n",
       "      <td>14:50</td>\n",
       "      <td>BROOKLYN</td>\n",
       "      <td>11204</td>\n",
       "      <td>40.611447</td>\n",
       "      <td>-73.991140</td>\n",
       "      <td>(40.6114466, -73.9911399)</td>\n",
       "      <td>20 AVENUE</td>\n",
       "      <td>74 STREET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>123931</td>\n",
       "      <td>SPORT UTILITY / STATION WAGON</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516656</th>\n",
       "      <td>2013-06-29</td>\n",
       "      <td>15:00</td>\n",
       "      <td>BROOKLYN</td>\n",
       "      <td>11222</td>\n",
       "      <td>40.735553</td>\n",
       "      <td>-73.958525</td>\n",
       "      <td>(40.7355527, -73.9585253)</td>\n",
       "      <td>FRANKLIN STREET</td>\n",
       "      <td>DUPONT STREET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Passenger Distraction</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>199851</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516678</th>\n",
       "      <td>2013-06-29</td>\n",
       "      <td>15:30</td>\n",
       "      <td>QUEENS</td>\n",
       "      <td>11004</td>\n",
       "      <td>40.745451</td>\n",
       "      <td>-73.708374</td>\n",
       "      <td>(40.7454509, -73.7083741)</td>\n",
       "      <td>263 STREET</td>\n",
       "      <td>80 AVENUE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>224272</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516764</th>\n",
       "      <td>2013-06-29</td>\n",
       "      <td>17:30</td>\n",
       "      <td>QUEENS</td>\n",
       "      <td>11416</td>\n",
       "      <td>40.684254</td>\n",
       "      <td>-73.852801</td>\n",
       "      <td>(40.6842542, -73.8528013)</td>\n",
       "      <td>88 STREET</td>\n",
       "      <td>97 AVENUE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>206559</td>\n",
       "      <td>SPORT UTILITY / STATION WAGON</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516804</th>\n",
       "      <td>2013-06-29</td>\n",
       "      <td>18:30</td>\n",
       "      <td>MANHATTAN</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.735305</td>\n",
       "      <td>-74.004933</td>\n",
       "      <td>(40.7353048, -74.0049326)</td>\n",
       "      <td>BLEECKER STREET</td>\n",
       "      <td>PERRY STREET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11064</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516810</th>\n",
       "      <td>2013-06-29</td>\n",
       "      <td>18:40</td>\n",
       "      <td>BROOKLYN</td>\n",
       "      <td>11208</td>\n",
       "      <td>40.682038</td>\n",
       "      <td>-73.877868</td>\n",
       "      <td>(40.6820384, -73.8778679)</td>\n",
       "      <td>FULTON STREET</td>\n",
       "      <td>LOGAN STREET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>167712</td>\n",
       "      <td>SPORT UTILITY / STATION WAGON</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516847</th>\n",
       "      <td>2013-06-29</td>\n",
       "      <td>19:50</td>\n",
       "      <td>QUEENS</td>\n",
       "      <td>11368</td>\n",
       "      <td>40.756287</td>\n",
       "      <td>-73.860720</td>\n",
       "      <td>(40.7562867, -73.8607202)</td>\n",
       "      <td>34 AVENUE</td>\n",
       "      <td>108 STREET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>282501</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516881</th>\n",
       "      <td>2013-06-29</td>\n",
       "      <td>20:36</td>\n",
       "      <td>BROOKLYN</td>\n",
       "      <td>11212</td>\n",
       "      <td>40.654629</td>\n",
       "      <td>-73.922006</td>\n",
       "      <td>(40.654629, -73.9220058)</td>\n",
       "      <td>REMSEN AVENUE</td>\n",
       "      <td>KINGS HIGHWAY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>138378</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516894</th>\n",
       "      <td>2013-06-29</td>\n",
       "      <td>21:15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WESTCHESTER AVENUE</td>\n",
       "      <td>HOBART AVENUE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>90656</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516992</th>\n",
       "      <td>2013-06-29</td>\n",
       "      <td>4:35</td>\n",
       "      <td>BROOKLYN</td>\n",
       "      <td>11217</td>\n",
       "      <td>40.685659</td>\n",
       "      <td>-73.985689</td>\n",
       "      <td>(40.6856595, -73.9856891)</td>\n",
       "      <td>DEAN STREET</td>\n",
       "      <td>BOND STREET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>189912</td>\n",
       "      <td>SPORT UTILITY / STATION WAGON</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>517066</th>\n",
       "      <td>2013-06-28</td>\n",
       "      <td>17:20</td>\n",
       "      <td>MANHATTAN</td>\n",
       "      <td>10035</td>\n",
       "      <td>40.804376</td>\n",
       "      <td>-73.937420</td>\n",
       "      <td>(40.8043758, -73.9374202)</td>\n",
       "      <td>EAST 125 STREET</td>\n",
       "      <td>LEXINGTON AVENUE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>61113</td>\n",
       "      <td>OTHER</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>517090</th>\n",
       "      <td>2013-06-28</td>\n",
       "      <td>16:59</td>\n",
       "      <td>MANHATTAN</td>\n",
       "      <td>10002</td>\n",
       "      <td>40.721463</td>\n",
       "      <td>-73.988524</td>\n",
       "      <td>(40.7214625, -73.9885242)</td>\n",
       "      <td>ORCHARD STREET</td>\n",
       "      <td>STANTON STREET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13147</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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>715260</th>\n",
       "      <td>2012-07-02</td>\n",
       "      <td>16:45</td>\n",
       "      <td>MANHATTAN</td>\n",
       "      <td>10027</td>\n",
       "      <td>40.810765</td>\n",
       "      <td>-73.952590</td>\n",
       "      <td>(40.8107645, -73.9525902)</td>\n",
       "      <td>WEST 125 STREET</td>\n",
       "      <td>SAINT NICHOLAS AVENUE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62169</td>\n",
       "      <td>SPORT UTILITY / STATION WAGON</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715274</th>\n",
       "      <td>2012-07-02</td>\n",
       "      <td>17:00</td>\n",
       "      <td>MANHATTAN</td>\n",
       "      <td>10016</td>\n",
       "      <td>40.748302</td>\n",
       "      <td>-73.978338</td>\n",
       "      <td>(40.748302, -73.9783384)</td>\n",
       "      <td>EAST 37 STREET</td>\n",
       "      <td>LEXINGTON AVENUE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>32055</td>\n",
       "      <td>TAXI</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715293</th>\n",
       "      <td>2012-07-02</td>\n",
       "      <td>17:25</td>\n",
       "      <td>MANHATTAN</td>\n",
       "      <td>10009</td>\n",
       "      <td>40.733212</td>\n",
       "      <td>-73.981057</td>\n",
       "      <td>(40.7332119, -73.9810567)</td>\n",
       "      <td>EAST 17 STREET</td>\n",
       "      <td>1 AVENUE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21682</td>\n",
       "      <td>BUS</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715308</th>\n",
       "      <td>2012-07-02</td>\n",
       "      <td>17:40</td>\n",
       "      <td>BROOKLYN</td>\n",
       "      <td>11216</td>\n",
       "      <td>40.682835</td>\n",
       "      <td>-73.940913</td>\n",
       "      <td>(40.6828346, -73.9409127)</td>\n",
       "      <td>HALSEY STREET</td>\n",
       "      <td>THROOP AVENUE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Physical Disability</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>179422</td>\n",
       "      <td>OTHER</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715330</th>\n",
       "      <td>2012-07-02</td>\n",
       "      <td>18:04</td>\n",
       "      <td>BROOKLYN</td>\n",
       "      <td>11213</td>\n",
       "      <td>40.671125</td>\n",
       "      <td>-73.940930</td>\n",
       "      <td>(40.6711254, -73.9409303)</td>\n",
       "      <td>SAINT JOHNS PLACE</td>\n",
       "      <td>HAMPTON PLACE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>172559</td>\n",
       "      <td>SPORT UTILITY / STATION WAGON</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715343</th>\n",
       "      <td>2012-07-02</td>\n",
       "      <td>18:30</td>\n",
       "      <td>BROOKLYN</td>\n",
       "      <td>11205</td>\n",
       "      <td>40.698117</td>\n",
       "      <td>-73.977532</td>\n",
       "      <td>(40.6981167, -73.9775324)</td>\n",
       "      <td>NORTH ELLIOT PLACE</td>\n",
       "      <td>FLUSHING AVENUE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Driver Inexperience</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>191557</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715387</th>\n",
       "      <td>2012-07-02</td>\n",
       "      <td>8:30</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RIVERSIDE DRIVE</td>\n",
       "      <td>WEST 158 STREET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>68165</td>\n",
       "      <td>SPORT UTILITY / STATION WAGON</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715437</th>\n",
       "      <td>2012-07-02</td>\n",
       "      <td>19:28</td>\n",
       "      <td>MANHATTAN</td>\n",
       "      <td>10032</td>\n",
       "      <td>40.830892</td>\n",
       "      <td>-73.941367</td>\n",
       "      <td>(40.8308918, -73.9413666)</td>\n",
       "      <td>SAINT NICHOLAS AVENUE</td>\n",
       "      <td>WEST 155 STREET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>65003</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715439</th>\n",
       "      <td>2012-07-02</td>\n",
       "      <td>12:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>KINGS HIGHWAY</td>\n",
       "      <td>CLARENDON ROAD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>135050</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715453</th>\n",
       "      <td>2012-07-02</td>\n",
       "      <td>19:40</td>\n",
       "      <td>BROOKLYN</td>\n",
       "      <td>11208</td>\n",
       "      <td>40.676056</td>\n",
       "      <td>-73.876509</td>\n",
       "      <td>(40.676056, -73.8765089)</td>\n",
       "      <td>GLENMORE AVENUE</td>\n",
       "      <td>LOGAN STREET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>163390</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715454</th>\n",
       "      <td>2012-07-02</td>\n",
       "      <td>19:42</td>\n",
       "      <td>QUEENS</td>\n",
       "      <td>11421</td>\n",
       "      <td>40.695520</td>\n",
       "      <td>-73.864558</td>\n",
       "      <td>(40.6955195, -73.8645579)</td>\n",
       "      <td>PARK LANE SOUTH</td>\n",
       "      <td>79 STREET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>203698</td>\n",
       "      <td>SPORT UTILITY / STATION WAGON</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715455</th>\n",
       "      <td>2012-07-02</td>\n",
       "      <td>19:45</td>\n",
       "      <td>QUEENS</td>\n",
       "      <td>11369</td>\n",
       "      <td>40.768841</td>\n",
       "      <td>-73.869662</td>\n",
       "      <td>(40.7688406, -73.8696616)</td>\n",
       "      <td>101 STREET</td>\n",
       "      <td>23 AVENUE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>279657</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715457</th>\n",
       "      <td>2012-07-02</td>\n",
       "      <td>19:50</td>\n",
       "      <td>BROOKLYN</td>\n",
       "      <td>11234</td>\n",
       "      <td>40.623980</td>\n",
       "      <td>-73.920626</td>\n",
       "      <td>(40.6239797, -73.9206259)</td>\n",
       "      <td>EAST 57 STREET</td>\n",
       "      <td>AVENUE L</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>125676</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715476</th>\n",
       "      <td>2012-07-02</td>\n",
       "      <td>22:56</td>\n",
       "      <td>QUEENS</td>\n",
       "      <td>11385</td>\n",
       "      <td>40.700593</td>\n",
       "      <td>-73.854565</td>\n",
       "      <td>(40.7005934, -73.8545649)</td>\n",
       "      <td>WOODHAVEN BOULEVARD</td>\n",
       "      <td>FOREST PARK DRIVE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>203707</td>\n",
       "      <td>UNKNOWN</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715496</th>\n",
       "      <td>2012-07-02</td>\n",
       "      <td>21:25</td>\n",
       "      <td>BRONX</td>\n",
       "      <td>10474</td>\n",
       "      <td>40.806972</td>\n",
       "      <td>-73.883559</td>\n",
       "      <td>(40.8069716, -73.8835591)</td>\n",
       "      <td>BRYANT AVENUE</td>\n",
       "      <td>VIELE AVENUE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>76210</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715500</th>\n",
       "      <td>2012-07-02</td>\n",
       "      <td>21:10</td>\n",
       "      <td>QUEENS</td>\n",
       "      <td>11377</td>\n",
       "      <td>40.751840</td>\n",
       "      <td>-73.903571</td>\n",
       "      <td>(40.7518401, -73.9035714)</td>\n",
       "      <td>BROADWAY</td>\n",
       "      <td>58 STREET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>238659</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715516</th>\n",
       "      <td>2012-07-02</td>\n",
       "      <td>20:20</td>\n",
       "      <td>QUEENS</td>\n",
       "      <td>11417</td>\n",
       "      <td>40.680297</td>\n",
       "      <td>-73.844640</td>\n",
       "      <td>(40.6802965, -73.8446402)</td>\n",
       "      <td>CROSSBAY BOULEVARD</td>\n",
       "      <td>LIBERTY AVENUE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>227954</td>\n",
       "      <td>LARGE COM VEH(6 OR MORE TIRES)</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715524</th>\n",
       "      <td>2012-07-02</td>\n",
       "      <td>0:19</td>\n",
       "      <td>MANHATTAN</td>\n",
       "      <td>10007</td>\n",
       "      <td>40.713692</td>\n",
       "      <td>-74.013754</td>\n",
       "      <td>(40.7136919, -74.0137542)</td>\n",
       "      <td>VESEY STREET</td>\n",
       "      <td>WEST STREET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>37</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715525</th>\n",
       "      <td>2012-07-02</td>\n",
       "      <td>0:21</td>\n",
       "      <td>BROOKLYN</td>\n",
       "      <td>11218</td>\n",
       "      <td>40.636133</td>\n",
       "      <td>-73.972736</td>\n",
       "      <td>(40.6361331, -73.9727361)</td>\n",
       "      <td>DITMAS AVENUE</td>\n",
       "      <td>OCEAN PARKWAY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>129911</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715554</th>\n",
       "      <td>2012-07-02</td>\n",
       "      <td>9:46</td>\n",
       "      <td>MANHATTAN</td>\n",
       "      <td>10002</td>\n",
       "      <td>40.717724</td>\n",
       "      <td>-73.985765</td>\n",
       "      <td>(40.7177239, -73.9857652)</td>\n",
       "      <td>DELANCEY STREET</td>\n",
       "      <td>CLINTON STREET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12187</td>\n",
       "      <td>PICK-UP TRUCK</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715577</th>\n",
       "      <td>2012-07-02</td>\n",
       "      <td>5:25</td>\n",
       "      <td>MANHATTAN</td>\n",
       "      <td>10002</td>\n",
       "      <td>40.717894</td>\n",
       "      <td>-73.989474</td>\n",
       "      <td>(40.7178944, -73.9894735)</td>\n",
       "      <td>LUDLOW STREET</td>\n",
       "      <td>BROOME STREET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12185</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715704</th>\n",
       "      <td>2012-07-01</td>\n",
       "      <td>14:14</td>\n",
       "      <td>MANHATTAN</td>\n",
       "      <td>10003</td>\n",
       "      <td>40.731166</td>\n",
       "      <td>-73.991921</td>\n",
       "      <td>(40.7311655, -73.9919214)</td>\n",
       "      <td>BROADWAY</td>\n",
       "      <td>EAST 9 STREET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9409</td>\n",
       "      <td>TAXI</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715812</th>\n",
       "      <td>2012-07-01</td>\n",
       "      <td>15:40</td>\n",
       "      <td>BROOKLYN</td>\n",
       "      <td>11224</td>\n",
       "      <td>40.576159</td>\n",
       "      <td>-73.989017</td>\n",
       "      <td>(40.5761593, -73.9890171)</td>\n",
       "      <td>MERMAID AVENUE</td>\n",
       "      <td>WEST 22 STREET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>113545</td>\n",
       "      <td>BUS</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715854</th>\n",
       "      <td>2012-07-01</td>\n",
       "      <td>12:15</td>\n",
       "      <td>BROOKLYN</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.711801</td>\n",
       "      <td>-73.942229</td>\n",
       "      <td>(40.7118008, -73.9422288)</td>\n",
       "      <td>GRAND STREET</td>\n",
       "      <td>HUMBOLDT STREET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>193861</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715963</th>\n",
       "      <td>2012-07-01</td>\n",
       "      <td>2:30</td>\n",
       "      <td>MANHATTAN</td>\n",
       "      <td>10065</td>\n",
       "      <td>40.764162</td>\n",
       "      <td>-73.968890</td>\n",
       "      <td>(40.7641617, -73.9688897)</td>\n",
       "      <td>EAST 61 STREET</td>\n",
       "      <td>PARK AVENUE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Passenger Distraction</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44909</td>\n",
       "      <td>TAXI</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715990</th>\n",
       "      <td>2012-07-01</td>\n",
       "      <td>22:47</td>\n",
       "      <td>BROOKLYN</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.710957</td>\n",
       "      <td>-73.951117</td>\n",
       "      <td>(40.7109568, -73.9511173)</td>\n",
       "      <td>GRAND STREET</td>\n",
       "      <td>UNION AVENUE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>193864</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715998</th>\n",
       "      <td>2012-07-01</td>\n",
       "      <td>22:20</td>\n",
       "      <td>BRONX</td>\n",
       "      <td>10473</td>\n",
       "      <td>40.823191</td>\n",
       "      <td>-73.855312</td>\n",
       "      <td>(40.8231912, -73.8553122)</td>\n",
       "      <td>TURNBULL AVENUE</td>\n",
       "      <td>PUGSLEY AVENUE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>80828</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>716009</th>\n",
       "      <td>2012-07-01</td>\n",
       "      <td>21:40</td>\n",
       "      <td>MANHATTAN</td>\n",
       "      <td>10009</td>\n",
       "      <td>40.724285</td>\n",
       "      <td>-73.975594</td>\n",
       "      <td>(40.7242849, -73.9755935)</td>\n",
       "      <td>EAST 9 STREET</td>\n",
       "      <td>AVENUE D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13871</td>\n",
       "      <td>TAXI</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>716017</th>\n",
       "      <td>2012-07-01</td>\n",
       "      <td>21:08</td>\n",
       "      <td>BROOKLYN</td>\n",
       "      <td>11212</td>\n",
       "      <td>40.672075</td>\n",
       "      <td>-73.911336</td>\n",
       "      <td>(40.6720753, -73.9113364)</td>\n",
       "      <td>EAST NEW YORK AVENUE</td>\n",
       "      <td>ROCKAWAY AVENUE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>160106</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>716122</th>\n",
       "      <td>2012-07-01</td>\n",
       "      <td>6:50</td>\n",
       "      <td>BRONX</td>\n",
       "      <td>10468</td>\n",
       "      <td>40.862679</td>\n",
       "      <td>-73.909040</td>\n",
       "      <td>(40.8626793, -73.9090397)</td>\n",
       "      <td>SEDGWICK AVENUE</td>\n",
       "      <td>WEST FORDHAM ROAD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unspecified</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>109483</td>\n",
       "      <td>PASSENGER VEHICLE</td>\n",
       "      <td>BICYCLE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3914 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             DATE   TIME    BOROUGH  ZIP CODE   LATITUDE  LONGITUDE  \\\n",
       "516048 2013-06-30   0:10   BROOKLYN     11221  40.691624 -73.942661   \n",
       "516077 2013-06-30  10:57   BROOKLYN     11205  40.692778 -73.957679   \n",
       "516100 2013-06-30  12:00     QUEENS     11368  40.742845 -73.851210   \n",
       "516130 2013-06-30  13:09     QUEENS     11354  40.776627 -73.839054   \n",
       "516187 2013-06-30  15:20     QUEENS     11372  40.749940 -73.882450   \n",
       "516262 2013-06-30  17:50     QUEENS     11366  40.735604 -73.775154   \n",
       "516331 2013-06-30   1:30        NaN       NaN        NaN        NaN   \n",
       "516354 2013-06-30  21:35      BRONX     10472  40.830078 -73.853762   \n",
       "516362 2013-06-30  22:00     QUEENS     11105  40.779747 -73.915819   \n",
       "516363 2013-06-30  22:00     QUEENS     11354  40.772790 -73.837124   \n",
       "516391 2013-06-30   2:20      BRONX     10457  40.838875 -73.902647   \n",
       "516406 2013-06-30   3:30      BRONX     10452  40.843823 -73.916554   \n",
       "516442 2013-06-30   6:45   BROOKLYN     11215  40.675437 -73.977958   \n",
       "516492 2013-06-29  10:30     QUEENS     11101  40.754807 -73.916871   \n",
       "516508 2013-06-29  11:10  MANHATTAN     10016  40.742706 -73.984526   \n",
       "516558 2013-06-29  12:30   BROOKLYN     11238  40.673588 -73.962955   \n",
       "516601 2013-06-29  13:30  MANHATTAN     10040  40.856715 -73.932632   \n",
       "516638 2013-06-29  14:41   BROOKLYN     11236  40.635508 -73.913277   \n",
       "516644 2013-06-29  14:50   BROOKLYN     11204  40.611447 -73.991140   \n",
       "516656 2013-06-29  15:00   BROOKLYN     11222  40.735553 -73.958525   \n",
       "516678 2013-06-29  15:30     QUEENS     11004  40.745451 -73.708374   \n",
       "516764 2013-06-29  17:30     QUEENS     11416  40.684254 -73.852801   \n",
       "516804 2013-06-29  18:30  MANHATTAN     10014  40.735305 -74.004933   \n",
       "516810 2013-06-29  18:40   BROOKLYN     11208  40.682038 -73.877868   \n",
       "516847 2013-06-29  19:50     QUEENS     11368  40.756287 -73.860720   \n",
       "516881 2013-06-29  20:36   BROOKLYN     11212  40.654629 -73.922006   \n",
       "516894 2013-06-29  21:15        NaN       NaN        NaN        NaN   \n",
       "516992 2013-06-29   4:35   BROOKLYN     11217  40.685659 -73.985689   \n",
       "517066 2013-06-28  17:20  MANHATTAN     10035  40.804376 -73.937420   \n",
       "517090 2013-06-28  16:59  MANHATTAN     10002  40.721463 -73.988524   \n",
       "...           ...    ...        ...       ...        ...        ...   \n",
       "715260 2012-07-02  16:45  MANHATTAN     10027  40.810765 -73.952590   \n",
       "715274 2012-07-02  17:00  MANHATTAN     10016  40.748302 -73.978338   \n",
       "715293 2012-07-02  17:25  MANHATTAN     10009  40.733212 -73.981057   \n",
       "715308 2012-07-02  17:40   BROOKLYN     11216  40.682835 -73.940913   \n",
       "715330 2012-07-02  18:04   BROOKLYN     11213  40.671125 -73.940930   \n",
       "715343 2012-07-02  18:30   BROOKLYN     11205  40.698117 -73.977532   \n",
       "715387 2012-07-02   8:30        NaN       NaN        NaN        NaN   \n",
       "715437 2012-07-02  19:28  MANHATTAN     10032  40.830892 -73.941367   \n",
       "715439 2012-07-02  12:00        NaN       NaN        NaN        NaN   \n",
       "715453 2012-07-02  19:40   BROOKLYN     11208  40.676056 -73.876509   \n",
       "715454 2012-07-02  19:42     QUEENS     11421  40.695520 -73.864558   \n",
       "715455 2012-07-02  19:45     QUEENS     11369  40.768841 -73.869662   \n",
       "715457 2012-07-02  19:50   BROOKLYN     11234  40.623980 -73.920626   \n",
       "715476 2012-07-02  22:56     QUEENS     11385  40.700593 -73.854565   \n",
       "715496 2012-07-02  21:25      BRONX     10474  40.806972 -73.883559   \n",
       "715500 2012-07-02  21:10     QUEENS     11377  40.751840 -73.903571   \n",
       "715516 2012-07-02  20:20     QUEENS     11417  40.680297 -73.844640   \n",
       "715524 2012-07-02   0:19  MANHATTAN     10007  40.713692 -74.013754   \n",
       "715525 2012-07-02   0:21   BROOKLYN     11218  40.636133 -73.972736   \n",
       "715554 2012-07-02   9:46  MANHATTAN     10002  40.717724 -73.985765   \n",
       "715577 2012-07-02   5:25  MANHATTAN     10002  40.717894 -73.989474   \n",
       "715704 2012-07-01  14:14  MANHATTAN     10003  40.731166 -73.991921   \n",
       "715812 2012-07-01  15:40   BROOKLYN     11224  40.576159 -73.989017   \n",
       "715854 2012-07-01  12:15   BROOKLYN     11211  40.711801 -73.942229   \n",
       "715963 2012-07-01   2:30  MANHATTAN     10065  40.764162 -73.968890   \n",
       "715990 2012-07-01  22:47   BROOKLYN     11211  40.710957 -73.951117   \n",
       "715998 2012-07-01  22:20      BRONX     10473  40.823191 -73.855312   \n",
       "716009 2012-07-01  21:40  MANHATTAN     10009  40.724285 -73.975594   \n",
       "716017 2012-07-01  21:08   BROOKLYN     11212  40.672075 -73.911336   \n",
       "716122 2012-07-01   6:50      BRONX     10468  40.862679 -73.909040   \n",
       "\n",
       "                         LOCATION         ON STREET NAME  \\\n",
       "516048   (40.6916242, -73.942661)       KOSCIUSKO STREET   \n",
       "516077   (40.692778, -73.9576793)        FRANKLIN AVENUE   \n",
       "516100  (40.7428447, -73.8512103)             111 STREET   \n",
       "516130  (40.7766272, -73.8390537)           ULMER STREET   \n",
       "516187  (40.7499403, -73.8824498)              37 AVENUE   \n",
       "516262  (40.7356042, -73.7751544)              73 AVENUE   \n",
       "516331                        NaN          CORONA AVENUE   \n",
       "516354  (40.8300784, -73.8537615)        HAVILAND AVENUE   \n",
       "516362  (40.7797473, -73.9158185)      DITMARS BOULEVARD   \n",
       "516363  (40.7727901, -73.8371242)              28 AVENUE   \n",
       "516391  (40.8388747, -73.9026466)      WASHINGTON AVENUE   \n",
       "516406  (40.8438234, -73.9165542)          INWOOD AVENUE   \n",
       "516442  (40.6754368, -73.9779583)               6 AVENUE   \n",
       "516492  (40.7548066, -73.9168715)              34 AVENUE   \n",
       "516508  (40.7427065, -73.9845256)      PARK AVENUE SOUTH   \n",
       "516558  (40.6735884, -73.9629548)      WASHINGTON AVENUE   \n",
       "516601  (40.8567148, -73.9326318)               BROADWAY   \n",
       "516638   (40.635508, -73.9132766)         EAST 80 STREET   \n",
       "516644  (40.6114466, -73.9911399)              20 AVENUE   \n",
       "516656  (40.7355527, -73.9585253)        FRANKLIN STREET   \n",
       "516678  (40.7454509, -73.7083741)             263 STREET   \n",
       "516764  (40.6842542, -73.8528013)              88 STREET   \n",
       "516804  (40.7353048, -74.0049326)        BLEECKER STREET   \n",
       "516810  (40.6820384, -73.8778679)          FULTON STREET   \n",
       "516847  (40.7562867, -73.8607202)              34 AVENUE   \n",
       "516881   (40.654629, -73.9220058)          REMSEN AVENUE   \n",
       "516894                        NaN     WESTCHESTER AVENUE   \n",
       "516992  (40.6856595, -73.9856891)            DEAN STREET   \n",
       "517066  (40.8043758, -73.9374202)        EAST 125 STREET   \n",
       "517090  (40.7214625, -73.9885242)         ORCHARD STREET   \n",
       "...                           ...                    ...   \n",
       "715260  (40.8107645, -73.9525902)        WEST 125 STREET   \n",
       "715274   (40.748302, -73.9783384)         EAST 37 STREET   \n",
       "715293  (40.7332119, -73.9810567)         EAST 17 STREET   \n",
       "715308  (40.6828346, -73.9409127)          HALSEY STREET   \n",
       "715330  (40.6711254, -73.9409303)      SAINT JOHNS PLACE   \n",
       "715343  (40.6981167, -73.9775324)     NORTH ELLIOT PLACE   \n",
       "715387                        NaN        RIVERSIDE DRIVE   \n",
       "715437  (40.8308918, -73.9413666)  SAINT NICHOLAS AVENUE   \n",
       "715439                        NaN          KINGS HIGHWAY   \n",
       "715453   (40.676056, -73.8765089)        GLENMORE AVENUE   \n",
       "715454  (40.6955195, -73.8645579)        PARK LANE SOUTH   \n",
       "715455  (40.7688406, -73.8696616)             101 STREET   \n",
       "715457  (40.6239797, -73.9206259)         EAST 57 STREET   \n",
       "715476  (40.7005934, -73.8545649)    WOODHAVEN BOULEVARD   \n",
       "715496  (40.8069716, -73.8835591)          BRYANT AVENUE   \n",
       "715500  (40.7518401, -73.9035714)               BROADWAY   \n",
       "715516  (40.6802965, -73.8446402)     CROSSBAY BOULEVARD   \n",
       "715524  (40.7136919, -74.0137542)           VESEY STREET   \n",
       "715525  (40.6361331, -73.9727361)          DITMAS AVENUE   \n",
       "715554  (40.7177239, -73.9857652)        DELANCEY STREET   \n",
       "715577  (40.7178944, -73.9894735)          LUDLOW STREET   \n",
       "715704  (40.7311655, -73.9919214)               BROADWAY   \n",
       "715812  (40.5761593, -73.9890171)         MERMAID AVENUE   \n",
       "715854  (40.7118008, -73.9422288)           GRAND STREET   \n",
       "715963  (40.7641617, -73.9688897)         EAST 61 STREET   \n",
       "715990  (40.7109568, -73.9511173)           GRAND STREET   \n",
       "715998  (40.8231912, -73.8553122)        TURNBULL AVENUE   \n",
       "716009  (40.7242849, -73.9755935)          EAST 9 STREET   \n",
       "716017  (40.6720753, -73.9113364)   EAST NEW YORK AVENUE   \n",
       "716122  (40.8626793, -73.9090397)        SEDGWICK AVENUE   \n",
       "\n",
       "            CROSS STREET NAME OFF STREET NAME         ...          \\\n",
       "516048          THROOP AVENUE             NaN         ...           \n",
       "516077      WILLOUGHBY AVENUE             NaN         ...           \n",
       "516100              54 AVENUE             NaN         ...           \n",
       "516130              25 AVENUE             NaN         ...           \n",
       "516187              84 STREET             NaN         ...           \n",
       "516262             197 STREET             NaN         ...           \n",
       "516331               91 PLACE             NaN         ...           \n",
       "516354        OLMSTEAD AVENUE             NaN         ...           \n",
       "516362              23 STREET             NaN         ...           \n",
       "516363           ULMER STREET             NaN         ...           \n",
       "516391      CLAREMONT PARKWAY             NaN         ...           \n",
       "516406            GOBLE PLACE             NaN         ...           \n",
       "516442           UNION STREET             NaN         ...           \n",
       "516492              45 STREET             NaN         ...           \n",
       "516508         EAST 27 STREET             NaN         ...           \n",
       "516558      SAINT JOHNS PLACE             NaN         ...           \n",
       "516601        FAIRVIEW AVENUE             NaN         ...           \n",
       "516638       FLATLANDS AVENUE             NaN         ...           \n",
       "516644              74 STREET             NaN         ...           \n",
       "516656          DUPONT STREET             NaN         ...           \n",
       "516678              80 AVENUE             NaN         ...           \n",
       "516764              97 AVENUE             NaN         ...           \n",
       "516804           PERRY STREET             NaN         ...           \n",
       "516810           LOGAN STREET             NaN         ...           \n",
       "516847             108 STREET             NaN         ...           \n",
       "516881          KINGS HIGHWAY             NaN         ...           \n",
       "516894          HOBART AVENUE             NaN         ...           \n",
       "516992            BOND STREET             NaN         ...           \n",
       "517066       LEXINGTON AVENUE             NaN         ...           \n",
       "517090         STANTON STREET             NaN         ...           \n",
       "...                       ...             ...         ...           \n",
       "715260  SAINT NICHOLAS AVENUE             NaN         ...           \n",
       "715274       LEXINGTON AVENUE             NaN         ...           \n",
       "715293               1 AVENUE             NaN         ...           \n",
       "715308          THROOP AVENUE             NaN         ...           \n",
       "715330          HAMPTON PLACE             NaN         ...           \n",
       "715343        FLUSHING AVENUE             NaN         ...           \n",
       "715387        WEST 158 STREET             NaN         ...           \n",
       "715437        WEST 155 STREET             NaN         ...           \n",
       "715439         CLARENDON ROAD             NaN         ...           \n",
       "715453           LOGAN STREET             NaN         ...           \n",
       "715454              79 STREET             NaN         ...           \n",
       "715455              23 AVENUE             NaN         ...           \n",
       "715457               AVENUE L             NaN         ...           \n",
       "715476      FOREST PARK DRIVE             NaN         ...           \n",
       "715496           VIELE AVENUE             NaN         ...           \n",
       "715500              58 STREET             NaN         ...           \n",
       "715516         LIBERTY AVENUE             NaN         ...           \n",
       "715524            WEST STREET             NaN         ...           \n",
       "715525          OCEAN PARKWAY             NaN         ...           \n",
       "715554         CLINTON STREET             NaN         ...           \n",
       "715577          BROOME STREET             NaN         ...           \n",
       "715704          EAST 9 STREET             NaN         ...           \n",
       "715812         WEST 22 STREET             NaN         ...           \n",
       "715854        HUMBOLDT STREET             NaN         ...           \n",
       "715963            PARK AVENUE             NaN         ...           \n",
       "715990           UNION AVENUE             NaN         ...           \n",
       "715998         PUGSLEY AVENUE             NaN         ...           \n",
       "716009               AVENUE D             NaN         ...           \n",
       "716017        ROCKAWAY AVENUE             NaN         ...           \n",
       "716122      WEST FORDHAM ROAD             NaN         ...           \n",
       "\n",
       "        CONTRIBUTING FACTOR VEHICLE 2  CONTRIBUTING FACTOR VEHICLE 3  \\\n",
       "516048                    Unspecified                            NaN   \n",
       "516077                    Unspecified                            NaN   \n",
       "516100                    Unspecified                            NaN   \n",
       "516130                    Unspecified                            NaN   \n",
       "516187                    Unspecified                            NaN   \n",
       "516262                    Unspecified                            NaN   \n",
       "516331                    Unspecified                            NaN   \n",
       "516354                    Unspecified                            NaN   \n",
       "516362                    Unspecified                            NaN   \n",
       "516363                    Unspecified                            NaN   \n",
       "516391                    Unspecified                            NaN   \n",
       "516406                    Unspecified                            NaN   \n",
       "516442                    Unspecified                            NaN   \n",
       "516492                    Unspecified                            NaN   \n",
       "516508                    Unspecified                            NaN   \n",
       "516558                    Unspecified                            NaN   \n",
       "516601                    Unspecified                            NaN   \n",
       "516638                    Unspecified                            NaN   \n",
       "516644                    Unspecified                            NaN   \n",
       "516656          Passenger Distraction                            NaN   \n",
       "516678                    Unspecified                            NaN   \n",
       "516764                    Unspecified                            NaN   \n",
       "516804                    Unspecified                            NaN   \n",
       "516810                    Unspecified                            NaN   \n",
       "516847                    Unspecified                            NaN   \n",
       "516881                    Unspecified                    Unspecified   \n",
       "516894                    Unspecified                            NaN   \n",
       "516992                    Unspecified                            NaN   \n",
       "517066                    Unspecified                            NaN   \n",
       "517090                    Unspecified                            NaN   \n",
       "...                               ...                            ...   \n",
       "715260                    Unspecified                            NaN   \n",
       "715274                    Unspecified                            NaN   \n",
       "715293                    Unspecified                            NaN   \n",
       "715308            Physical Disability                            NaN   \n",
       "715330                    Unspecified                            NaN   \n",
       "715343            Driver Inexperience                            NaN   \n",
       "715387                    Unspecified                            NaN   \n",
       "715437                    Unspecified                            NaN   \n",
       "715439                    Unspecified                            NaN   \n",
       "715453                    Unspecified                            NaN   \n",
       "715454                    Unspecified                            NaN   \n",
       "715455                    Unspecified                            NaN   \n",
       "715457                    Unspecified                            NaN   \n",
       "715476                    Unspecified                            NaN   \n",
       "715496                    Unspecified                            NaN   \n",
       "715500                    Unspecified                            NaN   \n",
       "715516                    Unspecified                            NaN   \n",
       "715524                    Unspecified                            NaN   \n",
       "715525                    Unspecified                            NaN   \n",
       "715554                    Unspecified                            NaN   \n",
       "715577                    Unspecified                            NaN   \n",
       "715704                    Unspecified                            NaN   \n",
       "715812                    Unspecified                            NaN   \n",
       "715854                    Unspecified                            NaN   \n",
       "715963          Passenger Distraction                            NaN   \n",
       "715990                    Unspecified                            NaN   \n",
       "715998                    Unspecified                            NaN   \n",
       "716009                    Unspecified                            NaN   \n",
       "716017                    Unspecified                            NaN   \n",
       "716122                    Unspecified                            NaN   \n",
       "\n",
       "        CONTRIBUTING FACTOR VEHICLE 4  CONTRIBUTING FACTOR VEHICLE 5  \\\n",
       "516048                            NaN                            NaN   \n",
       "516077                            NaN                            NaN   \n",
       "516100                            NaN                            NaN   \n",
       "516130                            NaN                            NaN   \n",
       "516187                            NaN                            NaN   \n",
       "516262                            NaN                            NaN   \n",
       "516331                            NaN                            NaN   \n",
       "516354                            NaN                            NaN   \n",
       "516362                            NaN                            NaN   \n",
       "516363                            NaN                            NaN   \n",
       "516391                            NaN                            NaN   \n",
       "516406                            NaN                            NaN   \n",
       "516442                            NaN                            NaN   \n",
       "516492                            NaN                            NaN   \n",
       "516508                            NaN                            NaN   \n",
       "516558                            NaN                            NaN   \n",
       "516601                            NaN                            NaN   \n",
       "516638                            NaN                            NaN   \n",
       "516644                            NaN                            NaN   \n",
       "516656                            NaN                            NaN   \n",
       "516678                            NaN                            NaN   \n",
       "516764                            NaN                            NaN   \n",
       "516804                            NaN                            NaN   \n",
       "516810                            NaN                            NaN   \n",
       "516847                            NaN                            NaN   \n",
       "516881                            NaN                            NaN   \n",
       "516894                            NaN                            NaN   \n",
       "516992                            NaN                            NaN   \n",
       "517066                            NaN                            NaN   \n",
       "517090                            NaN                            NaN   \n",
       "...                               ...                            ...   \n",
       "715260                            NaN                            NaN   \n",
       "715274                            NaN                            NaN   \n",
       "715293                            NaN                            NaN   \n",
       "715308                            NaN                            NaN   \n",
       "715330                            NaN                            NaN   \n",
       "715343                            NaN                            NaN   \n",
       "715387                            NaN                            NaN   \n",
       "715437                            NaN                            NaN   \n",
       "715439                            NaN                            NaN   \n",
       "715453                            NaN                            NaN   \n",
       "715454                            NaN                            NaN   \n",
       "715455                            NaN                            NaN   \n",
       "715457                            NaN                            NaN   \n",
       "715476                            NaN                            NaN   \n",
       "715496                            NaN                            NaN   \n",
       "715500                            NaN                            NaN   \n",
       "715516                            NaN                            NaN   \n",
       "715524                            NaN                            NaN   \n",
       "715525                            NaN                            NaN   \n",
       "715554                            NaN                            NaN   \n",
       "715577                            NaN                            NaN   \n",
       "715704                            NaN                            NaN   \n",
       "715812                            NaN                            NaN   \n",
       "715854                            NaN                            NaN   \n",
       "715963                            NaN                            NaN   \n",
       "715990                            NaN                            NaN   \n",
       "715998                            NaN                            NaN   \n",
       "716009                            NaN                            NaN   \n",
       "716017                            NaN                            NaN   \n",
       "716122                            NaN                            NaN   \n",
       "\n",
       "        UNIQUE KEY             VEHICLE TYPE CODE 1  VEHICLE TYPE CODE 2  \\\n",
       "516048      181326                         UNKNOWN              BICYCLE   \n",
       "516077      181325               PASSENGER VEHICLE              BICYCLE   \n",
       "516100      257535   SPORT UTILITY / STATION WAGON              BICYCLE   \n",
       "516130      251041   SPORT UTILITY / STATION WAGON              BICYCLE   \n",
       "516187      282512               PASSENGER VEHICLE              BICYCLE   \n",
       "516262      236201               PASSENGER VEHICLE              BICYCLE   \n",
       "516331      257531               PASSENGER VEHICLE              BICYCLE   \n",
       "516354       83334                  LIVERY VEHICLE              BICYCLE   \n",
       "516362      276543   SPORT UTILITY / STATION WAGON              BICYCLE   \n",
       "516363      251044   SPORT UTILITY / STATION WAGON              BICYCLE   \n",
       "516391       79857                           OTHER              BICYCLE   \n",
       "516406       87192                  LIVERY VEHICLE              BICYCLE   \n",
       "516442      177896               PASSENGER VEHICLE              BICYCLE   \n",
       "516492      276526   SPORT UTILITY / STATION WAGON              BICYCLE   \n",
       "516508       24263                            TAXI              BICYCLE   \n",
       "516558      174369   SPORT UTILITY / STATION WAGON              BICYCLE   \n",
       "516601       71530                             BUS              BICYCLE   \n",
       "516638      146317               PASSENGER VEHICLE              BICYCLE   \n",
       "516644      123931   SPORT UTILITY / STATION WAGON              BICYCLE   \n",
       "516656      199851               PASSENGER VEHICLE              BICYCLE   \n",
       "516678      224272               PASSENGER VEHICLE              BICYCLE   \n",
       "516764      206559   SPORT UTILITY / STATION WAGON              BICYCLE   \n",
       "516804       11064               PASSENGER VEHICLE              BICYCLE   \n",
       "516810      167712   SPORT UTILITY / STATION WAGON              BICYCLE   \n",
       "516847      282501               PASSENGER VEHICLE              BICYCLE   \n",
       "516881      138378               PASSENGER VEHICLE    PASSENGER VEHICLE   \n",
       "516894       90656               PASSENGER VEHICLE              BICYCLE   \n",
       "516992      189912   SPORT UTILITY / STATION WAGON              BICYCLE   \n",
       "517066       61113                           OTHER              BICYCLE   \n",
       "517090       13147               PASSENGER VEHICLE              BICYCLE   \n",
       "...            ...                             ...                  ...   \n",
       "715260       62169   SPORT UTILITY / STATION WAGON              BICYCLE   \n",
       "715274       32055                            TAXI              BICYCLE   \n",
       "715293       21682                             BUS              BICYCLE   \n",
       "715308      179422                           OTHER              BICYCLE   \n",
       "715330      172559   SPORT UTILITY / STATION WAGON              BICYCLE   \n",
       "715343      191557               PASSENGER VEHICLE              BICYCLE   \n",
       "715387       68165   SPORT UTILITY / STATION WAGON              BICYCLE   \n",
       "715437       65003               PASSENGER VEHICLE              BICYCLE   \n",
       "715439      135050               PASSENGER VEHICLE              BICYCLE   \n",
       "715453      163390               PASSENGER VEHICLE              BICYCLE   \n",
       "715454      203698   SPORT UTILITY / STATION WAGON              BICYCLE   \n",
       "715455      279657               PASSENGER VEHICLE              BICYCLE   \n",
       "715457      125676               PASSENGER VEHICLE              BICYCLE   \n",
       "715476      203707                         UNKNOWN              BICYCLE   \n",
       "715496       76210               PASSENGER VEHICLE              BICYCLE   \n",
       "715500      238659               PASSENGER VEHICLE              BICYCLE   \n",
       "715516      227954  LARGE COM VEH(6 OR MORE TIRES)              BICYCLE   \n",
       "715524          37               PASSENGER VEHICLE              BICYCLE   \n",
       "715525      129911               PASSENGER VEHICLE              BICYCLE   \n",
       "715554       12187                   PICK-UP TRUCK              BICYCLE   \n",
       "715577       12185               PASSENGER VEHICLE              BICYCLE   \n",
       "715704        9409                            TAXI              BICYCLE   \n",
       "715812      113545                             BUS              BICYCLE   \n",
       "715854      193861               PASSENGER VEHICLE              BICYCLE   \n",
       "715963       44909                            TAXI              BICYCLE   \n",
       "715990      193864               PASSENGER VEHICLE              BICYCLE   \n",
       "715998       80828               PASSENGER VEHICLE              BICYCLE   \n",
       "716009       13871                            TAXI              BICYCLE   \n",
       "716017      160106               PASSENGER VEHICLE              BICYCLE   \n",
       "716122      109483               PASSENGER VEHICLE              BICYCLE   \n",
       "\n",
       "        VEHICLE TYPE CODE 3 VEHICLE TYPE CODE 4 VEHICLE TYPE CODE 5  \n",
       "516048                  NaN                 NaN                 NaN  \n",
       "516077                  NaN                 NaN                 NaN  \n",
       "516100                  NaN                 NaN                 NaN  \n",
       "516130                  NaN                 NaN                 NaN  \n",
       "516187                  NaN                 NaN                 NaN  \n",
       "516262                  NaN                 NaN                 NaN  \n",
       "516331                  NaN                 NaN                 NaN  \n",
       "516354                  NaN                 NaN                 NaN  \n",
       "516362                  NaN                 NaN                 NaN  \n",
       "516363                  NaN                 NaN                 NaN  \n",
       "516391                  NaN                 NaN                 NaN  \n",
       "516406                  NaN                 NaN                 NaN  \n",
       "516442                  NaN                 NaN                 NaN  \n",
       "516492                  NaN                 NaN                 NaN  \n",
       "516508                  NaN                 NaN                 NaN  \n",
       "516558                  NaN                 NaN                 NaN  \n",
       "516601                  NaN                 NaN                 NaN  \n",
       "516638                  NaN                 NaN                 NaN  \n",
       "516644                  NaN                 NaN                 NaN  \n",
       "516656                  NaN                 NaN                 NaN  \n",
       "516678                  NaN                 NaN                 NaN  \n",
       "516764                  NaN                 NaN                 NaN  \n",
       "516804                  NaN                 NaN                 NaN  \n",
       "516810                  NaN                 NaN                 NaN  \n",
       "516847                  NaN                 NaN                 NaN  \n",
       "516881              BICYCLE                 NaN                 NaN  \n",
       "516894                  NaN                 NaN                 NaN  \n",
       "516992                  NaN                 NaN                 NaN  \n",
       "517066                  NaN                 NaN                 NaN  \n",
       "517090                  NaN                 NaN                 NaN  \n",
       "...                     ...                 ...                 ...  \n",
       "715260                  NaN                 NaN                 NaN  \n",
       "715274                  NaN                 NaN                 NaN  \n",
       "715293                  NaN                 NaN                 NaN  \n",
       "715308                  NaN                 NaN                 NaN  \n",
       "715330                  NaN                 NaN                 NaN  \n",
       "715343                  NaN                 NaN                 NaN  \n",
       "715387                  NaN                 NaN                 NaN  \n",
       "715437                  NaN                 NaN                 NaN  \n",
       "715439                  NaN                 NaN                 NaN  \n",
       "715453                  NaN                 NaN                 NaN  \n",
       "715454                  NaN                 NaN                 NaN  \n",
       "715455                  NaN                 NaN                 NaN  \n",
       "715457                  NaN                 NaN                 NaN  \n",
       "715476                  NaN                 NaN                 NaN  \n",
       "715496                  NaN                 NaN                 NaN  \n",
       "715500                  NaN                 NaN                 NaN  \n",
       "715516                  NaN                 NaN                 NaN  \n",
       "715524                  NaN                 NaN                 NaN  \n",
       "715525                  NaN                 NaN                 NaN  \n",
       "715554                  NaN                 NaN                 NaN  \n",
       "715577                  NaN                 NaN                 NaN  \n",
       "715704                  NaN                 NaN                 NaN  \n",
       "715812                  NaN                 NaN                 NaN  \n",
       "715854                  NaN                 NaN                 NaN  \n",
       "715963                  NaN                 NaN                 NaN  \n",
       "715990                  NaN                 NaN                 NaN  \n",
       "715998                  NaN                 NaN                 NaN  \n",
       "716009                  NaN                 NaN                 NaN  \n",
       "716017                  NaN                 NaN                 NaN  \n",
       "716122                  NaN                 NaN                 NaN  \n",
       "\n",
       "[3914 rows x 29 columns]"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print len(d1),len(d2)\n",
    "d1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "d1.to_csv('data/b4ct_collisions.csv')\n",
    "d2.to_csv('data/afct_collisions.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "inj_b4 = d1.groupby('ZIP CODE').sum()['NUMBER OF CYCLIST INJURED']\n",
    "inj_af = d2.groupby('ZIP CODE').sum()['NUMBER OF CYCLIST INJURED']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([ 1, 46, 80, 75,  6,  6,  1, 15, 49, 51, 48, 28, 29, 17, 55, 27, 28,\n",
       "       49,  1, 28, 39, 31, 18, 23, 23, 32, 12, 27, 12, 18, 10, 16, 13, 14,\n",
       "       32,  5, 12,  6, 10, 12,  1, 11,  1, 23,  2,  2,  7,  4,  3,  5,  4,\n",
       "        6,  2,  1,  5,  2,  3, 11, 15, 11,  8,  9, 14, 15, 23, 13, 19, 13,\n",
       "       13,  6,  2,  8, 11, 14, 20, 10,  1,  2, 18, 10, 10,  3,  3, 39, 23,\n",
       "       35, 18, 14, 20, 44, 53, 39, 63, 91, 69, 32, 24, 29, 71, 47, 43, 25,\n",
       "       49, 56, 56, 42, 37, 47, 43, 40, 36, 15, 50, 54, 14, 30, 42, 13, 34,\n",
       "       31, 22, 27, 21, 24, 57,  1, 30, 15, 15,  2,  5,  6,  4,  1,  6,  6,\n",
       "        3,  3,  7, 68, 14,  9, 75, 34,  9, 17, 50, 11,  9, 28,  4, 16,  9,\n",
       "        1,  7,  9,  6, 10, 16, 12, 15,  5,  4,  4,  2,  3,  5,  8,  8, 12,\n",
       "        4,  5, 13,  2,  6,  3])"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "inj_b4.values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ZipCode</th>\n",
       "      <th>NumberofIncidents</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>10001</td>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>10002</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>10003</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>10004</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>10005</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>10006</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>10007</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>10009</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10010</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10011</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>10012</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>10013</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>10014</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>10016</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>10017</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>10018</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>10019</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>10020</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>10021</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>10022</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>10023</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>10024</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>10025</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>10026</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>10027</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>10028</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>10029</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>10030</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>10031</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>11377</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>11378</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>11379</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>11385</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>11411</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>11412</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>11413</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>11414</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>11415</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>11416</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>11417</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>11418</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>11419</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>11420</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>11421</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>11422</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>11423</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>11426</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>11427</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>11428</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>11429</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>11432</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>11433</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>11434</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>11435</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>11436</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>11691</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>11693</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>11694</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>11697</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>176 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     ZipCode  NumberofIncidents\n",
       "0      10000                  1\n",
       "1      10001                 46\n",
       "2      10002                 80\n",
       "3      10003                 75\n",
       "4      10004                  6\n",
       "5      10005                  6\n",
       "6      10006                  1\n",
       "7      10007                 15\n",
       "8      10009                 49\n",
       "9      10010                 51\n",
       "10     10011                 48\n",
       "11     10012                 28\n",
       "12     10013                 29\n",
       "13     10014                 17\n",
       "14     10016                 55\n",
       "15     10017                 27\n",
       "16     10018                 28\n",
       "17     10019                 49\n",
       "18     10020                  1\n",
       "19     10021                 28\n",
       "20     10022                 39\n",
       "21     10023                 31\n",
       "22     10024                 18\n",
       "23     10025                 23\n",
       "24     10026                 23\n",
       "25     10027                 32\n",
       "26     10028                 12\n",
       "27     10029                 27\n",
       "28     10030                 12\n",
       "29     10031                 18\n",
       "..       ...                ...\n",
       "146    11377                 50\n",
       "147    11378                 11\n",
       "148    11379                  9\n",
       "149    11385                 28\n",
       "150    11411                  4\n",
       "151    11412                 16\n",
       "152    11413                  9\n",
       "153    11414                  1\n",
       "154    11415                  7\n",
       "155    11416                  9\n",
       "156    11417                  6\n",
       "157    11418                 10\n",
       "158    11419                 16\n",
       "159    11420                 12\n",
       "160    11421                 15\n",
       "161    11422                  5\n",
       "162    11423                  4\n",
       "163    11426                  4\n",
       "164    11427                  2\n",
       "165    11428                  3\n",
       "166    11429                  5\n",
       "167    11432                  8\n",
       "168    11433                  8\n",
       "169    11434                 12\n",
       "170    11435                  4\n",
       "171    11436                  5\n",
       "172    11691                 13\n",
       "173    11693                  2\n",
       "174    11694                  6\n",
       "175    11697                  3\n",
       "\n",
       "[176 rows x 2 columns]"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_b4 = pd.DataFrame(columns=['ZipCode','NumberofIncidents'])\n",
    "df_b4['ZipCode'] = inj_b4.index\n",
    "df_b4['NumberofIncidents'] = inj_b4.values\n",
    "df_b4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ZipCode</th>\n",
       "      <th>NumberofIncidents</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>11206</td>\n",
       "      <td>91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>10002</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>10003</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>11372</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>11211</td>\n",
       "      <td>71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>11207</td>\n",
       "      <td>69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>11368</td>\n",
       "      <td>68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>11205</td>\n",
       "      <td>63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>11238</td>\n",
       "      <td>57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>11216</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>11217</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>10016</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>11226</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>11203</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10010</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>11225</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>11377</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>10019</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>10009</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>11215</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     ZipCode  NumberofIncidents\n",
       "93     11206                 91\n",
       "2      10002                 80\n",
       "3      10003                 75\n",
       "142    11372                 75\n",
       "98     11211                 71\n",
       "94     11207                 69\n",
       "139    11368                 68\n",
       "92     11205                 63\n",
       "124    11238                 57\n",
       "103    11216                 56\n",
       "104    11217                 56\n",
       "14     10016                 55\n",
       "113    11226                 54\n",
       "90     11203                 53\n",
       "9      10010                 51\n",
       "112    11225                 50\n",
       "146    11377                 50\n",
       "17     10019                 49\n",
       "8      10009                 49\n",
       "102    11215                 49"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_b4 = df_b4.sort(['NumberofIncidents'],ascending=False)\n",
    "df_b4[:20]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df_b4.to_csv('data_/b4_collision_zip.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ZipCode</th>\n",
       "      <th>NumberofIncidents</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>11211</td>\n",
       "      <td>250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>11206</td>\n",
       "      <td>230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>10002</td>\n",
       "      <td>199</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>10003</td>\n",
       "      <td>168</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>11368</td>\n",
       "      <td>166</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>11226</td>\n",
       "      <td>166</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>10010</td>\n",
       "      <td>165</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>11205</td>\n",
       "      <td>163</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>11207</td>\n",
       "      <td>152</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>10016</td>\n",
       "      <td>150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>11221</td>\n",
       "      <td>145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>11238</td>\n",
       "      <td>145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>11215</td>\n",
       "      <td>143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>10019</td>\n",
       "      <td>137</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>11201</td>\n",
       "      <td>137</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>11217</td>\n",
       "      <td>135</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>11216</td>\n",
       "      <td>133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>11377</td>\n",
       "      <td>130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>10009</td>\n",
       "      <td>128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>11372</td>\n",
       "      <td>128</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     ZipCode  NumberofIncidents\n",
       "96     11211                250\n",
       "91     11206                230\n",
       "1      10002                199\n",
       "2      10003                168\n",
       "137    11368                166\n",
       "111    11226                166\n",
       "8      10010                165\n",
       "90     11205                163\n",
       "92     11207                152\n",
       "13     10016                150\n",
       "106    11221                145\n",
       "122    11238                145\n",
       "100    11215                143\n",
       "16     10019                137\n",
       "87     11201                137\n",
       "102    11217                135\n",
       "101    11216                133\n",
       "144    11377                130\n",
       "7      10009                128\n",
       "140    11372                128"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_af = pd.DataFrame(columns=['ZipCode','NumberofIncidents'])\n",
    "df_af['ZipCode'] = inj_af.index\n",
    "df_af['NumberofIncidents'] = inj_af.values\n",
    "df_af = df_af.sort(['NumberofIncidents'],ascending=False)\n",
    "df_af[:20]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df_af.to_csv('data_/af_collision_zip.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}