Is it possible to use spread on multiple columns in tidyr similar to dcast? [duplicate]

by

One option would be to create a new ‘Prod_Count’ by joining the ‘Product’ and ‘Country’ columns by paste, remove those columns with the select and reshape from ‘long’ to ‘wide’ using spread from tidyr.

 library(dplyr)
 library(tidyr)
 sdt %>%
 mutate(Prod_Count=paste(Product, Country, sep="_")) %>%
 select(-Product, -Country)%>% 
 spread(Prod_Count, value)%>%
 head(2)
 #  Year      A_AI       B_EI
 #1 1990 0.7878674  0.2486044
 #2 1991 0.2343285 -1.1694878

Or we can avoid a couple of steps by using unite from tidyr (from @beetroot’s comment) and reshape as before.

 sdt%>% 
 unite(Prod_Count, Product,Country) %>%
 spread(Prod_Count, value)%>% 
 head(2)
 #   Year      A_AI       B_EI
 # 1 1990 0.7878674  0.2486044
 # 2 1991 0.2343285 -1.1694878

More Related Contents:

  1. Reshaping multiple sets of measurement columns (wide format) into single columns (long format)
  2. How to use Pivot_longer to reshape from wide-type data to long-type data with multiple variables
  3. Reshape multiple values at once
  4. Tidyr how to spread into count of occurrence [duplicate]
  5. R: Reshaping Multiple Columns from Long to Wide
  6. Unlisting columns by groups
  7. Convert an upper to lower triangle matrix in r [duplicate]
  8. Gather multiple sets of columns
  9. dcast warning: ‘Aggregation function missing: defaulting to length’
  10. pivot_wider issue “Values in `values_from` are not uniquely identified; output will contain list-cols”
  11. Combine Multiple Columns Into Tidy Data [duplicate]
  12. Reshaping wide to long with multiple values columns [duplicate]
  13. R spreading multiple columns with tidyr [duplicate]
  14. Grouped bar plot in ggplot
  15. Compute mean and standard deviation by group for multiple variables in a data.frame
  16. melt / reshape in excel using VBA?
  17. Proper idiom for adding zero count rows in tidyr/dplyr
  18. How to spread columns with duplicate identifiers?
  19. Add NAs to make all list elements equal length
  20. Reshape from long to wide and create columns with binary value
  21. Convert a dataframe to presence absence matrix
  22. adding default values to item x group pairs that don’t have a value (df %>% spread %>% gather seems strange)
  23. How to use tidyr::separate when the number of needed variables is unknown [duplicate]
  24. Spread with duplicate identifiers (using tidyverse and %>%) [duplicate]
  25. Can dcast be used without an aggregate function? [duplicate]
  26. Spreading a two column data frame with tidyr
  27. pivot_longer with multiple classes causes error (“No common type”)
  28. How to replace all NA in a dataframe using tidyr::replace_na? [duplicate]
  29. How to transpose a dataframe in tidyverse?
  30. R reshape a vector into multiple columns

Leave a Comment