Project Information

The downloadable data files contain information about hospitalisation and Intensive Care Unit (ICU) admission rates and current occupancy for COVID-19 by date and country. Each row contains the corresponding data for a certain date (day or week) and per country.

Installation

Install the libraries from CRAN as follows

install.packages('tidyverse')
install.packages('readxl')
install.packages('ggplot2')
install.packages('readr')

OR with devtools package as follows from github

devtools::install_github("tidyverse/tidyverse")

Data Providers

• Downloadable data from

European Centre for Disease Prevention and Control

Project Phases

Project Phases

1. Data Collection

   • Data have been downloaded from European Centre for Disease Prevention and Control

2. Data Cleaning

   • This process includes all the necessary edits in order to make the data tidy and in format that can be worked in order to produce insights, such as

   i) Coverting dates 
   ii) Changing format of some variables
   iii) Deleting columns
   iv) Detecting outliers and NA values 

3. Exploratory Data Analysis

   • In this stage of the project we produce insights and key visualization that will help ups understand the data and spot trends among them. For this reason we rely on

   barplots
   histograms 
   boxplots
   

Code Samples

• Importing the dataset

df <- read_excel("TestingForCovid.xlsx")

• Changing format in some variables

df$year <- as.numeric(df$year)
df$new_cases <- as.numeric(df$new_cases)

• Extracting the final dataset into excel

write.xlsx(df, file = 'TestCovid.xlsx')

Project Goal

The goal of this project aims to analyze certain information about hospitalization, ICU(Intensive Care Units) and current occupancy of COVID-19.

Visuals

Raw Data

Dataframe after cleaning

Problems Faced

• Analzying this dataset i came across with varius problems such as:

  1. The column names must be replaced
  2. Columns with no use on dataset must be excluded from the dataframe
  3. The year_week variable is not following the 3rd normality form 
  4. The week variable must be inserted in a new column
  5. Scientific notation 

Visualizations

Tableau Public,

Microsoft Excel

Languages

R Programming language

Integrated Development Environment

RStudio