NYC_311-data

Introduction:

What is 311? 311 is a non-emergency service line that helps provide the public with quick, easy access to all New York City government services,allows the public to report problems to government agencies and request information. The data being requested was from Open data NYC. The dataset has 28 million rows, the information is automatically updated daily. I’m focusing on the years 2019 to 2021,I will be exploring what trends come up. The goal of this project is to analyze what issues are New Yorkers and inform the public about 311 for those who don’t know.

In my analysis, I wanted to answer following questions:

1. What are the most frequent 311 complaints in NYC?
2. What are the least frequent 311 complaints in NYC?
3. Which Agency responds to the most requests?
4. What month & year has the most service requests ?
5. The agencies which are more efficient in solving Service requests?

I only focused on certain columns:

• Created_Date: Date SR was created
• Agency: Acronym of responding City Government Agency
• Complaint Type: This is the first level of a hierarchy identifying the topic of the incident or condition.
• Status: Status of SR submitted
• Borough: Provided by the submitter and confirmed by geovalidation