Summarizing by subgroup percentage in R

by

Per your comment, if the subgroups are unique you can do

library(dplyr)
group_by(df, group) %>% mutate(percent = value/sum(value))
#   group subgroup value   percent
# 1     A        a     1 0.1250000
# 2     A        b     4 0.5000000
# 3     A        c     2 0.2500000
# 4     A        d     1 0.1250000
# 5     B        a     1 0.1666667
# 6     B        b     2 0.3333333
# 7     B        c     3 0.5000000

Or to remove the value column and add the percent column at the same time, use transmute

group_by(df, group) %>% transmute(subgroup, percent = value/sum(value))
#   group subgroup   percent
# 1     A        a 0.1250000
# 2     A        b 0.5000000
# 3     A        c 0.2500000
# 4     A        d 0.1250000
# 5     B        a 0.1666667
# 6     B        b 0.3333333
# 7     B        c 0.5000000

More Related Contents:

  1. How to sum a variable by group
  2. Aggregate / summarize multiple variables per group (e.g. sum, mean)
  3. Collapse / concatenate / aggregate a column to a single comma separated string within each group
  4. Aggregating by unique identifier and concatenating related values into a string [duplicate]
  5. Count number of rows per group and add result to original data frame
  6. Apply several summary functions on several variables by group in one call
  7. Extract row corresponding to minimum value of a variable by group
  8. Summarizing multiple columns with dplyr? [duplicate]
  9. Extract the maximum value within each group in a dataframe [duplicate]
  10. Group by multiple columns and sum other multiple columns
  11. Add count of unique / distinct values by group to the original data
  12. Select the first and last row by group in a data frame
  13. Apply function conditionally
  14. Aggregate multiple columns at once [duplicate]
  15. Aggregate a dataframe on a given column and display another column
  16. Aggregate a data frame based on unordered pairs of columns
  17. Compute mean and standard deviation by group for multiple variables in a data.frame
  18. aggregate methods treat missing values (NA) differently
  19. Group integer vector into consecutive runs
  20. Returning first row of group
  21. Get the means of sub groups of means in R
  22. Apply several summary functions (sum, mean, etc.) on several variables by group in one call
  23. Aggregate data in R
  24. R sum a variable by two groups [duplicate]
  25. R group by aggregate
  26. R use ddply or aggregate
  27. Combining duplicated rows in R and adding new column containing IDs of duplicates
  28. Aggregate by week in R
  29. Aggregating all unique values of each column of data frame
  30. How can I count the number of NAs per group?

Leave a Comment