Remove Rows/Columns with Empty String

Removes rows/columns that contain empty strings.

Usage

remove_empty(x, ...)

# S4 method for ANY
remove_empty(x, margin = 1, all = FALSE, verbose = getOption("arkhe.verbose"))

Arguments

x

An R object (should be a matrix or a data.frame).

...

Currently not used.

margin

A length-one numeric vector giving the subscripts which the function will be applied over (1 indicates rows, 2 indicates columns).

all

A logical scalar. If TRUE, only the rows/columns whose values all meet the condition defined by f are considered. If FALSE (the default), only rows/columns where at least one value validates the condition defined by f are considered.

verbose

A logical scalar: should R report extra information on progress?

See also

Other data cleaning tools: clean_whitespace(), remove_Inf(), remove_NA(), remove_constant(), remove_zero(), replace_Inf(), replace_NA(), replace_empty(), replace_zero()

Author

N. Frerebeau

Examples

## Create a data matrix
X <- matrix(sample(LETTERS, 25, TRUE), nrow = 5, ncol = 5)

## Add empty string
k <- sample(1:25, 3, FALSE)
X[k] <- ""
X
#>      [,1] [,2] [,3] [,4] [,5]
#> [1,] "G"  "B"  "B"  ""   "C" 
#> [2,] "B"  "C"  "B"  "S"  "O" 
#> [3,] "P"  "O"  "U"  "L"  "I" 
#> [4,] "S"  "N"  ""   "Y"  "E" 
#> [5,] "M"  "S"  ""   "W"  "E" 

## Remove rows with empty strings
remove_empty(X, margin = 1)
#>      [,1] [,2] [,3] [,4] [,5]
#> [1,] "B"  "C"  "B"  "S"  "O" 
#> [2,] "P"  "O"  "U"  "L"  "I" 

## Replace empty strings
replace_empty(X, value = "XXX")
#>      [,1] [,2] [,3]  [,4]  [,5]
#> [1,] "G"  "B"  "B"   "XXX" "C" 
#> [2,] "B"  "C"  "B"   "S"   "O" 
#> [3,] "P"  "O"  "U"   "L"   "I" 
#> [4,] "S"  "N"  "XXX" "Y"   "E" 
#> [5,] "M"  "S"  "XXX" "W"   "E"