notebook.community

Edit and run

How to count the rat complaints in New York with Python

Follow along by downloading this presentation and running the code yourself:

Setup:

  • You can ask me any question, any time.
  • I'd rather cover less material and you have you understand more of it.
  • There will be exercises! Do them with a partner.

Some instructions

Run a cell by either:

  • pressing the 'play' key at in the toolbar
  • Ctrl+Enter
  • Shift+Enter

You need to run the cells in order.





In [4]:



    


# ignore this!
# ignore me!
# This is just to make everything look prettier!
import pandas as pd
pd.set_option('display.mpl_style', 'default')
figsize(15, 6)
pd.set_option('display.line_width', 4000)
pd.set_option('display.max_columns', 100)

Goal (Today): Learn how to find out

1. Which borough has the most rat complaints

2. Whether there are more noise complaints about houses of worship or helicopters

3. What people complain about on my street

Step 1: Read our data from a file





In [2]:



    


# Download the data!
!wget "http://bit.ly/311-data-tar-gz"
!tar -xzf "311-data.tar.gz"



    


















    






--2013-11-08 02:37:39--  http://bit.ly/311-data-tar-gz
Resolving bit.ly... 69.58.188.39, 69.58.188.40
Connecting to bit.ly|69.58.188.39|:80... connected.
HTTP request sent, awaiting response... 301 Moved
Location: https://dl.dropboxusercontent.com/u/115162019/311-data.tar.gz [following]
--2013-11-08 02:37:39--  https://dl.dropboxusercontent.com/u/115162019/311-data.tar.gz
Resolving dl.dropboxusercontent.com... 23.21.83.28
Connecting to dl.dropboxusercontent.com|23.21.83.28|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 8492118 (8.1M) [application/octet-stream]
Saving to: `311-data.tar.gz'

100%[======================================>] 8,492,118   5.89M/s   in 1.4s    

2013-11-08 02:37:41 (5.89 MB/s) - `311-data.tar.gz' saved [8492118/8492118]


















In [3]:



    


# This reads the data from a file!
orig_data = pd.read_csv('./311-service-requests.csv', nrows=100000, parse_dates=['Created Date'])
orig_data['Street Name'].fillna("", inplace=True) # ignore this! This is replacing missing street names
# Look at the first 5 columns of the data
orig_data[:5]



    


















    
Out[3]:










  
    

      
      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
    

  
  
    

      0
       26589651
      2013-10-31 02:08:41
                          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)
    

    

      1
       26593698
      2013-10-31 02:01:04
                          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)
    

    

      2
       26594139
      2013-10-31 02:00:24
       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)
    

    

      3
       26595721
      2013-10-31 01:56:23
       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)
    

    

      4
       26590930
      2013-10-31 01:53:44
                          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
            N/A
        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)
    

  




















In [25]:



    


plot(orig_data['Longitude'], orig_data['Latitude'], '.', color='purple')



    


















    
Out[25]:








[<matplotlib.lines.Line2D at 0x5d8c5d0>]

Exercise 0: Change the color of the plot above!

Example 1: What do people complain about?





In [4]:



    


orig_data['Complaint Type']



    


















    
Out[4]:








0      Noise - Street/Sidewalk
1              Illegal Parking
2           Noise - Commercial
3              Noise - Vehicle
4                       Rodent
5           Noise - Commercial
6             Blocked Driveway
7           Noise - Commercial
8           Noise - Commercial
9           Noise - Commercial
10    Noise - House of Worship
11          Noise - Commercial
12             Illegal Parking
13             Noise - Vehicle
14                      Rodent
...
99985                 Street Condition
99986                 Street Condition
99987                  Illegal Parking
99988                     Damaged Tree
99989                     Damaged Tree
99990                 Derelict Vehicle
99991           DOF Literature Request
99992           DOF Literature Request
99993    Root/Sewer/Sidewalk Condition
99994                            Sewer
99995         Benefit Card Replacement
99996          Overgrown Tree/Branches
99997           DOF Literature Request
99998       Fire Safety Director - F58
99999             EAP Inspection - F59
Name: Complaint Type, Length: 100000, dtype: object

















In [5]:



    


orig_data['Complaint Type'].value_counts()



    


















    
Out[5]:








HEATING                     13983
GENERAL CONSTRUCTION         6859
Street Light Condition       6513
DOF Literature Request       5107
PLUMBING                     4884
PAINT - PLASTER              4671
Blocked Driveway             3992
NONCONST                     3646
Street Condition             3070
Noise                        2942
Traffic Signal Condition     2895
Illegal Parking              2865
Dirty Conditions             2364
ELECTRIC                     2154
Noise - Commercial           2120
...
Window Guard                         2
Legal Services Provider Complaint    2
Public Assembly                      2
Ferry Permit                         1
Trans Fat                            1
DFTA Literature Request              1
Highway Sign - Damaged               1
X-Ray Machine/Equipment              1
DHS Income Savings Requirement       1
Tunnel Condition                     1
Snow                                 1
Stalled Sites                        1
Open Flame Permit                    1
Municipal Parking Facility           1
DWD                                  1
Length: 165, dtype: int64

















In [6]:



    


# Or we can make a graph!
orig_data['Complaint Type'].value_counts()[:20].plot(kind='bar')



    


















    
Out[6]:








<matplotlib.axes.AxesSubplot at 0x5e4b250>

Exercise 1: Find out how many complaints there were in Manhattan

(hint: look at the Borough column)





In [26]:



    


# your code here! (hint: look at the Borough column)

Example 2: How many complaints are there in my zip code?





In [8]:



    


orig_data['Incident Zip'].value_counts()



    


















    
Out[8]:








11226    1563
10467    1304
10458    1177
11233    1070
11207     993
11221     969
10468     964
10457     928
10032     917
11212     896
11225     880
10453     852
11208     851
11238     851
11203     841
...
11797.0       1
10162         1
02061         1
10048.0       1
92123.0       1
000000        1
11501.0       1
07020         1
11530.0       1
11563.0       1
61702         1
11580.0       1
77092-2016    1
11788.0       1
0.0           1
Length: 433, dtype: int64

I can't see my zip code! We're going to have to do something else.





In [9]:



    


orig_data['Incident Zip'] == 11211



    


















    
Out[9]:








0     False
1     False
2     False
3     False
4     False
5     False
6     False
7     False
8     False
9     False
10    False
11    False
12    False
13    False
14    False
...
99985    False
99986    False
99987    False
99988    False
99989    False
99990    False
99991    False
99992    False
99993    False
99994    False
99995    False
99996    False
99997    False
99998    False
99999    False
Name: Incident Zip, Length: 100000, dtype: bool

















In [10]:



    


just_my_zip = orig_data[orig_data['Incident Zip'] == 11211]



    











In [11]:



    


just_my_zip[:5]



    


















    
Out[11]:










  
    

      
      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
    

  
  
    

      49205
       26523942
      2013-10-21 04:52:01
                          NaN
         DOT
                            Department of Transportation
       Highway Condition
        Loose Plate
                       Highway
       11211
                      NaN
                  NaN
                  NaN
                    NaN
       NaN
       NaN
           NaN
       BROOKLYN
       NaN
       N/A
           Open
       10/31/2013 04:52:01 AM
                          NaN
       01 BROOKLYN
       BROOKLYN
       997809
       200027
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
         N
      NaN
       NaN
       NaN
       NaN
       BQE/Gowanus Expwy
       East/Queens Bound
       Roadway
       Williamsburg Br / Metropolitan Ave (Exit 32) -...
       NaN
       NaN
       NaN
       40.715694
      -73.951089
        (40.71569425596994, -73.95108860038542)
    

    

      49345
       26525807
      2013-10-21 00:00:00
       10/24/2013 12:00:00 AM
         HPD
       Department of Housing Preservation and Develop...
                 HEATING
               HEAT
          RESIDENTIAL BUILDING
       11211
             340 BROADWAY
             BROADWAY
       SOUTH 9 STREET
            KEAP STREET
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
       N/A
         Closed
                          NaN
       10/24/2013 12:00:00 AM
       01 BROOKLYN
       BROOKLYN
       996403
       197151
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
       NaN
                     NaN
                     NaN
           NaN
                                                     NaN
       NaN
       NaN
       NaN
       40.707802
      -73.956166
       (40.707802364159264, -73.95616565678144)
    

    

      49519
       26524669
      2013-10-21 00:00:00
                          NaN
       DOHMH
                 Department of Health and Mental Hygiene
                  Rodent
       Rat Sighting
       3+ Family Apt. Building
       11211
       376 SOUTH 3 STREET
       SOUTH 3 STREET
        HOOPER STREET
           HEWES STREET
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
       N/A
       Assigned
       11/20/2013 01:17:46 PM
       10/21/2013 01:28:03 PM
       01 BROOKLYN
       BROOKLYN
       997505
       197490
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
         N
      NaN
       NaN
       NaN
       NaN
                     NaN
                     NaN
           NaN
                                                     NaN
       NaN
       NaN
       NaN
       40.708731
      -73.952190
        (40.70873125658687, -73.95219021471766)
    

    

      49549
       26523621
      2013-10-21 00:00:00
       10/23/2013 12:00:00 AM
         HPD
       Department of Housing Preservation and Develop...
                 HEATING
               HEAT
          RESIDENTIAL BUILDING
       11211
         654 GRAND STREET
         GRAND STREET
       LEONARD STREET
       MANHATTAN AVENUE
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
       N/A
         Closed
                          NaN
       10/23/2013 12:00:00 AM
       01 BROOKLYN
       BROOKLYN
       999154
       198468
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
       NaN
                     NaN
                     NaN
           NaN
                                                     NaN
       NaN
       NaN
       NaN
       40.711413
      -73.946240
       (40.711413010067396, -73.94624023257417)
    

    

      49595
       26521681
      2013-10-21 00:00:00
       10/23/2013 12:00:00 AM
         HPD
       Department of Housing Preservation and Develop...
         PAINT - PLASTER
              WALLS
          RESIDENTIAL BUILDING
       11211
         733 GRAND STREET
         GRAND STREET
        GRAHAM AVENUE
        HUMBOLDT STREET
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
       N/A
         Closed
                          NaN
       10/23/2013 12:00:00 AM
       01 BROOKLYN
       BROOKLYN
       999926
       198571
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
       NaN
                     NaN
                     NaN
           NaN
                                                     NaN
       NaN
       NaN
       NaN
       40.711694
      -73.943455
        (40.71169438639939, -73.94345533566411)
    

  




















In [12]:



    


len(just_my_zip)



    


















    
Out[12]:








126

So we have 126 complaints.

Exercise 2: Find out how many complaints there are in your zip code!

If that's too easy for you, try to find out if there are more complaints about rats or mice (check out the 'Complaint Type', and 'Descriptor' columns)





In [13]:



    


# your code here



    











In [13]:

Example 3: Which borough complains the most about rats?





In [14]:



    


rodent_complaints = orig_data[orig_data['Complaint Type'] == 'Rodent']



    











In [15]:



    


rodent_complaints[:5]



    


















    
Out[15]:










  
    

      
      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
    

  
  
    

      4  
       26590930
      2013-10-31 01:53:44
       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
       N/A
       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)
    

    

      14 
       26590917
      2013-10-31 01:19:54
       NaN
       DOHMH
       Department of Health and Mental Hygiene
       Rodent
                       Rat Sighting
       1-2 Family Mixed Use Building
       11219
                63 STREET
             63 STREET
            13 AVENUE
                              14 AVENUE
       NaN
       NaN
       BLOCKFACE
       BROOKLYN
       NaN
       N/A
       Pending
       11/30/2013 01:19:54 AM
       10/31/2013 01:29:26 AM
        10 BROOKLYN
        BROOKLYN
       984467
       167519
       Unspecified
        BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       N
      NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.626477
      -73.999218
        (40.6264774690411, -73.99921826202639)
    

    

      104
       26593903
      2013-10-30 23:30:37
       NaN
       DOHMH
       Department of Health and Mental Hygiene
       Rodent
                     Mouse Sighting
             3+ Family Apt. Building
       10065
       210 EAST 67 STREET
        EAST 67 STREET
             3 AVENUE
                               2 AVENUE
       NaN
       NaN
         ADDRESS
       NEW YORK
       NaN
       N/A
       Pending
       11/29/2013 11:30:37 PM
       10/30/2013 11:32:56 PM
       08 MANHATTAN
       MANHATTAN
       994655
       218478
       Unspecified
       MANHATTAN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       N
      NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.766342
      -73.962437
       (40.76634192531301, -73.96243748655138)
    

    

      113
       26592036
      2013-10-30 23:23:20
       NaN
       DOHMH
       Department of Health and Mental Hygiene
       Rodent
       Condition Attracting Rodents
       1-2 Family Mixed Use Building
       11249
          333 KENT AVENUE
           KENT AVENUE
       SOUTH 4 STREET
                         SOUTH 5 STREET
       NaN
       NaN
         ADDRESS
       BROOKLYN
       NaN
       N/A
       Pending
       11/29/2013 11:23:20 PM
       10/30/2013 11:25:36 PM
        01 BROOKLYN
        BROOKLYN
       993267
       199095
       Unspecified
        BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       N
      NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.713142
      -73.967474
       (40.71314193383838, -73.96747420978451)
    

    

      119
       26590227
      2013-10-30 23:18:31
       NaN
       DOHMH
       Department of Health and Mental Hygiene
       Rodent
       Condition Attracting Rodents
       1-2 Family Mixed Use Building
       11249
        20 SOUTH 4 STREET
        SOUTH 4 STREET
          KENT AVENUE
                           WYTHE AVENUE
       NaN
       NaN
         ADDRESS
       BROOKLYN
       NaN
       N/A
       Pending
       11/29/2013 11:18:31 PM
       10/30/2013 11:20:17 PM
        01 BROOKLYN
        BROOKLYN
       993350
       199125
       Unspecified
        BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       N
      NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.713224
      -73.967175
       (40.71322419170144, -73.96717477471884)
    

  




















In [16]:



    


rodent_complaints['Borough']



    


















    
Out[16]:








4      MANHATTAN
14      BROOKLYN
104    MANHATTAN
113     BROOKLYN
119     BROOKLYN
124     BROOKLYN
129     BROOKLYN
137        BRONX
209     BROOKLYN
255    MANHATTAN
279     BROOKLYN
316        BRONX
398    MANHATTAN
431        BRONX
448     BROOKLYN
...
98222       QUEENS
98245     BROOKLYN
98251     BROOKLYN
98279     BROOKLYN
98290        BRONX
98292        BRONX
98293        BRONX
98294        BRONX
98295    MANHATTAN
98298       QUEENS
98303     BROOKLYN
98329    MANHATTAN
98336        BRONX
98350     BROOKLYN
98351       QUEENS
Name: Borough, Length: 1483, dtype: object

















In [28]:



    


rodent_complaints['Borough'].value_counts()



    


















    
Out[28]:








BRONX            429
BROOKLYN         424
MANHATTAN        334
QUEENS           215
STATEN ISLAND     81
dtype: int64

















In [18]:



    


rodent_complaints['Borough'].value_counts().plot(kind='bar')



    


















    
Out[18]:








<matplotlib.axes.AxesSubplot at 0x536f5d0>

Example 4: What kinds of noise complaints do people have?





In [19]:



    


orig_data['Complaint Type'].str.contains("Noise")



    


















    
Out[19]:








0      True
1     False
2      True
3      True
4     False
5      True
6     False
7      True
8      True
9      True
10     True
11     True
12    False
13     True
14    False
...
99985    False
99986    False
99987    False
99988    False
99989    False
99990    False
99991    False
99992    False
99993    False
99994    False
99995    False
99996    False
99997    False
99998    False
99999    False
Name: Complaint Type, Length: 100000, dtype: bool

















In [20]:



    


noise_complaints = orig_data[orig_data['Complaint Type'].str.contains("Noise")]



    











In [21]:



    


noise_complaints['Complaint Type'].value_counts()



    


















    
Out[21]:








Noise                       2942
Noise - Commercial          2120
Noise - Street/Sidewalk     1512
Noise - Vehicle              619
Noise - Park                 137
Noise - Helicopter            96
Noise - House of Worship      48
Collection Truck Noise         7
dtype: int64

Example 4: What do people on my street complain about?





In [41]:



    


# Here's my street!
my_street = orig_data[orig_data['Street Name'].str.contains('SOUTH 4 STREET')]
my_street



    


















    
Out[41]:










  
    

      
      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
    

  
  
    

      119  
       26590227
      2013-10-30 23:18:31
                          NaN
       DOHMH
                 Department of Health and Mental Hygiene
                              Rodent
              Condition Attracting Rodents
       1-2 Family Mixed Use Building
       11249
        20 SOUTH 4 STREET
       SOUTH 4 STREET
           KENT AVENUE
          WYTHE AVENUE
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
        Pending
       11/29/2013 11:18:31 PM
       10/30/2013 11:20:17 PM
       01 BROOKLYN
       BROOKLYN
       993350
       199125
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
         N
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.713224
      -73.967175
        (40.71322419170144, -73.96717477471884)
    

    

      837  
       26594423
      2013-10-30 16:48:13
                          NaN
         DOT
                            Department of Transportation
                    Street Condition
                                   Pothole
                                 NaN
       11249
        20 SOUTH 4 STREET
       SOUTH 4 STREET
           KENT AVENUE
          WYTHE AVENUE
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
           Open
                          NaN
       10/30/2013 04:48:13 PM
       01 BROOKLYN
       BROOKLYN
       993350
       199125
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.713224
      -73.967175
        (40.71322419170144, -73.96717477471884)
    

    

      910  
       26589418
      2013-10-30 16:26:00
                          NaN
        DSNY
                                            A - Brooklyn
                    Dirty Conditions
                         E3 Dirty Sidewalk
                            Sidewalk
       11249
        20 SOUTH 4 STREET
       SOUTH 4 STREET
           KENT AVENUE
          WYTHE AVENUE
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
           Open
                          NaN
                          NaN
       01 BROOKLYN
       BROOKLYN
       993350
       199125
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.713224
      -73.967175
        (40.71322419170144, -73.96717477471884)
    

    

      924  
       26593972
      2013-10-30 16:22:00
                          NaN
        DSNY
                                    BCC - Brooklyn North
                Sanitation Condition
          15 Street Cond/Dump-Out/Drop-Off
                              Street
       11249
        20 SOUTH 4 STREET
       SOUTH 4 STREET
           KENT AVENUE
          WYTHE AVENUE
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
       DSNY Garage
           Open
                          NaN
                          NaN
       01 BROOKLYN
       BROOKLYN
       993350
       199125
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.713224
      -73.967175
        (40.71322419170144, -73.96717477471884)
    

    

      940  
       26593049
      2013-10-30 16:18:00
                          NaN
        DSNY
                                    BCC - Brooklyn North
                Sanitation Condition
          15 Street Cond/Dump-Out/Drop-Off
                              Street
       11249
        34 SOUTH 4 STREET
       SOUTH 4 STREET
           KENT AVENUE
          WYTHE AVENUE
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
       DSNY Garage
           Open
                          NaN
                          NaN
       01 BROOKLYN
       BROOKLYN
       993467
       199084
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.713112
      -73.966753
        (40.71311153537016, -73.96675279228094)
    

    

      5606 
       26585291
      2013-10-29 20:05:00
                          NaN
        DSNY
                                            A - Brooklyn
                    Dirty Conditions
                         E3 Dirty Sidewalk
                            Sidewalk
       11211
       369 SOUTH 4 STREET
       SOUTH 4 STREET
         HOOPER STREET
          HEWES STREET
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
           Open
                          NaN
                          NaN
       01 BROOKLYN
       BROOKLYN
       997299
       197317
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.708257
      -73.952934
        (40.70825671880703, -73.95293357631375)
    

    

      14945
       26575887
      2013-10-28 00:00:00
                          NaN
         HPD
       Department of Housing Preservation and Develop...
                            PLUMBING
                               WATER-LEAKS
                RESIDENTIAL BUILDING
       11211
       155 SOUTH 4 STREET
       SOUTH 4 STREET
        BEDFORD AVENUE
         DRIGGS AVENUE
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
           Open
                          NaN
       10/28/2013 12:00:00 AM
       01 BROOKLYN
       BROOKLYN
       994785
       198523
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.711570
      -73.961999
        (40.71157025286253, -73.96199943182411)
    

    

      16291
       26574375
      2013-10-28 00:00:00
                          NaN
         HPD
       Department of Housing Preservation and Develop...
                            PLUMBING
                               WATER-LEAKS
                RESIDENTIAL BUILDING
       11211
       155 SOUTH 4 STREET
       SOUTH 4 STREET
        BEDFORD AVENUE
         DRIGGS AVENUE
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
           Open
                          NaN
       10/28/2013 12:00:00 AM
       01 BROOKLYN
       BROOKLYN
       994785
       198523
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.711570
      -73.961999
        (40.71157025286253, -73.96199943182411)
    

    

      17440
       26570350
      2013-10-27 10:42:48
       10/28/2013 12:00:00 AM
         DOB
                                 Department of Buildings
       General Construction/Plumbing
       Site Conditions Endangering Workers
                                 NaN
       11211
       150 SOUTH 4 STREET
       SOUTH 4 STREET
        BEDFORD AVENUE
         DRIGGS AVENUE
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
         Closed
                          NaN
       10/28/2013 12:00:00 AM
       01 BROOKLYN
       BROOKLYN
       994766
       198525
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.711576
      -73.962068
        (40.71157576498943, -73.96206796317621)
    

    

      19798
       26568678
      2013-10-26 15:04:42
                          NaN
        DSNY
                                Department of Sanitation
                            Graffiti
                                  Graffiti
                           Mixed Use
       11211
       219 SOUTH 4 STREET
       SOUTH 4 STREET
       ROEBLING STREET
                  RAMP
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
           Open
                          NaN
       10/26/2013 03:04:42 PM
       01 BROOKLYN
       BROOKLYN
       995502
       198168
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.710595
      -73.959414
        (40.71059497953592, -73.95941375045541)
    

    

      21811
       26567092
      2013-10-26 00:00:00
                          NaN
         HPD
       Department of Housing Preservation and Develop...
                     PAINT - PLASTER
                                     WALLS
                RESIDENTIAL BUILDING
       11211
       155 SOUTH 4 STREET
       SOUTH 4 STREET
        BEDFORD AVENUE
         DRIGGS AVENUE
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
           Open
                          NaN
       10/26/2013 12:00:00 AM
       01 BROOKLYN
       BROOKLYN
       994785
       198523
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.711570
      -73.961999
        (40.71157025286253, -73.96199943182411)
    

    

      26423
       26560051
      2013-10-25 00:00:00
                          NaN
         HPD
       Department of Housing Preservation and Develop...
                             HEATING
                                      HEAT
                RESIDENTIAL BUILDING
       11211
       382 SOUTH 4 STREET
       SOUTH 4 STREET
         HOOPER STREET
          HEWES STREET
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
           Open
                          NaN
       10/25/2013 12:00:00 AM
       01 BROOKLYN
       BROOKLYN
       997396
       197264
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.708111
      -73.952584
       (40.708111102782304, -73.95258381066652)
    

    

      26843
       26561371
      2013-10-25 00:00:00
                          NaN
         HPD
       Department of Housing Preservation and Develop...
                            PLUMBING
                               WATER-LEAKS
                RESIDENTIAL BUILDING
       11211
       155 SOUTH 4 STREET
       SOUTH 4 STREET
        BEDFORD AVENUE
         DRIGGS AVENUE
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
           Open
                          NaN
       10/25/2013 12:00:00 AM
       01 BROOKLYN
       BROOKLYN
       994785
       198523
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.711570
      -73.961999
        (40.71157025286253, -73.96199943182411)
    

    

      27697
       26562312
      2013-10-25 00:00:00
                          NaN
         HPD
       Department of Housing Preservation and Develop...
                            PLUMBING
                               WATER-LEAKS
                RESIDENTIAL BUILDING
       11211
       155 SOUTH 4 STREET
       SOUTH 4 STREET
        BEDFORD AVENUE
         DRIGGS AVENUE
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
           Open
                          NaN
       10/25/2013 12:00:00 AM
       01 BROOKLYN
       BROOKLYN
       994785
       198523
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.711570
      -73.961999
        (40.71157025286253, -73.96199943182411)
    

    

      38742
       26535512
      2013-10-23 00:00:00
                          NaN
         HPD
       Department of Housing Preservation and Develop...
                             HEATING
                                      HEAT
                RESIDENTIAL BUILDING
       11211
       365 SOUTH 4 STREET
       SOUTH 4 STREET
           KEAP STREET
         HOOPER STREET
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
           Open
                          NaN
       10/23/2013 12:00:00 AM
       01 BROOKLYN
       BROOKLYN
       997159
       197384
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.708441
      -73.953438
        (40.70844082328705, -73.95343841360993)
    

    

      40019
       26546011
      2013-10-23 00:00:00
                          NaN
         HPD
       Department of Housing Preservation and Develop...
                             HEATING
                                      HEAT
                RESIDENTIAL BUILDING
       11211
       365 SOUTH 4 STREET
       SOUTH 4 STREET
           KEAP STREET
         HOOPER STREET
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
           Open
                          NaN
       10/23/2013 12:00:00 AM
       01 BROOKLYN
       BROOKLYN
       997159
       197384
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.708441
      -73.953438
        (40.70844082328705, -73.95343841360993)
    

    

      40352
       26542847
      2013-10-23 00:00:00
                          NaN
         HPD
       Department of Housing Preservation and Develop...
                             HEATING
                                      HEAT
                RESIDENTIAL BUILDING
       11211
       365 SOUTH 4 STREET
       SOUTH 4 STREET
           KEAP STREET
         HOOPER STREET
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
           Open
                          NaN
       10/23/2013 12:00:00 AM
       01 BROOKLYN
       BROOKLYN
       997159
       197384
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.708441
      -73.953438
        (40.70844082328705, -73.95343841360993)
    

    

      40586
       26540859
      2013-10-23 00:00:00
                          NaN
         HPD
       Department of Housing Preservation and Develop...
                             HEATING
                                      HEAT
                RESIDENTIAL BUILDING
       11211
       365 SOUTH 4 STREET
       SOUTH 4 STREET
           KEAP STREET
         HOOPER STREET
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
           Open
                          NaN
       10/23/2013 12:00:00 AM
       01 BROOKLYN
       BROOKLYN
       997159
       197384
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.708441
      -73.953438
        (40.70844082328705, -73.95343841360993)
    

    

      43344
       26532299
      2013-10-22 11:48:10
                          NaN
         DCA
                          Department of Consumer Affairs
                  Consumer Complaint
               Non-Delivery Goods/Services
                                 NaN
       11211
       263 SOUTH 4 STREET
       SOUTH 4 STREET
                  BEND
          MARCY AVENUE
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
           Open
       10/26/2013 11:48:10 AM
                          NaN
       01 BROOKLYN
       BROOKLYN
       996030
       197928
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
         N
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.709936
      -73.957510
       (40.709935549347286, -73.95750966126214)
    

    

      55318
       26517078
      2013-10-19 00:00:00
       10/22/2013 01:18:14 PM
       DOHMH
                 Department of Health and Mental Hygiene
                              Rodent
                          Signs of Rodents
        3+ Family Mixed Use Building
       11211
       400 SOUTH 4 STREET
       SOUTH 4 STREET
         HOOPER STREET
          HEWES STREET
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
         Closed
       11/18/2013 09:37:24 PM
       10/22/2013 01:18:14 PM
       01 BROOKLYN
       BROOKLYN
       997570
       197180
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
         N
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.707880
      -73.951956
          (40.7078802824555, -73.9519563779262)
    

    

      56738
       26512694
      2013-10-18 16:35:07
       10/18/2013 06:10:57 PM
        NYPD
                         New York City Police Department
                             Vending
                                Unlicensed
                     Street/Sidewalk
       11211
       146 SOUTH 4 STREET
       SOUTH 4 STREET
        BEDFORD AVENUE
         DRIGGS AVENUE
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
          Precinct
         Closed
       10/19/2013 12:35:07 AM
       10/18/2013 06:10:57 PM
       01 BROOKLYN
       BROOKLYN
       994734
       198541
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
         N
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.711620
      -73.962183
        (40.71161971915637, -73.96218336475637)
    

    

      65416
       26496031
      2013-10-16 17:02:21
                          NaN
         TLC
                           Taxi and Limousine Commission
                      Taxi Complaint
                          Driver Complaint
                                 NaN
       11249
        74 SOUTH 4 STREET
       SOUTH 4 STREET
          WYTHE AVENUE
          BERRY STREET
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
       Assigned
       12/01/2013 08:39:55 AM
       10/17/2013 08:40:44 AM
       01 BROOKLYN
       BROOKLYN
       993918
       198917
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
         N
      NaN
       NaN
       NaN
                       Other
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.712653
      -73.965126
        (40.71265267886822, -73.96512620242689)
    

    

      66193
       26499942
      2013-10-16 14:05:34
       10/21/2013 03:05:35 PM
         DOT
                            Department of Transportation
                  Sidewalk Condition
                    Blocked - Construction
                            Sidewalk
       11211
       134 SOUTH 4 STREET
       SOUTH 4 STREET
        BEDFORD AVENUE
         DRIGGS AVENUE
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
         Closed
       10/26/2013 02:05:34 PM
       10/21/2013 03:05:36 PM
       01 BROOKLYN
       BROOKLYN
       994635
       198588
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
         N
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.711749
      -73.962540
        (40.71174883972136, -73.96254039321501)
    

    

      68413
       26496259
      2013-10-16 00:00:00
       10/20/2013 12:00:00 AM
         HPD
       Department of Housing Preservation and Develop...
                             HEATING
                                      HEAT
                RESIDENTIAL BUILDING
       11211
       365 SOUTH 4 STREET
       SOUTH 4 STREET
           KEAP STREET
         HOOPER STREET
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
         Closed
                          NaN
       10/20/2013 12:00:00 AM
       01 BROOKLYN
       BROOKLYN
       997159
       197384
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.708441
      -73.953438
        (40.70844082328705, -73.95343841360993)
    

    

      69321
       26498155
      2013-10-16 00:00:00
       10/20/2013 12:00:00 AM
         HPD
       Department of Housing Preservation and Develop...
                             HEATING
                                      HEAT
                RESIDENTIAL BUILDING
       11211
       201 SOUTH 4 STREET
       SOUTH 4 STREET
         SOUTH 5 PLACE
       ROEBLING STREET
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
         Closed
                          NaN
       10/20/2013 12:00:00 AM
       01 BROOKLYN
       BROOKLYN
       995295
       198272
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.710881
      -73.960160
        (40.71088069563202, -73.96016023399284)
    

    

      70127
       26491816
      2013-10-15 17:52:16
                          NaN
         TLC
                           Taxi and Limousine Commission
                      Taxi Complaint
                          Driver Complaint
                                 NaN
       11249
        74 SOUTH 4 STREET
       SOUTH 4 STREET
          WYTHE AVENUE
          BERRY STREET
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
       Assigned
       11/30/2013 01:20:33 PM
       10/16/2013 01:21:44 PM
       01 BROOKLYN
       BROOKLYN
       993918
       198917
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
         N
      NaN
       NaN
       NaN
       New York-Penn Station
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.712653
      -73.965126
        (40.71265267886822, -73.96512620242689)
    

    

      72355
       26490943
      2013-10-15 03:20:00
                          NaN
        DSNY
       A - Illegal Posting Staten Island, Queens and ...
                    Dirty Conditions
                     E15 Illegal Postering
                            Sidewalk
       11211
       370 SOUTH 4 STREET
       SOUTH 4 STREET
         HOOPER STREET
          HEWES STREET
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
           Open
                          NaN
                          NaN
       01 BROOKLYN
       BROOKLYN
       997280
       197319
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.708262
      -73.953002
        (40.70826223633335, -73.95300210350923)
    

    

      72642
       26491231
      2013-10-15 00:00:00
       10/17/2013 12:00:00 AM
         HPD
       Department of Housing Preservation and Develop...
                GENERAL CONSTRUCTION
                                  CABINETS
                RESIDENTIAL BUILDING
       11211
       322 SOUTH 4 STREET
       SOUTH 4 STREET
         RODNEY STREET
           KEAP STREET
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
         Closed
                          NaN
       10/17/2013 12:00:00 AM
       01 BROOKLYN
       BROOKLYN
       996667
       197614
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.709073
      -73.955213
        (40.70907282287113, -73.95521258829159)
    

    

      72805
       26489522
      2013-10-15 00:00:00
       10/17/2013 12:00:00 AM
         HPD
       Department of Housing Preservation and Develop...
                GENERAL CONSTRUCTION
                                   WINDOWS
                RESIDENTIAL BUILDING
       11211
       322 SOUTH 4 STREET
       SOUTH 4 STREET
         RODNEY STREET
           KEAP STREET
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
         Closed
                          NaN
       10/17/2013 12:00:00 AM
       01 BROOKLYN
       BROOKLYN
       996667
       197614
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.709073
      -73.955213
        (40.70907282287113, -73.95521258829159)
    

    

      73479
       26491349
      2013-10-15 00:00:00
       10/17/2013 12:00:00 AM
         HPD
       Department of Housing Preservation and Develop...
                GENERAL CONSTRUCTION
                                    STAIRS
                RESIDENTIAL BUILDING
       11211
       322 SOUTH 4 STREET
       SOUTH 4 STREET
         RODNEY STREET
           KEAP STREET
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
         Closed
                          NaN
       10/17/2013 12:00:00 AM
       01 BROOKLYN
       BROOKLYN
       996667
       197614
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.709073
      -73.955213
        (40.70907282287113, -73.95521258829159)
    

    

      73482
       26491280
      2013-10-15 00:00:00
       10/17/2013 12:00:00 AM
         HPD
       Department of Housing Preservation and Develop...
                GENERAL CONSTRUCTION
                                  CABINETS
                RESIDENTIAL BUILDING
       11211
       322 SOUTH 4 STREET
       SOUTH 4 STREET
         RODNEY STREET
           KEAP STREET
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
         Closed
                          NaN
       10/17/2013 12:00:00 AM
       01 BROOKLYN
       BROOKLYN
       996667
       197614
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.709073
      -73.955213
        (40.70907282287113, -73.95521258829159)
    

    

      73585
       26486733
      2013-10-15 00:00:00
       10/15/2013 12:00:00 AM
         HPD
       Department of Housing Preservation and Develop...
                             HEATING
                                      HEAT
                RESIDENTIAL BUILDING
       11211
       201 SOUTH 4 STREET
       SOUTH 4 STREET
         SOUTH 5 PLACE
       ROEBLING STREET
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
         Closed
                          NaN
       10/15/2013 12:00:00 AM
       01 BROOKLYN
       BROOKLYN
       995295
       198272
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.710881
      -73.960160
        (40.71088069563202, -73.96016023399284)
    

    

      73798
       26490449
      2013-10-15 00:00:00
       10/15/2013 12:00:00 AM
         HPD
       Department of Housing Preservation and Develop...
                             HEATING
                                      HEAT
                RESIDENTIAL BUILDING
       11211
       365 SOUTH 4 STREET
       SOUTH 4 STREET
           KEAP STREET
         HOOPER STREET
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
         Closed
                          NaN
       10/15/2013 12:00:00 AM
       01 BROOKLYN
       BROOKLYN
       997159
       197384
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.708441
      -73.953438
        (40.70844082328705, -73.95343841360993)
    

    

      76757
       26481927
      2013-10-14 00:00:00
       10/15/2013 12:00:00 AM
         HPD
       Department of Housing Preservation and Develop...
                             HEATING
                                      HEAT
                RESIDENTIAL BUILDING
       11211
       201 SOUTH 4 STREET
       SOUTH 4 STREET
         SOUTH 5 PLACE
       ROEBLING STREET
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
         Closed
                          NaN
       10/15/2013 12:00:00 AM
       01 BROOKLYN
       BROOKLYN
       995295
       198272
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.710881
      -73.960160
        (40.71088069563202, -73.96016023399284)
    

    

      78217
       26477216
      2013-10-13 10:09:00
       10/15/2013 12:00:00 PM
        DSNY
                                    BCC - Brooklyn North
                Sanitation Condition
          15 Street Cond/Dump-Out/Drop-Off
                              Street
       11211
       371 SOUTH 4 STREET
       SOUTH 4 STREET
         HOOPER STREET
          HEWES STREET
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
       DSNY Garage
        Pending
                          NaN
       10/15/2013 12:00:00 PM
       01 BROOKLYN
       BROOKLYN
       997315
       197309
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.708235
      -73.952876
         (40.70823473709217, -73.9528758814656)
    

    

      79373
       26486584
      2013-10-12 17:00:21
       10/16/2013 07:28:23 AM
         DOT
                            Department of Transportation
                    Street Condition
                   Plate Condition - Noisy
                              Street
       11211
       141 SOUTH 4 STREET
       SOUTH 4 STREET
        BEDFORD AVENUE
         DRIGGS AVENUE
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
         Closed
       10/22/2013 05:00:21 PM
       10/16/2013 07:28:23 AM
       01 BROOKLYN
       BROOKLYN
       994671
       198578
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
         N
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.711721
      -73.962411
        (40.71172134977408, -73.96241055354882)
    

    

      79966
       26483834
      2013-10-12 00:00:00
       10/15/2013 12:00:00 AM
         HPD
       Department of Housing Preservation and Develop...
                             HEATING
                                      HEAT
                RESIDENTIAL BUILDING
       11211
       365 SOUTH 4 STREET
       SOUTH 4 STREET
           KEAP STREET
         HOOPER STREET
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
         Closed
                          NaN
       10/15/2013 12:00:00 AM
       01 BROOKLYN
       BROOKLYN
       997159
       197384
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.708441
      -73.953438
        (40.70844082328705, -73.95343841360993)
    

    

      81302
       26474354
      2013-10-11 13:50:20
                          NaN
        DSNY
                                Department of Sanitation
                            Graffiti
                                  Graffiti
                           Comercial
       11249
        50 SOUTH 4 STREET
       SOUTH 4 STREET
           KENT AVENUE
          WYTHE AVENUE
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
           Open
                          NaN
       10/15/2013 01:42:13 PM
       01 BROOKLYN
       BROOKLYN
       993600
       199037
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       NaN
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.712982
      -73.966273
        (40.71298239202725, -73.96627310512139)
    

    

      98033
       26455763
      2013-10-08 00:00:00
                          NaN
       DOHMH
                 Department of Health and Mental Hygiene
                              Rodent
                              Rat Sighting
             3+ Family Apt. Building
       11211
       364 SOUTH 4 STREET
       SOUTH 4 STREET
           KEAP STREET
         HOOPER STREET
       NaN
       NaN
       ADDRESS
       BROOKLYN
       NaN
               N/A
       Assigned
       11/07/2013 04:15:10 PM
       10/08/2013 04:17:49 PM
       01 BROOKLYN
       BROOKLYN
       997122
       197395
       Unspecified
       BROOKLYN
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
       Unspecified
         N
      NaN
       NaN
       NaN
                         NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       NaN
       40.708471
      -73.953572
       (40.708471069583375, -73.95357184818346)
    

  




















In [45]:



    


my_street['Complaint Type'].value_counts()



    


















    
Out[45]:








HEATING                          11
PLUMBING                          4
GENERAL CONSTRUCTION              4
Sanitation Condition              3
Dirty Conditions                  3
Rodent                            3
Graffiti                          2
Street Condition                  2
Taxi Complaint                    2
Sidewalk Condition                1
PAINT - PLASTER                   1
General Construction/Plumbing     1
Consumer Complaint                1
Vending                           1
dtype: int64

Exercise 3: Find out what people complain about on your street





In [43]:



    


# You know the drill. If this is too easy, try to find how many streets there are with 'South' in them.



    











In [ ]:

Content source: jvns/talks

Similar notebooks:

notebook.community | gallery | about