Data Analysis work required for Coronavirus statistics in RStudio

1. Create a directory “Covid19Data” in your PC and set the working directory in R to this directory
using setwd().

2. Save all data files “covid_19_india.csv”, “covid_vaccine_statewise.csv” and
“StatewiseTestingDetails.csv”, which are provided as part of this assessment into the
“Covid19Data” directory. Run the command library(tidyverse) in R before moving to (3).

3. Read the data files “covid_19_india.csv”, “covid_vaccine_statewise.csv” and
“StatewiseTestingDetails.csv” into three tibbles (a modern take on data frames) in R using
read_csv() function. Name the tibbles (tibble variables) as follows: indiaCovid, indiaCovidVaccine
and indiaCovidTesting.

4. Now, calculate the total number of confirmed cases (people affected by the novel coronavirus),
tests (Total Samples collected) and vaccinations (First Dose Administered) conducted in India
from these datasets. Some of the columns in these tibbles have running total values state-wise.

5. Now, create a data frame with the total number of confirmed cases (people affected by the
novel coronavirus), tests (Total Samples collected) and vaccinations (First Dose Administered)
conducted in India as follows:
indiaCovidData<-data.frame(
category=c("Confirmed", "Tested", "Vaccinated"),
count=c(totalIndiaConfirmed, totalIndiaTested, totalIndiaVaccinated))

6. Plot the data stored in the “indiaCovidData” as follows: ggplot(indiaCovidData, aes(category,
count, colour=category)) + geom_col(). [Note: Make sure you run library(ggplot2) command
before ggpolt()].

I have three separate excel sheets containing the data which I want to analyse.