If a variable contains observations with multiple delimited values, this separates the values and places each one in its own row.
separate_rows(data, ..., sep = "[^[:alnum:].]+", convert = FALSE)
data | A data frame. |
---|---|
... | < |
sep | Separator delimiting collapsed values. |
convert | If |
df <- tibble( x = 1:3, y = c("a", "d,e,f", "g,h"), z = c("1", "2,3,4", "5,6") ) separate_rows(df, y, z, convert = TRUE)#> # A tibble: 6 × 3 #> x y z #> <int> <chr> <int> #> 1 1 a 1 #> 2 2 d 2 #> 3 2 e 3 #> 4 2 f 4 #> 5 3 g 5 #> 6 3 h 6