Using spread with duplicate identifiers for rows

by

Your answer was missing mutate id! Here is the solution using dplyr packge only.

jj %>% 
  gather(variable, value, -(month:student)) %>% 
  unite(temp, student, variable) %>% 
  group_by(temp) %>% 
  mutate(id=1:n()) %>% 
  spread(temp, value) 
#  A tibble: 6 x 6
#  month    id Amy_A Amy_B Bob_A Bob_B
# * <int> <int> <dbl> <dbl> <dbl> <dbl>
# 1     1     1     9     6     3     5
# 2     1     4     8     5     5     3
# 3     2     2     7     7     2     4
# 4     2     5     6     6     6     1
# 5     3     3     6     8     1     6
# 6     3     6     9     7     5     5

More Related Contents:

  1. Gather multiple sets of columns
  2. Combine Multiple Columns Into Tidy Data [duplicate]
  3. R spreading multiple columns with tidyr [duplicate]
  4. dplyr summarise: Equivalent of “.drop=FALSE” to keep groups with zero length in output
  5. Proper idiom for adding zero count rows in tidyr/dplyr
  6. Add NAs to make all list elements equal length
  7. Reshape from long to wide and create columns with binary value
  8. adding default values to item x group pairs that don’t have a value (df %>% spread %>% gather seems strange)
  9. combine two data frames with all posible combinations
  10. Spread with duplicate identifiers (using tidyverse and %>%) [duplicate]
  11. Spreading a two column data frame with tidyr
  12. How to replace all NA in a dataframe using tidyr::replace_na? [duplicate]
  13. tidyverse – prefered way to turn a named vector into a data.frame/tibble
  14. Unlisting columns by groups
  15. Unique rows, considering two columns, in R, without order
  16. standard evaluation in dplyr: summarise a variable given as a character string
  17. Use variable names in functions of dplyr
  18. Finding percentage in a sub-group using group_by and summarise
  19. Make a group_indices based on several columns
  20. Spread with data.frame/tibble with duplicate identifiers
  21. Change value of variable with dplyr
  22. sample rows of subgroups from dataframe with dplyr
  23. Assigning Dates to Fiscal Year
  24. filter function in dplyr errors: object ‘name’ not found
  25. How to pass dynamic column names in dplyr into custom function?
  26. R – Group by variable and then assign a unique ID [duplicate]
  27. R sum a variable by two groups [duplicate]
  28. data.table row-wise sum, mean, min, max like dplyr?
  29. Update/Replace Values in Dataframe with Tidyverse Join
  30. Collapse all columns by an ID column [duplicate]

Leave a Comment