{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "## Chapter 3 Which borough has the most noise complaints?" ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": false }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Populating the interactive namespace from numpy and matplotlib\n", "line_width has been deprecated, use display.width instead (currently both are\n", "identical)\n", "\n" ] } ], "source": [ "%pylab inline\n", "import pandas as pd\n", "\n", "# Make the graphs a bit prettier, and bigger\n", "pd.set_option('display.mpl_style', 'default')\n", "figsize(15, 5)\n", "\n", "# Always display all the columns\n", "pd.set_option('display.line_width', 5000) \n", "pd.set_option('display.max_columns', 60) \n", "\n", "import matplotlib\n", "matplotlib.style.use('ggplot')" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": false }, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "/usr/local/lib/python2.7/site-packages/IPython/core/interactiveshell.py:2723: DtypeWarning: Columns (8) have mixed types. Specify dtype option on import or set low_memory=False.\n", " interactivity=interactivity, compiler=compiler, result=result)\n" ] } ], "source": [ "complaints = pd.read_csv('./data/311-service-requests.csv')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## 3.1 Selecting only noise complaints" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\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", " \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", " \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", " \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", " \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", " \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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Unique KeyCreated DateClosed DateAgencyAgency NameComplaint TypeDescriptorLocation TypeIncident ZipIncident AddressStreet NameCross Street 1Cross Street 2Intersection Street 1Intersection Street 2Address TypeCityLandmarkFacility TypeStatusDue DateResolution Action Updated DateCommunity BoardBoroughX Coordinate (State Plane)Y Coordinate (State Plane)Park Facility NamePark BoroughSchool NameSchool NumberSchool RegionSchool CodeSchool Phone NumberSchool AddressSchool CitySchool StateSchool ZipSchool Not FoundSchool or Citywide ComplaintVehicle TypeTaxi Company BoroughTaxi Pick Up LocationBridge Highway NameBridge Highway DirectionRoad RampBridge Highway SegmentGarage Lot NameFerry DirectionFerry Terminal NameLatitudeLongitudeLocation
02658965110/31/2013 02:08:41 AMNaNNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud TalkingStreet/Sidewalk1143290-03 169 STREET169 STREET90 AVENUE91 AVENUENaNNaNADDRESSJAMAICANaNPrecinctAssigned10/31/2013 10:08:41 AM10/31/2013 02:35:17 AM12 QUEENSQUEENS1042027197389UnspecifiedQUEENSUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.708275-73.791604(40.70827532593202, -73.79160395779721)
12659369810/31/2013 02:01:04 AMNaNNYPDNew York City Police DepartmentIllegal ParkingCommercial Overnight ParkingStreet/Sidewalk1137858 AVENUE58 AVENUE58 PLACE59 STREETNaNNaNBLOCKFACEMASPETHNaNPrecinctOpen10/31/2013 10:01:04 AMNaN05 QUEENSQUEENS1009349201984UnspecifiedQUEENSUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.721041-73.909453(40.721040535628305, -73.90945306791765)
22659413910/31/2013 02:00:24 AM10/31/2013 02:40:32 AMNYPDNew York City Police DepartmentNoise - CommercialLoud Music/PartyClub/Bar/Restaurant100324060 BROADWAYBROADWAYWEST 171 STREETWEST 172 STREETNaNNaNADDRESSNEW YORKNaNPrecinctClosed10/31/2013 10:00:24 AM10/31/2013 02:39:42 AM12 MANHATTANMANHATTAN1001088246531UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.843330-73.939144(40.84332975466513, -73.93914371913482)
32659572110/31/2013 01:56:23 AM10/31/2013 02:21:48 AMNYPDNew York City Police DepartmentNoise - VehicleCar/Truck HornStreet/Sidewalk10023WEST 72 STREETWEST 72 STREETCOLUMBUS AVENUEAMSTERDAM AVENUENaNNaNBLOCKFACENEW YORKNaNPrecinctClosed10/31/2013 09:56:23 AM10/31/2013 02:21:10 AM07 MANHATTANMANHATTAN989730222727UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.778009-73.980213(40.7780087446372, -73.98021349023975)
42659093010/31/2013 01:53:44 AMNaNDOHMHDepartment of Health and Mental HygieneRodentCondition Attracting RodentsVacant Lot10027WEST 124 STREETWEST 124 STREETLENOX AVENUEADAM CLAYTON POWELL JR BOULEVARDNaNNaNBLOCKFACENEW YORKNaNNaNPending11/30/2013 01:53:44 AM10/31/2013 01:59:54 AM10 MANHATTANMANHATTAN998815233545UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.807691-73.947387(40.80769092704951, -73.94738703491433)
\n", "
" ], "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\n", "0 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)\n", "1 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)\n", "2 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)\n", "3 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)\n", "4 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)" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "complaints[: 5]" ] }, { "cell_type": "code", "execution_count": 4, "metadata": { "collapsed": true }, "outputs": [], "source": [ "noise_complaints = complaints[complaints['Complaint Type'] == 'Noise - Street/Sidewalk']" ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\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", " \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", " \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", " \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", " \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", " \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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Unique KeyCreated DateClosed DateAgencyAgency NameComplaint TypeDescriptorLocation TypeIncident ZipIncident AddressStreet NameCross Street 1Cross Street 2Intersection Street 1Intersection Street 2Address TypeCityLandmarkFacility TypeStatusDue DateResolution Action Updated DateCommunity BoardBoroughX Coordinate (State Plane)Y Coordinate (State Plane)Park Facility NamePark BoroughSchool NameSchool NumberSchool RegionSchool CodeSchool Phone NumberSchool AddressSchool CitySchool StateSchool ZipSchool Not FoundSchool or Citywide ComplaintVehicle TypeTaxi Company BoroughTaxi Pick Up LocationBridge Highway NameBridge Highway DirectionRoad RampBridge Highway SegmentGarage Lot NameFerry DirectionFerry Terminal NameLatitudeLongitudeLocation
02658965110/31/2013 02:08:41 AMNaNNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud TalkingStreet/Sidewalk1143290-03 169 STREET169 STREET90 AVENUE91 AVENUENaNNaNADDRESSJAMAICANaNPrecinctAssigned10/31/2013 10:08:41 AM10/31/2013 02:35:17 AM12 QUEENSQUEENS1042027197389UnspecifiedQUEENSUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.708275-73.791604(40.70827532593202, -73.79160395779721)
162659408610/31/2013 12:54:03 AM10/31/2013 02:16:39 AMNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud Music/PartyStreet/Sidewalk10310173 CAMPBELL AVENUECAMPBELL AVENUEHENDERSON AVENUEWINEGAR LANENaNNaNADDRESSSTATEN ISLANDNaNPrecinctClosed10/31/2013 08:54:03 AM10/31/2013 02:07:14 AM01 STATEN ISLANDSTATEN ISLAND952013171076UnspecifiedSTATEN ISLANDUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.636182-74.116150(40.63618202176914, -74.1161500428337)
252659157310/31/2013 12:35:18 AM10/31/2013 02:41:35 AMNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud TalkingStreet/Sidewalk1031224 PRINCETON LANEPRINCETON LANEHAMPTON GREENDEAD ENDNaNNaNADDRESSSTATEN ISLANDNaNPrecinctClosed10/31/2013 08:35:18 AM10/31/2013 01:45:17 AM03 STATEN ISLANDSTATEN ISLAND929577140964UnspecifiedSTATEN ISLANDUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.553421-74.196743(40.55342078716953, -74.19674315017886)
282659408510/31/2013 12:32:08 AMNaNNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud TalkingStreet/Sidewalk10026121 WEST 116 STREETWEST 116 STREETLENOX AVENUE7 AVENUENaNNaNADDRESSNEW YORKNaNPrecinctAssigned10/31/2013 08:32:08 AM10/31/2013 02:00:57 AM10 MANHATTANMANHATTAN997947231613UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.802390-73.950526(40.80238950799943, -73.95052644123253)
312659556410/31/2013 12:30:36 AMNaNNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud Music/PartyStreet/Sidewalk11236AVENUE JAVENUE JEAST 80 STREETEAST 81 STREETNaNNaNBLOCKFACEBROOKLYNNaNPrecinctOpen10/31/2013 08:30:36 AMNaN18 BROOKLYNBROOKLYN1008937170310UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.634104-73.911055(40.634103775951736, -73.91105541883589)
\n", "
" ], "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\n", "0 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)\n", "16 26594086 10/31/2013 12:54:03 AM 10/31/2013 02:16:39 AM NYPD New York City Police Department Noise - Street/Sidewalk Loud Music/Party Street/Sidewalk 10310 173 CAMPBELL AVENUE CAMPBELL AVENUE HENDERSON AVENUE WINEGAR LANE NaN NaN ADDRESS STATEN ISLAND NaN Precinct Closed 10/31/2013 08:54:03 AM 10/31/2013 02:07:14 AM 01 STATEN ISLAND STATEN ISLAND 952013 171076 Unspecified STATEN ISLAND Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.636182 -74.116150 (40.63618202176914, -74.1161500428337)\n", "25 26591573 10/31/2013 12:35:18 AM 10/31/2013 02:41:35 AM NYPD New York City Police Department Noise - Street/Sidewalk Loud Talking Street/Sidewalk 10312 24 PRINCETON LANE PRINCETON LANE HAMPTON GREEN DEAD END NaN NaN ADDRESS STATEN ISLAND NaN Precinct Closed 10/31/2013 08:35:18 AM 10/31/2013 01:45:17 AM 03 STATEN ISLAND STATEN ISLAND 929577 140964 Unspecified STATEN ISLAND Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.553421 -74.196743 (40.55342078716953, -74.19674315017886)\n", "28 26594085 10/31/2013 12:32:08 AM NaN NYPD New York City Police Department Noise - Street/Sidewalk Loud Talking Street/Sidewalk 10026 121 WEST 116 STREET WEST 116 STREET LENOX AVENUE 7 AVENUE NaN NaN ADDRESS NEW YORK NaN Precinct Assigned 10/31/2013 08:32:08 AM 10/31/2013 02:00:57 AM 10 MANHATTAN MANHATTAN 997947 231613 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.802390 -73.950526 (40.80238950799943, -73.95052644123253)\n", "31 26595564 10/31/2013 12:30:36 AM NaN NYPD New York City Police Department Noise - Street/Sidewalk Loud Music/Party Street/Sidewalk 11236 AVENUE J AVENUE J EAST 80 STREET EAST 81 STREET NaN NaN BLOCKFACE BROOKLYN NaN Precinct Open 10/31/2013 08:30:36 AM NaN 18 BROOKLYN BROOKLYN 1008937 170310 Unspecified BROOKLYN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.634104 -73.911055 (40.634103775951736, -73.91105541883589)" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "noise_complaints[: 5]" ] }, { "cell_type": "code", "execution_count": 6, "metadata": { "collapsed": true }, "outputs": [], "source": [ "is_noise = complaints['Complaint Type'] == 'Noise - Street/Sidewalk'" ] }, { "cell_type": "code", "execution_count": 7, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "0 True\n", "1 False\n", "2 False\n", "3 False\n", "4 False\n", "Name: Complaint Type, dtype: bool" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "is_noise[: 5]" ] }, { "cell_type": "code", "execution_count": 8, "metadata": { "collapsed": true }, "outputs": [], "source": [ "in_brooklyn = complaints['Borough'] == 'BROOKLYN'" ] }, { "cell_type": "code", "execution_count": 10, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "0 False\n", "1 False\n", "2 False\n", "3 False\n", "4 False\n", "Name: Borough, dtype: bool" ] }, "execution_count": 10, "metadata": {}, "output_type": "execute_result" } ], "source": [ "in_brooklyn[: 5]" ] }, { "cell_type": "code", "execution_count": 12, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\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", " \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", " \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", " \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", " \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", " \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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Unique KeyCreated DateClosed DateAgencyAgency NameComplaint TypeDescriptorLocation TypeIncident ZipIncident AddressStreet NameCross Street 1Cross Street 2Intersection Street 1Intersection Street 2Address TypeCityLandmarkFacility TypeStatusDue DateResolution Action Updated DateCommunity BoardBoroughX Coordinate (State Plane)Y Coordinate (State Plane)Park Facility NamePark BoroughSchool NameSchool NumberSchool RegionSchool CodeSchool Phone NumberSchool AddressSchool CitySchool StateSchool ZipSchool Not FoundSchool or Citywide ComplaintVehicle TypeTaxi Company BoroughTaxi Pick Up LocationBridge Highway NameBridge Highway DirectionRoad RampBridge Highway SegmentGarage Lot NameFerry DirectionFerry Terminal NameLatitudeLongitudeLocation
312659556410/31/2013 12:30:36 AMNaNNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud Music/PartyStreet/Sidewalk11236AVENUE JAVENUE JEAST 80 STREETEAST 81 STREETNaNNaNBLOCKFACEBROOKLYNNaNPrecinctOpen10/31/2013 08:30:36 AMNaN18 BROOKLYNBROOKLYN1008937170310UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.634104-73.911055(40.634103775951736, -73.91105541883589)
492659555310/31/2013 12:05:10 AM10/31/2013 02:43:43 AMNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud TalkingStreet/Sidewalk1122525 LEFFERTS AVENUELEFFERTS AVENUEWASHINGTON AVENUEBEDFORD AVENUENaNNaNADDRESSBROOKLYNNaNPrecinctClosed10/31/2013 08:05:10 AM10/31/2013 01:29:29 AM09 BROOKLYNBROOKLYN995366180388UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.661793-73.959934(40.6617931276793, -73.95993363978067)
1092659465310/30/2013 11:26:32 PM10/31/2013 12:18:54 AMNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud Music/PartyStreet/Sidewalk11222NaNNaNNaNNaNDOBBIN STREETNORMAN STREETINTERSECTIONBROOKLYNNaNPrecinctClosed10/31/2013 07:26:32 AM10/31/2013 12:18:54 AM01 BROOKLYNBROOKLYN996925203271UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.724600-73.954271(40.724599563793525, -73.95427134534344)
2362659199210/30/2013 10:02:58 PM10/30/2013 10:23:20 PMNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud TalkingStreet/Sidewalk11218DITMAS AVENUEDITMAS AVENUENaNNaNNaNNaNLATLONGBROOKLYNNaNPrecinctClosed10/31/2013 06:02:58 AM10/30/2013 10:23:20 PM01 BROOKLYNBROOKLYN991895171051UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.636169-73.972455(40.63616876563881, -73.97245504682485)
3702659416710/30/2013 08:38:25 PM10/30/2013 10:26:28 PMNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud Music/PartyStreet/Sidewalk11218126 BEVERLY ROADBEVERLY ROADCHURCH AVENUEEAST 2 STREETNaNNaNADDRESSBROOKLYNNaNPrecinctClosed10/31/2013 04:38:25 AM10/30/2013 10:26:28 PM12 BROOKLYNBROOKLYN990144173511UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.642922-73.978762(40.6429222774404, -73.97876175474585)
\n", "
" ], "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\n", "31 26595564 10/31/2013 12:30:36 AM NaN NYPD New York City Police Department Noise - Street/Sidewalk Loud Music/Party Street/Sidewalk 11236 AVENUE J AVENUE J EAST 80 STREET EAST 81 STREET NaN NaN BLOCKFACE BROOKLYN NaN Precinct Open 10/31/2013 08:30:36 AM NaN 18 BROOKLYN BROOKLYN 1008937 170310 Unspecified BROOKLYN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.634104 -73.911055 (40.634103775951736, -73.91105541883589)\n", "49 26595553 10/31/2013 12:05:10 AM 10/31/2013 02:43:43 AM NYPD New York City Police Department Noise - Street/Sidewalk Loud Talking Street/Sidewalk 11225 25 LEFFERTS AVENUE LEFFERTS AVENUE WASHINGTON AVENUE BEDFORD AVENUE NaN NaN ADDRESS BROOKLYN NaN Precinct Closed 10/31/2013 08:05:10 AM 10/31/2013 01:29:29 AM 09 BROOKLYN BROOKLYN 995366 180388 Unspecified BROOKLYN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.661793 -73.959934 (40.6617931276793, -73.95993363978067)\n", "109 26594653 10/30/2013 11:26:32 PM 10/31/2013 12:18:54 AM NYPD New York City Police Department Noise - Street/Sidewalk Loud Music/Party Street/Sidewalk 11222 NaN NaN NaN NaN DOBBIN STREET NORMAN STREET INTERSECTION BROOKLYN NaN Precinct Closed 10/31/2013 07:26:32 AM 10/31/2013 12:18:54 AM 01 BROOKLYN BROOKLYN 996925 203271 Unspecified BROOKLYN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.724600 -73.954271 (40.724599563793525, -73.95427134534344)\n", "236 26591992 10/30/2013 10:02:58 PM 10/30/2013 10:23:20 PM NYPD New York City Police Department Noise - Street/Sidewalk Loud Talking Street/Sidewalk 11218 DITMAS AVENUE DITMAS AVENUE NaN NaN NaN NaN LATLONG BROOKLYN NaN Precinct Closed 10/31/2013 06:02:58 AM 10/30/2013 10:23:20 PM 01 BROOKLYN BROOKLYN 991895 171051 Unspecified BROOKLYN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.636169 -73.972455 (40.63616876563881, -73.97245504682485)\n", "370 26594167 10/30/2013 08:38:25 PM 10/30/2013 10:26:28 PM NYPD New York City Police Department Noise - Street/Sidewalk Loud Music/Party Street/Sidewalk 11218 126 BEVERLY ROAD BEVERLY ROAD CHURCH AVENUE EAST 2 STREET NaN NaN ADDRESS BROOKLYN NaN Precinct Closed 10/31/2013 04:38:25 AM 10/30/2013 10:26:28 PM 12 BROOKLYN BROOKLYN 990144 173511 Unspecified BROOKLYN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.642922 -73.978762 (40.6429222774404, -73.97876175474585)" ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "complaints[is_noise & in_brooklyn][: 5]" ] }, { "cell_type": "code", "execution_count": 13, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\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", "
Complaint TypeBoroughCreated DateDescriptor
31Noise - Street/SidewalkBROOKLYN10/31/2013 12:30:36 AMLoud Music/Party
49Noise - Street/SidewalkBROOKLYN10/31/2013 12:05:10 AMLoud Talking
109Noise - Street/SidewalkBROOKLYN10/30/2013 11:26:32 PMLoud Music/Party
236Noise - Street/SidewalkBROOKLYN10/30/2013 10:02:58 PMLoud Talking
370Noise - Street/SidewalkBROOKLYN10/30/2013 08:38:25 PMLoud Music/Party
\n", "
" ], "text/plain": [ " Complaint Type Borough Created Date Descriptor\n", "31 Noise - Street/Sidewalk BROOKLYN 10/31/2013 12:30:36 AM Loud Music/Party\n", "49 Noise - Street/Sidewalk BROOKLYN 10/31/2013 12:05:10 AM Loud Talking\n", "109 Noise - Street/Sidewalk BROOKLYN 10/30/2013 11:26:32 PM Loud Music/Party\n", "236 Noise - Street/Sidewalk BROOKLYN 10/30/2013 10:02:58 PM Loud Talking\n", "370 Noise - Street/Sidewalk BROOKLYN 10/30/2013 08:38:25 PM Loud Music/Party" ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "complaints[is_noise & in_brooklyn][['Complaint Type', 'Borough', 'Created Date', 'Descriptor']][0: 5]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## 3.2 A digression about numpy arrays" ] }, { "cell_type": "code", "execution_count": 14, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "0 1\n", "1 2\n", "2 3\n", "dtype: int64" ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "pd.Series([1, 2, 3])" ] }, { "cell_type": "code", "execution_count": 15, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "array([1, 2, 3])" ] }, "execution_count": 15, "metadata": {}, "output_type": "execute_result" } ], "source": [ "np.array([1, 2, 3])" ] }, { "cell_type": "code", "execution_count": 16, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "array([1, 2, 3])" ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "pd.Series([1, 2, 3]).values" ] }, { "cell_type": "code", "execution_count": 17, "metadata": { "collapsed": true }, "outputs": [], "source": [ "arr = np.array([1, 2, 3])" ] }, { "cell_type": "code", "execution_count": 18, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "array([ True, False, True], dtype=bool)" ] }, "execution_count": 18, "metadata": {}, "output_type": "execute_result" } ], "source": [ "arr != 2" ] }, { "cell_type": "code", "execution_count": 19, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "array([1, 3])" ] }, "execution_count": 19, "metadata": {}, "output_type": "execute_result" } ], "source": [ "arr[arr != 2]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## 3.3 which borough has the most noise complaints?" ] }, { "cell_type": "code", "execution_count": 20, "metadata": { "collapsed": true }, "outputs": [], "source": [ "is_noise = complaints['Complaint Type'] == 'Noise - Street/Sidewalk'" ] }, { "cell_type": "code", "execution_count": 21, "metadata": { "collapsed": true }, "outputs": [], "source": [ "noise_complaints = complaints[is_noise]" ] }, { "cell_type": "code", "execution_count": 22, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "MANHATTAN 917\n", "BROOKLYN 456\n", "BRONX 292\n", "QUEENS 226\n", "STATEN ISLAND 36\n", "Unspecified 1\n", "Name: Borough, dtype: int64" ] }, "execution_count": 22, "metadata": {}, "output_type": "execute_result" } ], "source": [ "noise_complaints['Borough'].value_counts()" ] }, { "cell_type": "code", "execution_count": 23, "metadata": { "collapsed": true }, "outputs": [], "source": [ "noise_coplaints_counts = noise_complaints['Borough'].value_counts()\n", "complaints_counts = complaints['Borough'].value_counts()" ] }, { "cell_type": "code", "execution_count": 24, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "MANHATTAN 917\n", "BROOKLYN 456\n", "BRONX 292\n", "QUEENS 226\n", "STATEN ISLAND 36\n", "Unspecified 1\n", "Name: Borough, dtype: int64" ] }, "execution_count": 24, "metadata": {}, "output_type": "execute_result" } ], "source": [ "noise_coplaints_counts" ] }, { "cell_type": "code", "execution_count": 25, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "BROOKLYN 32890\n", "MANHATTAN 24288\n", "QUEENS 22281\n", "BRONX 19686\n", "Unspecified 7107\n", "STATEN ISLAND 4817\n", "Name: Borough, dtype: int64" ] }, "execution_count": 25, "metadata": {}, "output_type": "execute_result" } ], "source": [ "complaints_counts" ] }, { "cell_type": "code", "execution_count": 27, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "BRONX 0.014833\n", "BROOKLYN 0.013864\n", "MANHATTAN 0.037755\n", "QUEENS 0.010143\n", "STATEN ISLAND 0.007474\n", "Unspecified 0.000141\n", "Name: Borough, dtype: float64" ] }, "execution_count": 27, "metadata": {}, "output_type": "execute_result" } ], "source": [ "noise_coplaints_counts/complaints_counts" ] }, { "cell_type": "code", "execution_count": 29, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 29, "metadata": {}, "output_type": "execute_result" }, { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAA3cAAAF9CAYAAACnN5FZAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzt3X+Q1Hd9P/DX/do7Nnd4xgjHkSaaVmMacmaosUqxRGdM\nUhwL2l7HVKcYIGSk1oo2ziSdG0S8ksRWEU1mlE7jNU1V6KSoHUziiHV0chATyxwQSUI0rXJ3VATC\nnksCd7vfP/Llmsjd7S6QfHY/PB4zmVk++75PXru82LvnfT6f16euWCwWAwAAgJpWn3QBAAAAnDnh\nDgAAIAWEOwAAgBQQ7gAAAFJAuAMAAEgB4Q4AACAFGstZtGvXrti8eXPU1dVFd3d3zJkz57TWjo6O\nxl//9V/HH//xH8e1115b8b4BAACYWMlwVywWY9OmTdHT0xMREb29vZMGsFJrH3zwwXjta197WvsG\nAABgciVPyxwaGopZs2ZFJpOJTCYTM2fOjOHh4YrXHj9+PAYGBuKqq646rX0DAAAwuZJH7kZGRiKb\nzUZfX18Ui8XIZrORy+Wio6OjorVbt26N6667Lo4cOXJa+wYAAGByJY/ctba2Rj6fj+uvvz7+/M//\nPH79619HW1tbRWvz+Xzs3bs3rrzyytPeNwAAAJMreeSuo6MjhoaGIuL5a+SGh4cnPbI22dof//jH\nceLEifj85z8f//u//xuFQiEuv/zy6OzsLHvfJw0ODlb0As8FbW1tkcvlki6DGqBXqIR+oVx6hUro\nF8qlVybW2dk56XMlw119fX10d3fH2rVrxydantTf3x/Nzc0xd+7cKdfOnTt3fM33v//9ePbZZ+PC\nCy+MiJh03wAAAJSvrlgsFpMuohKO3J3KbzUol16hEvqFcukVKqFfKJdemdhUR+7cxBwAACAFhDsA\nAIAUEO4AAABSQLgDAABIAeEOAAAgBYQ7AACAFBDuAAAAUkC4AwAASAHhDgAAIAWEOwAAgBQQ7gAA\nAFKgMekCAPg/+/c3x+BgQ9JlREREQ0PE2Fg26TIiIqKzcyxmz34u6TIAoKoJdwBVZHCwIRYvbk+6\njKqzZcuRmD076SoAoLo5LRMAACAFhDsAAIAUEO4AAABSQLgDAABIAeEOAAAgBYQ7AACAFBDuAAAA\nUkC4AwAASAHhDgAAIAWEOwAAgBQQ7gAAAFJAuAMAAEgB4Q4AACAFhDsAAIAUaCxn0a5du2Lz5s1R\nV1cX3d3dMWfOnIrXfu1rX4vHH3886uvr46abbooZM2ZERMRdd90V+/fvj0wmE1dffXUsWLDgLLws\nAACAc0vJcFcsFmPTpk3R09MTERG9vb2Thrup1r7vfe+LiIi9e/fGli1bYsWKFeNft2rVqrjgggvO\n7JUAAACcw0qeljk0NBSzZs2KTCYTmUwmZs6cGcPDw6e9dt++fTF79uwXbSsWi2fwEgAAACh55G5k\nZCSy2Wz09fVFsViMbDYbuVwuOjo6Kl67evXqOHr0aKxdu3b8a1paWmLDhg3R2toaS5YsmXC/AAAA\nTK1kuGttbY18Ph/Lly+PiIiNGzdGW1vbaa1ds2ZN7Nu3L77whS/ELbfcEhERS5cujYiIp59+Ou65\n5564+eabp6xnsv/3uSyTyXhfKIteqX4NDUlXUJ0aGhr0bhXz2UIl9Avl0iuVKxnuOjo6YmhoKCKe\nP31yeHh40qNr5axtb2+PQqFwytc2NTVFQxk/1eRyuZJrzjVtbW3eF8qiV6rf2Fg26RKq0tjYWORy\n+aTLYBI+W6iEfqFcemViUwXekuGuvr4+uru7Y+3ateMTME/q7++P5ubmmDt3bsm1n/vc5yKXy0VT\nU9P40bqIiPXr18fhw4dj2rRpsWzZstN6gQAAAOe6umKNTTMZHBxMuoSq47calEuvVL8f/Sgbixe3\nJ11G1dmy5UhcdZUjd9XKZwuV0C+US69MrLOzc9Ln3MQcAAAgBYQ7AACAFBDuAAAAUkC4AwAASAHh\nDgAAIAWEOwAAgBQQ7gAAAFJAuAMAAEgB4Q4AACAFhDsAAIAUEO4AAABSQLgDAABIAeEOAAAgBYQ7\nAACAFBDuAAAAUkC4AwAASAHhDgAAIAWEOwAAgBQQ7gAAAFJAuAMAAEgB4Q4AACAFhDsAAIAUEO4A\nAABSQLgDAABIAeEOAAAgBYQ7AACAFBDuAAAAUqCxnEW7du2KzZs3R11dXXR3d8ecOXMqXvu1r30t\nHn/88aivr4+bbropZsyYUfG+AQAAmFjJcFcsFmPTpk3R09MTERG9vb2TBrCp1r7vfe+LiIi9e/fG\nli1bYsWKFRXtGwAAgMmVPC1zaGgoZs2aFZlMJjKZTMycOTOGh4dPe+2+ffti9uzZFe8bAACAyZU8\ncjcyMhLZbDb6+vqiWCxGNpuNXC4XHR0dFa9dvXp1HD16NNauXVvxvgEAAJhcyXDX2toa+Xw+li9f\nHhERGzdujLa2ttNau2bNmti3b1984QtfiFtuuaWifZ9U6vlzUSaT8b5QFr1S/Roakq6gOjU0NOjd\nKuazhUroF8qlVypXMtx1dHTE0NBQRDx/Td3w8PCkR9bKWdve3h6FQqHifZ+Uy+VKlXzOaWtr875Q\nFr1S/cbGskmXUJXGxsYil8snXQaT8NlCJfQL5dIrE5sq8JYMd/X19dHd3R1r164dn2h5Un9/fzQ3\nN8fcuXNLrv3c5z4XuVwumpqaYunSpSXXAwAAUL66YrFYTLqISgwODiZdQtXxWw3KpVeq349+lI3F\ni9uTLqPqbNlyJK66ypG7auWzhUroF8qlVybW2dk56XNuYg4AAJACwh0AAEAKCHcAAAApINwBAACk\ngHAHAACQAsIdAABACgh3AAAAKSDcAQAApIBwBwAAkALCHQAAQAoIdwAAACkg3AEAAKSAcAcAAJAC\nwh0AAEAKCHcAAAApINwBAACkgHAHAACQAsIdAABACgh3AAAAKSDcAQAApIBwBwAAkALCHQAAQAoI\ndwAAACkg3AEAAKSAcAcAAJACwh0AAEAKCHcAAAAp0FjOol27dsXmzZujrq4uuru7Y86cORWv/fKX\nvxxDQ0NRLBZj5cqVMWPGjIiIuOuuu2L//v2RyWTi6quvjgULFpyFlwUAAHBuKRnuisVibNq0KXp6\neiIiore3d9JwN9XaFStWRETE7t274xvf+EbceOON41+3atWquOCCC87slQAAAJzDSp6WOTQ0FLNm\nzYpMJhOZTCZmzpwZw8PDp7122rRp0dTU9KJtxWLxDF4CAAAAJY/cjYyMRDabjb6+vigWi5HNZiOX\ny0VHR8dprd22bVssXLhw/M8tLS2xYcOGaG1tjSVLlky43xdqa2ur5PWdEzKZjPeFsuiV6tfQkHQF\n1amhoUHvVjGfLVRCv1AuvVK5kuGutbU18vl8LF++PCIiNm7cOOmbXGrto48+Gp2dnTF79uzxbUuX\nLo2IiKeffjruueeeuPnmm6esJ5fLlSr5nNPW1uZ9oSx6pfqNjWWTLqEqjY2NRS6XT7oMJuGzhUro\nF8qlVyY2VeAteVpmR0dHDA0NRcTzp08ODw9PenRtqrU//elPY8+ePfGud71rwq9tamqKBr+yBgAA\nOC0lj9zV19dHd3d3rF27dnwC5kn9/f3R3Nwcc+fOLbn2s5/9bLzqVa+KNWvWxEUXXRQ33HBDRESs\nX78+Dh8+HNOmTYtly5ad7dcHAABwTqgr1tg0k8HBwaRLqDoOWVMuvVL9fvSjbCxe3J50GVVny5Yj\ncdVVTsusVj5bqIR+oVx6ZWKdnZ2TPucm5gAAACkg3AEAAKSAcAcAAJACwh0AAEAKCHcAAAApINwB\nAACkgHAHAACQAsIdAABACgh3AAAAKSDcAQAApIBwBwAAkALCHQAAQAoIdwAAACkg3AEAAKSAcAcA\nAJACwh0AAEAKCHcAAAApINwBAACkgHAHAACQAsIdAABACgh3AAAAKSDcAQAApIBwBwAAkALCHQAA\nQAoIdwAAACkg3AEAAKSAcAcAAJACjeUs2rVrV2zevDnq6uqiu7s75syZU/HaL3/5yzE0NBTFYjFW\nrlwZM2bMqHjfAAAATKxkuCsWi7Fp06bo6emJiIje3t5JA9hUa1esWBEREbt3745vfOMbceONN1a0\nbwAAACZX8rTMoaGhmDVrVmQymchkMjFz5swYHh4+7bXTpk2LpqamivcNAADA5EoeuRsZGYlsNht9\nfX1RLBYjm81GLpeLjo6O01q7bdu2WLhwYcX7Pqmtre10XmeqZTIZ7wtl0SvVr6Eh6QqqU0NDg96t\nYj5bqIR+oVx6pXIlw11ra2vk8/lYvnx5RERs3Lhx0je51NpHH300Ojs7Y/bs2RXv+6RcLlfGyzq3\ntLW1eV8oi16pfmNj2aRLqEpjY2ORy+WTLoNJ+GyhEvqFcumViU2Vl0qeltnR0RFDQ0MR8fw1dcPD\nw5MeWZtq7U9/+tPYs2dPvOtd7zqtfQMAADC5kkfu6uvro7u7O9auXTs+0fKk/v7+aG5ujrlz55Zc\n+9nPfjZe9apXxZo1a+Kiiy6KG264Ycr1AAAAlK+uWCwWky6iEoODg0mXUHUcsqZceqX6/ehH2Vi8\nuD3pMqrOli1H4qqrnJZZrXy2UAn9Qrn0ysQ6Ozsnfc5NzAEAAFJAuAMAAEgB4Q4AACAFhDsAAIAU\nEO4AAABSQLgDAABIAeEOAAAgBYQ7AACAFBDuAAAAUkC4AwAASAHhDgAAIAWEOwAAgBQQ7gAAAFJA\nuAMAAEgB4Q4AACAFhDsAAIAUEO4AAABSQLgDAABIAeEOAAAgBYQ7AACAFBDuAAAAUkC4AwAASAHh\nDgAAIAWEOwAAgBQQ7gAAAFJAuAMAAEgB4Q4AACAFGstZtGvXrti8eXPU1dVFd3d3zJkzp+K1e/fu\njb6+vrj88svjAx/4wPj6u+66K/bv3x+ZTCauvvrqWLBgwRm+JAAAgHNPyXBXLBZj06ZN0dPTExER\nvb29k4a7qdaeOHEi3vOe98QTTzxxytetWrUqLrjggtN+EQAAAOe6kqdlDg0NxaxZsyKTyUQmk4mZ\nM2fG8PBwxWuvuOKKaG1tnfDrisXiGbwEAAAASh65GxkZiWw2G319fVEsFiObzUYul4uOjo4zWntS\nS0tLbNiwIVpbW2PJkiVTro2IaGtrK+NlnVsymYz3hbLolerX0JB0BdWpoaFB71Yxny1UQr9QLr1S\nuZLhrrW1NfL5fCxfvjwiIjZu3Djpm1zJ2pOWLl0aERFPP/103HPPPXHzzTdPuT6Xy5Uq+WWxf39z\nDA5Wx09hDQ3HY2xsLOkyIiKis3MsZs9+LukymERbW1vV/BtiYmNj2aRLqEpjY2ORy+WTLoNJ+Gyh\nEvqFcumViU2Vr0qGu46OjhgaGoqI50+fHB4envToWjlrJzsFs6mpKRpq6FfWg4MNsXhxe9JlVJ0t\nW47E7NlJVwEAAOeekuGuvr4+uru7Y+3ateMTME/q7++P5ubmmDt3bsm1W7ZsiZ07d8YzzzwTx44d\nixUrVkRExPr16+Pw4cMxbdq0WLZs2dl+fQAAAOeEsm6F0NXVFV1dXadsf+tb31r22sWLF8fixYtP\n2f7Rj360nBIAAACYgpuYAwAApIBwBwAAkALCHQAAQAqUdc0dcGaq5dYZDQ3VM2rfbTMAAM4u4Q5e\nBm6dcSq3zQAAOLuclgkAAJACwh0AAEAKCHcAAAApINwBAACkgHAHAACQAsIdAABACgh3AAAAKSDc\nAQAApIBwBwAAkALCHQAAQAoIdwAAACkg3AEAAKSAcAcAAJACwh0AAEAKCHcAAAApINwBAACkgHAH\nAACQAsIdAABACgh3AAAAKSDcAQAApIBwBwAAkAKN5SzatWtXbN68Oerq6qK7uzvmzJlT8dq9e/dG\nX19fXH755fGBD3zgtPYNAADAxEqGu2KxGJs2bYqenp6IiOjt7Z00gE219sSJE/Ge97wnnnjiidPa\nNwAAAJMreVrm0NBQzJo1KzKZTGQymZg5c2YMDw9XvPaKK66I1tbW0943AAAAkyt55G5kZCSy2Wz0\n9fVFsViMbDYbuVwuOjo6zmjt6awHAP7P/v3NMTjYkHQZ0dAQMTaWTbqMiIjo7ByL2bOfS7oMgESU\nDHetra2Rz+dj+fLlERGxcePGaGtrO+O1p7M+Iko+/3JpSP57aVVqaGiomr+jaqJfTqVXJqZXJqZf\nJnbgQMTixd6XF/rWt3Lxhjdkki6DKWQyGf+eKYteqVzJcNfR0RFDQ0MR8fw1csPDw5MeWStnbbFY\nPK19n5TL5UqV/LKolt9QVpuxsbHI5fJJl1F19Mup9MrE9MrE9MvE9Mup9Er1a2trq5qf56huemVi\nUwXekuGuvr4+uru7Y+3ateMTLU/q7++P5ubmmDt3bsm1W7ZsiZ07d8YzzzwTx44dixUrVky5HgAA\ngPKVdSuErq6u6OrqOmX7W9/61rLXLl68OBYvXlz2egAAAMrnJuYAAAApINwBAACkgHAHAACQAsId\nAABACgh3AAAAKSDcAQAApIBwBwAAkALCHQAAQAoIdwAAACkg3AEAAKSAcAcAAJACwh0AAEAKCHcA\nAAApINwBAACkQGPSBQAA8NLav785Bgcbki4jIiIaGiLGxrJJlxEREZ2dYzF79nNJlwFnjXAHAJBy\ng4MNsXhxe9JlVJ0tW47E7NlJVwFnj9MyAQAAUkC4AwAASAHhDgAAIAWEOwAAgBQQ7gAAAFJAuAMA\nAEgB4Q4AACAFhDsAAIAUEO4AAABSQLgDAABIAeEOAAAgBRrLWbRr167YvHlz1NXVRXd3d8yZM6fi\ntZNtv+uuu2L//v2RyWTi6quvjgULFpyFlwUAAHBuKRnuisVibNq0KXp6eiIiore3d9JwN9naUvtY\ntWpVXHDBBWf8YgAAAM5VJU/LHBoailmzZkUmk4lMJhMzZ86M4eHhitaW2kexWDx7rwgAAOAcVPLI\n3cjISGSz2ejr64tisRjZbDZyuVx0dHSUvfbk44n20dLSEhs2bIjW1tZYsmTJhPsFAABgaiXDXWtr\na+Tz+Vi+fHlERGzcuDHa2toqWlsoFCbdx9KlSyMi4umnn4577rknbr755inrmez//XJraEi6gurU\n0NBQNX9H1US/nEqvTEyvTEy/TEy/nEqvTEyvTEy/VLdMJuPvp0Ilw11HR0cMDQ1FxPOnTw4PD096\ndG2ytYVCoeQ+mpqaoqGMT55cLldyzcthbCybdAlVaWxsLHK5fNJlVB39ciq9MjG9MjH9MjH9ciq9\nMjG9MjH9Ut3a2tqq5mf/ajJV4C0Z7urr66O7uzvWrl07PunypP7+/mhubo65c+dOuXaqfaxfvz4O\nHz4c06ZNi2XLlp32iwQAADiXlXUrhK6urujq6jpl+1vf+tay1062/aMf/Wg5JQAAADAFNzEHAABI\nAeEOAAAgBYQ7AACAFBDuAAAAUkC4AwAASAHhDgAAIAWEOwAAgBQQ7gAAAFJAuAMAAEgB4Q4AACAF\nhDsAAIAUEO4AAABSQLgDAABIAeEOAAAgBYQ7AACAFBDuAAAAUkC4AwAASAHhDgAAIAWEOwAAgBQQ\n7gAAAFJAuAMAAEgB4Q4AACAFhDsAAIAUEO4AAABSQLgDAABIAeEOAAAgBYQ7AACAFGgsZ9GuXbti\n8+bNUVdXF93d3TFnzpyK11a6HQAAgPKVDHfFYjE2bdoUPT09ERHR29s7aQCbbG2l2wEAAKhMyXA3\nNDQUs2bNikwmExERM2fOjOHh4ejo6Ch7baFQqGj7RPsGAABgciXD3cjISGSz2ejr64tisRjZbDZy\nudyEAWyytScfl7tduAMAgGTs398cg4MNSZcRDQ0RY2PZpMuIiIjOzrGYPfu5pMsoqWS4a21tjXw+\nH8uXL4+IiI0bN0ZbW1tFawuFQkXbp9LZ2Vn+q3sJLVoUUSwmXUU1av////FC+mUiemUiemUy+mUi\n+mUiemUiemUy+mUiVfLjNqehZLjr6OiIoaGhiHj+mrqpTpucbG2hUKhoOwAAAJWpKxZL/x5nYGBg\nfKLln/7pn0ZXV1dERPT390dzc3PMnTu35NpKtwMAAFC+ssIdAAAA1c1NzAEAAFJAuAMAAEgB4Q4A\nACAFhDsAAIAUKHkrBAAAOF2Dg4Nx6NChOP/886vmfsWQVsJdjXnkkUfiTW960ynbv//978eCBQsS\nqIhq9txzz036XHNz88tYCdVOrwBn28GDB+MLX/hCvOpVr4oLLrggDh48GIcOHYoPf/jDccEFFyRd\nHqSScFdjHnvssfjhD38YS5YsiVe+8pUxODgYX/nKV+J3fud3ki6NKnTbbbedsu1nP/tZnDhxIu69\n994EKqJa6RUq8eCDD8Y111wTERFPPvlk3H333VEsFuP9739/zJkzJ+HqqBZ33313fPCDH4zXvva1\n49v++7//O/7pn/4pPvGJTyRYGdXqlltuiYiIZ599No4fPx7Tp0+Pw4cPx3nnnRf/8A//kHB1tUG4\nqzF/8Rd/EU8//XTcdddd8cpXvjJGRkZi6dKl0dHRkXRpVKHVq1dHREShUIj+/v743ve+F9dcc01c\nd911CVdGtdErVGL79u1xzTXXRLFYjPvuuy9Wr14dxWIx1q1bJ9wxLp/PvyjYRURcfPHFcezYsYQq\notqtW7cuIiLuvPPOWLp0aUybNi2OHj0a//Iv/5JwZbVDuKtBuVwujh8/Hq94xSvil7/8ZYyMjCRd\nElXq2WefjW3btsWjjz4ab37zm+MTn/hEZDKZpMuiCukVKnHixInI5/PR398fb3nLW8ZP3a2vN6eN\n//PTn/50/EjMCw0ODiZQDbXkF7/4RbS0tERERFtbW/z85z9PuKLaUVcsFotJF0H5NmzYEM3NzfGB\nD3wgzjvvvDhy5Ej88z//czQ3N8dNN92UdHlUmRtuuCEiIi6//PJTfuj62Mc+lkRJVCm9QiUGBgbi\n61//elx88cVx4403Rl1dXRQKhbjnnntiyZIlSZcH1Lh///d/j0cffTQuueSSePrpp+P3fu/3YtGi\nRUmXVROEuxrz2GOPxe/+7u+esn1gYCC6uroSqIhq9stf/nLS51796le/jJVQ7fQKcLYZ1MSZOHLk\nSBw8eDBmzJgR06dPT7qcmiHc1RgflFRisumqUEqhUIjHHnssduzYEcuWLUu6HKqM70WUY82aNads\nM6iJco2OjsahQ4dixowZSZdSU4S7GuODkkr84z/+YwwODsb73ve+eP3rX590OVS50dHRGBgYiO3b\nt4+fDTB//nxnBXAK34uoxAsHNV1yySVx3XXXxfnnn590WVSxHTt2xNatWyOfz8dnPvOZ2LBhQ3zk\nIx9JuqyaINzVKB+UlOvAgQOxadOmOH78+Ium2F177bUJVkW1Wb9+fRw4cCAuvfTSuPLKK+O73/1u\nfPzjH0+6LKqc70VM5TcHNb397W83qImy9PT0xJo1a2Lt2rWxevXqWLNmzfhUZ6ZmWmaNMdGOSo2O\njsbo6Gg0Nzc7XYpJNTY2RqFQiNHR0SgUClFXV5d0SVQx34sox4c+9KGIeH5Q0549e2LPnj3jzxnU\nxFSKxWIcP348IiKOHTsWjkWVz5G7GmOiHZX44he/GCMjI3H99dfHxRdfnHQ5VLmxsbHYs2dP7Nix\nI3bu3BmXXXZZzJ8/P6688sqkS6PK+F5EOQxq4nTt3Lkz7r333jh06FBceOGFcf3118cb3vCGpMuq\nCcJdjfFBSSV2797thsKclmKxGI8//njs2LHDaHtO4XsRp8OgJipRLBYjl8uZlFkh4a4GHTt2LJ58\n8skYGRmJ1tbWeN3rXhfTpk1Luiyghn3nO9+Jd77znUmXAaSMQU3w8qovvYRq8tBDD0Vvb2/85Cc/\nicOHD8djjz0Wvb298dBDDyVdGjXks5/9bNIlUGV8hlCJL33pS+OPv/rVr44/vvPOO5Mohyq1fv36\n6OnpiYGBgZg3b1687nWvi5UrVwp28BIyUKXG3H///fHJT34yGhv/76/uxIkT8alPfSrmzZuXYGVA\nLTt06FA88MADEz5nsiq/aXh4ePzxE088Mf744MGDSZRDlTKoiUrdd9998d73vjduueWWU55bt25d\nAhXVHuGuxhQKhVO21dXVmSLEhCa70fBEfcS5rb6+PlpaWnyWUJZCoRDHjx+PQqFwymM46cMf/vCL\nBjU99dRT8cUvftGgJia1cOHCiIhoaWlx64PTJNzVmIULF0ZPT0+88Y1vjOnTp8fRo0dj9+7d4/8Y\n4IVuu+22pEugRrS3t8eCBQuSLoMaUV9fP/5b9N98DC/U0NAQXV1d0dXV9aJBTcIdE2lpaYmI8P3o\nDBioUoPy+Xzs27cvcrnc+ECVbDabdFlADdu2bVu84x3vSLoMAOAM+BVbDcpms9HV1RV/8Ad/EG98\n4xsjm83GD3/4w6TLogpt3779lG2FQiG+/vWvJ1AN1WxsbCzpEoBzhKFe8NIR7mrMd7/73bj55pvj\n1ltvjV/84hdx+PDhuP3222PXrl1Jl0YV2r17dzz44IPjf/75z38ePT09kclkEqyKamRaJpUwLRN4\nKdxxxx0REfH5z38+4Upql2vuasy2bdvi9ttvj6NHj8Ztt90WxWIx3v/+9xsrzISWL18emzZtis2b\nN0dzc3Ps2LEjbrrpprjooouSLo0qY1omlTAtk3IY6kWlfvWrX8VTTz0VBw4ciF/84hcveu7CCy9M\nqKraItzVmEwmE/X19dHe3h4NDQ2xevVqR2GY0p/92Z/F/fffHw8++GDccccdL7qNBpxkWiaVMC2T\nchjqRaWuv/76+N73vhe/+tWv4pvf/OaLnlu5cmVCVdUWA1VqzJIlS6KzszMiIgYHB8cfR7j/B6d6\n4X1iBgcH4/zzzx+fRKVfeKE1a9YYO03Z1qxZM+lz+gg4U3//938ff/M3f5N0GTVJuAPAtEwASAHh\nrsYdOXIk8vn8i47gwQsdO3YsnnzyyRgZGRm/dca0adOSLosqVygUYs+ePfHwww/HsmXLki4HqEEP\nPvhgXHPNNRER8eSTT8bdd989Pitgzpw5CVcH6eTimxrzgx/8IL75zW9GNpuNRYsWxdatW6OxsTEu\nu+yyWLRzVkVsAAAK2ElEQVRoUdLlUWUeeuih2Lp1a1xxxRXR2toa//M//xObNm2KhQsXxrx585Iu\njyozOjoaAwMDsX379hgYGIiurq6YP39+0mVRhV54yvdJjY2NsWjRonjTm96UQEVUo+3bt8c111wT\nxWIx7rvvvli9enUUi8VYt26dcAcvEeGuxmzdujXWrVsX+Xw+Pv7xj8edd94ZTU1Nceuttwp3nOL+\n+++PT37yky8aonLixIn41Kc+JdzxIuvXr48DBw7EpZdeGvPmzYtjx465eJ1JTXTN7nPPPRd33HGH\ncMe4EydORD6fj/7+/njLW94Szc3NEfH8ACeYyH333Rfvfe97J/wFklkB5RHuakxLS0s0NjbG9OnT\nY/bs2eOTMk8OyYAXmmhyXV1dnYmInKKxsTEKhUKMjo5GoVCIurq6pEuixjQ1NSVdAlWmu7s7ent7\n4+KLL44bb7wxIp7/vvSa17wm2cKoWgsXLoyI53+uNZzp9LjmrsZMNi1zcHAw+vr6kiyNKvTQQw/F\nt771rXjjG98Y06dPj6NHj8bu3budlsmExsbGYs+ePbFjx47YuXNnXHbZZTF//vy48sorky6NKjPR\nb9ULhUK8+93vdiovcMb+8z//M66++uqky6hJwh2kXD6fj3379kUulxsfqJLNZpMuiypXLBZj7969\n8fDDD8eSJUuSLocqdPKz5ejRo3HeeefF61//+jjvvPNix44d8fu///tJlwdwTnLSM6TcydPr6urq\nxv+DUurq6uKyyy4T7JhQf39/rFu3Ln7yk5/EM888E48//nj83d/9XWzdujUeeOCBpMujSkzWC3oE\nXjquuYMUMy2Tcr3wNLsjR45Ee3v7+J9dxM5v+va3vx2rV69+0bCmP/mTP4lVq1bFTTfdlGBlVJOt\nW7eesq1YLMa3v/3tuPbaaxOoiFpx5513xl/+5V+O//lzn/tcrFq1KsGKaodwBylmWiblemGAW7Nm\njQvZmdJkw5ra29vjiiuuSKAiqlF9fX20tLScMsTLtExKOXjw4Iv+/MwzzyRUSe0R7iDFTMsEXgoL\nFy6Mnp6eCYc1wUnXXnttLFiw4JTtzz77bALVUEvq6urimWeeiVe84hXxq1/9yiUlFTBQBVLMtEzK\n9cLTMl84iTfCaZlMzLAm4KWyb9++2LhxY7S3t8eRI0dixYoV8du//dtJl1UThDtIOT+AAQC16OjR\nozF9+vSky6gpwh2cg374wx+6FxUv8txzz036XHNz88tYCQBEjI6OxqFDh2LGjBlJl1JTXHMHKfbd\n73437r///mhqaoqVK1fGeeedF1/+8pdj+vTpwh0vctttt52y7Wc/+1mcOHEi7r333gQqAuBctWPH\njti6dWvk8/n4zGc+Exs2bIiPfOQjSZdVE4Q7SLFt27bF7bffHkePHo3bbrstisVivP/974+urq6k\nS6PKnJyOWSgUor+/P773ve/FNddcE9ddd13ClQFwrvmP//iPWLNmTaxduzYiIg4fPpxwRbVDuIMU\ny2QyUV9fH+3t7dHQ0BCrV6+OTCaTdFlUoWeffTa2bdsWjz76aLz5zW+OT3ziE3oFgEQUi8U4fvx4\nREQcO3bMlO8KuOYOUmzJkiXjUw9NQGQqN9xwQ0REXH755afcg+pjH/tYEiUBcI7auXNn3HvvvXHo\n0KG48MIL4/rrr483vOENSZdVE4Q7AOKXv/zlpM+9+tWvfhkrAdLCoCbORLFYjFwuZ1pmhZyWCeeQ\nI0eORD6ff9ERPIg4NcAVCoV47LHHYseOHbFs2bKEqgJqmUFNnIlnnnkmDh48GPX19dHa2pp0OTXD\nkTtIsR/84AfxzW9+M7LZbCxatCi2bt0ajY2Ncdlll8WiRYuSLo8qMzo6GgMDA7F9+/YYGBiIrq6u\nmD9/vgE8wBl54aCmSy65JK677ro4//zzky6LKvZv//ZvsXPnzrjkkkviZz/7WcybNy/+6I/+KOmy\naoIjd5BiW7dujXXr1kU+n4+Pf/zjceedd0ZTU1Pceuutwh0vsn79+jhw4EBceumlMW/evDh27Fis\nXLky6bKAGmZQE6frxz/+cXz605+O+vr6KBQK8bd/+7fCXZmEO0ixlpaWaGxsjOnTp8fs2bPHv6m2\ntLQkXBnVprGxMQqFQoyOjkahUIi6urqkSwJq3Ic+9KGIeH5Q0549e2LPnj3jzxnUxFQuuuiiOH78\neLS0tEQ+n4/f+q3fSrqkmuG0TEixyaZlDg4ORl9fX5KlUYXGxsZiz549sWPHjti5c2dcdtllMX/+\n/LjyyiuTLg2oQQY1cbpWrVoVx48fj+nTp8ehQ4fivPPOGx/CY9r31IQ7AOKxxx570Z8LhUI8/vjj\n8fDDD8ftt9+eUFUAQCXqSy8BIO1uv/32uPvuu+ORRx6JH//4x/Ff//Vfkc/nY86cOUmXBtSoL33p\nS+OPv/rVr44/vvPOO5MoB84JrrkDIDZu3BiPPPJI7Nq1K84///zo7u5OuiSgxg0PD48/fuKJJ8Yf\nHzx4MIlyqCHbtm2Ld7zjHbF37964++6747rrrou3v/3tSZdVExy5AyByuVwcPHgwisVivPKVr0y6\nHCAFCoVCHD9+PJ599tlTHsNUvv/970dExCOPPBKf/vSn44EHHki4otrhyB0AsXLlyrjoooti1qxZ\nMTAwEAMDA+PPmWoHnI76+vrx4Re/+RimMjY2Fr/+9a+jtbU1mpqaYtq0aUmXVDMMVAHAVDsAqsYD\nDzwQ27dvj7/6q7+K888/P77yla/EBz/4waTLqgnCHQAAZ913vvOdeOc735l0GXBOcVwcAICz7qGH\nHkq6BDjnuOYOAICz7tChQ5MOwrj22mtf5mqoJf/6r/8ajz76aGQymfFtbl5eHuEOAICzrr6+Plpa\nWsIVQFRqz5498ZnPfMbwndMg3AEAcNa1t7fHggULki6DGnTppZdGLpeLV7ziFUmXUnOEOwAAzrq3\nve1tSZdAjdq1a1f09/dHe3v7+DanZZbHtEwAAF5yhUIh9uzZEw8//HAsW7Ys6XIglRy5AwDgJTE6\nOhoDAwOxffv2GBgYiK6urpg/f37SZUFqCXcAAJx169evjwMHDsSll14a8+bNi2PHjsXKlSuTLosq\ndsstt5yyrbGxMRYtWhRvetObEqio9gh3AACcdY2NjVEoFGJ0dDQKhULU1dUlXRJVbqLr6p577rm4\n4447hLsyCXcAAJx1H/7wh2NsbCz27NkTO3bsiKeeeiq++MUvxvz58+PKK69MujxqRFNTU9Il1BTh\nDgCAl0RDQ0N0dXVFV1dXFIvFePzxx2PHjh3CHROa6LTMQqEQ7373uxOopjaZlgkAwFn3ne98J975\nzncmXQacU9z2HQCAs+6hhx5KugQ45zgtEwCAs+7QoUPxwAMPTPjctdde+zJXA+cG4Q4AgLOuvr4+\nWlpawhVA8PIR7gAAOOva29tjwYIFSZcB5xTX3AEAcNa97W1vS7oEOOeYlgkAAJACjtwBAHDWPfjg\ng+OPn3zyybj11lvjlltuid27dydYFaSbcAcAwFm3ffv2iIgoFotx3333xerVq2P16tWxefPmhCuD\n9DJQBQCAs+7EiRORz+ejv78/3vKWt0Rzc3NEPD9FE3hp+NcFAMBZ193dHb29vfHUU0/FH/7hH0ZE\nRKFQiNe85jXJFgYpZqAKAABACjhyBwAAkALCHQAAQAoIdwAAACkg3AEAAKSAcAcAAJAC/w/LQz4i\nOZF/mAAAAABJRU5ErkJggg==\n", "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "(noise_coplaints_counts/complaints_counts.astype(float)).plot(kind='bar')" ] } ], "metadata": { "kernelspec": { "display_name": "Python 2", "language": "python", "name": "python2" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 2 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython2", "version": "2.7.11" } }, "nbformat": 4, "nbformat_minor": 0 }