how to pivot/unpivot (cast/melt) data frame? [duplicate]

by

I still can’t believe I beat Andrie with an answer. 🙂

> library(reshape)
> my.df <- read.table(text = "Country     2001    2002    2003
   + Nigeria     1       2       3
   + UK          2       NA       1", header = TRUE)
> my.result <- melt(my.df, id = c("Country"))
> my.result[order(my.result$Country),]
     Country variable value
   1 Nigeria    X2001     1
   3 Nigeria    X2002     2
   5 Nigeria    X2003     3
   2      UK    X2001     2
   4      UK    X2002    NA
   6      UK    X2003     1

More Related Contents:

  1. Convert an upper to lower triangle matrix in r [duplicate]
  2. Reshaping multiple sets of measurement columns (wide format) into single columns (long format)
  3. dcast warning: ‘Aggregation function missing: defaulting to length’
  4. Reshaping wide to long with multiple values columns [duplicate]
  5. Reshape multiple values at once
  6. Grouped bar plot in ggplot
  7. Compute mean and standard deviation by group for multiple variables in a data.frame
  8. melt / reshape in excel using VBA?
  9. R: Reshaping Multiple Columns from Long to Wide
  10. can the value.var in dcast be a list or have multiple value variables?
  11. Reshape a dataframe to long format with multiple sets of measure columns [duplicate]
  12. R reshape a vector into multiple columns
  13. How to reshape data from long to wide format
  14. Reshaping data.frame from wide to long format
  15. Transpose / reshape dataframe without “timevar” from long to wide format
  16. Faster ways to calculate frequencies and cast from long to wide
  17. Split delimited strings in a column and insert as new rows [duplicate]
  18. Reshape three column data frame to matrix (“long” to “wide” format) [duplicate]
  19. How to use Pivot_longer to reshape from wide-type data to long-type data with multiple variables
  20. Using Reshape from wide to long in R [closed]
  21. R Reshape data frame from long to wide format? [duplicate]
  22. Easy way to convert long to wide format with counts [duplicate]
  23. Subsetting R data frame results in mysterious NA rows
  24. Is it possible to use spread on multiple columns in tidyr similar to dcast? [duplicate]
  25. Convert a dataframe to presence absence matrix
  26. Getting a stacked area plot in R
  27. Aggregate and reshape from long to wide
  28. Is there an R function to reshape this data from long to wide?
  29. Can dcast be used without an aggregate function? [duplicate]
  30. Unlisting columns by groups

Leave a Comment