Is there an R function to reshape this data from long to wide?

by

You could create a new identifier column with unique value for every student and then use pivot_wider to case multiple columns to wide. 

library(dplyr)
df %>%
  mutate(name = as.integer(factor(Student))) %>%
  tidyr::pivot_wider(names_from = name, values_from = c(Student, score))

#  CoachID Student_1 Student_2 Student_3 score_1 score_2 score_3
#    <int> <fct>     <fct>     <fct>       <int>   <int>   <int>
#1       1 A         B         NA              8       3      NA
#2       2 A         B         C               5       4       7

data

df <- structure(list(CoachID = c(1L, 1L, 2L, 2L, 2L), Student = structure(c(1L, 
2L, 1L, 2L, 3L), .Label = c("A", "B", "C"), class = "factor"), 
score = c(8L, 3L, 5L, 4L, 7L)), class = "data.frame", row.names = c(NA, -5L))

More Related Contents:

  1. Convert an upper to lower triangle matrix in r [duplicate]
  2. In R; I would like to do something in R rather than excel because excel can’t handle the calculation. In excel the calculation is: =A2+SUM($B$2:B2)
  3. How to plot intersecting ranges in Excel/R/Matlab [closed]
  4. How to reshape data from long to wide format
  5. Reshaping data.frame from wide to long format
  6. Reshaping multiple sets of measurement columns (wide format) into single columns (long format)
  7. Split delimited strings in a column and insert as new rows [duplicate]
  8. Reshape three column data frame to matrix (“long” to “wide” format) [duplicate]
  9. Gather multiple sets of columns
  10. Reshape multiple value columns to wide format
  11. R Reshape data frame from long to wide format? [duplicate]
  12. Frequency counts in R [duplicate]
  13. Reshaping wide to long with multiple values columns [duplicate]
  14. Read all worksheets in an Excel workbook into an R list with data.frames
  15. Reshape multiple values at once
  16. Easy way to convert long to wide format with counts [duplicate]
  17. Grouped bar plot in ggplot
  18. Subsetting R data frame results in mysterious NA rows
  19. Compute mean and standard deviation by group for multiple variables in a data.frame
  20. melt / reshape in excel using VBA?
  21. Read Excel file from a URL using the readxl package
  22. Getting a stacked area plot in R
  23. Aggregate and reshape from long to wide
  24. how to pivot/unpivot (cast/melt) data frame? [duplicate]
  25. What methods can we use to reshape VERY large data sets?
  26. Is it possible to get the number of rows in a CSV file without opening it?
  27. How do you read a password protected excel file into r?
  28. Importing a big xlsx file into R?
  29. R reshape a vector into multiple columns
  30. Using R to read out excel-colorinfo

Leave a Comment