Relative frequencies / proportions with dplyr

by

Try this:

mtcars %>%
  group_by(am, gear) %>%
  summarise(n = n()) %>%
  mutate(freq = n / sum(n))

#   am gear  n      freq
# 1  0    3 15 0.7894737
# 2  0    4  4 0.2105263
# 3  1    4  8 0.6153846
# 4  1    5  5 0.3846154

From the dplyr vignette:

When you group by multiple variables, each summary peels off one level of the grouping. That makes it easy to progressively roll-up a dataset.

Thus, after the summarise, the last grouping variable specified in group_by, ‘gear’, is peeled off. In the mutate step, the data is grouped by the remaining grouping variable(s), here ‘am’. You may check grouping in each step with groups.

The outcome of the peeling is of course dependent of the order of the grouping variables in the group_by call. You may wish to do a subsequent group_by(am), to make your code more explicit.

For rounding and prettification, please refer to the nice answer by @Tyler Rinker.

More Related Contents:

  1. How to number/label data-table by group-number from group_by?
  2. Finding percentage in a sub-group using group_by and summarise
  3. Count non-NA values by group [duplicate]
  4. dplyr issues when using group_by(multiple variables)
  5. dplyr – groupby on multiple columns using variable names
  6. Use dynamic name for new column/variable in `dplyr`
  7. What does the dplyr period character “.” reference?
  8. case_when in mutate pipe
  9. Summarize all group values and a conditional subset in the same call
  10. dplyr filter with condition on multiple columns
  11. dplyr mutate with conditional values
  12. How to add a cumulative column to an R dataframe using dplyr?
  13. Concatenate unique strings after groupby in R
  14. Get last row of each group in R [duplicate]
  15. dplyr on data.table, am I really using data.table?
  16. Set certain values to NA with dplyr
  17. How to filter rows based on difference in dates between rows in R?
  18. Use filter in dplyr conditional on an if statement in R
  19. combine two data frames with all posible combinations
  20. Performing dplyr mutate on subset of columns
  21. dplyr / R cumulative sum with reset
  22. finding close match from data frame 1 in data fame 2
  23. Add a column with count of NAs and Mean
  24. How to group data.table by multiple columns?
  25. select columns based on multiple strings with dplyr contains()
  26. Error with select function from dplyr
  27. Create sequential counter that restarts on a condition within panel data groups [duplicate]
  28. How to find difference between values in two rows in an R dataframe using dplyr
  29. Collapse all columns by an ID column [duplicate]
  30. use rollapply and zoo to calculate rolling average of a column of variables

Leave a Comment