Customer-Service-Requests-Analysis.---Project

DESCRIPTION

You've been asked to perform data analysis of service request (311) calls from New York City. You've also been asked to utilize data wrangling techniques to understand the pattern in the data and visualize the major types of complaints.

Note: Download 311-service-requests-nyc.zip file using the link given in the Customer Service Requests Analysis project problem statement and extract the 311_Service_Requests_from_2010_to_Present.csv file

Perform the following steps:

1. Understand the dataset:

2. Identify the shape of the dataset

3. Identify variables with null values

4. Perform basic data exploratory analysis:

5. Utilize missing value treatment

6. Analyze the date column and remove the entries if it has an incorrect timeline 1. Draw a frequency plot for city-wise complaints 2. Draw scatter and hexbin plots for complaint concentration across Brooklyn

7. Find major types of complaints:

8. Plot a bar graph of count vs. complaint types

9. Find the top 10 types of complaints

10. Display the types of complaints in each city in a separate dataset

11. Visualize the major types of complaints in each city

12. Check if the average response time across various types of complaints

13. Identify significant variables by performing a statistical analysis using p-values and chi-square values (Optional)