Handling the Missing values

Handling the missing values into Data.csv

  • Write following lines of code in R Script to handle missing values.
  • What we are doing here
    • Just placing an average of other observation into missing values.
  • Here in Age & Salary column, we contain null value so we want to fill it with an average of other observation.
#handling missing values
dataset$Age = ifelse(
  is.na(dataset$Age),
  ave(dataset$Age,FUN = function(x) mean (x,na.rm=TRUE)),
  dataset$Age
)
dataset$Salary = ifelse(
  is.na(dataset$Salary),
  ave(dataset$Salary,FUN = function(x) mean (x,na.rm=TRUE)),
  dataset$Salary
)

  • ifelse argument
    1. is.na(dataset$Age) gives a TRUE/FALSE value.
    2. the value if  1st argument returns TRUE, ave is used to perform average.
    3. the value if 1st argument return FALSE,dataset$Age
  • After writing this line of code in R Script 
  • Press alt+enter
  • See dataset data from Global Environment. 

Comments

Post a Comment

Popular posts from this blog

Download DataSet

Download DataSet Download Folder Hierarchy:  click here. This Folder Hierarchy is used in all projects. Extract Folder Hierarchy into any folder of your computer. Download Dataset of Section:2: Data preprocessing  click here Extract Dataset Zip & move it to the folder Hierarchy according to its appropriate location. Now, we are completed to download the dataset. Our Dataset contains Data.csv file. Information about the company's customer. It has 4 column Country (IV) Age (IV) Salary (IV) Purchase (DV) 10 Observation (10 row) There are two types of Variable Dependent Variable (DV) Independent Variable (Features) (IV)
Read more

Categorical Data

Categorical Data Here in Data.csv, two column  are Categorical Data Country (France / Spain /Germany) Purchased (YES/NO) So we want to make categorical data. #categorical data dataset$Country = factor ( dataset$Country,                            levels = c('France','Spain','Germany'),                            labels = c(1,2,3)) dataset$Purchased =factor( dataset$Purchased ,                            levels =c('Yes','No'),                            labels = c(1,0)) Just add this line of code and run it, observe dataset variable. It assigns country column 1,2,3 to France, Spain, Germany. purchased column 1,0 to  Yes, No.
Read more