7318AFE Business Data Analytics - 24-Hour Assignment Questions

Question 2 (10 marks)

Load Covid19 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. Obtain data till the end of September (2020-09-30). (Alternatively, use covid0930.csv.) Note that the three numerical variables (Deaths, Confirms, and Recovered) in the dataset are accumulated figures (i.e. 'total' numbers up to date).

1. Find countries with total (accumulated) deaths over 15000 and obtain the first date for each of these countries when it happened. Find the dates that the total covid death number globally surpass 500000 and 1000000, respectively.
2. Compute the global 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 4%.
3. Find countries with at least one day having more than 20000 new confirmed cases. How many countries have never experienced over 100 daily new confirmed cases?
4. Find 'increased deaths' globally during each of the following months: March, April, May, June, July, August, and September (i.e. new deaths in each month) and make a bar plot to present these 7 monthly death figures. Comment on the plot.
5. Make 3 line plots (in one graph) of daily new confirmed cases in Australia: original, 7- day rolling (moving average), and 14-day rolling. Comment on the plot and identify the peak date of each series (line).