tidyr: separate_rows – R documentation

Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!

separate_rows

Separate a collapsed column into multiple rows

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.
`...`	<`tidy-select`> Columns to separate across multiple rows
`sep`	Separator delimiting collapsed values.
`convert`	If `TRUE` will automatically run `type.convert()` on the key column. This is useful if the column types are actually numeric, integer, or logical.

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)

Tidy Messy Data

v1.1.3

MIT + file LICENSE

Authors

Hadley Wickham [aut, cre], RStudio [cph]

Initial release