Assignment 3. Working with Data Frame. Base R Style

Note: This assignment practices working with Data Frame using Base R.

How to do it?:

• Open the Rmarkdown file of this assignment (link) in Rstudio.

• Right under each question, insert a code chunk (you can use the hotkey Ctrl + Alt + I to add a code chunk) and code the solution for the question.

• Knit the rmarkdown file (hotkey: Ctrl + Alt + K) to export an html.

• Publish the html file to your Githiub Page.

Submission: Submit the link on Github of the assignment to Canvas under Assignment 3.

---

Problems

1. Create the following data frame

Rank	Age	Name
0	28	Tom
1	34	Jack
2	29	Steve
3	42	Ricky

2. Use read.csv to import the Covid19 Vaccination data from WHO: link.

3. Show the names of the variables in the data

4. How many columns and rows the data have?

5. How many missing values are there? Show the missing values by columns. What variable has the most number of missing values?

6. What is the class of the date column. Change the date columns to date type using the as.Date function. Show the new class of the date column.

7. Capitalize the names of all the variables

8. Find the average number of cases per day. Find the maximum cases a day.

9. How many states are there in the data?

10. Create a new variable weekdays to store the weekday for each rows.

11. Create the categorical variable death2 variable taking the values as follows

• has_death if there is a death that day
• no_death if there is no death that day

Find the frequency and relative frequency of no_death and has_death.

11. Find the first quartile (Q1), second quartile (Q2) and and third quartile (Q3) of the variable death. (Hint: Use the summary function)

12. Create the categorical variable death3 variable taking the values as follows

• low_death if the number of deaths smaller than the 25 percentile (Q1)

• mid_death if the number of deaths from Q1 to Q3

• high_death if the number of deaths greater than Q3

13. Find the average cases in Rhode Island in 2021

14. Find the median cases by weekdays in Rhode Island in 2021

15. Compare the median cases in Rhode Island in June, July, August and September in 2021.

16. Find your own dataset, import it and implement the following functions on the data

• head
• str
• names
• mean, min, max
• table
• is.na
• colSums
• class
• cor
• by
• ifelse
• case_when

17. In the dataset in #16, practice the follows. You can reuse the code of 16.

• Create a categorical variable from a continuous variable
• From one categorical variable, create a new categorical variable with fewer categories

If you do not have a data, you can use the titanic dataset, which can be downloaded at this link