Language: python

Jupyter Notebook

1. There are six boroughs in New York. What are the top 5 most common complaints, by borough? Include results for the 'Unspecified' category.

2. How long are complaints open, on average? What is the standard deviation of complaint time?

Required:

For part 1, include a bar chart illustrating your results.

Hints:

You may find the .unique() method helpful

It's more efficient to write a function for part 1

Created Date	Agency	Complaint Type	City	Borough	Closed Date
06/28/2015 2:12:50 AM	NYPD	Noise - Commercial	NEW YORK	MANHATTAN	06/28/2015 2:39:38 AM
06/28/2015 2:12:32 AM	NYPD	Blocked Driveway	FLUSHING	QUEENS	06/28/2015 3:13:41 AM
06/28/2015 2:11:48 AM	TLC	Taxi Complaint	BROOKLYN	BROOKLYN
06/28/2015 2:11:47 AM	NYPD	Noise - Commercial	BROOKLYN	BROOKLYN
06/28/2015 2:09:50 AM	HRA	Benefit Card Replacement		Unspecified	06/28/2015 2:10:07 AM
06/28/2015 2:08:24 AM	NYPD	Blocked Driveway	BROOKLYN	BROOKLYN	06/28/2015 2:43:01 AM
06/28/2015 2:04:13 AM	TLC	Taxi Compliment		Unspecified
06/28/2015 2:03:03 AM	NYPD	Noise - Street/Sidewalk	NEW YORK	MANHATTAN
06/28/2015 1:59:26 AM	HRA	Benefit Card Replacement		Unspecified	06/28/2015 1:59:58 AM
06/28/2015 1:59:05 AM	NYPD	Noise - Commercial	BROOKLYN	BROOKLYN
06/28/2015 1:57:34 AM	NYPD	Noise - Commercial	BROOKLYN	BROOKLYN
06/28/2015 1:54:50 AM	TLC	Taxi Complaint	HOBOKEN	Unspecified
06/28/2015 1:54:47 AM	DOHMH	Rodent	BROOKLYN	BROOKLYN
06/28/2015 1:54:22 AM	NYPD	Noise - Commercial	ASTORIA	QUEENS
06/28/2015 1:53:52 AM	DOHMH	Rodent	BROOKLYN	BROOKLYN
06/28/2015 1:51:54 AM	NYPD	Blocked Driveway	BROOKLYN	BROOKLYN	06/28/2015 3:22:35 AM
06/28/2015 1:45:12 AM	NYPD	Noise - Commercial	NEW YORK	MANHATTAN	06/28/2015 1:56:14 AM
06/28/2015 1:44:59 AM	NYPD	Blocked Driveway	BRONX	BRONX	06/28/2015 2:29:48 AM
06/28/2015 1:08:04 AM	NYPD	Illegal Parking	STATEN ISLAND	STATEN ISLAND
06/28/2015 12:52:33 AM	NYPD	Blocked Driveway	STATEN ISLAND	STATEN ISLAND