To perform data analysis of service request (311) calls from New York City.You have also been asked to utilize data wrangling techniques to understand the pattern in the data and visualize the major types of complaints
-
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