tidyverse pivot_longer several sets of columns, but avoid intermediate mutate_wider steps [duplicate]

by

You can use : 

tidyr::pivot_longer(dat, cols = -id, 
                   names_to = c('.value', 'brand'), 
                   names_sep = "_")


#  id    brand  Q1r1  Q1r2
#  <chr> <chr> <dbl> <dbl>
#1 A     pepsi     1     1
#2 A     cola      0     0
#3 B     pepsi     0     1
#4 B     cola      0     1
#5 C     pepsi     1     1
#6 C     cola      1     1

More Related Contents:

  1. Tidyr how to spread into count of occurrence [duplicate]
  2. pivot_longer into multiple columns
  3. Reshaping multiple sets of measurement columns (wide format) into single columns (long format)
  4. Gather multiple sets of columns
  5. How to use Pivot_longer to reshape from wide-type data to long-type data with multiple variables
  6. pivot_wider issue “Values in `values_from` are not uniquely identified; output will contain list-cols”
  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. Spread with data.frame/tibble with duplicate identifiers
  12. Using spread with duplicate identifiers for rows
  13. Proper idiom for adding zero count rows in tidyr/dplyr
  14. How to spread columns with duplicate identifiers?
  15. Is it possible to use spread on multiple columns in tidyr similar to dcast? [duplicate]
  16. Add NAs to make all list elements equal length
  17. Reshape from long to wide and create columns with binary value
  18. adding default values to item x group pairs that don’t have a value (df %>% spread %>% gather seems strange)
  19. How to use tidyr::separate when the number of needed variables is unknown [duplicate]
  20. How to complete missing factor levels in data frame?
  21. R: Reshaping Multiple Columns from Long to Wide
  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 replace all NA in a dataframe using tidyr::replace_na? [duplicate]
  28. How to transpose a dataframe in tidyverse?
  29. tidyverse – prefered way to turn a named vector into a data.frame/tibble
  30. Unlisting columns by groups

Leave a Comment