notebook.community

Edit and run 





In [21]:



    


import numpy as np
import pandas as pd
import itertools
from __future__ import division
import geoplotlib as glp
from geoplotlib.utils import BoundingBox, DataAccessObject
from sklearn import cluster
import geoplotlib as gpl

%matplotlib inline
pd.set_option('display.max_columns', None)



    











In [28]:



    


filePath = 'datasets/NYPD_Motor_Vehicle_Collisions_weather4.csv'
collisions = pd.read_csv(filePath)
collisions['YEAR'] = collisions.DATE.str.split('/').str.get(2)



    











In [76]:



    


def kmean(k, dataset, colums):
    md = cluster.KMeans(n_clusters=k).fit(dataset[colums])
    return md.predict(dataset[colums]),md.cluster_centers_


def encode_column(df, target_column):
    df_mod = df.copy()
    targets = pd.Series(df_mod[target_column].unique())
    map_to_int = {name: n for n, name in enumerate(targets)}
    df_mod[target_column+"_encoded"] = df_mod[target_column].replace(map_to_int)
    return (df_mod, targets)

mask = ((pd.notnull(collisions.LOCATION)) & (collisions.YEAR == str(2015)) & (pd.notnull(collisions.TemperatureC)))
data = collisions.loc[mask]
print "Data size: %s" % len(data.index)

data, _ = encode_column(data, 'CONTRIBUTING FACTOR VEHICLE 1')
data, _ = encode_column(data, 'Conditions')

data.TemperatureC = data.TemperatureC.astype('float64')

k = 30

kmeans, centoid = kmean(k, data.loc[mask], ['Conditions_encoded', 'CONTRIBUTING FACTOR VEHICLE 1_encoded', 'TemperatureC'])

result = pd.DataFrame(data.loc[mask])
result['K-mean'] = kmeans



    


















    






Data size: 182788

















In [77]:



    


def get_spaced_colors(n):
    max_value = 16581375 #255**3
    interval = int(max_value / n)
    colors = [hex(I)[2:].zfill(6) for I in range(0, max_value, interval)]
    
    return [[int(i[:2], 16), int(i[2:4], 16), int(i[4:], 16), 255] for i in colors]

def coords(k):
    lat = result[result['K-mean'] == k].LATITUDE.values
    lon = result[result['K-mean'] == k].LONGITUDE.values
    
    return lat,lon


colormap = get_spaced_colors(k)
for i in range(0, k):
    lat, lon = coords(i)

    data = {'lon': lon, 'lat': lat}
    gpl.dot(data, color=colormap[i])

gpl.inline()



    


















    























In [78]:



    


result



    


















    
Out[78]:










  
    

      
      Unnamed: 0
      DATE
      TIME
      BOROUGH
      ZIP CODE
      LATITUDE
      LONGITUDE
      LOCATION
      ON STREET NAME
      CROSS STREET NAME
      OFF STREET NAME
      NUMBER OF PERSONS INJURED
      NUMBER OF PERSONS KILLED
      NUMBER OF PEDESTRIANS INJURED
      NUMBER OF PEDESTRIANS KILLED
      NUMBER OF CYCLIST INJURED
      NUMBER OF CYCLIST KILLED
      NUMBER OF MOTORIST INJURED
      NUMBER OF MOTORIST KILLED
      CONTRIBUTING FACTOR VEHICLE 1
      CONTRIBUTING FACTOR VEHICLE 2
      CONTRIBUTING FACTOR VEHICLE 3
      CONTRIBUTING FACTOR VEHICLE 4
      CONTRIBUTING FACTOR VEHICLE 5
      UNIQUE KEY
      VEHICLE TYPE CODE 1
      VEHICLE TYPE CODE 2
      VEHICLE TYPE CODE 3
      VEHICLE TYPE CODE 4
      VEHICLE TYPE CODE 5
      Conditions
      Precipitationmm
      TemperatureC
      VisibilityKm
      YEAR
      CONTRIBUTING FACTOR VEHICLE 1_encoded
      Conditions_encoded
      K-mean
    

  
  
    

      41375
      41375
      12/31/2015
      5:30
      QUEENS
      11420
      40.681006
      -73.812561
      (40.6810063, -73.812561)
      LINDEN BOULEVARD
      128 STREET
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Unspecified
      Unspecified
      Unspecified
      Unspecified
      NaN
      3363204
      SPORT UTILITY / STATION WAGON
      PASSENGER VEHICLE
      PASSENGER VEHICLE
      PASSENGER VEHICLE
      NaN
      Mostly Cloudy
      -
      8.0
      16.1
      2015
      0
      0
      3
    

    

      41376
      41376
      12/31/2015
      5:40
      NaN
      NaN
      40.822145
      -73.887813
      (40.8221447, -73.8878132)
      NaN
      NaN
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Outside Car Distraction
      Pavement Slippery
      NaN
      NaN
      NaN
      3363688
      PASSENGER VEHICLE
      UNKNOWN
      NaN
      NaN
      NaN
      Mostly Cloudy
      -
      8.0
      16.1
      2015
      1
      0
      3
    

    

      41377
      41377
      12/31/2015
      5:50
      NaN
      NaN
      40.754901
      -73.745477
      (40.7549013, -73.7454772)
      NaN
      NaN
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Outside Car Distraction
      NaN
      NaN
      NaN
      NaN
      3363266
      PASSENGER VEHICLE
      NaN
      NaN
      NaN
      NaN
      Mostly Cloudy
      -
      8.0
      16.1
      2015
      1
      0
      3
    

    

      41378
      41378
      12/31/2015
      5:55
      BRONX
      10463
      40.875683
      -73.908378
      (40.8756831, -73.9083783)
      BROADWAY
      WEST 228 STREET
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Other Vehicular
      Other Vehicular
      Traffic Control Disregarded
      NaN
      NaN
      3363003
      PASSENGER VEHICLE
      SPORT UTILITY / STATION WAGON
      UNKNOWN
      NaN
      NaN
      Mostly Cloudy
      -
      8.0
      16.1
      2015
      2
      0
      3
    

    

      41379
      41379
      12/31/2015
      6:45
      NaN
      NaN
      40.754151
      -73.722875
      (40.7541513, -73.7228746)
      NaN
      NaN
      NaN
      1
      0
      0
      0
      0
      0
      1
      0
      Traffic Control Disregarded
      Unspecified
      Unspecified
      Unspecified
      NaN
      3363196
      PASSENGER VEHICLE
      PASSENGER VEHICLE
      SPORT UTILITY / STATION WAGON
      SPORT UTILITY / STATION WAGON
      NaN
      Mostly Cloudy
      -
      7.8
      16.1
      2015
      3
      0
      27
    

    

      41380
      41380
      12/31/2015
      7:00
      MANHATTAN
      10037
      40.808905
      -73.938337
      (40.8089051, -73.9383371)
      EAST 130 STREET
      MADISON AVENUE
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Unspecified
      Unspecified
      NaN
      NaN
      NaN
      3362880
      PASSENGER VEHICLE
      UNKNOWN
      NaN
      NaN
      NaN
      Mostly Cloudy
      -
      8.9
      16.1
      2015
      0
      0
      3
    

    

      41383
      41383
      12/31/2015
      8:00
      BRONX
      10470
      40.907219
      -73.850401
      (40.9072194, -73.8504009)
      EAST 242 STREET
      ROBERTSON STREET
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Unspecified
      Unspecified
      NaN
      NaN
      NaN
      3362979
      OTHER
      PASSENGER VEHICLE
      NaN
      NaN
      NaN
      Mostly Cloudy
      -
      10.6
      16.1
      2015
      0
      0
      3
    

    

      41384
      41384
      12/31/2015
      8:00
      QUEENS
      11106
      40.755821
      -73.932579
      (40.7558214, -73.9325786)
      29 STREET
      37 AVENUE
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Unspecified
      Unspecified
      NaN
      NaN
      NaN
      3364431
      PASSENGER VEHICLE
      UNKNOWN
      NaN
      NaN
      NaN
      Mostly Cloudy
      -
      10.6
      16.1
      2015
      0
      0
      3
    

    

      41385
      41385
      12/31/2015
      8:00
      QUEENS
      11356
      40.784918
      -73.842128
      (40.7849178, -73.8421283)
      15 AVENUE
      126 STREET
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Unspecified
      Unspecified
      NaN
      NaN
      NaN
      3363257
      PASSENGER VEHICLE
      UNKNOWN
      NaN
      NaN
      NaN
      Mostly Cloudy
      -
      10.6
      16.1
      2015
      0
      0
      3
    

    

      41387
      41387
      12/31/2015
      8:15
      BROOKLYN
      11214
      40.614167
      -74.000396
      (40.614167, -74.0003962)
      NEW UTRECHT AVENUE
      77 STREET
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Unspecified
      Unspecified
      NaN
      NaN
      NaN
      3363760
      PASSENGER VEHICLE
      PASSENGER VEHICLE
      NaN
      NaN
      NaN
      Mostly Cloudy
      -
      10.6
      16.1
      2015
      0
      0
      3
    

    

      41388
      41388
      12/31/2015
      8:15
      QUEENS
      11416
      40.684240
      -73.846095
      (40.68424, -73.8460949)
      101 AVENUE
      WOODHAVEN BOULEVARD
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Driver Inattention/Distraction
      Unspecified
      NaN
      NaN
      NaN
      3363164
      SPORT UTILITY / STATION WAGON
      PASSENGER VEHICLE
      NaN
      NaN
      NaN
      Mostly Cloudy
      -
      10.6
      16.1
      2015
      4
      0
      27
    

    

      41389
      41389
      12/31/2015
      8:15
      QUEENS
      11421
      40.685963
      -73.856529
      (40.6859635, -73.8565294)
      85 STREET
      ATLANTIC AVENUE
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Unspecified
      Unspecified
      NaN
      NaN
      NaN
      3363166
      BUS
      PASSENGER VEHICLE
      NaN
      NaN
      NaN
      Mostly Cloudy
      -
      10.6
      16.1
      2015
      0
      0
      3
    

    

      41390
      41390
      12/31/2015
      8:15
      BROOKLYN
      11214
      40.612216
      -73.997173
      (40.6122155, -73.9971727)
      18 AVENUE
      77 STREET
      NaN
      1
      0
      1
      0
      0
      0
      0
      0
      Unspecified
      NaN
      NaN
      NaN
      NaN
      3363761
      PASSENGER VEHICLE
      NaN
      NaN
      NaN
      NaN
      Mostly Cloudy
      -
      10.6
      16.1
      2015
      0
      0
      3
    

    

      41392
      41392
      12/31/2015
      8:30
      MANHATTAN
      10038
      40.709872
      -74.007052
      (40.7098718, -74.0070517)
      FULTON STREET
      DUTCH STREET
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Other Vehicular
      Other Vehicular
      NaN
      NaN
      NaN
      3362791
      PASSENGER VEHICLE
      UNKNOWN
      NaN
      NaN
      NaN
      Mostly Cloudy
      -
      10.6
      16.1
      2015
      2
      0
      3
    

    

      41393
      41393
      12/31/2015
      8:30
      QUEENS
      11691
      40.596001
      -73.770663
      (40.596001, -73.7706626)
      BEACH 38 STREET
      BEACH CHANNEL DRIVE
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Backing Unsafely
      Unspecified
      NaN
      NaN
      NaN
      3363159
      PASSENGER VEHICLE
      SPORT UTILITY / STATION WAGON
      NaN
      NaN
      NaN
      Mostly Cloudy
      -
      10.6
      16.1
      2015
      5
      0
      27
    

    

      41394
      41394
      12/31/2015
      8:35
      BRONX
      10452
      40.835052
      -73.926138
      (40.8350523, -73.9261381)
      WEST 166 STREET
      WOODYCREST AVENUE
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Physical Disability
      Traffic Control Disregarded
      NaN
      NaN
      NaN
      3364129
      PASSENGER VEHICLE
      TAXI
      NaN
      NaN
      NaN
      Mostly Cloudy
      -
      10.6
      16.1
      2015
      6
      0
      27
    

    

      41396
      41396
      12/31/2015
      8:48
      QUEENS
      11435
      40.692479
      -73.800986
      (40.6924792, -73.8009858)
      LAKEWOOD AVENUE
      WALTHAM STREET
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Unspecified
      Unspecified
      NaN
      NaN
      NaN
      3363176
      SPORT UTILITY / STATION WAGON
      UNKNOWN
      NaN
      NaN
      NaN
      Mostly Cloudy
      -
      10.6
      16.1
      2015
      0
      0
      3
    

    

      41397
      41397
      12/31/2015
      8:50
      BROOKLYN
      11236
      40.648546
      -73.897090
      (40.6485461, -73.89709)
      GLENWOOD ROAD
      EAST 104 STREET
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Driver Inattention/Distraction
      Unspecified
      NaN
      NaN
      NaN
      3363074
      PASSENGER VEHICLE
      SPORT UTILITY / STATION WAGON
      NaN
      NaN
      NaN
      Mostly Cloudy
      -
      10.6
      16.1
      2015
      4
      0
      27
    

    

      41398
      41398
      12/31/2015
      9:20
      MANHATTAN
      10010
      40.740873
      -73.987983
      (40.7408734, -73.9879831)
      EAST 23 STREET
      MADISON AVENUE
      NaN
      1
      0
      1
      0
      0
      0
      0
      0
      Unspecified
      NaN
      NaN
      NaN
      NaN
      3362829
      SPORT UTILITY / STATION WAGON
      NaN
      NaN
      NaN
      NaN
      Mostly Cloudy
      -
      10.0
      16.1
      2015
      0
      0
      3
    

    

      41399
      41399
      12/31/2015
      9:29
      MANHATTAN
      10009
      40.729432
      -73.978027
      (40.7294318, -73.978027)
      EAST 14 STREET
      AVENUE B
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Outside Car Distraction
      Unspecified
      NaN
      NaN
      NaN
      3362833
      PASSENGER VEHICLE
      PASSENGER VEHICLE
      NaN
      NaN
      NaN
      Mostly Cloudy
      -
      10.0
      16.1
      2015
      1
      0
      3
    

    

      41400
      41400
      12/31/2015
      9:30
      BRONX
      10466
      40.892905
      -73.843655
      (40.8929052, -73.843655)
      BAYCHESTER AVENUE
      EDENWALD AVENUE
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Oversized Vehicle
      Unspecified
      NaN
      NaN
      NaN
      3364672
      OTHER
      NaN
      NaN
      NaN
      NaN
      Mostly Cloudy
      -
      10.0
      16.1
      2015
      7
      0
      27
    

    

      41401
      41401
      12/31/2015
      9:30
      BROOKLYN
      11212
      40.658355
      -73.904961
      (40.6583545, -73.9049608)
      LOTT AVENUE
      WATKINS STREET
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Unspecified
      Unspecified
      NaN
      NaN
      NaN
      3363104
      PASSENGER VEHICLE
      PASSENGER VEHICLE
      NaN
      NaN
      NaN
      Mostly Cloudy
      -
      10.0
      16.1
      2015
      0
      0
      3
    

    

      41402
      41402
      12/31/2015
      9:31
      BROOKLYN
      11203
      40.634947
      -73.932499
      (40.6349472, -73.932499)
      GLENWOOD ROAD
      EAST 46 STREET
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Unspecified
      Unspecified
      NaN
      NaN
      NaN
      3363497
      PASSENGER VEHICLE
      UNKNOWN
      NaN
      NaN
      NaN
      Mostly Cloudy
      -
      10.0
      16.1
      2015
      0
      0
      3
    

    

      41403
      41403
      12/31/2015
      9:38
      MANHATTAN
      10128
      40.785191
      -73.951428
      (40.7851914, -73.9514275)
      EAST 95 STREET
      LEXINGTON AVENUE
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Unspecified
      Unspecified
      NaN
      NaN
      NaN
      3362861
      PASSENGER VEHICLE
      VAN
      NaN
      NaN
      NaN
      Mostly Cloudy
      -
      10.0
      16.1
      2015
      0
      0
      3
    

    

      41404
      41404
      12/31/2015
      9:40
      MANHATTAN
      10024
      40.787566
      -73.978813
      (40.7875656, -73.9788131)
      WEST END AVENUE
      WEST 84 STREET
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Driver Inattention/Distraction
      Driver Inattention/Distraction
      NaN
      NaN
      NaN
      3364080
      TAXI
      PASSENGER VEHICLE
      NaN
      NaN
      NaN
      Mostly Cloudy
      -
      10.0
      16.1
      2015
      4
      0
      27
    

    

      41406
      41406
      12/31/2015
      9:49
      MANHATTAN
      10009
      40.725777
      -73.986604
      (40.7257771, -73.9866041)
      EAST 5 STREET
      1 AVENUE
      NaN
      1
      0
      0
      0
      1
      0
      0
      0
      Unspecified
      Unspecified
      NaN
      NaN
      NaN
      3362820
      TAXI
      PEDICAB
      NaN
      NaN
      NaN
      Mostly Cloudy
      -
      10.0
      16.1
      2015
      0
      0
      3
    

    

      41407
      41407
      12/31/2015
      9:50
      BROOKLYN
      11207
      40.663448
      -73.883485
      (40.6634483, -73.8834853)
      HEGEMAN AVENUE
      JEROME STREET
      NaN
      1
      0
      0
      0
      0
      0
      1
      0
      Failure to Yield Right-of-Way
      Unspecified
      NaN
      NaN
      NaN
      3363798
      PASSENGER VEHICLE
      UNKNOWN
      NaN
      NaN
      NaN
      Mostly Cloudy
      -
      10.0
      16.1
      2015
      8
      0
      27
    

    

      41408
      41408
      12/31/2015
      9:55
      MANHATTAN
      10018
      40.755869
      -73.998210
      (40.7558686, -73.9982097)
      10 AVENUE
      WEST 36 STREET
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Unspecified
      Unspecified
      NaN
      NaN
      NaN
      3362824
      PASSENGER VEHICLE
      OTHER
      NaN
      NaN
      NaN
      Mostly Cloudy
      -
      10.0
      16.1
      2015
      0
      0
      3
    

    

      41409
      41409
      12/31/2015
      9:56
      QUEENS
      11101
      40.752976
      -73.910233
      (40.7529763, -73.9102326)
      51 STREET
      NORTHERN BOULEVARD
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Unspecified
      Unspecified
      NaN
      NaN
      NaN
      3363299
      SPORT UTILITY / STATION WAGON
      UNKNOWN
      NaN
      NaN
      NaN
      Mostly Cloudy
      -
      10.0
      16.1
      2015
      0
      0
      3
    

    

      41410
      41410
      12/31/2015
      12:50
      BROOKLYN
      11224
      40.579804
      -73.971834
      (40.5798042, -73.9718339)
      WEST 5 STREET
      NEPTUNE AVENUE
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Backing Unsafely
      Unspecified
      NaN
      NaN
      NaN
      3363011
      VAN
      PASSENGER VEHICLE
      NaN
      NaN
      NaN
      Mostly Cloudy
      -
      10.0
      16.1
      2015
      5
      0
      27
    

    

      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
      ...
    

    

      258878
      258878
      01/01/2015
      3:44
      BRONX
      10451
      40.821276
      -73.917417
      (40.8212762, -73.9174171)
      COURTLANDT AVENUE
      EAST 156 STREET
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Prescription Medication
      Unspecified
      NaN
      NaN
      NaN
      3145915
      SPORT UTILITY / STATION WAGON
      SPORT UTILITY / STATION WAGON
      NaN
      NaN
      NaN
      Clear
      -
      -1.7
      16.1
      2015
      11
      14
      22
    

    

      258879
      258879
      01/01/2015
      3:40
      BROOKLYN
      11215
      40.666169
      -73.988808
      (40.6661692, -73.9888076)
      5 AVENUE
      14 STREET
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Unspecified
      Unspecified
      NaN
      NaN
      NaN
      3146376
      PASSENGER VEHICLE
      UNKNOWN
      NaN
      NaN
      NaN
      Clear
      -
      -1.7
      16.1
      2015
      0
      14
      18
    

    

      258881
      258881
      01/01/2015
      3:30
      BROOKLYN
      11234
      40.616611
      -73.926628
      (40.6166112, -73.9266283)
      UTICA AVENUE
      AVENUE O
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Alcohol Involvement
      Other Vehicular
      Other Vehicular
      Other Vehicular
      Other Vehicular
      3146307
      VAN
      PASSENGER VEHICLE
      PASSENGER VEHICLE
      PASSENGER VEHICLE
      PASSENGER VEHICLE
      Clear
      -
      -1.7
      16.1
      2015
      21
      14
      22
    

    

      258882
      258882
      01/01/2015
      3:30
      BROOKLYN
      11216
      40.673422
      -73.950164
      (40.6734216, -73.9501643)
      NOSTRAND AVENUE
      PARK PLACE
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Driver Inattention/Distraction
      Unspecified
      NaN
      NaN
      NaN
      3146014
      TAXI
      PASSENGER VEHICLE
      NaN
      NaN
      NaN
      Clear
      -
      -1.7
      16.1
      2015
      4
      14
      18
    

    

      258883
      258883
      01/01/2015
      3:20
      BRONX
      10452
      40.846240
      -73.918178
      (40.8462399, -73.9181776)
      FEATHERBED LANE
      JESUP AVENUE
      NaN
      1
      0
      0
      0
      0
      0
      1
      0
      Lost Consciousness
      Lost Consciousness
      NaN
      NaN
      NaN
      3145935
      SPORT UTILITY / STATION WAGON
      PASSENGER VEHICLE
      NaN
      NaN
      NaN
      Clear
      -
      -1.7
      16.1
      2015
      20
      14
      22
    

    

      258884
      258884
      01/01/2015
      22:13
      MANHATTAN
      10019
      40.766714
      -73.982878
      (40.7667145, -73.9828775)
      8 AVENUE
      WEST 57 STREET
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Driver Inattention/Distraction
      Unspecified
      NaN
      NaN
      NaN
      3147001
      SPORT UTILITY / STATION WAGON
      PASSENGER VEHICLE
      NaN
      NaN
      NaN
      Partly Cloudy
      -
      2.8
      16.1
      2015
      4
      12
      0
    

    

      258885
      258885
      01/01/2015
      1:35
      NaN
      NaN
      40.763901
      -73.953224
      (40.7639012, -73.9532241)
      NaN
      NaN
      NaN
      1
      0
      1
      0
      0
      0
      0
      0
      Unspecified
      NaN
      NaN
      NaN
      NaN
      3146181
      PASSENGER VEHICLE
      NaN
      NaN
      NaN
      NaN
      Scattered Clouds
      -
      -1.7
      16.1
      2015
      0
      4
      17
    

    

      258886
      258886
      01/01/2015
      1:30
      QUEENS
      11385
      40.709219
      -73.913033
      (40.7092188, -73.9130328)
      WOODWARD AVENUE
      STOCKHOLM STREET
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Unspecified
      Unspecified
      Unspecified
      NaN
      NaN
      3146448
      UNKNOWN
      SPORT UTILITY / STATION WAGON
      SPORT UTILITY / STATION WAGON
      NaN
      NaN
      Scattered Clouds
      -
      -1.7
      16.1
      2015
      0
      4
      17
    

    

      258887
      258887
      01/01/2015
      1:30
      QUEENS
      11362
      40.761744
      -73.724204
      (40.7617443, -73.724204)
      256 STREET
      58 AVENUE
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Traffic Control Disregarded
      Unspecified
      Unspecified
      NaN
      NaN
      3146912
      SPORT UTILITY / STATION WAGON
      PASSENGER VEHICLE
      PASSENGER VEHICLE
      NaN
      NaN
      Scattered Clouds
      -
      -1.7
      16.1
      2015
      3
      4
      17
    

    

      258888
      258888
      01/01/2015
      1:30
      MANHATTAN
      10029
      40.792933
      -73.947901
      (40.7929327, -73.9479007)
      EAST 106 STREET
      PARK AVENUE
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Illness
      NaN
      NaN
      NaN
      NaN
      3146198
      TAXI
      SPORT UTILITY / STATION WAGON
      NaN
      NaN
      NaN
      Scattered Clouds
      -
      -1.7
      16.1
      2015
      24
      4
      4
    

    

      258889
      258889
      01/01/2015
      1:30
      MANHATTAN
      10012
      40.720321
      -73.994040
      (40.7203211, -73.9940403)
      BOWERY
      KENMARE STREET
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Turning Improperly
      Unspecified
      NaN
      NaN
      NaN
      3145854
      PASSENGER VEHICLE
      PASSENGER VEHICLE
      NaN
      NaN
      NaN
      Scattered Clouds
      -
      -1.7
      16.1
      2015
      14
      4
      24
    

    

      258890
      258890
      01/01/2015
      18:15
      QUEENS
      11104
      40.743808
      -73.924258
      (40.743808, -73.924258)
      40 STREET
      QUEENS BOULEVARD
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Unspecified
      Unspecified
      NaN
      NaN
      NaN
      3147766
      PASSENGER VEHICLE
      SPORT UTILITY / STATION WAGON
      NaN
      NaN
      NaN
      Partly Cloudy
      -
      3.9
      16.1
      2015
      0
      12
      0
    

    

      258891
      258891
      01/01/2015
      18:05
      BROOKLYN
      11206
      40.693905
      -73.948916
      (40.6939053, -73.9489157)
      WILLOUGHBY AVENUE
      MARCY AVENUE
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Unspecified
      Unspecified
      NaN
      NaN
      NaN
      3146382
      PASSENGER VEHICLE
      UNKNOWN
      NaN
      NaN
      NaN
      Partly Cloudy
      -
      3.9
      16.1
      2015
      0
      12
      0
    

    

      258892
      258892
      01/01/2015
      18:00
      NaN
      NaN
      40.795539
      -73.977228
      (40.7955388, -73.9772278)
      NaN
      NaN
      NaN
      2
      0
      0
      0
      0
      0
      2
      0
      Driver Inattention/Distraction
      NaN
      NaN
      NaN
      NaN
      3146204
      PASSENGER VEHICLE
      NaN
      NaN
      NaN
      NaN
      Partly Cloudy
      -
      3.9
      16.1
      2015
      4
      12
      0
    

    

      258893
      258893
      01/01/2015
      14:40
      QUEENS
      11367
      40.730830
      -73.828553
      (40.7308296, -73.8285528)
      68 DRIVE
      138 STREET
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Failure to Yield Right-of-Way
      Unspecified
      NaN
      NaN
      NaN
      3146479
      PASSENGER VEHICLE
      SPORT UTILITY / STATION WAGON
      NaN
      NaN
      NaN
      Partly Cloudy
      -
      4.4
      16.1
      2015
      8
      12
      0
    

    

      258894
      258894
      01/01/2015
      14:40
      MANHATTAN
      10128
      40.780065
      -73.947048
      (40.780065, -73.9470478)
      EAST 91 STREET
      1 AVENUE
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Other Vehicular
      Other Vehicular
      NaN
      NaN
      NaN
      3145896
      SPORT UTILITY / STATION WAGON
      SPORT UTILITY / STATION WAGON
      NaN
      NaN
      NaN
      Partly Cloudy
      -
      4.4
      16.1
      2015
      2
      12
      0
    

    

      258895
      258895
      01/01/2015
      14:40
      BRONX
      10467
      40.882220
      -73.880458
      (40.8822201, -73.8804583)
      EAST GUN HILL ROAD
      DEKALB AVENUE
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Turning Improperly
      Unspecified
      NaN
      NaN
      NaN
      3145949
      PASSENGER VEHICLE
      SPORT UTILITY / STATION WAGON
      NaN
      NaN
      NaN
      Partly Cloudy
      -
      4.4
      16.1
      2015
      14
      12
      8
    

    

      258897
      258897
      01/01/2015
      14:30
      BROOKLYN
      11212
      40.668324
      -73.902330
      (40.6683241, -73.9023296)
      NaN
      NaN
      F/O 455 SUTTER AVE
      0
      0
      0
      0
      0
      0
      0
      0
      Unspecified
      Unspecified
      NaN
      NaN
      NaN
      3146357
      PASSENGER VEHICLE
      PASSENGER VEHICLE
      NaN
      NaN
      NaN
      Partly Cloudy
      -
      4.4
      16.1
      2015
      0
      12
      0
    

    

      258898
      258898
      01/01/2015
      14:22
      QUEENS
      11429
      40.717552
      -73.731522
      (40.7175517, -73.7315223)
      222 STREET
      97 AVENUE
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Unspecified
      NaN
      NaN
      NaN
      NaN
      3146064
      SPORT UTILITY / STATION WAGON
      NaN
      NaN
      NaN
      NaN
      Partly Cloudy
      -
      4.4
      16.1
      2015
      0
      12
      0
    

    

      258899
      258899
      01/01/2015
      14:20
      QUEENS
      11412
      40.705684
      -73.771136
      (40.7056838, -73.7711364)
      104 AVENUE
      186 STREET
      NaN
      1
      0
      0
      0
      0
      0
      1
      0
      Glare
      Glare
      NaN
      NaN
      NaN
      3146430
      PASSENGER VEHICLE
      PASSENGER VEHICLE
      NaN
      NaN
      NaN
      Partly Cloudy
      -
      4.4
      16.1
      2015
      40
      12
      28
    

    

      258901
      258901
      01/01/2015
      14:09
      BROOKLYN
      11230
      40.616757
      -73.971411
      (40.6167573, -73.9714113)
      EAST 4 STREET
      AVENUE M
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Driver Inattention/Distraction
      Unspecified
      NaN
      NaN
      NaN
      3146314
      PASSENGER VEHICLE
      PASSENGER VEHICLE
      NaN
      NaN
      NaN
      Partly Cloudy
      -
      4.4
      16.1
      2015
      4
      12
      0
    

    

      258902
      258902
      01/01/2015
      14:00
      QUEENS
      11385
      40.707192
      -73.915102
      (40.707192, -73.9151022)
      SENECA AVENUE
      STOCKHOLM STREET
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Unspecified
      Unspecified
      NaN
      NaN
      NaN
      3146457
      PASSENGER VEHICLE
      UNKNOWN
      NaN
      NaN
      NaN
      Partly Cloudy
      -
      4.4
      16.1
      2015
      0
      12
      0
    

    

      258903
      258903
      01/01/2015
      13:55
      NaN
      NaN
      40.754864
      -73.816832
      (40.7548638, -73.8168325)
      NaN
      NaN
      PARKING LOT 146-01 45 AVE
      0
      0
      0
      0
      0
      0
      0
      0
      Unspecified
      Unspecified
      NaN
      NaN
      NaN
      3146086
      SPORT UTILITY / STATION WAGON
      PASSENGER VEHICLE
      NaN
      NaN
      NaN
      Scattered Clouds
      -
      3.9
      16.1
      2015
      0
      4
      10
    

    

      258904
      258904
      01/01/2015
      13:30
      BRONX
      10469
      40.875483
      -73.857578
      (40.8754834, -73.8575777)
      PAULDING AVENUE
      EAST 211 STREET
      NaN
      1
      0
      0
      0
      0
      0
      1
      0
      Unspecified
      Unspecified
      Unspecified
      NaN
      NaN
      3146262
      OTHER
      SPORT UTILITY / STATION WAGON
      PASSENGER VEHICLE
      NaN
      NaN
      Scattered Clouds
      -
      3.9
      16.1
      2015
      0
      4
      10
    

    

      258905
      258905
      01/01/2015
      13:30
      QUEENS
      11373
      40.737806
      -73.882810
      (40.7378061, -73.8828104)
      QUEENS BOULEVARD
      DONGAN AVENUE
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Driver Inattention/Distraction
      Unspecified
      NaN
      NaN
      NaN
      3146506
      PASSENGER VEHICLE
      PASSENGER VEHICLE
      NaN
      NaN
      NaN
      Scattered Clouds
      -
      3.9
      16.1
      2015
      4
      4
      10
    

    

      258906
      258906
      01/01/2015
      13:30
      BROOKLYN
      11206
      40.693905
      -73.948916
      (40.6939053, -73.9489157)
      WILLOUGHBY AVENUE
      MARCY AVENUE
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Outside Car Distraction
      Outside Car Distraction
      Unspecified
      NaN
      NaN
      3146380
      PASSENGER VEHICLE
      PASSENGER VEHICLE
      PASSENGER VEHICLE
      NaN
      NaN
      Scattered Clouds
      -
      3.9
      16.1
      2015
      1
      4
      10
    

    

      258908
      258908
      01/01/2015
      12:15
      BROOKLYN
      11238
      40.671406
      -73.961319
      (40.6714058, -73.9613194)
      EASTERN PARKWAY
      CLASSON AVENUE
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Lost Consciousness
      Unspecified
      NaN
      NaN
      NaN
      3146016
      SPORT UTILITY / STATION WAGON
      UNKNOWN
      NaN
      NaN
      NaN
      Scattered Clouds
      -
      3.3
      16.1
      2015
      20
      4
      4
    

    

      258909
      258909
      01/01/2015
      12:12
      BRONX
      10463
      40.878755
      -73.899616
      (40.8787554, -73.8996157)
      FORT INDEPENDENCE STREET
      HEATH AVENUE
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Unspecified
      Unspecified
      NaN
      NaN
      NaN
      3145944
      SPORT UTILITY / STATION WAGON
      UNKNOWN
      NaN
      NaN
      NaN
      Scattered Clouds
      -
      3.3
      16.1
      2015
      0
      4
      10
    

    

      258912
      258912
      01/01/2015
      11:24
      MANHATTAN
      10031
      40.823120
      -73.950497
      (40.8231203, -73.9504966)
      WEST 141 STREET
      HAMILTON PLACE
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Unspecified
      Unspecified
      NaN
      NaN
      NaN
      3147994
      VAN
      UNKNOWN
      NaN
      NaN
      NaN
      Scattered Clouds
      -
      2.2
      16.1
      2015
      0
      4
      10
    

    

      258913
      258913
      01/01/2015
      17:30
      BROOKLYN
      11228
      40.606843
      -74.015497
      (40.6068429, -74.0154969)
      BAY 8 STREET
      CROPSEY AVENUE
      NaN
      0
      0
      0
      0
      0
      0
      0
      0
      Unspecified
      Unspecified
      NaN
      NaN
      NaN
      3149467
      PASSENGER VEHICLE
      UNKNOWN
      NaN
      NaN
      NaN
      Partly Cloudy
      -
      3.9
      16.1
      2015
      0
      12
      0
    

  



182788 rows × 38 columns



















In [ ]:

Content source: masve/saav-deliveries

Similar notebooks:

notebook.community | gallery | about