separate: Separate a character column into multiple columns

In tidytable: Tidy Interface to 'data.table'

Separate a character column into multiple columns

Description

Superseded

separate() has been superseded by separate_wider_delim().

Separates a single column into multiple columns using a user supplied separator or regex.

If a separator is not supplied one will be automatically detected.

Note: Using automatic detection or regex will be slower than simple separators such as "," or ".".

Usage

separate(
  .df,
  col,
  into,
  sep = "[^[:alnum:]]+",
  remove = TRUE,
  convert = FALSE,
  ...
)

Arguments

.df	A data frame
col	The column to split into multiple columns
into	New column names to split into. A character vector. Use NA to omit the variable in the output.
sep	Separator to split on. Can be specified or detected automatically
remove	If TRUE, remove the input column from the output data.table
convert	TRUE calls type.convert() with as.is = TRUE on new columns
...	Arguments passed on to methods

Examples

df <- data.table(x = c("a", "a.b", "a.b", NA))

# "sep" can be automatically detected (slower)
df %>%
  separate(x, into = c("c1", "c2"))

# Faster if "sep" is provided
df %>%
  separate(x, into = c("c1", "c2"), sep = ".")

tidytable documentation built on Sept. 11, 2024, 8:05 p.m.