{"nbformat": 4, "metadata": {"orig_nbformat": 3}, "cells": [{"cell_type": "code", "execution_count": 11, "outputs": [], "source": "# The usual preamble\n%matplotlib inline\nimport pandas as pd\nimport matplotlib.pyplot as plt\nimport numpy as np\n\n# Make the graphs a bit prettier, and bigger\npd.set_option('display.mpl_style', 'default')\nplt.rcParams['figure.figsize'] = (15, 5)\n\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)", "metadata": {"collapsed": false, "trusted": false}}, {"source": "Let's continue with our NYC 311 service requests example.", "cell_type": "markdown", "metadata": {}}, {"cell_type": "code", "execution_count": 12, "outputs": [], "source": "complaints = pd.read_csv('../data/311-service-requests.csv')", "metadata": {"collapsed": false, "trusted": false}}, {"source": "# 3.1 Selecting only noise complaints", "cell_type": "markdown", "metadata": {}}, {"source": "I'd like to know which borough has the most noise complaints. First, we'll take a look at the data to see what it looks like:", "cell_type": "markdown", "metadata": {}}, {"cell_type": "code", "execution_count": 13, "outputs": [{"execution_count": 13, "output_type": "execute_result", "data": {"text/plain": " Unique Key Created Date Closed Date Agency Agency Name Complaint Type Descriptor Location Type Incident Zip Incident Address Street Name Cross Street 1 Cross Street 2 Intersection Street 1 Intersection Street 2 Address Type City Landmark Facility Type Status Due Date Resolution Action Updated Date Community Board Borough X Coordinate (State Plane) Y Coordinate (State Plane) Park Facility Name Park Borough School Name School Number School Region School Code School Phone Number School Address School City School State School Zip School Not Found School or Citywide Complaint Vehicle Type Taxi Company Borough Taxi Pick Up Location Bridge Highway Name Bridge Highway Direction Road Ramp Bridge Highway Segment Garage Lot Name Ferry Direction Ferry Terminal Name Latitude Longitude Location\n0 26589651 10/31/2013 02:08:41 AM NaN NYPD New York City Police Department Noise - Street/Sidewalk Loud Talking Street/Sidewalk 11432 90-03 169 STREET 169 STREET 90 AVENUE 91 AVENUE NaN NaN ADDRESS JAMAICA NaN Precinct Assigned 10/31/2013 10:08:41 AM 10/31/2013 02:35:17 AM 12 QUEENS QUEENS 1042027 197389 Unspecified QUEENS Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.708275 -73.791604 (40.70827532593202, -73.79160395779721)\n1 26593698 10/31/2013 02:01:04 AM NaN NYPD New York City Police Department Illegal Parking Commercial Overnight Parking Street/Sidewalk 11378 58 AVENUE 58 AVENUE 58 PLACE 59 STREET NaN NaN BLOCKFACE MASPETH NaN Precinct Open 10/31/2013 10:01:04 AM NaN 05 QUEENS QUEENS 1009349 201984 Unspecified QUEENS Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.721041 -73.909453 (40.721040535628305, -73.90945306791765)\n2 26594139 10/31/2013 02:00:24 AM 10/31/2013 02:40:32 AM NYPD New York City Police Department Noise - Commercial Loud Music/Party Club/Bar/Restaurant 10032 4060 BROADWAY BROADWAY WEST 171 STREET WEST 172 STREET NaN NaN ADDRESS NEW YORK NaN Precinct Closed 10/31/2013 10:00:24 AM 10/31/2013 02:39:42 AM 12 MANHATTAN MANHATTAN 1001088 246531 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.843330 -73.939144 (40.84332975466513, -73.93914371913482)\n3 26595721 10/31/2013 01:56:23 AM 10/31/2013 02:21:48 AM NYPD New York City Police Department Noise - Vehicle Car/Truck Horn Street/Sidewalk 10023 WEST 72 STREET WEST 72 STREET COLUMBUS AVENUE AMSTERDAM AVENUE NaN NaN BLOCKFACE NEW YORK NaN Precinct Closed 10/31/2013 09:56:23 AM 10/31/2013 02:21:10 AM 07 MANHATTAN MANHATTAN 989730 222727 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.778009 -73.980213 (40.7780087446372, -73.98021349023975)\n4 26590930 10/31/2013 01:53:44 AM NaN DOHMH Department of Health and Mental Hygiene Rodent Condition Attracting Rodents Vacant Lot 10027 WEST 124 STREET WEST 124 STREET LENOX AVENUE ADAM CLAYTON POWELL JR BOULEVARD NaN NaN BLOCKFACE NEW YORK NaN NaN Pending 11/30/2013 01:53:44 AM 10/31/2013 01:59:54 AM 10 MANHATTAN MANHATTAN 998815 233545 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.807691 -73.947387 (40.80769092704951, -73.94738703491433)\n\n[5 rows x 52 columns]", "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 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
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
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
3 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
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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
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
109 | \n26594653 | \n10/30/2013 11:26:32 PM | \n10/31/2013 12:18:54 AM | \nNYPD | \nNew York City Police Department | \nNoise - Street/Sidewalk | \nLoud Music/Party | \nStreet/Sidewalk | \n11222 | \nNaN | \nNaN | \nNaN | \nNaN | \nDOBBIN STREET | \nNORMAN STREET | \nINTERSECTION | \nBROOKLYN | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 07:26:32 AM | \n10/31/2013 12:18:54 AM | \n01 BROOKLYN | \nBROOKLYN | \n996925 | \n203271 | \nUnspecified | \nBROOKLYN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.724600 | \n-73.954271 | \n(40.724599563793525, -73.95427134534344) | \n
236 | \n26591992 | \n10/30/2013 10:02:58 PM | \n10/30/2013 10:23:20 PM | \nNYPD | \nNew York City Police Department | \nNoise - Street/Sidewalk | \nLoud Talking | \nStreet/Sidewalk | \n11218 | \nDITMAS AVENUE | \nDITMAS AVENUE | \nNaN | \nNaN | \nNaN | \nNaN | \nLATLONG | \nBROOKLYN | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 06:02:58 AM | \n10/30/2013 10:23:20 PM | \n01 BROOKLYN | \nBROOKLYN | \n991895 | \n171051 | \nUnspecified | \nBROOKLYN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.636169 | \n-73.972455 | \n(40.63616876563881, -73.97245504682485) | \n
370 | \n26594167 | \n10/30/2013 08:38:25 PM | \n10/30/2013 10:26:28 PM | \nNYPD | \nNew York City Police Department | \nNoise - Street/Sidewalk | \nLoud Music/Party | \nStreet/Sidewalk | \n11218 | \n126 BEVERLY ROAD | \nBEVERLY ROAD | \nCHURCH AVENUE | \nEAST 2 STREET | \nNaN | \nNaN | \nADDRESS | \nBROOKLYN | \nNaN | \nPrecinct | \nClosed | \n10/31/2013 04:38:25 AM | \n10/30/2013 10:26:28 PM | \n12 BROOKLYN | \nBROOKLYN | \n990144 | \n173511 | \nUnspecified | \nBROOKLYN | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nUnspecified | \nN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \nNaN | \n40.642922 | \n-73.978762 | \n(40.6429222774404, -73.97876175474585) | \n
5 rows \u00d7 52 columns
\n\n | Complaint Type | \nBorough | \nCreated Date | \nDescriptor | \n
---|---|---|---|---|
31 | \nNoise - Street/Sidewalk | \nBROOKLYN | \n10/31/2013 12:30:36 AM | \nLoud Music/Party | \n
49 | \nNoise - Street/Sidewalk | \nBROOKLYN | \n10/31/2013 12:05:10 AM | \nLoud Talking | \n
109 | \nNoise - Street/Sidewalk | \nBROOKLYN | \n10/30/2013 11:26:32 PM | \nLoud Music/Party | \n
236 | \nNoise - Street/Sidewalk | \nBROOKLYN | \n10/30/2013 10:02:58 PM | \nLoud Talking | \n
370 | \nNoise - Street/Sidewalk | \nBROOKLYN | \n10/30/2013 08:38:25 PM | \nLoud Music/Party | \n
378 | \nNoise - Street/Sidewalk | \nBROOKLYN | \n10/30/2013 08:32:13 PM | \nLoud Talking | \n
656 | \nNoise - Street/Sidewalk | \nBROOKLYN | \n10/30/2013 06:07:39 PM | \nLoud Music/Party | \n
1251 | \nNoise - Street/Sidewalk | \nBROOKLYN | \n10/30/2013 03:04:51 PM | \nLoud Talking | \n
5416 | \nNoise - Street/Sidewalk | \nBROOKLYN | \n10/29/2013 10:07:02 PM | \nLoud Talking | \n
5584 | \nNoise - Street/Sidewalk | \nBROOKLYN | \n10/29/2013 08:15:59 PM | \nLoud Music/Party | \n
10 rows \u00d7 4 columns
\n