05/08/2021

Data Set Overview

The data used for this presentation can be freely obtained from Covid19 GitHub page https://github.com/owid/covid-19-data/tree/master/public/data)
The full explanation of the data can be found on the same webpage.

The used database is SCV file, that has been downloaded, and the data was modified as follows:


- Selected columns: location, date, total cases, total deaths, fully vaccinated, population; the column date been dropped later. - Selected rows: the most recent date, only completed cases. - Added values: vaccination ratio; death ratio; total number of cases ratio; all of the above with respect to the country population.

The R code below shows how the data been downloaded

# Download temp file to obtain data and then unlink
temp <- tempfile()
download.file(
      "https://covid.ourworldindata.org/data/owid-covid-data.csv", temp)
data<-read.csv(temp)
unlink(temp)

The R code below shows how the data been manipulated

#Data preparation
mydata<-data[,c(3,4,5,8,37,45)]
mydata<-subset(mydata, mydata$date==max(mydata$date))
mydata<- mydata[,c(-2)]
mydata<-mydata[complete.cases(mydata),]
mydata$vac_ratio<-round(mydata$people_fully_vaccinated/mydata$population,2)
mydata$death_ratio<-round(mydata$total_deaths/mydata$population,2)
mydata$cases_ratio<-round(mydata$total_cases/mydata$population,2)
colnames(mydata)[colnames(mydata) == "people_fully_vaccinated"] <- "f_vacc"

The top 5 lines of the dataset

       location total_cases total_deaths    f_vacc population vac_ratio
1067     Africa     6855440       173931  24887269 1340598113      0.02
4414  Argentina     4975616       106747   7689258   45195777      0.17
5626       Asia    63063520       916770 523766380 4639847425      0.11
6183  Australia       35391          932   4139162   25499881      0.16
6710    Austria      660854        10744   4722383    9006400      0.52
7232 Azerbaijan      346878         5039   2173808   10139175      0.21
     death_ratio cases_ratio
1067           0        0.01
4414           0        0.11
5626           0        0.01
6183           0        0.00
6710           0        0.07
7232           0        0.03

Death rate with respect to the population

The highest rate of the death cases with respect to the population.

## [1] 0.00310879

As it is less than 1% it will be dropped from the graphical presentation.

Plot 1 (PlotLy)

Total Cases Rates per Country

Plot 2 (Plotly)

Box plot