mutate_all_na_character: Normalize Character Column Values to 'NA_character_"

In patelm9/rubix: rubix Package

Description

Normalize Character Column Values to 'NA_character_“

Usage

mutate_all_na_character(data, blank = TRUE, empty = TRUE, na_str = TRUE)

Arguments

data	A dataframe or tibble.
blank	Should strings consisting with one or more spaces be replaced with NA_character_?
empty	Should strings with a length of 0 be replaced with NA_character_?
na_str	Should "NA" be replaced with NA_character_?

See Also

mutate_all,vars,reexports

Examples

library(tidyverse)
test_data <- 
        tibble(A = sample(c(NA_integer_, 1:3), size = 10, replace = TRUE),
               B = sample(c(NA_integer_, 4:6), size = 10, replace = TRUE),
               C = sample(c(NA_integer_, 7:9), size = 10, replace = TRUE),
               D = sample(c(NA_integer_, 10:12), size = 10, replace = TRUE),
               E = sample(c(NA_integer_, 13:15), size = 10, replace = TRUE),
               )

# Only operates on character columns
mutate_all_na_character(data = test_data)


test_data <- 
        tibble(A = sample(c(NA_character_, "NA", " ", "   ", "", 1:3), size = 10, replace = TRUE),
               B = sample(c(NA_character_, "NA", " ", "   ", "", 4:6), size = 10, replace = TRUE),
               C = sample(c(NA_character_, "NA", " ", "   ", "", 7:9), size = 10, replace = TRUE)
        )

# Results with all input character columns
mutate_all_na_character(data = test_data)

mutate_all_na_character(data = test_data,
                        blank = FALSE)

mutate_all_na_character(data = test_data,
                        blank = FALSE,
                        empty = FALSE)

mutate_all_na_character(data = test_data,
                        na_str = FALSE)

patelm9/rubix documentation built on Sept. 3, 2021, 10:22 p.m.