Answered step by step
Verified Expert Solution
Question
1 Approved Answer
he tasks for this lab are to read in some data on COVID-19 statistics in Maine from the Maine CDC. omplete this assignment in a
he tasks for this lab are to read in some data on COVID-19 statistics in Maine from the Maine CDC. omplete this assignment in a jupyter notebook and submit the jupyter notebook in Brightspace. Provide comments for your code either in line or as text descriptions in a markdown ell. our code should do the following: - Create lists for each variable in the dataset (10 pts) - You will notice that some of these variables make for natural combinations, and as such, write for loops that will calculate these relevant measures into lists ( 35 pts): - Final-First should be a good estimate (though not perfect) of JNJ vaccines administered - Additional/Final should be a good estimate for average number of booster doses given to a person - Final/Census should be a good estimate of the vaccination percentage in a county - Hospital/Cases should be a good estimate for hospitalization rate in a county - Death/Hospitals should be a good estimate for relative severity in a county - JNJ/ Census should be a good estimate for the JNJ prevalence in the population - (Final-JNJ)/JNJ should be a good estimate for the odds that someone who is vaccinated received a bivalent vaccine - Using the county list and your measures lists, create dictionaries for each measure. (10 pts) - Using the county list and your dictionaries, create sets of counties that fit these criteria individually using list comprehension (20 points) - Boosters per full vaccination exceeds 1.1 - Relative severity exceeds 50% - Vaccination rate is less than 75% - Hospitalization rate exceeds JNJ vaccination rate - Bivalent vaccination odds less than 20:1 - Using those sets, answer the following questions (note that some of these may produce empty sets): (20 points) - Find all counties whose boosters per full vaccination exceeds 1.1 and overall vaccination rate is less than 75% - Find all counties where the hospitalization rate exceeds JNJ vaccination rate or the bivalent vaccination odds are less than 20:1 - Find all counties where the relative severity exceeds 50%, but the vaccination rate is higher than 75% - Find all counties where the boosters per full vaccination exceeds 1.1, vaccination rate exceeds 75%, and the bivalent vaccination odds are greater than 20;1 - Create a dictionary of tuples that represents each county's data ( 5 points)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started