1. Clean the excel data set using Rstudio.-Utilize the forcats package for reducing categories-Utilize the mice package for imputingThe HOR_state and UnitST columns of States needs to be reduced to 4...

-
-
-
2022-11-11
Importing the dataset
library(readxl)
data <- read_excel("data.xlsx", col_types = c("text",
"text", "text", "text", "date", "date",
"numeric", "numeric", "text", "text",
"numeric", "text", "text", "text", "text",
"text", "text", "numeric", "numeric",
"text", "text", "text", "text", "date",
"text", "text", "text", "text", "text",
"numeric", "text", "text", "text", "text"))
First look of the Data
skimr::skim(data)
Data summary
    Name
    data
    Number of rows
    176485
    Number of columns
    34
    _______________________
    
    Column type frequency:
    
    character
    25
    numeric
    6
    POSIXct
    3
    ________________________
    
    Group variables
    None
Variable type:...