Question: For this assignment you are going to work with the Covid-19 data stored on owid-covid-data csv file. This dataset contains up to date detailed information

For this assignment you are going to work with the Covid-19 data stored on owid-covid-data csv file. This dataset contains up to date detailed information of coronavirus data across the globe. As you explore the dataset, answer the following questions using Pandas

Q1.a: How many total cases globally were there since the first case?

Q1.b: What was the total number of deaths, globally, so far?

Q1.c: How many total tests, globally, were conducted so far?

Q1.d: How many total vaccinations has been administered, globally, so far?

Question 2 Which country has the greatest number of total cases? Which one has the lowest one? Do the same for total deaths, total cases per million and total deaths per million?

Question 3 For each date calculate, total cases, new cases, total deaths, new deaths, total tests and new tests, globally.

Question 4 Create a variable that holds total cases per million for each country on April 19, 2020. What was the mean total cases per million on that date? How many countries had more than 1000 total cases per million on that date? (Note that not all countries have information for this variable, so think carefully how to treat those countries).

Question 5 Choose three countries. For each country, find the deadliest date (measured by highest number of new deaths). Find the date with the highest new cases. By how many days those two dates are apart from each other?

For this assignment you are going to work with the Covid-19 data

2/25/2020 iso_code AFG AFG 4 JAFG 5 AFG 6 AFG 7 AFG 8 AFG 9 AFG 10 AFG 2/28/2020 0.026 11 AFG 0.429 0.051 0.429 1.143 12 AFG 13 AFG 14 AFG 15 AFG 16 AFG AFG 18 AFG 19 AFG 20 AFG 21 AFG 22 AFG 23 AFG - 24 JAFG 25 JAFG 26 JAFG 27 AFG 0.051 B continent location Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan owid-covid-data D F M N date 0 total_cases new_cases new_cases_smoothed total_deaths new_deaths new_deaths_smoothed total_cases_per_million new_cases_per_million new_cases_smoothed_per_million total_deaths_per_million new_deaths_per_million new_deaths_smoothed_per_million reproduction_rate icu_ Q 2/24/2020 1 1 0.026 0.026 1 0 0.026 2/26/2020 1 0 0.026 2/27/2020 1 0 0.026 1 0 0.026 0 2/29/2020 1 0 0.143 0 0.026 0 0.004 3/1/2020 1 0.143 0 0 0.026 3/2/2020 0 0.004 1 0 0 0 0 0.026 0 3/3/2020 0 2 1 1 0.143 0 0 0.051 0.004 3/4/2020 4 4 2 2 0 o 0.103 3/5/2020 4 0 0.011 0 0.103 3/6/2020 O 0.011 4 0 0.429 0 0 0.103 0 0.011 3/7/2020 4 0 0.429 0 0 0.103 0 0.011 3/8/2020 5 0.571 0 0 0.128 0.026 3/9/2020 0.015 7 0.857 0 0 0.18 0.051 0.022 3/10/2020 8 1 0.857 0 0 0.206 0.026 3/11/2020 0.022 11 3 1 0 0 0.283 0.077 3/12/2020 0.026 12 1 0 0 0.308 0.026 0.029 3/13/2020 13 1 1.286 0 0 0.334 0.026 3/14/2020 0.033 15 2 1.571 0 0 9 3/15/2020 0.385 16 1 0.04 1.571 0 0.411 0.026 3/16/2020 0.04 18 2 0 1.571 0.462 0.051 3/17/2020 0.04 20 2 0 1.714 O 0.514 0.051 3/18/2020 24 4 0.044 1.857 0 0 0.617 0.103 3/19/2020 25 0.048 1 1.857 0 0 0.642 0.026 0.048 3/20/2020 29 4 2.286 0 0 0.745 0.103 0.059 3/21/2020 30 1 2.143 0 0 0.771 0.026 3/22/2020 0.055 34 4 2.571 1 1 0 0.873 0.103 0.066 3/23/2020 41 7 0.026 0.026 3.286 0.004 1 0 0.143 1.053 0.18 3/24/2020 0.084 43 0.026 0 3.286 1 0 0.004 0.143 1.105 0.051 3/25/2020 0.084 0.026 76 33 7.429 0 2 1 0.004 0.286 1.952 0.848 0.191 3/26/2020 0.051 80 4 0.026 7.857 3 1 0.429 0.007 2.055 0.103 3/27/2020 0.202 91 0.077 0.026 11 8.857 3 0.011 0 0.429 2.338 3/28/2020 0.283 0.228 107 0.077 16 11 1 0 0.011 0.571 2.749 0.411 0.283 3/29/2020 0.103 118 0.026 12 4 0 0.015 0.429 3.031 0.308 146 28 15 0.103 4 0 0.429 0 0.011 3.75 0.719 1.44 0.385 3/31/2020 175 29 0.103 18.857 0 4 0.429 4.495 0.011 1.45 0.745 4/1/2020 0.484 197 22 17.286 0.103 0 0.011 4 0 0.286 5.061 1.46 0.565 4/2/2020 0.444 240 0.103 0 43 22.857 0.007 4 0 0.143 6.165 1.105 1.46 4/3/2020 0.587 0.103 275 35 26.286 0 0.004 8 4 0.714 7.064 1.46 0.899 0.675 4/4/2020 0.206 300 0.103 25 27.571 0.018 10 1.45 2 0.857 7.706 4/5/2020 0.642 338 0.708 0.257 38 0.051 12 2 1.143 0.022 8.683 0.976 1.43 4/6/2020 368 0.807 30 0.051 15 2 3 1.43 9.453 4/7/2020 0.815 424 56 35.571 16 1 0.04 10.892 1.42 4/8/2020 445 0.914 21 0.411 0.026 35.429 0 16 0.044 1.714 11.431 1.41 4/9/2020 485 0.91 0 40 35 17 1 1.857 0.044 1.39 12.459 1.028 4/10/2020 532 0.899 47 0.437 0.026 36.714 18 1 0.048 1.39 1.429 13.666 1.207 4/11/2020 556 24 0.943 0.462 0.026 36.571 18 0 0.037 1.143 14.283 1.39 0.617 4/12/2020 0.939 0.462 608 52 38.571 0 19 1 0.029 1.38 1 15.618 1.336 0.991 4/13/2020 666 0.488 58 0.026 42.571 0.026 22 3 1 17.108 1.39 1.49 1.094 0.565 0.077 0.026 1.4 28 AFG 0.143 29 AFG 30 AFG 31 AFG 32 AFG 33 AFG 34 AFG 35 AFG 36 AFG 0.283 3/30/2020 37 AFG 38 AFG 39 AFG 40 AFG 41 AFG AFG 43 AFG 31.429 0.308 0.029 44 AFG 31.714 257 0.771 0.385 0.077 1.714 1.439 0.539 0.411 45 AFG 46 AFG - 47 AFG 48 IAFG 49 AFG 50 AFG 51 AFG 2/25/2020 iso_code AFG AFG 4 JAFG 5 AFG 6 AFG 7 AFG 8 AFG 9 AFG 10 AFG 2/28/2020 0.026 11 AFG 0.429 0.051 0.429 1.143 12 AFG 13 AFG 14 AFG 15 AFG 16 AFG AFG 18 AFG 19 AFG 20 AFG 21 AFG 22 AFG 23 AFG - 24 JAFG 25 JAFG 26 JAFG 27 AFG 0.051 B continent location Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan Asia Afghanistan owid-covid-data D F M N date 0 total_cases new_cases new_cases_smoothed total_deaths new_deaths new_deaths_smoothed total_cases_per_million new_cases_per_million new_cases_smoothed_per_million total_deaths_per_million new_deaths_per_million new_deaths_smoothed_per_million reproduction_rate icu_ Q 2/24/2020 1 1 0.026 0.026 1 0 0.026 2/26/2020 1 0 0.026 2/27/2020 1 0 0.026 1 0 0.026 0 2/29/2020 1 0 0.143 0 0.026 0 0.004 3/1/2020 1 0.143 0 0 0.026 3/2/2020 0 0.004 1 0 0 0 0 0.026 0 3/3/2020 0 2 1 1 0.143 0 0 0.051 0.004 3/4/2020 4 4 2 2 0 o 0.103 3/5/2020 4 0 0.011 0 0.103 3/6/2020 O 0.011 4 0 0.429 0 0 0.103 0 0.011 3/7/2020 4 0 0.429 0 0 0.103 0 0.011 3/8/2020 5 0.571 0 0 0.128 0.026 3/9/2020 0.015 7 0.857 0 0 0.18 0.051 0.022 3/10/2020 8 1 0.857 0 0 0.206 0.026 3/11/2020 0.022 11 3 1 0 0 0.283 0.077 3/12/2020 0.026 12 1 0 0 0.308 0.026 0.029 3/13/2020 13 1 1.286 0 0 0.334 0.026 3/14/2020 0.033 15 2 1.571 0 0 9 3/15/2020 0.385 16 1 0.04 1.571 0 0.411 0.026 3/16/2020 0.04 18 2 0 1.571 0.462 0.051 3/17/2020 0.04 20 2 0 1.714 O 0.514 0.051 3/18/2020 24 4 0.044 1.857 0 0 0.617 0.103 3/19/2020 25 0.048 1 1.857 0 0 0.642 0.026 0.048 3/20/2020 29 4 2.286 0 0 0.745 0.103 0.059 3/21/2020 30 1 2.143 0 0 0.771 0.026 3/22/2020 0.055 34 4 2.571 1 1 0 0.873 0.103 0.066 3/23/2020 41 7 0.026 0.026 3.286 0.004 1 0 0.143 1.053 0.18 3/24/2020 0.084 43 0.026 0 3.286 1 0 0.004 0.143 1.105 0.051 3/25/2020 0.084 0.026 76 33 7.429 0 2 1 0.004 0.286 1.952 0.848 0.191 3/26/2020 0.051 80 4 0.026 7.857 3 1 0.429 0.007 2.055 0.103 3/27/2020 0.202 91 0.077 0.026 11 8.857 3 0.011 0 0.429 2.338 3/28/2020 0.283 0.228 107 0.077 16 11 1 0 0.011 0.571 2.749 0.411 0.283 3/29/2020 0.103 118 0.026 12 4 0 0.015 0.429 3.031 0.308 146 28 15 0.103 4 0 0.429 0 0.011 3.75 0.719 1.44 0.385 3/31/2020 175 29 0.103 18.857 0 4 0.429 4.495 0.011 1.45 0.745 4/1/2020 0.484 197 22 17.286 0.103 0 0.011 4 0 0.286 5.061 1.46 0.565 4/2/2020 0.444 240 0.103 0 43 22.857 0.007 4 0 0.143 6.165 1.105 1.46 4/3/2020 0.587 0.103 275 35 26.286 0 0.004 8 4 0.714 7.064 1.46 0.899 0.675 4/4/2020 0.206 300 0.103 25 27.571 0.018 10 1.45 2 0.857 7.706 4/5/2020 0.642 338 0.708 0.257 38 0.051 12 2 1.143 0.022 8.683 0.976 1.43 4/6/2020 368 0.807 30 0.051 15 2 3 1.43 9.453 4/7/2020 0.815 424 56 35.571 16 1 0.04 10.892 1.42 4/8/2020 445 0.914 21 0.411 0.026 35.429 0 16 0.044 1.714 11.431 1.41 4/9/2020 485 0.91 0 40 35 17 1 1.857 0.044 1.39 12.459 1.028 4/10/2020 532 0.899 47 0.437 0.026 36.714 18 1 0.048 1.39 1.429 13.666 1.207 4/11/2020 556 24 0.943 0.462 0.026 36.571 18 0 0.037 1.143 14.283 1.39 0.617 4/12/2020 0.939 0.462 608 52 38.571 0 19 1 0.029 1.38 1 15.618 1.336 0.991 4/13/2020 666 0.488 58 0.026 42.571 0.026 22 3 1 17.108 1.39 1.49 1.094 0.565 0.077 0.026 1.4 28 AFG 0.143 29 AFG 30 AFG 31 AFG 32 AFG 33 AFG 34 AFG 35 AFG 36 AFG 0.283 3/30/2020 37 AFG 38 AFG 39 AFG 40 AFG 41 AFG AFG 43 AFG 31.429 0.308 0.029 44 AFG 31.714 257 0.771 0.385 0.077 1.714 1.439 0.539 0.411 45 AFG 46 AFG - 47 AFG 48 IAFG 49 AFG 50 AFG 51 AFG

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

CHAPTER 12 Privacy \"If everybody minded their own business,\" the Dutchman said in a hoarse growl, \"the world would go round a deal faster than it does.\" Lewis Carroll, Alice's Adventures in...

think about what procedural changes would have the biggest positive impact, without being excessively costly for our lab members at every level (including undergrads!). Reference: the Lab Data Check...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

i am suck on part 2, plwase give me a hand I updated a clear image below,thanks i replace a clear figure on the bottom of the three unclear figure TRAIN CovDvaithale) con cord theme of the - mata...

For the below project, please write an executive summary covering the points below. 1. Project Description: Our group project will focus on visualizing the impact of COVID-19 on the US Stock Market....

The code should be in c language only. Header file: #include #include #include typedef struct microtweet{ int id; //unique integer value char user[51]; // the userid / username of the person who...

The resulting bar chart shows that when HMK is the AR Clerk and FKL is the Cash Receipts Clerk, CT is the GL Accounting Clerk for $226,851 of current AR balances. However, there are $25,352 of...

A plank with a box on it at one end is gradually raised about the other end. As the angle of inclination with the horizontal reaches 30 the box starts to slip and slides 4.0 m down the plank in 4.0s....

The first 10 elements of the periodic table and some of their properties can be found in Table 2 These elements can be combined to create molecules. For example, two hydrogen atoms (2H) can be added...

Under capital market theory, the best explanation for why investors eliminate nonsystematic risk is that the price of nonsystematic risk is: ? ( i ) | % | Search

CT Corp Comprehensive Question Canadian Tire Corporation, Limited ( Canadian Tire ) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Technology. The owner of your company recently purchased two pairs of season tickets for the local symphony orchestra concerts. He will retain one pair of tickets but make the other available to...

On July 1, you relocated your business from one Detroit suburb to another. A month prior to your move, you phoned your security system provider and notified its representative to cancel your service...

Technology. Brenda Durwood, one of your employees and president of the Woodland Ski and Snowboard Club,has requested permission to hold the clubs annual Gear Swap fund-raiser in the company parking...