Python Data - Assignment 1 Questions

Question 3 (6 marks)

Load the data from the following link

https://raw.githubusercontent.com/datasets/covid-19/master/data/countries-aggregated.csv

and use the data to answer this question. Note that data from this link have been applied in Part 1, Topic 3. Use data up to the end of July (2020-07-31).

1. Find countries with deaths exceeding 10000. Get the first date for each of countries with more than 500000 confirmed cases.
2. Compute the overall daily death rate (i.e. "Deaths" divided "Confirmed" across all countries in each day) and plot it in a line chart. Identify the period that the overall daily death rate is higher than 5%.
3. Make two rolling (moving-average) line plots over 7 days of new confirmed cases of Australia and Japan, respectively. Note: “new cases” is defined as the difference of confirmed cases over two consecutive days. Comment on the results.
4. Find countries in the world with at least one day having more than 10000 new cases.