7318AFE Business Data Analytics - 24-Hour Assignment Questions

Get Expert's Help on Assessment Writing

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).

Our Academic Assistance: service is all about doing research and being good at it. The more research one will do, the better the paper will turn out.

Expert's Answer

Your future, our responsibilty submit your task on time.

Order Now

 

Need Urgent Academic Assistance?

Get Professional Help at Low Prices!

*
*
*


*

 

 

Plagiarism Checker

Submit your documents and get Plagiarism report
Check Plagiarism

Chat with our Experts

Want to contact us directly? No Problem. We are always here for you

TOP
Order Notification

[variable_1] from [variable_2] has just ordered [variable_3] Assignment [amount] minutes ago.