separate_rows: Separate a collapsed column into multiple rows

In tidytable: Tidy Interface to 'data.table'

Separate a collapsed column into multiple rows

Description

Superseded

separate_rows() has been superseded by separate_longer_delim().

If a column contains observations with multiple delimited values, separate them each into their own row.

Usage

separate_rows(.df, ..., sep = "[^[:alnum:].]+", convert = FALSE)

Arguments

.df	A data.frame or data.table
...	Columns to separate across multiple rows. tidyselect compatible
sep	Separator delimiting collapsed values
convert	If TRUE, runs type.convert() on the resulting column. Useful if the resulting column should be type integer/double.

Examples

df <- data.table(
  x = 1:3,
  y = c("a", "d,e,f", "g,h"),
  z = c("1", "2,3,4", "5,6")
)

separate_rows(df, y, z)

separate_rows(df, y, z, convert = TRUE)

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