Split a string into rows — separate_longer

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

separate_longer_delim(.df, cols, delim, ...)

Arguments

.df: A data.frame or data.table
cols: Columns to separate
delim: Separator delimiting collapsed values
...: These dots are for future extensions and must be empty.

Examples

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

df %>%
  separate_longer_delim(c(y, z), ",")
#> # A tidytable: 6 × 3
#>       x y     z    
#>   <int> <chr> <chr>
#> 1     1 a     1    
#> 2     2 d     2    
#> 3     2 e     3    
#> 4     2 f     4    
#> 5     3 g     5    
#> 6     3 h     6