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:
Understand the dataset:
Identify the shape of the dataset
Identify variables with null values
-
Perform basic data exploratory analysis:
Utilize missing value treatment Analyze the date column and remove the entries if it has an incorrect timeline Draw a frequency plot for city-wise complaints Draw scatter and hexbin plots for complaint concentration across Brooklyn
-
Find major types of complaints:
Plot a bar graph of count vs. complaint types Find the top 10 types of complaints Display the types of complaints in each city in a separate dataset
-
Visualize the major types of complaints in each city
-
Check if the average response time across various types of complaints
-
Identify significant variables by performing a statistical analysis using p-values and chi-square values (Optional)