separate: Separate a character column into two columns using a regular...

In tidyft: Fast and Memory Efficient Data Operations in Tidy Syntax

Separate a character column into two columns using a regular expression separator

Description

Given either regular expression, separate() turns a single character column into two columns. Analogous to tidyr::separate, but only split into two columns only.

Usage

separate(.data, separated_colname, into, sep = "[^[:alnum:]]+", remove = TRUE)

Arguments

.data	A data frame.
separated_colname	Column name, string only.
into	Character vector of length 2.
sep	Separator between columns.
remove	If TRUE, remove input column from output data frame.

Value

A data.table

See Also

separate, unite_dt

Examples

df <- data.table(x = c(NA, "a.b", "a.d", "b.c"))
df %>% separate(x, c("A", "B"))
# equals to
df <- data.table(x = c(NA, "a.b", "a.d", "b.c"))
df %>% separate("x", c("A", "B"))

tidyft documentation built on Jan. 9, 2023, 1:27 a.m.