DataExplorer (version 0.4.0)

SetNaTo: Set all missing values to indicated value

Description

Quickly set all missing values to indicated value.

Usage

SetNaTo(data, value)

Arguments

data

input data, in data.table format only.

value

a single value or a list of two values to be set to. See 'Details'.

Details

This function will only work with data.table object as input. Consider setting your input to data.table first then assign the original class back after applying the function.

The class of value will determine what type of columns to be set, e.g., if value is 0, then missing values for continuous features will be set. When supplying a list of two values, only one numeric and one non-numeric is allowed.

Examples

# NOT RUN {
# Load packages
library(data.table)

# Generate missing values in iris data
dt <- data.table(iris)
for (j in 1:4) set(dt, i = sample.int(150, j * 30), j, value = NA_integer_)
set(dt, i = sample.int(150, 25), 5L, value = NA_character_)

# Set all missing values to 0L and unknown
dt2 <- copy(dt)
SetNaTo(dt2, list(0L, "unknown"))

# Set missing numerical values to 0L
dt3 <- copy(dt)
SetNaTo(dt3, 0L)

# Set missing discrete values to unknown
dt4 <- copy(dt)
SetNaTo(dt4, "unknown")
# }