MATH118-Homework 1 Solved

Problem 1                                                                                                                                                         

Homework 1 considers a Covid-19 dataset which is published on Github. Please download any document type that you prefer of the dataset from the links which are shown in Figure 1. The dataset is updated daily and

 

Figure 1: The complete dataset links

includes data on confirmed cases, deaths, hospitalizations, testing, and vaccinations as well as other variables of potential interest. The data set has the following basic columns:

•   iso code: Short name of the country

•   continent: The continent where the country exists

•   location: The country name

•   date: The date when the data about various variables are taken.

You are responsible to implement a program which reads the given dataset from the file and computes the data for the following questions. Any programming language that you prefer will be accepted. Putting comments on your functions that you implement is must. Each question must be appended to a file which is called ”output{.csv, .txt}”. The file contains the first 18 questions listed below. The 18th question will be written in this document.

1.      How many countries the dataset has?

2.      When is the earliest date data are taken for a country? Which country is it?

3. How many cases are confirmed for each country so far? Print pairwise results of country and total cases. 4. How many deaths are confirmed for each country so far? Print pairwise results of country and total deaths. 5. What are the average, minimum, maximum and variation values of the reproduction rates for each country? Table 1: The format of the output for the questions 5, 6, 7, 8, 9, 10, 12, 13.

Country
minimum
maximum
average
variation
value
value
value
value
value
6.        What are the average, minimum, maximum and variation values of the icu patients (intensive care unit patients) for each country?

7.        What are the average, minimum, maximum and variation values of the hosp patients (hospital patients) for each country?

8.        What are the average, minimum, maximum and variation values of the weekly icu (intensive care unit) admissions for each country?

9.        What are the average, minimum, maximum and variation values of the weekly hospital admissions for each country?

10.     What are the average, minimum, maximum and variation values of new tests per day for each country?

11.     How many tests are conducted in total for each country so far?

12.     What are the average, minimum, maximum and variation values of the positive rates of the tests for each country?

13.     What are the average, minimum, maximum and variation values of the tests per case for each country?

14.     How many people are vaccinated by at least one dose in each country?

15.     How many people are vaccinated fully in each country?

16.     How many vaccinations are administered in each country so far?

17.     List information about population, median age, # of people aged 65 older, # of people aged 70 older, economic performance, death rates due to heart disease, diabetes prevalence, # of female smokers, # of male smokers, handwashing facilities, hospital beds per thousand people, life expectancy and human development index.

Table 2: The format of the output for the question 17

Country
population
median age
# of people aged 65 older
value
value
value
value
18.     Summarize all the results that you obtain by the first 17 questions (except question 2).

Table 3: The format of the output for the question 18

Country
q#3
q#4
q#5 min
q#5 max
q#5 avg
q#5 var
value
value
value
value
value
value
value
19.     Comment the results based on your observations. Write your opinions about the reasons of increasing infection rates by giving examples from the results. Feel free to explain any situation that you observe.

More observations more opportunities will bring you for the second homework.

(Solution) (Write your observations here.)