Boise Idaho and Sacramento SPYDER Python Coding Project

I uploaded for you the assignment and the excel file in the Zip. Document. So, please follow the instructions and make sure there is no plagiarism. Also, please I want you to use the website that called SPYDER.

Let me know if you have any questions.

The CDC publishes data on influenza deaths in the United States. The data on weekly influenza deaths
from 2016 for 122 different cities (https://catalog.data.gov/dataset/table-iii-deaths-in-122-u-s-cities)
has been posted to Brightspace/D2L for you to use for this assignment.
You have been hired by one of those 122 cities (e.g., the one closest to your hometown) to create a plot
showing the number of deaths each week of 2016 flu season. Because the data set contains information
on 122 different cities, it may be a challenge to plot the data for a single city. If you use Pandas to
import the data, then selecting the data for a single city is as simple as:
data[data.Area == “Sacramento, CA”]
and storing the result in a new variable with just the Sacramento, CA data. If you do not use Pandas,
you will probably need to use Excel to sort the data and delete the data for all cities except the one you
choose, and then import the data into Python.
For reference, the plot for Spokane, WA (closest to my hometown) is show below. After generating the
plot, you should also calculate the average number of deaths per week from influenza in the selected
city. Write a memo to the city that includes your plot, average deaths per week, a description of your
approach, and your code in the appendix.
Spokane, WA, 2016
100-
Influenza Deaths
80 –
60
0
10
1
20
Week
30
40