• 01-4167615
  • 9851224985, 9851161198
  • info@iitnepal.edu.np
Follow us on:

Blog Details

  • Home
  • Our Blog
  • Data Analytics Customer Service Requests Analysis
Data Analytics Customer Service Requests Analysis

Background of Problem Statement 

NYC 311’s mission is to provide the public with quick and easy access to all New York City government services and information while offering the best customer service. Each day, NYC311 receives thousands of requests related to several hundred types of non-emergency services, including noise complaints, plumbing issues, and illegally parked cars. These requests are received by NYC311 and forwarded to the relevant agencies such as the police, buildings, or transportation. The agency responds to the request, addresses it, and then closes it.

Problem Objective :

Perform a service request data analysis of New York City 311 calls. You will focus on the data wrangling techniques to understand the pattern in the data and also visualize the major complaint types.

Analysis Tasks to be performed:

(Perform a service request data analysis of New York City 311 calls)

  1. Read or convert the columns ‘Created Date’ and Closed Date’ to DateTime data type and create a new column ‘Request_Closing_Time’ as the time elapsed between request creation and request closing. (Hint: Explore the package/module DateTime)
  2. Provide major insights/patterns that you can offer in a visual format (graphs or tables); at least 4 major conclusions that you can come up with after generic data mining.
  3. Order the complaint types based on the average ‘Request_Closing_Time’, grouping them for different locations.
  4. Perform a statistical test for the following:

Please note: For the below statements you need to state the Null and Alternate and then provide a statistical test to accept or reject the Null Hypothesis along with the corresponding ‘p-value’.

  • Whether the average response time across complaint types is similar or not (overall)
  • Are the type of complaint or service requested and location-related?

 

To get the Dataset please click here 

Need help to perform the analysis here you can get the solution.

Click here for the solution

 

Comment Section

Our Partners

Industry Partner

Our Industry Partners who helps our students for Internship and Job Placement.

Offshore Softtech
iFart Technology
Alpha Teds
Angel Sansar
Suga Inc
CygnusTech
Our Clientele

Clients