Reshaping multiple sets of measurement columns (wide format) into single columns (long format)

by 
reshape(dat, idvar="ID", direction="long", 
             varying=list(Start=c(2,5,8), End=c(3,6,9), Value=c(4,7,10)),
             v.names = c("DateRangeStart", "DateRangeEnd", "Value") )
#-------------
    ID time DateRangeStart DateRangeEnd Value
1.1  1    1          1/1/90        3/1/90    4.4
1.2  1    2          4/5/91        6/7/91    6.2
1.3  1    3          5/5/95        6/6/96    3.3

(Added the v.names per Josh’s suggestion.)

More Related Contents:

  1. Reshape multiple values at once
  2. R: Reshaping Multiple Columns from Long to Wide
  3. Convert an upper to lower triangle matrix in r [duplicate]
  4. How to reshape data from long to wide format
  5. Reshaping data.frame from wide to long format
  6. Transpose / reshape dataframe without “timevar” from long to wide format
  7. Gather multiple sets of columns
  8. How to use Pivot_longer to reshape from wide-type data to long-type data with multiple variables
  9. dcast warning: ‘Aggregation function missing: defaulting to length’
  10. Reshape multiple value columns to wide format
  11. Reshaping wide to long with multiple values columns [duplicate]
  12. Grouped bar plot in ggplot
  13. Compute mean and standard deviation by group for multiple variables in a data.frame
  14. Is it possible to use spread on multiple columns in tidyr similar to dcast? [duplicate]
  15. how to pivot/unpivot (cast/melt) data frame? [duplicate]
  16. Tidyr how to spread into count of occurrence [duplicate]
  17. can the value.var in dcast be a list or have multiple value variables?
  18. Reshape a dataframe to long format with multiple sets of measure columns [duplicate]
  19. R reshape a vector into multiple columns
  20. Unlisting columns by groups
  21. Split delimited strings in a column and insert as new rows [duplicate]
  22. Add regression line equation and R^2 on graph
  23. Generate a dummy-variable
  24. Error in : object of type ‘closure’ is not subsettable
  25. General suggestions for debugging in R
  26. Reorder levels of a factor without changing order of values
  27. Warning message: In `…` : invalid factor level, NA generated
  28. How to load packages in R automatically?
  29. Convert a dataframe to a vector (by rows)
  30. pivot_longer with multiple classes causes error (“No common type”)

Leave a Comment