Easy way to convert long to wide format with counts [duplicate]

by

The aggregation parameter in the dcast function of the reshape2-package defaults to length (= count). In the data.table-package an improved version of the dcastfunction is implemented. So in your case this would be: 

library('reshape2') # or library('data.table')
newdf <- dcast(sample.data, Case ~ Decision)

or with using the parameters explicitly:

newdf <- dcast(sample.data, Case ~ Decision,
               value.var = "Decision", fun.aggregate = length)

This gives the following dataframe:

> newdf
  Case Approved Declined Referred
1    1        1        0        3
2    2        0        1        1
3    3        0        1        2
4    4        1        0        0
5    5        0        1        0

If you don’t specify an aggregation function, you get a warning telling you that dcast is using lenght as a default.

More Related Contents:

  1. Convert an upper to lower triangle matrix in r [duplicate]
  2. How to reshape data from long to wide format
  3. Reshaping data.frame from wide to long format
  4. Reshaping multiple sets of measurement columns (wide format) into single columns (long format)
  5. Transpose / reshape dataframe without “timevar” from long to wide format
  6. Split delimited strings in a column and insert as new rows [duplicate]
  7. Reshape three column data frame to matrix (“long” to “wide” format) [duplicate]
  8. Gather multiple sets of columns
  9. dcast warning: ‘Aggregation function missing: defaulting to length’
  10. Reshape multiple value columns to wide format
  11. Using Reshape from wide to long in R [closed]
  12. R Reshape data frame from long to wide format? [duplicate]
  13. Frequency counts in R [duplicate]
  14. Reshaping wide to long with multiple values columns [duplicate]
  15. Reshape multiple values at once
  16. Grouped bar plot in ggplot
  17. Subsetting R data frame results in mysterious NA rows
  18. Compute mean and standard deviation by group for multiple variables in a data.frame
  19. Getting a stacked area plot in R
  20. Aggregate and reshape from long to wide
  21. how to pivot/unpivot (cast/melt) data frame? [duplicate]
  22. R: Reshaping Multiple Columns from Long to Wide
  23. Is there an R function to reshape this data from long to wide?
  24. What methods can we use to reshape VERY large data sets?
  25. can the value.var in dcast be a list or have multiple value variables?
  26. Reshape a dataframe to long format with multiple sets of measure columns [duplicate]
  27. R reshape a vector into multiple columns
  28. Labeling Outliers of Boxplots in R
  29. Merge Two Lists in R
  30. How to remove unicode from string?

Leave a Comment