The assignment should be done in Jupyter Notebook. The questions and guidance are below.Module 8-assignement-data.csv (link to the dataset in sendspace here: https://www.sendspace.com/file/z58l5b) is...

The assignment should be done in Jupyter Notebook. The questions and guidance are below.Module 8-assignement-data.csv (link to the dataset in sendspace here: https://www.sendspace.com/file/z58l5b) is a subset of a larger dataset: 311NYC data. This dataset includes service requests received by NYC311 during the second half of 2012. Hurricane Sandy impacted New York City on 29 Oct. 2012.
In this assignment, I want you to:
-Import this dataset to Python Jupyter Notebook, import it as data_311.- After importing the dataset as data_311, change ‘created time’ column type to datetime type using this code:data_311['created_date']= pd.to_datetime(data_311['created_date'])-Provide your answers to the following questions:-Did the total number of service requests after the hurricane increase significantly, compared to before the hurricane? To compare, consider total number of service requests during one month before the hurricane (i.e. from 2012-09-28 to 2012-10-29) and one month after the hurricane (i.e. from 2012-10-29 to 2012-11-29).To find the number of calls during one month after the hurricane, slice the dataset:after_data = data_311[(data_311['created_date']>='2012-10-29') & (data_311['created_date']Also calculate before_data with changing the dates. Then, calculate difference between size of after and before.-What were the highest complaint types during one month after the hurricane? PLOT the top 10 complaint types on a BAR CHART. Use GROUPBY to find the number of complaints:n_complaint_type = after_data.groupby('complaint_type').size()- Which agencies received the highest service requests after the hurricane (again consider a one-month timeframe)? PLOT top 10 agencies on a bar chart.** Provide your answers (including numbers and PLOTS) in a word document. You should also upload your Python code in JUPYTER NOTEBOOK.
Type your codes in a Jupyter Notebook file and your answers in a word documents named as follows: HW8YourFirstNameYourLastNameSubmit the 2 files.
Oct 17, 2021
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here