Finding percentage in a sub-group using group_by and summarise

by

Try

library(dplyr)
data %>%
    group_by(month) %>%
    mutate(countT= sum(count)) %>%
    group_by(type, add=TRUE) %>%
    mutate(per=paste0(round(100*count/countT,2),'%'))

Or make it more simpler without creating additional columns

data %>%
    group_by(month) %>%
    mutate(per =  100 *count/sum(count)) %>% 
    ungroup

We could also use left_join after summarising the sum(count) by ‘month’

Or an option using data.table.

 library(data.table)
 setkey(setDT(data), month)[data[, list(count=sum(count)), month], 
               per:= paste0(round(100*count/i.count,2), '%')][]

More Related Contents:

  1. Relative frequencies / proportions with dplyr
  2. How to number/label data-table by group-number from group_by?
  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. Summarizing multiple columns with dplyr? [duplicate]
  7. How to create a lag variable within each group?
  8. Why are my dplyr group_by & summarize not working properly? (name-collision with plyr)
  9. Unique rows, considering two columns, in R, without order
  10. standard evaluation in dplyr: summarise a variable given as a character string
  11. Use variable names in functions of dplyr
  12. Create new variables with mutate_at while keeping the original ones
  13. How to interpret dplyr message `summarise()` regrouping output by ‘x’ (override with `.groups` argument)?
  14. Can dplyr summarise over several variables without listing each one? [duplicate]
  15. Change value of variable with dplyr
  16. sample rows of subgroups from dataframe with dplyr
  17. Assigning Dates to Fiscal Year
  18. filter function in dplyr errors: object ‘name’ not found
  19. Create a ranking variable with dplyr?
  20. How to pass dynamic column names in dplyr into custom function?
  21. R – Group by variable and then assign a unique ID [duplicate]
  22. Emulate split() with dplyr group_by: return a list of data frames
  23. Sparklyr: how to center a Spark table based on column?
  24. R sum a variable by two groups [duplicate]
  25. Join two data frames in R based on closest timestamp
  26. Conditionally Count in dplyr
  27. data.table row-wise sum, mean, min, max like dplyr?
  28. Update/Replace Values in Dataframe with Tidyverse Join
  29. Collapse all columns by an ID column [duplicate]
  30. dplyr – Group by and select TOP x %

Leave a Comment