Gather multiple sets of columns

by

This approach seems pretty natural to me:

df %>%
  gather(key, value, -id, -time) %>%
  extract(key, c("question", "loop_number"), "(Q.\\..)\\.(.)") %>%
  spread(question, value)

First gather all question columns, use extract() to separate into question and loop_number, then spread() question back into the columns.

#>    id       time loop_number         Q3.2        Q3.3
#> 1   1 2009-01-01           1  0.142259203 -0.35842736
#> 2   1 2009-01-01           2  0.061034802  0.79354061
#> 3   1 2009-01-01           3 -0.525686204 -0.67456611
#> 4   2 2009-01-02           1 -1.044461185 -1.19662936
#> 5   2 2009-01-02           2  0.393808163  0.42384717

More Related Contents:

  1. Reshaping multiple sets of measurement columns (wide format) into single columns (long format)
  2. Combine Multiple Columns Into Tidy Data [duplicate]
  3. R spreading multiple columns with tidyr [duplicate]
  4. Reshape multiple values at once
  5. dplyr summarise: Equivalent of “.drop=FALSE” to keep groups with zero length in output
  6. Using spread with duplicate identifiers for rows
  7. Proper idiom for adding zero count rows in tidyr/dplyr
  8. Add NAs to make all list elements equal length
  9. Reshape from long to wide and create columns with binary value
  10. adding default values to item x group pairs that don’t have a value (df %>% spread %>% gather seems strange)
  11. combine two data frames with all posible combinations
  12. R: Reshaping Multiple Columns from Long to Wide
  13. Spread with duplicate identifiers (using tidyverse and %>%) [duplicate]
  14. Spreading a two column data frame with tidyr
  15. How to replace all NA in a dataframe using tidyr::replace_na? [duplicate]
  16. tidyverse – prefered way to turn a named vector into a data.frame/tibble
  17. Unlisting columns by groups
  18. Is there a dplyr equivalent to data.table::rleid?
  19. Replace NA with previous or next value, by group, using dplyr
  20. Frequency counts in R [duplicate]
  21. Pass a vector of variable names to arrange() in dplyr
  22. how to pivot/unpivot (cast/melt) data frame? [duplicate]
  23. Calculate group mean while excluding current observation using dplyr
  24. Emulate split() with dplyr group_by: return a list of data frames
  25. Sparklyr: how to center a Spark table based on column?
  26. data.table equivalent of tidyr::complete()
  27. Tilde Dot in R (~.)
  28. How to filter data without losing NA rows using dplyr
  29. How to replace empty string with NA in R dataframe?
  30. Add margin row totals in dplyr chain

Leave a Comment