tidytable (version 0.8.0)

separate_rows.: Separate a collapsed column into multiple rows

Description

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)