Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Concepts

Authors: David Kroenke

4th Edition

0136086535, 9780136086536

More Books

Students also viewed these Databases questions