Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Clean the data set using Rstudio.

1 answer below »
Clean the data set using Rstudio.
Answered 1 days After Oct 10, 2022

Solution

Mukesh answered on Oct 11 2022
46 Votes
R- Data Cleaning
Question
Data before cleaning
After data Cleaning
Drop the Row with maximum missing values as per variable importance
R Code

install.packages("UpSetR")
install.packages("naniar")
li
ary(ggplot2)
li
ary(naniar)
li
ary(UpSetR)
li
ary(readxl)
li
ary(dplyr)
DATA <- read_excel("C:/Users/vishw/OneDrive/Desktop/Project/DATA.xlsx")
View(DATA)
head(DATA)
str(DATA)
summary(DATA)
vis_miss(DATA,warn_large_data = FALSE)
colSums(is.na(DATA))
DATA <- DATA %>% mutate(Gender = as.factor(Gender),
MPC= as.factor(MPC),
Grade= as.factor(Grade),
HOR_state= as.factor(HOR_state),
ETS_MRDDATE= as.Date(ETS_MRDDATE),
PEBD_dt = as.Date(PEBD_dt),
Race= as.factor(Race),
Age_Grouping= as.factor(Age_Grouping),
PMOS= as.factor(PMOS),
Branch= as.factor(Branch),
RCC= as.factor(RCC),
MVNAR= as.factor(MVNAR),
Non_Part= as.factor(Non_Part),
Non_part_months=...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here