Aggregate and reshape from long to wide

by

Your data are already in a long format that can be used easily by “reshape2”, like this:

library(reshape)
dcast(df, bdate ~ sex + age + diag, value.var = "admissions")
#        bdate Female_35-64_card Female_35-64_cere Female_65-74_card Female_65-74_cere
# 1 1987-01-01                 1                 6                 1                 6
# 2 1987-01-02                 4                 4                 0                 6
# 3 1987-01-03                 2                 6                 4                 5
#   Male_35-64_card Male_35-64_cere Male_65-74_card Male_65-74_cere
# 1               0               6               0               1
# 2               0               5               0               2
# 3               1               6               0               4

I don’t see any aggregation in your sample output, but if aggregation is required, you can achieve this with the fun.aggregate function within dcast.

More Related Contents:

  1. Compute mean and standard deviation by group for multiple variables in a data.frame
  2. Convert an upper to lower triangle matrix in r [duplicate]
  3. How to reshape data from long to wide format
  4. Aggregate / summarize multiple variables per group (e.g. sum, mean)
  5. Collapse / concatenate / aggregate a column to a single comma separated string within each group
  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. Extract row corresponding to minimum value of a variable by group
  9. Gather multiple sets of columns
  10. Group by multiple columns and sum other multiple columns
  11. Add count of unique / distinct values by group to the original data
  12. R Reshape data frame from long to wide format? [duplicate]
  13. Select the first and last row by group in a data frame
  14. Apply function conditionally
  15. Frequency counts in R [duplicate]
  16. Reshaping wide to long with multiple values columns [duplicate]
  17. Reshape multiple values at once
  18. Grouped bar plot in ggplot
  19. Aggregate a dataframe on a given column and display another column
  20. aggregate methods treat missing values (NA) differently
  21. Group integer vector into consecutive runs
  22. Getting a stacked area plot in R
  23. R: Reshaping Multiple Columns from Long to Wide
  24. Is there an R function to reshape this data from long to wide?
  25. Apply several summary functions (sum, mean, etc.) on several variables by group in one call
  26. What methods can we use to reshape VERY large data sets?
  27. Aggregate data in R
  28. R use ddply or aggregate
  29. Aggregate by week in R
  30. How can I count the number of NAs per group?

Leave a Comment