{"nbformat_minor": 0, "cells": [{"execution_count": 1, "cell_type": "code", "metadata": {"collapsed": false, "trusted": false}, "outputs": [], "source": "# The usual preamble\n%matplotlib inline\nimport pandas as pd\nimport matplotlib.pyplot as plt\n\n# Make the graphs a bit prettier, and bigger\npd.set_option('display.mpl_style', 'default')\n\n# This is necessary to show lots of columns in pandas 0.12. \n# Not necessary in pandas 0.13.\npd.set_option('display.width', 5000) \npd.set_option('display.max_columns', 60)\n\nplt.rcParams['figure.figsize'] = (15, 5)"}, {"source": "We're going to use a new dataset here, to demonstrate how to deal with larger datasets. This is a subset of the of 311 service requests from [NYC Open Data](https://nycopendata.socrata.com/Social-Services/311-Service-Requests-from-2010-to-Present/erm2-nwe9). ", "cell_type": "markdown", "metadata": {}}, {"execution_count": 2, "cell_type": "code", "metadata": {"collapsed": false, "trusted": false}, "outputs": [{"output_type": "stream", "name": "stderr", "text": "/opt/anaconda/lib/python2.7/site-packages/pandas/io/parsers.py:1070: DtypeWarning: Columns (8) have mixed types. Specify dtype option on import or set low_memory=False.\n data = self._reader.read(nrows)\n"}], "source": "complaints = pd.read_csv('../data/311-service-requests.csv')"}, {"source": "Depending on your pandas version, you might see an error like \"DtypeWarning: Columns (8) have mixed types\". This means that it's encountered a problem reading in our data. In this case it almost certainly means that it has columns where some of the entries are strings and some are integers.\n\nFor now we're going to ignore it and hope we don't run into a problem, but in the long run we'd need to investigate this warning.", "cell_type": "markdown", "metadata": {}}, {"source": "# 2.1 What's even in it? (the summary)", "cell_type": "markdown", "metadata": {}}, {"source": "When you print a large dataframe, it will only show you the first few rows.\n\nIf you don't see this, don't panic! The default behavior for large dataframes changed between pandas 0.12 and 0.13. Previous to 0.13 it would show you a summary of the dataframe. This includes all the columns, and how many non-null values there are in each column.", "cell_type": "markdown", "metadata": {}}, {"execution_count": 3, "cell_type": "code", "metadata": {"collapsed": false, "trusted": false}, "outputs": [{"execution_count": 3, "metadata": {}, "data": {"text/html": "
\n | Unique Key | \nCreated Date | \nClosed Date | \nAgency | \nAgency Name | \nComplaint Type | \nDescriptor | \nLocation Type | \nIncident Zip | \nIncident Address | \nStreet Name | \nCross Street 1 | \nCross Street 2 | \nIntersection Street 1 | \nIntersection Street 2 | \nAddress Type | \nCity | \nLandmark | \nFacility Type | \nStatus | \nDue Date | \nResolution Action Updated Date | \nCommunity Board | \nBorough | \nX Coordinate (State Plane) | \nY Coordinate (State Plane) | \nPark Facility Name | \nPark Borough | \nSchool Name | \nSchool Number | \nSchool Region | \nSchool Code | \nSchool Phone Number | \nSchool Address | \nSchool City | \nSchool State | \nSchool Zip | \nSchool Not Found | \nSchool or Citywide Complaint | \nVehicle Type | \nTaxi Company Borough | \nTaxi Pick Up Location | \nBridge Highway Name | \nBridge Highway Direction | \nRoad Ramp | \nBridge Highway Segment | \nGarage Lot Name | \nFerry Direction | \nFerry Terminal Name | \nLatitude | \nLongitude | \nLocation | \n
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n26589651 | \n10/31/2013 02:08:41 AM | \nNaN | \nNYPD | \nNew York City Police Department | \nNoise - Street/Sidewalk | \nLoud Talking | \nStreet/Sidewalk | \n11432 | \n90-03 169 STREET | \n169 STREET | \n90 AVENUE | \n91 AVENUE | \nNaN | \nNaN | \nADDRESS | \nJAMAICA | \nNaN | \nPrecinct | \nAssigned | \n10/31/2013 10:08:41 AM | \n10/31/2013 02:35:17 AM | \n12 QUEENS | \nQUEENS | \n1042027 | \n197389 | \nUnspecified | \nQUEENS | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.708275 | \n-73.791604 | \n(40.70827532593202, -73.79160395779721) | \n
1 | \n26593698 | \n10/31/2013 02:01:04 AM | \nNaN | \nNYPD | \nNew York City Police Department | \nIllegal Parking | \nCommercial Overnight Parking | \nStreet/Sidewalk | \n11378 | \n58 AVENUE | \n58 AVENUE | \n58 PLACE | \n59 STREET | \nNaN | \nNaN | \nBLOCKFACE | \nMASPETH | \nNaN | \nPrecinct | \nOpen | \n10/31/2013 10:01:04 AM | \nNaN | \n05 QUEENS | \nQUEENS | \n1009349 | \n201984 | \nUnspecified | \nQUEENS | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.721041 | \n-73.909453 | \n(40.721040535628305, -73.90945306791765) | \n
2 | \n26594139 | \n10/31/2013 02:00:24 AM | \n10/31/2013 02:40:32 AM | \nNYPD | \nNew York City Police Department | \nNoise - Commercial | \nLoud Music/Party | \nClub/Bar/Restaurant | \n10032 | \n4060 BROADWAY | \nBROADWAY | \nWEST 171 STREET | \nWEST 172 STREET | \nNaN | \nNaN | \nADDRESS | \nNEW YORK | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 10:00:24 AM | \n10/31/2013 02:39:42 AM | \n12 MANHATTAN | \nMANHATTAN | \n1001088 | \n246531 | \nUnspecified | \nMANHATTAN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.843330 | \n-73.939144 | \n(40.84332975466513, -73.93914371913482) | \n
3 | \n26595721 | \n10/31/2013 01:56:23 AM | \n10/31/2013 02:21:48 AM | \nNYPD | \nNew York City Police Department | \nNoise - Vehicle | \nCar/Truck Horn | \nStreet/Sidewalk | \n10023 | \nWEST 72 STREET | \nWEST 72 STREET | \nCOLUMBUS AVENUE | \nAMSTERDAM AVENUE | \nNaN | \nNaN | \nBLOCKFACE | \nNEW YORK | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 09:56:23 AM | \n10/31/2013 02:21:10 AM | \n07 MANHATTAN | \nMANHATTAN | \n989730 | \n222727 | \nUnspecified | \nMANHATTAN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.778009 | \n-73.980213 | \n(40.7780087446372, -73.98021349023975) | \n
4 | \n26590930 | \n10/31/2013 01:53:44 AM | \nNaN | \nDOHMH | \nDepartment of Health and Mental Hygiene | \nRodent | \nCondition Attracting Rodents | \nVacant Lot | \n10027 | \nWEST 124 STREET | \nWEST 124 STREET | \nLENOX AVENUE | \nADAM CLAYTON POWELL JR BOULEVARD | \nNaN | \nNaN | \nBLOCKFACE | \nNEW YORK | \nNaN | \nNaN | \nPending | \n11/30/2013 01:53:44 AM | \n10/31/2013 01:59:54 AM | \n10 MANHATTAN | \nMANHATTAN | \n998815 | \n233545 | \nUnspecified | \nMANHATTAN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.807691 | \n-73.947387 | \n(40.80769092704951, -73.94738703491433) | \n
5 | \n26592370 | \n10/31/2013 01:46:52 AM | \nNaN | \nNYPD | \nNew York City Police Department | \nNoise - Commercial | \nBanging/Pounding | \nClub/Bar/Restaurant | \n11372 | \n37 AVENUE | \n37 AVENUE | \n84 STREET | \n85 STREET | \nNaN | \nNaN | \nBLOCKFACE | \nJACKSON HEIGHTS | \nNaN | \nPrecinct | \nOpen | \n10/31/2013 09:46:52 AM | \nNaN | \n03 QUEENS | \nQUEENS | \n1016948 | \n212540 | \nUnspecified | \nQUEENS | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.749989 | \n-73.881988 | \n(40.7499893014072, -73.88198770727831) | \n
6 | \n26595682 | \n10/31/2013 01:46:40 AM | \nNaN | \nNYPD | \nNew York City Police Department | \nBlocked Driveway | \nNo Access | \nStreet/Sidewalk | \n11419 | \n107-50 109 STREET | \n109 STREET | \n107 AVENUE | \n109 AVENUE | \nNaN | \nNaN | \nADDRESS | \nSOUTH RICHMOND HILL | \nNaN | \nPrecinct | \nAssigned | \n10/31/2013 09:46:40 AM | \n10/31/2013 01:59:51 AM | \n10 QUEENS | \nQUEENS | \n1030919 | \n187622 | \nUnspecified | \nQUEENS | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.681533 | \n-73.831737 | \n(40.68153278675525, -73.83173699701601) | \n
7 | \n26595195 | \n10/31/2013 01:44:19 AM | \n10/31/2013 01:58:49 AM | \nNYPD | \nNew York City Police Department | \nNoise - Commercial | \nLoud Music/Party | \nClub/Bar/Restaurant | \n11417 | \n137-09 CROSSBAY BOULEVARD | \nCROSSBAY BOULEVARD | \nPITKIN AVENUE | \nVAN WICKLEN ROAD | \nNaN | \nNaN | \nADDRESS | \nOZONE PARK | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 09:44:19 AM | \n10/31/2013 01:58:49 AM | \n10 QUEENS | \nQUEENS | \n1027776 | \n184076 | \nUnspecified | \nQUEENS | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.671816 | \n-73.843092 | \n(40.67181584567338, -73.84309181950769) | \n
8 | \n26590540 | \n10/31/2013 01:44:14 AM | \n10/31/2013 02:28:04 AM | \nNYPD | \nNew York City Police Department | \nNoise - Commercial | \nLoud Talking | \nClub/Bar/Restaurant | \n10011 | \n258 WEST 15 STREET | \nWEST 15 STREET | \n7 AVENUE | \n8 AVENUE | \nNaN | \nNaN | \nADDRESS | \nNEW YORK | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 09:44:14 AM | \n10/31/2013 02:00:56 AM | \n04 MANHATTAN | \nMANHATTAN | \n984031 | \n208847 | \nUnspecified | \nMANHATTAN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.739913 | \n-74.000790 | \n(40.73991339303542, -74.00079028612932) | \n
9 | \n26594392 | \n10/31/2013 01:34:41 AM | \n10/31/2013 02:23:51 AM | \nNYPD | \nNew York City Police Department | \nNoise - Commercial | \nLoud Music/Party | \nClub/Bar/Restaurant | \n11225 | \n835 NOSTRAND AVENUE | \nNOSTRAND AVENUE | \nUNION STREET | \nPRESIDENT STREET | \nNaN | \nNaN | \nADDRESS | \nBROOKLYN | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 09:34:41 AM | \n10/31/2013 01:48:26 AM | \n09 BROOKLYN | \nBROOKLYN | \n997941 | \n182725 | \nUnspecified | \nBROOKLYN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.668204 | \n-73.950648 | \n(40.66820406598287, -73.95064760056546) | \n
10 | \n26595176 | \n10/31/2013 01:25:12 AM | \nNaN | \nNYPD | \nNew York City Police Department | \nNoise - House of Worship | \nLoud Music/Party | \nHouse of Worship | \n11218 | \n3775 18 AVENUE | \n18 AVENUE | \nEAST 9 STREET | \nEAST 8 STREET | \nNaN | \nNaN | \nADDRESS | \nBROOKLYN | \nNaN | \nPrecinct | \nOpen | \n10/31/2013 09:25:12 AM | \nNaN | \n14 BROOKLYN | \nBROOKLYN | \n992726 | \n170399 | \nUnspecified | \nBROOKLYN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.634378 | \n-73.969462 | \n(40.63437840816299, -73.96946177104543) | \n
11 | \n26591982 | \n10/31/2013 01:24:14 AM | \n10/31/2013 01:54:39 AM | \nNYPD | \nNew York City Police Department | \nNoise - Commercial | \nLoud Music/Party | \nClub/Bar/Restaurant | \n10003 | \n187 2 AVENUE | \n2 AVENUE | \nEAST 11 STREET | \nEAST 12 STREET | \nNaN | \nNaN | \nADDRESS | \nNEW YORK | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 09:24:14 AM | \n10/31/2013 01:54:39 AM | \n03 MANHATTAN | \nMANHATTAN | \n988110 | \n205533 | \nUnspecified | \nMANHATTAN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.730816 | \n-73.986073 | \n(40.73081644089586, -73.98607265739876) | \n
12 | \n26594169 | \n10/31/2013 01:20:57 AM | \n10/31/2013 02:12:31 AM | \nNYPD | \nNew York City Police Department | \nIllegal Parking | \nDouble Parked Blocking Vehicle | \nStreet/Sidewalk | \n10029 | \n65 EAST 99 STREET | \nEAST 99 STREET | \nMADISON AVENUE | \nPARK AVENUE | \nNaN | \nNaN | \nADDRESS | \nNEW YORK | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 09:20:57 AM | \n10/31/2013 01:42:05 AM | \n11 MANHATTAN | \nMANHATTAN | \n997470 | \n226725 | \nUnspecified | \nMANHATTAN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.788974 | \n-73.952259 | \n(40.78897400211689, -73.95225898702977) | \n
13 | \n26594391 | \n10/31/2013 01:20:13 AM | \nNaN | \nNYPD | \nNew York City Police Department | \nNoise - Vehicle | \nEngine Idling | \nStreet/Sidewalk | \n10466 | \nNaN | \nNaN | \nNaN | \nNaN | \nSTRANG AVENUE | \nAMUNDSON AVENUE | \nINTERSECTION | \nBRONX | \nNaN | \nPrecinct | \nOpen | \n10/31/2013 09:20:13 AM | \nNaN | \n12 BRONX | \nBRONX | \n1029467 | \n264124 | \nUnspecified | \nBRONX | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.891517 | \n-73.836457 | \n(40.89151738488846, -73.83645714593568) | \n
14 | \n26590917 | \n10/31/2013 01:19:54 AM | \nNaN | \nDOHMH | \nDepartment of Health and Mental Hygiene | \nRodent | \nRat Sighting | \n1-2 Family Mixed Use Building | \n11219 | \n63 STREET | \n63 STREET | \n13 AVENUE | \n14 AVENUE | \nNaN | \nNaN | \nBLOCKFACE | \nBROOKLYN | \nNaN | \nNaN | \nPending | \n11/30/2013 01:19:54 AM | \n10/31/2013 01:29:26 AM | \n10 BROOKLYN | \nBROOKLYN | \n984467 | \n167519 | \nUnspecified | \nBROOKLYN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.626477 | \n-73.999218 | \n(40.6264774690411, -73.99921826202639) | \n
15 | \n26591458 | \n10/31/2013 01:14:02 AM | \n10/31/2013 01:30:34 AM | \nNYPD | \nNew York City Police Department | \nNoise - House of Worship | \nLoud Music/Party | \nHouse of Worship | \n10025 | \nNaN | \nNaN | \nNaN | \nNaN | \nWEST 99 STREET | \nBROADWAY | \nINTERSECTION | \nNEW YORK | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 09:14:02 AM | \n10/31/2013 01:30:34 AM | \n07 MANHATTAN | \nMANHATTAN | \n992454 | \n229500 | \nUnspecified | \nMANHATTAN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.796597 | \n-73.970370 | \n(40.7965967075252, -73.97036973473399) | \n
16 | \n26594086 | \n10/31/2013 12:54:03 AM | \n10/31/2013 02:16:39 AM | \nNYPD | \nNew York City Police Department | \nNoise - Street/Sidewalk | \nLoud Music/Party | \nStreet/Sidewalk | \n10310 | \n173 CAMPBELL AVENUE | \nCAMPBELL AVENUE | \nHENDERSON AVENUE | \nWINEGAR LANE | \nNaN | \nNaN | \nADDRESS | \nSTATEN ISLAND | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 08:54:03 AM | \n10/31/2013 02:07:14 AM | \n01 STATEN ISLAND | \nSTATEN ISLAND | \n952013 | \n171076 | \nUnspecified | \nSTATEN ISLAND | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.636182 | \n-74.116150 | \n(40.63618202176914, -74.1161500428337) | \n
17 | \n26595117 | \n10/31/2013 12:52:46 AM | \nNaN | \nNYPD | \nNew York City Police Department | \nIllegal Parking | \nPosted Parking Sign Violation | \nStreet/Sidewalk | \n11236 | \nNaN | \nNaN | \nNaN | \nNaN | \nROCKAWAY PARKWAY | \nSKIDMORE AVENUE | \nINTERSECTION | \nBROOKLYN | \nNaN | \nPrecinct | \nOpen | \n10/31/2013 08:52:46 AM | \nNaN | \n18 BROOKLYN | \nBROOKLYN | \n1015289 | \n169710 | \nUnspecified | \nBROOKLYN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.632437 | \n-73.888173 | \n(40.63243692394328, -73.88817263437012) | \n
18 | \n26590389 | \n10/31/2013 12:51:00 AM | \nNaN | \nDOT | \nDepartment of Transportation | \nStreet Light Condition | \nStreet Light Out | \nNaN | \nNaN | \n226 42 ST E | \n42 ST E | \nCHURCH AVE | \nSNYDER AVE | \nNaN | \nNaN | \nADDRESS | \nNaN | \nNaN | \nNaN | \nOpen | \nNaN | \nNaN | \nUnspecified BROOKLYN | \nBROOKLYN | \nNaN | \nNaN | \nUnspecified | \nBROOKLYN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n
19 | \n26594210 | \n10/31/2013 12:46:27 AM | \nNaN | \nNYPD | \nNew York City Police Department | \nNoise - Commercial | \nLoud Music/Party | \nClub/Bar/Restaurant | \n10033 | \nNaN | \nNaN | \nNaN | \nNaN | \nWEST 184 STREET | \nBROADWAY | \nINTERSECTION | \nNEW YORK | \nNaN | \nPrecinct | \nAssigned | \n10/31/2013 08:46:27 AM | \n10/31/2013 01:32:41 AM | \n12 MANHATTAN | \nMANHATTAN | \n1002294 | \n249712 | \nUnspecified | \nMANHATTAN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.852058 | \n-73.934776 | \n(40.85205827756883, -73.93477640780834) | \n
20 | \n26592932 | \n10/31/2013 12:43:47 AM | \n10/31/2013 12:56:20 AM | \nNYPD | \nNew York City Police Department | \nNoise - House of Worship | \nLoud Music/Party | \nHouse of Worship | \n11216 | \n778 PARK PLACE | \nPARK PLACE | \nROGERS AVENUE | \nNOSTRAND AVENUE | \nNaN | \nNaN | \nADDRESS | \nBROOKLYN | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 08:43:47 AM | \n10/31/2013 12:56:20 AM | \n08 BROOKLYN | \nBROOKLYN | \n997608 | \n184656 | \nUnspecified | \nBROOKLYN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.673505 | \n-73.951844 | \n(40.67350473678714, -73.95184414979961) | \n
21 | \n26594152 | \n10/31/2013 12:41:17 AM | \n10/31/2013 01:04:37 AM | \nNYPD | \nNew York City Police Department | \nNoise - Commercial | \nBanging/Pounding | \nStore/Commercial | \n10016 | \n155 E 34TH ST | \nE 34TH ST | \nNaN | \nNaN | \nNaN | \nNaN | \nLATLONG | \nNEW YORK | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 08:41:17 AM | \n10/31/2013 01:04:38 AM | \n06 MANHATTAN | \nMANHATTAN | \n990133 | \n211136 | \nUnspecified | \nMANHATTAN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.746194 | \n-73.978769 | \n(40.74619417253121, -73.97876853124392) | \n
22 | \n26589678 | \n10/31/2013 12:39:55 AM | \nNaN | \nNYPD | \nNew York City Police Department | \nNoise - Vehicle | \nCar/Truck Music | \nStreet/Sidewalk | \n11419 | \nNaN | \nNaN | \nNaN | \nNaN | \n112 STREET | \nATLANTIC AVENUE | \nINTERSECTION | \nSOUTH RICHMOND HILL | \nNaN | \nPrecinct | \nOpen | \n10/31/2013 08:39:55 AM | \nNaN | \n09 QUEENS | \nQUEENS | \n1030314 | \n191578 | \nUnspecified | \nQUEENS | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.692394 | \n-73.833891 | \n(40.69239424979043, -73.8338912453996) | \n
23 | \n26592304 | \n10/31/2013 12:38:00 AM | \nNaN | \nNYPD | \nNew York City Police Department | \nNoise - Commercial | \nLoud Music/Party | \nClub/Bar/Restaurant | \n11216 | \n371 TOMPKINS AVENUE | \nTOMPKINS AVENUE | \nMADISON STREET | \nPUTNAM AVENUE | \nNaN | \nNaN | \nADDRESS | \nBROOKLYN | \nNaN | \nPrecinct | \nAssigned | \n10/31/2013 08:38:00 AM | \n10/31/2013 01:16:53 AM | \n03 BROOKLYN | \nBROOKLYN | \n999720 | \n188825 | \nUnspecified | \nBROOKLYN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.684944 | \n-73.944221 | \n(40.6849442562592, -73.94422078036632) | \n
24 | \n26591892 | \n10/31/2013 12:37:16 AM | \nNaN | \nNYPD | \nNew York City Police Department | \nBlocked Driveway | \nPartial Access | \nStreet/Sidewalk | \n10305 | \n1496 BAY STREET | \nBAY STREET | \nLYMAN AVENUE | \nSCHOOL ROAD | \nNaN | \nNaN | \nADDRESS | \nSTATEN ISLAND | \nNaN | \nPrecinct | \nAssigned | \n10/31/2013 08:37:16 AM | \n10/31/2013 12:52:10 AM | \n01 STATEN ISLAND | \nSTATEN ISLAND | \n967283 | \n160518 | \nUnspecified | \nSTATEN ISLAND | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.607245 | \n-74.061106 | \n(40.60724493456944, -74.06110566015863) | \n
25 | \n26591573 | \n10/31/2013 12:35:18 AM | \n10/31/2013 02:41:35 AM | \nNYPD | \nNew York City Police Department | \nNoise - Street/Sidewalk | \nLoud Talking | \nStreet/Sidewalk | \n10312 | \n24 PRINCETON LANE | \nPRINCETON LANE | \nHAMPTON GREEN | \nDEAD END | \nNaN | \nNaN | \nADDRESS | \nSTATEN ISLAND | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 08:35:18 AM | \n10/31/2013 01:45:17 AM | \n03 STATEN ISLAND | \nSTATEN ISLAND | \n929577 | \n140964 | \nUnspecified | \nSTATEN ISLAND | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.553421 | \n-74.196743 | \n(40.55342078716953, -74.19674315017886) | \n
26 | \n26590509 | \n10/31/2013 12:33:00 AM | \nNaN | \nDOT | \nDepartment of Transportation | \nStreet Light Condition | \nStreet Light Out | \nNaN | \nNaN | \n38 ST E | \n38 ST E | \nCHURCH AVE | \nLINDEN BLVD | \nNaN | \nNaN | \nBLOCKFACE | \nNaN | \nNaN | \nNaN | \nOpen | \nNaN | \nNaN | \nUnspecified BROOKLYN | \nBROOKLYN | \nNaN | \nNaN | \nUnspecified | \nBROOKLYN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n
27 | \n26591379 | \n10/31/2013 12:32:44 AM | \nNaN | \nDOHMH | \nDepartment of Health and Mental Hygiene | \nHarboring Bees/Wasps | \nBees/Wasps - Not a beekeper | \n3+ Family Mixed Use Building | \n10025 | \n501 WEST 110 STREET | \nWEST 110 STREET | \nAMSTERDAM AVENUE | \nBROADWAY | \nNaN | \nNaN | \nADDRESS | \nNEW YORK | \nNaN | \nNaN | \nOpen | \n11/30/2013 12:32:44 AM | \nNaN | \n09 MANHATTAN | \nMANHATTAN | \n994143 | \n231888 | \nUnspecified | \nMANHATTAN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.803149 | \n-73.964266 | \n(40.80314938553783, -73.96426608076082) | \n
28 | \n26594085 | \n10/31/2013 12:32:08 AM | \nNaN | \nNYPD | \nNew York City Police Department | \nNoise - Street/Sidewalk | \nLoud Talking | \nStreet/Sidewalk | \n10026 | \n121 WEST 116 STREET | \nWEST 116 STREET | \nLENOX AVENUE | \n7 AVENUE | \nNaN | \nNaN | \nADDRESS | \nNEW YORK | \nNaN | \nPrecinct | \nAssigned | \n10/31/2013 08:32:08 AM | \n10/31/2013 02:00:57 AM | \n10 MANHATTAN | \nMANHATTAN | \n997947 | \n231613 | \nUnspecified | \nMANHATTAN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.802390 | \n-73.950526 | \n(40.80238950799943, -73.95052644123253) | \n
29 | \n26589201 | \n10/31/2013 12:32:00 AM | \nNaN | \nDOT | \nDepartment of Transportation | \nStreet Light Condition | \nStreet Light Out | \nNaN | \n10309 | \n295 BAYVIEW AVENUE | \nBAYVIEW AVENUE | \nVAIL AVENUE | \nBAYVIEW LANE | \nNaN | \nNaN | \nADDRESS | \nSTATEN ISLAND | \nNaN | \nNaN | \nOpen | \nNaN | \nNaN | \n03 STATEN ISLAND | \nSTATEN ISLAND | \n927687 | \n127837 | \nUnspecified | \nSTATEN ISLAND | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.517378 | \n-74.203435 | \n(40.517377871705676, -74.20343466779575) | \n
30 | \n26591641 | \n10/31/2013 12:31:17 AM | \n10/31/2013 02:41:36 AM | \nNYPD | \nNew York City Police Department | \nBlocked Driveway | \nNo Access | \nStreet/Sidewalk | \n10312 | \n24 PRINCETON LANE | \nPRINCETON LANE | \nHAMPTON GREEN | \nDEAD END | \nNaN | \nNaN | \nADDRESS | \nSTATEN ISLAND | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 08:31:17 AM | \n10/31/2013 01:43:09 AM | \n03 STATEN ISLAND | \nSTATEN ISLAND | \n929577 | \n140964 | \nUnspecified | \nSTATEN ISLAND | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.553421 | \n-74.196743 | \n(40.55342078716953, -74.19674315017886) | \n
31 | \n26595564 | \n10/31/2013 12:30:36 AM | \nNaN | \nNYPD | \nNew York City Police Department | \nNoise - Street/Sidewalk | \nLoud Music/Party | \nStreet/Sidewalk | \n11236 | \nAVENUE J | \nAVENUE J | \nEAST 80 STREET | \nEAST 81 STREET | \nNaN | \nNaN | \nBLOCKFACE | \nBROOKLYN | \nNaN | \nPrecinct | \nOpen | \n10/31/2013 08:30:36 AM | \nNaN | \n18 BROOKLYN | \nBROOKLYN | \n1008937 | \n170310 | \nUnspecified | \nBROOKLYN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.634104 | \n-73.911055 | \n(40.634103775951736, -73.91105541883589) | \n
32 | \n26591378 | \n10/31/2013 12:30:31 AM | \nNaN | \nTLC | \nTaxi and Limousine Commission | \nTaxi Complaint | \nDriver Complaint | \nNaN | \n10036 | \n645 10 AVENUE | \n10 AVENUE | \nWEST 45 STREET | \nWEST 46 STREET | \nNaN | \nNaN | \nADDRESS | \nNEW YORK | \nNaN | \nNaN | \nOpen | \nNaN | \nNaN | \n04 MANHATTAN | \nMANHATTAN | \n985965 | \n216868 | \nUnspecified | \nMANHATTAN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nOther | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.761929 | \n-73.993809 | \n(40.761928847500016, -73.99380918401052) | \n
33 | \n26593872 | \n10/31/2013 12:29:47 AM | \n10/31/2013 12:38:29 AM | \nNYPD | \nNew York City Police Department | \nNoise - House of Worship | \nBanging/Pounding | \nHouse of Worship | \n10025 | \nNaN | \nNaN | \nNaN | \nNaN | \nWEST 99 STREET | \nAMSTERDAM AVENUE | \nINTERSECTION | \nNEW YORK | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 08:29:47 AM | \n10/31/2013 12:38:29 AM | \n07 MANHATTAN | \nMANHATTAN | \n992846 | \n229279 | \nUnspecified | \nMANHATTAN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.795990 | \n-73.968954 | \n(40.795989749917204, -73.96895423714467) | \n
34 | \n26591420 | \n10/31/2013 12:28:30 AM | \n10/31/2013 02:06:11 AM | \nNYPD | \nNew York City Police Department | \nHomeless Encampment | \nNaN | \nResidential Building/House | \n10025 | \n2754 BROADWAY | \nBROADWAY | \nWEST 105 STREET | \nWEST 106 STREET | \nNaN | \nNaN | \nADDRESS | \nNEW YORK | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 08:28:30 AM | \n10/31/2013 02:06:11 AM | \n07 MANHATTAN | \nMANHATTAN | \n993139 | \n231139 | \nUnspecified | \nMANHATTAN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.801095 | \n-73.967894 | \n(40.8010946529914, -73.96789356094007) | \n
35 | \n26592976 | \n10/31/2013 12:23:24 AM | \n10/31/2013 01:05:41 AM | \nNYPD | \nNew York City Police Department | \nBlocked Driveway | \nNo Access | \nStreet/Sidewalk | \n11433 | \n173-41 103 ROAD | \n103 ROAD | \n173 STREET | \n177 STREET | \nNaN | \nNaN | \nADDRESS | \nJAMAICA | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 08:23:24 AM | \n10/31/2013 01:05:41 AM | \n12 QUEENS | \nQUEENS | \n1044124 | \n195866 | \nUnspecified | \nQUEENS | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.704081 | \n-73.784054 | \n(40.70408112125158, -73.78405385422116) | \n
36 | \n26590262 | \n10/31/2013 12:23:00 AM | \nNaN | \nDOT | \nDepartment of Transportation | \nTraffic Signal Condition | \nController | \nNaN | \n11235 | \nNaN | \nNaN | \nNaN | \nNaN | \nSHORE BOULEVARD | \nCASS PLACE | \nINTERSECTION | \nBROOKLYN | \nNaN | \nNaN | \nOpen | \nNaN | \nNaN | \n15 BROOKLYN | \nBROOKLYN | \n997073 | \n151225 | \nUnspecified | \nBROOKLYN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.581744 | \n-73.953836 | \n(40.5817444882428, -73.95383634845487) | \n
37 | \n26589606 | \n10/31/2013 12:20:44 AM | \n10/31/2013 02:10:24 AM | \nNYPD | \nNew York City Police Department | \nNoise - Commercial | \nLoud Music/Party | \nClub/Bar/Restaurant | \n11216 | \n826 ST JOHN'S PLACE | \nST JOHN'S PLACE | \nROGERS AVENUE | \nNOSTRAND AVENUE | \nNaN | \nNaN | \nADDRESS | \nBROOKLYN | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 08:20:44 AM | \n10/31/2013 02:10:24 AM | \n08 BROOKLYN | \nBROOKLYN | \n997865 | \n183985 | \nUnspecified | \nBROOKLYN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.671663 | \n-73.950919 | \n(40.671662601079895, -73.95091901534035) | \n
38 | \n26592083 | \n10/31/2013 12:20:00 AM | \nNaN | \nDOT | \nDepartment of Transportation | \nTraffic Signal Condition | \nController | \nNaN | \n11213 | \nNaN | \nNaN | \nNaN | \nNaN | \nBUFFALO AVENUE | \nPARK PLACE | \nINTERSECTION | \nBROOKLYN | \nNaN | \nNaN | \nOpen | \nNaN | \nNaN | \n08 BROOKLYN | \nBROOKLYN | \n1004987 | \n184136 | \nUnspecified | \nBROOKLYN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.672063 | \n-73.925244 | \n(40.67206324438088, -73.92524432147842) | \n
39 | \n26593840 | \n10/31/2013 12:19:48 AM | \nNaN | \nNYPD | \nNew York City Police Department | \nBlocked Driveway | \nNo Access | \nStreet/Sidewalk | \n11379 | \n78-41 68 ROAD | \n68 ROAD | \n78 STREET | \n79 STREET | \nNaN | \nNaN | \nADDRESS | \nMIDDLE VILLAGE | \nNaN | \nPrecinct | \nOpen | \n10/31/2013 08:19:48 AM | \nNaN | \n05 QUEENS | \nQUEENS | \n1019062 | \n198120 | \nUnspecified | \nQUEENS | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.710402 | \n-73.874433 | \n(40.71040190143904, -73.8744325577748) | \n
40 | \n26589646 | \n10/31/2013 12:18:05 AM | \n10/31/2013 01:26:15 AM | \nNYPD | \nNew York City Police Department | \nNoise - Commercial | \nLoud Music/Party | \nClub/Bar/Restaurant | \n11101 | \n34-19 STEINWAY STREET | \nSTEINWAY STREET | \n34 AVENUE | \n35 AVENUE | \nNaN | \nNaN | \nADDRESS | \nLONG ISLAND CITY | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 08:18:05 AM | \n10/31/2013 01:26:15 AM | \n01 QUEENS | \nQUEENS | \n1006080 | \n214807 | \nUnspecified | \nQUEENS | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.756245 | \n-73.921205 | \n(40.75624514774764, -73.92120466494264) | \n
41 | \n26593296 | \n10/31/2013 12:16:25 AM | \nNaN | \nDOHMH | \nDepartment of Health and Mental Hygiene | \nFood Establishment | \nRodents/Insects/Garbage | \nRestaurant/Bar/Deli/Bakery | \n10014 | \n12 CHRISTOPHER STREET | \nCHRISTOPHER STREET | \nGREENWICH AVENUE | \nGAY STREET | \nNaN | \nNaN | \nADDRESS | \nNEW YORK | \nNaN | \nNaN | \nOpen | \n12/07/2013 12:16:25 AM | \nNaN | \n02 MANHATTAN | \nMANHATTAN | \n984181 | \n206685 | \nUnspecified | \nMANHATTAN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.733979 | \n-74.000249 | \n(40.73397924003587, -74.0002489720853) | \n
42 | \n26590480 | \n10/31/2013 12:15:06 AM | \n10/31/2013 03:00:20 AM | \nNYPD | \nNew York City Police Department | \nNoise - Commercial | \nLoud Music/Party | \nStore/Commercial | \n11231 | \n325 COLUMBIA STREET | \nCOLUMBIA STREET | \nNaN | \nNaN | \nNaN | \nNaN | \nLATLONG | \nBROOKLYN | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 08:15:06 AM | \n10/31/2013 02:58:55 AM | \n06 BROOKLYN | \nBROOKLYN | \n982995 | \n187440 | \nUnspecified | \nBROOKLYN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.681156 | \n-74.004525 | \n(40.68115617695543, -74.00452481832494) | \n
43 | \n26589626 | \n10/31/2013 12:14:42 AM | \n10/31/2013 01:39:00 AM | \nNYPD | \nNew York City Police Department | \nNoise - Commercial | \nLoud Music/Party | \nClub/Bar/Restaurant | \n11234 | \n2192 FLATBUSH AVENUE | \nFLATBUSH AVENUE | \nEAST 46 STREET | \nAVENUE O | \nNaN | \nNaN | \nADDRESS | \nBROOKLYN | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 08:14:42 AM | \n10/31/2013 01:39:00 AM | \n18 BROOKLYN | \nBROOKLYN | \n1003628 | \n163910 | \nUnspecified | \nBROOKLYN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.616550 | \n-73.930202 | \n(40.61655032892211, -73.93020153359745) | \n
44 | \n26592898 | \n10/31/2013 12:12:08 AM | \n10/31/2013 01:13:45 AM | \nNYPD | \nNew York City Police Department | \nNoise - Park | \nLoud Talking | \nPark/Playground | \n10457 | \nCROTONA PARK NORTH | \nCROTONA PARK NORTH | \nCLINTON AVENUE | \nPROSPECT AVENUE | \nNaN | \nNaN | \nBLOCKFACE | \nBRONX | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 08:12:08 AM | \n10/31/2013 01:13:45 AM | \n06 BRONX | \nBRONX | \n1013947 | \n245819 | \nUnspecified | \nBRONX | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.841342 | \n-73.892672 | \n(40.841341641554614, -73.89267161957397) | \n
45 | \n26590446 | \n10/31/2013 12:11:58 AM | \n10/31/2013 01:54:38 AM | \nNYPD | \nNew York City Police Department | \nNoise - Street/Sidewalk | \nLoud Music/Party | \nStreet/Sidewalk | \n10459 | \n819 EAST 167 STREET | \nEAST 167 STREET | \nUNION AVENUE | \nPROSPECT AVENUE | \nNaN | \nNaN | \nADDRESS | \nBRONX | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 08:11:58 AM | \n10/31/2013 01:54:38 AM | \n03 BRONX | \nBRONX | \n1011935 | \n240454 | \nUnspecified | \nBRONX | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.826623 | \n-73.899965 | \n(40.826622810177874, -73.8999653556452) | \n
46 | \n26595546 | \n10/31/2013 12:09:07 AM | \n10/31/2013 12:53:12 AM | \nNYPD | \nNew York City Police Department | \nNoise - Commercial | \nLoud Music/Party | \nClub/Bar/Restaurant | \n10465 | \n4005 EAST TREMONT AVENUE | \nEAST TREMONT AVENUE | \nSAMPSON AVENUE | \nGERBER PLACE | \nNaN | \nNaN | \nADDRESS | \nBRONX | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 08:09:07 AM | \n10/31/2013 12:53:12 AM | \n10 BRONX | \nBRONX | \n1034640 | \n238172 | \nUnspecified | \nBRONX | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.820259 | \n-73.817942 | \n(40.820259030934515, -73.81794234356029) | \n
47 | \n26595944 | \n10/31/2013 12:08:47 AM | \nNaN | \nTLC | \nTaxi and Limousine Commission | \nTaxi Complaint | \nDriver Complaint | \nNaN | \n10036 | \nNaN | \nNaN | \nNaN | \nNaN | \nWEST 46 STREET | \n10 AVENUE | \nINTERSECTION | \nNEW YORK | \nNaN | \nNaN | \nOpen | \n11/14/2013 12:08:47 AM | \nNaN | \n04 MANHATTAN | \nMANHATTAN | \n986020 | \n216961 | \nUnspecified | \nMANHATTAN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nOther | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.762184 | \n-73.993611 | \n(40.76218409774632, -73.99361062023596) | \n
48 | \n26595084 | \n10/31/2013 12:07:45 AM | \n10/31/2013 01:43:11 AM | \nNYPD | \nNew York City Police Department | \nNoise - Commercial | \nLoud Music/Party | \nClub/Bar/Restaurant | \n10014 | \n12 CHRISTOPHER STREET | \nCHRISTOPHER STREET | \nGREENWICH AVENUE | \nGAY STREET | \nNaN | \nNaN | \nADDRESS | \nNEW YORK | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 08:07:45 AM | \n10/31/2013 01:43:11 AM | \n02 MANHATTAN | \nMANHATTAN | \n984181 | \n206685 | \nUnspecified | \nMANHATTAN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.733979 | \n-74.000249 | \n(40.73397924003587, -74.0002489720853) | \n
49 | \n26595553 | \n10/31/2013 12:05:10 AM | \n10/31/2013 02:43:43 AM | \nNYPD | \nNew York City Police Department | \nNoise - Street/Sidewalk | \nLoud Talking | \nStreet/Sidewalk | \n11225 | \n25 LEFFERTS AVENUE | \nLEFFERTS AVENUE | \nWASHINGTON AVENUE | \nBEDFORD AVENUE | \nNaN | \nNaN | \nADDRESS | \nBROOKLYN | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 08:05:10 AM | \n10/31/2013 01:29:29 AM | \n09 BROOKLYN | \nBROOKLYN | \n995366 | \n180388 | \nUnspecified | \nBROOKLYN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.661793 | \n-73.959934 | \n(40.6617931276793, -73.95993363978067) | \n
50 | \n26594087 | \n10/31/2013 12:04:50 AM | \n10/31/2013 01:09:38 AM | \nNYPD | \nNew York City Police Department | \nNoise - Commercial | \nLoud Music/Party | \nStore/Commercial | \n10011 | \n258 WEST 15TH STREET | \nWEST 15TH STREET | \nNaN | \nNaN | \nNaN | \nNaN | \nLATLONG | \nNEW YORK | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 08:04:50 AM | \n10/31/2013 01:09:38 AM | \n04 MANHATTAN | \nMANHATTAN | \n983789 | \n208891 | \nUnspecified | \nMANHATTAN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.740034 | \n-74.001664 | \n(40.74003415280169, -74.00166357336052) | \n
51 | \n26595572 | \n10/31/2013 12:03:27 AM | \nNaN | \nDOT | \nDepartment of Transportation | \nBroken Muni Meter | \nNo Receipt | \nStreet | \n10003 | \nNaN | \nNaN | \nNaN | \nNaN | \nEAST 10 STREET | \n2 AVENUE | \nINTERSECTION | \nNEW YORK | \nNaN | \nNaN | \nOpen | \n11/21/2013 12:03:27 AM | \nNaN | \n03 MANHATTAN | \nMANHATTAN | \n987906 | \n205154 | \nUnspecified | \nMANHATTAN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.729776 | \n-73.986809 | \n(40.72977626532991, -73.98680891976119) | \n
52 | \n26590848 | \n10/31/2013 12:02:01 AM | \n10/31/2013 01:02:28 AM | \nNYPD | \nNew York City Police Department | \nBlocked Driveway | \nNo Access | \nStreet/Sidewalk | \n11207 | \n422 WYONA STREET | \nWYONA STREET | \nSUTTER AVENUE | \nBLAKE AVENUE | \nNaN | \nNaN | \nADDRESS | \nBROOKLYN | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 08:02:01 AM | \n10/31/2013 01:02:28 AM | \n05 BROOKLYN | \nBROOKLYN | \n1014188 | \n182855 | \nUnspecified | \nBROOKLYN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.668521 | \n-73.892081 | \n(40.66852085465471, -73.89208096944678) | \n
53 | \n26590413 | \n10/31/2013 12:01:47 AM | \n10/31/2013 12:39:31 AM | \nNYPD | \nNew York City Police Department | \nNoise - Commercial | \nLoud Music/Party | \nClub/Bar/Restaurant | \n10002 | \n121 RIVINGTON STREET | \nRIVINGTON STREET | \nESSEX STREET | \nNORFOLK STREET | \nNaN | \nNaN | \nADDRESS | \nNEW YORK | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 08:01:47 AM | \n10/31/2013 12:39:31 AM | \n03 MANHATTAN | \nMANHATTAN | \n987766 | \n201503 | \nUnspecified | \nMANHATTAN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.719755 | \n-73.987316 | \n(40.71975521311322, -73.98731595609806) | \n
54 | \n26591287 | \n10/31/2013 12:01:45 AM | \n10/31/2013 12:02:37 AM | \nHRA | \nHRA Benefit Card Replacement | \nBenefit Card Replacement | \nMedicaid | \nNYC Street Address | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nClosed | \nNaN | \nNaN | \n0 Unspecified | \nUnspecified | \nNaN | \nNaN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n
55 | \n26595001 | \n10/31/2013 12:01:34 AM | \n10/31/2013 01:32:43 AM | \nNYPD | \nNew York City Police Department | \nNoise - Commercial | \nLoud Music/Party | \nStore/Commercial | \n10034 | \n524 WEST 207TH STREET | \nWEST 207TH STREET | \nNaN | \nNaN | \nNaN | \nNaN | \nLATLONG | \nNEW YORK | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 08:01:34 AM | \n10/31/2013 01:32:43 AM | \n01 MANHATTAN | \nMANHATTAN | \n1006481 | \n254514 | \nUnspecified | \nMANHATTAN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.865229 | \n-73.919626 | \n(40.86522877164924, -73.91962575276823) | \n
56 | \n26591162 | \n10/31/2013 12:01:00 AM | \nNaN | \nDSNY | \nBCC - Brooklyn South | \nSanitation Condition | \n15 Street Cond/Dump-Out/Drop-Off | \nStreet | \n11231 | \n135 COLUMBIA STREET | \nCOLUMBIA STREET | \nKANE STREET | \nIRVING STREET | \nNaN | \nNaN | \nADDRESS | \nBROOKLYN | \nNaN | \nDSNY Garage | \nOpen | \nNaN | \nNaN | \n06 BROOKLYN | \nBROOKLYN | \n983797 | \n189648 | \nUnspecified | \nBROOKLYN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.687217 | \n-74.001633 | \n(40.68721671044577, -74.00163340956126) | \n
57 | \n26593459 | \n10/31/2013 12:00:00 AM | \nNaN | \nHPD | \nDepartment of Housing Preservation and Develop... | \nELECTRIC | \nELECTRIC-SUPPLY | \nRESIDENTIAL BUILDING | \n11233 | \n199 HOWARD AVENUE | \nHOWARD AVENUE | \nBAINBRIDGE STREET | \nCHAUNCEY STREET | \nNaN | \nNaN | \nADDRESS | \nBROOKLYN | \nNaN | \nNaN | \nOpen | \nNaN | \n10/31/2013 12:00:00 AM | \n03 BROOKLYN | \nBROOKLYN | \n1006513 | \n187623 | \nUnspecified | \nBROOKLYN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.681631 | \n-73.919732 | \n(40.68163056217252, -73.91973166452124) | \n
58 | \n26592634 | \n10/31/2013 12:00:00 AM | \nNaN | \nHPD | \nDepartment of Housing Preservation and Develop... | \nPLUMBING | \nBASIN/SINK | \nRESIDENTIAL BUILDING | \n11233 | \n199 HOWARD AVENUE | \nHOWARD AVENUE | \nBAINBRIDGE STREET | \nCHAUNCEY STREET | \nNaN | \nNaN | \nADDRESS | \nBROOKLYN | \nNaN | \nNaN | \nOpen | \nNaN | \n10/31/2013 12:00:00 AM | \n03 BROOKLYN | \nBROOKLYN | \n1006513 | \n187623 | \nUnspecified | \nBROOKLYN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.681631 | \n-73.919732 | \n(40.68163056217252, -73.91973166452124) | \n
59 | \n26591688 | \n10/31/2013 12:00:00 AM | \nNaN | \nHPD | \nDepartment of Housing Preservation and Develop... | \nHEATING | \nHEAT | \nRESIDENTIAL BUILDING | \n10453 | \n150 WEST 179 STREET | \nWEST 179 STREET | \nANDREWS AVENUE | \nLORING PLACE | \nNaN | \nNaN | \nADDRESS | \nBRONX | \nNaN | \nNaN | \nOpen | \nNaN | \n10/31/2013 12:00:00 AM | \n05 BRONX | \nBRONX | \n1008161 | \n250940 | \nUnspecified | \nBRONX | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.855415 | \n-73.913565 | \n(40.855414830918306, -73.91356461276855) | \n
\n | ... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n
111069 rows \u00d7 52 columns
\n\n | Unique Key | \nCreated Date | \nClosed Date | \nAgency | \nAgency Name | \nComplaint Type | \nDescriptor | \nLocation Type | \nIncident Zip | \nIncident Address | \nStreet Name | \nCross Street 1 | \nCross Street 2 | \nIntersection Street 1 | \nIntersection Street 2 | \nAddress Type | \nCity | \nLandmark | \nFacility Type | \nStatus | \nDue Date | \nResolution Action Updated Date | \nCommunity Board | \nBorough | \nX Coordinate (State Plane) | \nY Coordinate (State Plane) | \nPark Facility Name | \nPark Borough | \nSchool Name | \nSchool Number | \nSchool Region | \nSchool Code | \nSchool Phone Number | \nSchool Address | \nSchool City | \nSchool State | \nSchool Zip | \nSchool Not Found | \nSchool or Citywide Complaint | \nVehicle Type | \nTaxi Company Borough | \nTaxi Pick Up Location | \nBridge Highway Name | \nBridge Highway Direction | \nRoad Ramp | \nBridge Highway Segment | \nGarage Lot Name | \nFerry Direction | \nFerry Terminal Name | \nLatitude | \nLongitude | \nLocation | \n
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n26589651 | \n10/31/2013 02:08:41 AM | \nNaN | \nNYPD | \nNew York City Police Department | \nNoise - Street/Sidewalk | \nLoud Talking | \nStreet/Sidewalk | \n11432 | \n90-03 169 STREET | \n169 STREET | \n90 AVENUE | \n91 AVENUE | \nNaN | \nNaN | \nADDRESS | \nJAMAICA | \nNaN | \nPrecinct | \nAssigned | \n10/31/2013 10:08:41 AM | \n10/31/2013 02:35:17 AM | \n12 QUEENS | \nQUEENS | \n1042027 | \n197389 | \nUnspecified | \nQUEENS | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.708275 | \n-73.791604 | \n(40.70827532593202, -73.79160395779721) | \n
1 | \n26593698 | \n10/31/2013 02:01:04 AM | \nNaN | \nNYPD | \nNew York City Police Department | \nIllegal Parking | \nCommercial Overnight Parking | \nStreet/Sidewalk | \n11378 | \n58 AVENUE | \n58 AVENUE | \n58 PLACE | \n59 STREET | \nNaN | \nNaN | \nBLOCKFACE | \nMASPETH | \nNaN | \nPrecinct | \nOpen | \n10/31/2013 10:01:04 AM | \nNaN | \n05 QUEENS | \nQUEENS | \n1009349 | \n201984 | \nUnspecified | \nQUEENS | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.721041 | \n-73.909453 | \n(40.721040535628305, -73.90945306791765) | \n
2 | \n26594139 | \n10/31/2013 02:00:24 AM | \n10/31/2013 02:40:32 AM | \nNYPD | \nNew York City Police Department | \nNoise - Commercial | \nLoud Music/Party | \nClub/Bar/Restaurant | \n10032 | \n4060 BROADWAY | \nBROADWAY | \nWEST 171 STREET | \nWEST 172 STREET | \nNaN | \nNaN | \nADDRESS | \nNEW YORK | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 10:00:24 AM | \n10/31/2013 02:39:42 AM | \n12 MANHATTAN | \nMANHATTAN | \n1001088 | \n246531 | \nUnspecified | \nMANHATTAN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.843330 | \n-73.939144 | \n(40.84332975466513, -73.93914371913482) | \n
3 | \n26595721 | \n10/31/2013 01:56:23 AM | \n10/31/2013 02:21:48 AM | \nNYPD | \nNew York City Police Department | \nNoise - Vehicle | \nCar/Truck Horn | \nStreet/Sidewalk | \n10023 | \nWEST 72 STREET | \nWEST 72 STREET | \nCOLUMBUS AVENUE | \nAMSTERDAM AVENUE | \nNaN | \nNaN | \nBLOCKFACE | \nNEW YORK | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 09:56:23 AM | \n10/31/2013 02:21:10 AM | \n07 MANHATTAN | \nMANHATTAN | \n989730 | \n222727 | \nUnspecified | \nMANHATTAN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.778009 | \n-73.980213 | \n(40.7780087446372, -73.98021349023975) | \n
4 | \n26590930 | \n10/31/2013 01:53:44 AM | \nNaN | \nDOHMH | \nDepartment of Health and Mental Hygiene | \nRodent | \nCondition Attracting Rodents | \nVacant Lot | \n10027 | \nWEST 124 STREET | \nWEST 124 STREET | \nLENOX AVENUE | \nADAM CLAYTON POWELL JR BOULEVARD | \nNaN | \nNaN | \nBLOCKFACE | \nNEW YORK | \nNaN | \nNaN | \nPending | \n11/30/2013 01:53:44 AM | \n10/31/2013 01:59:54 AM | \n10 MANHATTAN | \nMANHATTAN | \n998815 | \n233545 | \nUnspecified | \nMANHATTAN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.807691 | \n-73.947387 | \n(40.80769092704951, -73.94738703491433) | \n
5 rows \u00d7 52 columns
\n\n | Complaint Type | \nBorough | \n
---|---|---|
0 | \nNoise - Street/Sidewalk | \nQUEENS | \n
1 | \nIllegal Parking | \nQUEENS | \n
2 | \nNoise - Commercial | \nMANHATTAN | \n
3 | \nNoise - Vehicle | \nMANHATTAN | \n
4 | \nRodent | \nMANHATTAN | \n
5 | \nNoise - Commercial | \nQUEENS | \n
6 | \nBlocked Driveway | \nQUEENS | \n
7 | \nNoise - Commercial | \nQUEENS | \n
8 | \nNoise - Commercial | \nMANHATTAN | \n
9 | \nNoise - Commercial | \nBROOKLYN | \n
10 | \nNoise - House of Worship | \nBROOKLYN | \n
11 | \nNoise - Commercial | \nMANHATTAN | \n
12 | \nIllegal Parking | \nMANHATTAN | \n
13 | \nNoise - Vehicle | \nBRONX | \n
14 | \nRodent | \nBROOKLYN | \n
15 | \nNoise - House of Worship | \nMANHATTAN | \n
16 | \nNoise - Street/Sidewalk | \nSTATEN ISLAND | \n
17 | \nIllegal Parking | \nBROOKLYN | \n
18 | \nStreet Light Condition | \nBROOKLYN | \n
19 | \nNoise - Commercial | \nMANHATTAN | \n
20 | \nNoise - House of Worship | \nBROOKLYN | \n
21 | \nNoise - Commercial | \nMANHATTAN | \n
22 | \nNoise - Vehicle | \nQUEENS | \n
23 | \nNoise - Commercial | \nBROOKLYN | \n
24 | \nBlocked Driveway | \nSTATEN ISLAND | \n
25 | \nNoise - Street/Sidewalk | \nSTATEN ISLAND | \n
26 | \nStreet Light Condition | \nBROOKLYN | \n
27 | \nHarboring Bees/Wasps | \nMANHATTAN | \n
28 | \nNoise - Street/Sidewalk | \nMANHATTAN | \n
29 | \nStreet Light Condition | \nSTATEN ISLAND | \n
30 | \nBlocked Driveway | \nSTATEN ISLAND | \n
31 | \nNoise - Street/Sidewalk | \nBROOKLYN | \n
32 | \nTaxi Complaint | \nMANHATTAN | \n
33 | \nNoise - House of Worship | \nMANHATTAN | \n
34 | \nHomeless Encampment | \nMANHATTAN | \n
35 | \nBlocked Driveway | \nQUEENS | \n
36 | \nTraffic Signal Condition | \nBROOKLYN | \n
37 | \nNoise - Commercial | \nBROOKLYN | \n
38 | \nTraffic Signal Condition | \nBROOKLYN | \n
39 | \nBlocked Driveway | \nQUEENS | \n
40 | \nNoise - Commercial | \nQUEENS | \n
41 | \nFood Establishment | \nMANHATTAN | \n
42 | \nNoise - Commercial | \nBROOKLYN | \n
43 | \nNoise - Commercial | \nBROOKLYN | \n
44 | \nNoise - Park | \nBRONX | \n
45 | \nNoise - Street/Sidewalk | \nBRONX | \n
46 | \nNoise - Commercial | \nBRONX | \n
47 | \nTaxi Complaint | \nMANHATTAN | \n
48 | \nNoise - Commercial | \nMANHATTAN | \n
49 | \nNoise - Street/Sidewalk | \nBROOKLYN | \n
50 | \nNoise - Commercial | \nMANHATTAN | \n
51 | \nBroken Muni Meter | \nMANHATTAN | \n
52 | \nBlocked Driveway | \nBROOKLYN | \n
53 | \nNoise - Commercial | \nMANHATTAN | \n
54 | \nBenefit Card Replacement | \nUnspecified | \n
55 | \nNoise - Commercial | \nMANHATTAN | \n
56 | \nSanitation Condition | \nBROOKLYN | \n
57 | \nELECTRIC | \nBROOKLYN | \n
58 | \nPLUMBING | \nBROOKLYN | \n
59 | \nHEATING | \nBRONX | \n
\n | ... | \n... | \n
111069 rows \u00d7 2 columns
\n\n | Complaint Type | \nBorough | \n
---|---|---|
0 | \nNoise - Street/Sidewalk | \nQUEENS | \n
1 | \nIllegal Parking | \nQUEENS | \n
2 | \nNoise - Commercial | \nMANHATTAN | \n
3 | \nNoise - Vehicle | \nMANHATTAN | \n
4 | \nRodent | \nMANHATTAN | \n
5 | \nNoise - Commercial | \nQUEENS | \n
6 | \nBlocked Driveway | \nQUEENS | \n
7 | \nNoise - Commercial | \nQUEENS | \n
8 | \nNoise - Commercial | \nMANHATTAN | \n
9 | \nNoise - Commercial | \nBROOKLYN | \n
10 rows \u00d7 2 columns
\n