Reshape multiple value columns to wide format

by

Your best option is to reshape your data to long format, using melt, and then to dcast:

library(reshape2)

meltExpensesByMonth <- melt(expensesByMonth, id.vars=1:2)
dcast(meltExpensesByMonth, expense_type ~ month + variable, fun.aggregate = sum)

The first few lines of output:

             expense_type 2012-02-01_value 2012-02-01_percent 2012-03-01_value 2012-03-01_percent
1              Adjustment           442.37        0.124025031             2.00       0.0005064625
2     Bank Service Charge           200.00        0.056072985           200.00       0.0506462461
3                   Cable            21.33        0.005980184            36.33       0.0091998906
4                 Charity             0.00        0.000000000             0.00       0.0000000000

More Related Contents:

  1. How to reshape data from long to wide format
  2. Reshaping data.frame from wide to long format
  3. Reshaping multiple sets of measurement columns (wide format) into single columns (long format)
  4. Transpose / reshape dataframe without “timevar” from long to wide format
  5. Collapse / concatenate / aggregate a column to a single comma separated string within each group
  6. Filter data.frame rows by a logical condition
  7. Evaluate expression given as a string
  8. Pass a data.frame column name to a function
  9. Gather multiple sets of columns
  10. What is the difference between require() and library()?
  11. How to sort a character vector where elements contain letters and numbers in R?
  12. Plot two graphs in same plot in R
  13. Add column which contains binned values of a numeric column
  14. Replace all 0 values to NA
  15. Paste multiple columns together
  16. Using R to download zipped data file, extract, and import data
  17. R Reshape data frame from long to wide format? [duplicate]
  18. How does one reorder columns in a data frame?
  19. Group by multiple columns in dplyr, using string vector input
  20. Reshaping wide to long with multiple values columns [duplicate]
  21. Changing date format in R
  22. How to perform natural (lexicographic) sorting in R? [duplicate]
  23. Test if characters are in a string
  24. How to filter a data frame
  25. Why is `vapply` safer than `sapply`?
  26. Getting a stacked area plot in R
  27. Create categorical variable in R based on range
  28. Apply several summary functions (sum, mean, etc.) on several variables by group in one call
  29. Order of operator precedence when using “:” (the colon)
  30. What methods can we use to reshape VERY large data sets?

Leave a Comment