How to use tidyr::separate when the number of needed variables is unknown [duplicate]

by

This is a good question – my usual repsonse is to use strsplit, then unnest and spread, which is also not super efficient:

library(dplyr)
library(tidyr)

dat %>% mutate(to = strsplit(to, ",")) %>%
        unnest(to) %>%
        group_by(from) %>%
        mutate(row = row_number()) %>%
        spread(row, to)

Source: local data frame [4 x 5]

                 date                from                   1                   2                 3
               (time)               (chr)               (chr)               (chr)             (chr)
1 2015-10-22 15:03:17   [email protected]   [email protected] [email protected]                NA
2 2015-10-22 15:03:17   [email protected] [email protected]                  NA                NA
3 2015-10-22 15:03:17 [email protected]     [email protected]   [email protected] [email protected]
4 2015-10-22 15:03:17     [email protected]   [email protected]                  NA                NA

More Related Contents:

  1. Reshaping multiple sets of measurement columns (wide format) into single columns (long format)
  2. Gather multiple sets of columns
  3. How to use Pivot_longer to reshape from wide-type data to long-type data with multiple variables
  4. Complete dataframe with missing combinations of values
  5. pivot_wider issue “Values in `values_from` are not uniquely identified; output will contain list-cols”
  6. How can I spread repeated measures of multiple variables into wide format?
  7. Combine Multiple Columns Into Tidy Data [duplicate]
  8. R spreading multiple columns with tidyr [duplicate]
  9. Reshape multiple values at once
  10. dplyr summarise: Equivalent of “.drop=FALSE” to keep groups with zero length in output
  11. Proper idiom for adding zero count rows in tidyr/dplyr
  12. How to spread columns with duplicate identifiers?
  13. Is it possible to use spread on multiple columns in tidyr similar to dcast? [duplicate]
  14. Add NAs to make all list elements equal length
  15. Reshape from long to wide and create columns with binary value
  16. adding default values to item x group pairs that don’t have a value (df %>% spread %>% gather seems strange)
  17. How to complete missing factor levels in data frame?
  18. combine two data frames with all posible combinations
  19. Tidyr how to spread into count of occurrence [duplicate]
  20. R: Reshaping Multiple Columns from Long to Wide
  21. tidyverse pivot_longer several sets of columns, but avoid intermediate mutate_wider steps [duplicate]
  22. Spread with duplicate identifiers (using tidyverse and %>%) [duplicate]
  23. data.table equivalent of tidyr::complete()
  24. Changing Million/Billion abbreviations into actual numbers? ie. 5.12M -> 5,120,000 [duplicate]
  25. Spreading a two column data frame with tidyr
  26. pivot_longer with multiple classes causes error (“No common type”)
  27. How to transpose a dataframe in tidyverse?
  28. tidyverse – prefered way to turn a named vector into a data.frame/tibble
  29. pivot_longer into multiple columns
  30. Unlisting columns by groups

Leave a Comment