Sum by two variables

by

In base R (for sum) there’s xtabs:

> xtabs(sales ~ Date + area, mydf)
        area
Date     beijing shanghai
  201204      41       23
  201205      17       71

To get it as a data.frame, wrap it in as.data.frame.matrix.

To update this with the approach that is making the rounds these days, you can also use a combination of “dplyr” (for aggregation) and “tidyr” (for reshaping), like this:

library(tidyr)
library(dplyr)
mydf %>% 
  group_by(Date, area) %>% 
  summarise(sales = sum(sales)) %>% 
  spread(area, sales)
# Source: local data frame [2 x 3]
# 
#     Date beijing shanghai
# 1 201204      41       23
# 2 201205      17       71

More Related Contents:

  1. Row-wise sum for select columns while ignoring NAs [closed]
  2. Efficiently sum across multiple columns in R
  3. ignore NA in dplyr row sum
  4. Sum every nth points
  5. Divide each value by the sum of values by group
  6. how to use loop to subset 1000 csv files and do co-integration test in R?
  7. Replacing NAs with latest non-NA value
  8. Update data frame via function doesn’t work
  9. Select groups with more than one distinct value
  10. Scatterplot with too many points
  11. Finding Overlaps between interval sets / Efficient Overlap Joins
  12. R dplyr rolling sum
  13. Using multiple criteria in subset function and logical operators
  14. Select columns based on string match – dplyr::select
  15. Can’t download data from Yahoo Finance using Quantmod in R
  16. Splitting a data.frame by a variable [duplicate]
  17. Using row-wise column indices in a vector to extract values from data frame [duplicate]
  18. How can a non-imported method in a not-attached package be found by calls to functions not having it in their namespace?
  19. How to add table of contents in Rmarkdown?
  20. How to hold figure position with figure caption in pdf output of knitr?
  21. Recognize PDF table using R
  22. How do you delete a column by name in data.table?
  23. Merging two sets of data by data.table roll=’nearest’ function
  24. Non-numeric Argument to Binary Operator Error in R
  25. Special characters and superscripts on plot axis titles
  26. print to pdf file using grid.table in r – too many rows to fit on one page
  27. Obtaining connected components of neighboring values
  28. how to start a for loop in R programming
  29. error in strsplit when trying to separate by a comma
  30. Administrative regions map of a country with ggmap and ggplot2

Leave a Comment