How can I spread repeated measures of multiple variables into wide format?

by

Edit: I’m updating this answer since pivot_wider has been around for a while now and addresses the issue in this question and comments. You can now do

pivot_wider(
    dat, 
    id_cols="Person", 
    names_from = 'Time', 
    values_from = c('Score1', 'Score2', 'Score3'), 
    names_glue="{Time}.{.value}"
)

to get the desired result.

The original answer was

dat %>% 
  gather(temp, score, starts_with("Score")) %>% 
  unite(temp1, Time, temp, sep = ".") %>% 
  spread(temp1, score)

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