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.govidataset/table-iii-deaths-in-122-u-s-cities) has been posted to Brightspace/D21 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 the 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 shown 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.