Summarize all group values and a conditional subset in the same call

by

You can do both sums in a single dplyr statement:

df1 <- df %>%
  group_by(ID) %>%
  summarize(sumB = sum(B),
            sumBfoo = sum(B[A=="foo"]))

And here is a data.table version:

library(data.table)

dt = setDT(df) 

dt1 = dt[ , .(sumB = sum(B),
              sumBfoo = sum(B[A=="foo"])), 
          by = ID]

dt1

   ID sumB sumBfoo
1:  1    6       1
2:  2   30      30
3:  3   54       0
4:  5  202       0

More Related Contents:

  1. Summarizing multiple columns with dplyr? [duplicate]
  2. Relative frequencies / proportions with dplyr
  3. How to create a lag variable within each group?
  4. Why are my dplyr group_by & summarize not working properly? (name-collision with plyr)
  5. Unique rows, considering two columns, in R, without order
  6. standard evaluation in dplyr: summarise a variable given as a character string
  7. Use variable names in functions of dplyr
  8. Create new variables with mutate_at while keeping the original ones
  9. How to interpret dplyr message `summarise()` regrouping output by ‘x’ (override with `.groups` argument)?
  10. Finding percentage in a sub-group using group_by and summarise
  11. Make a group_indices based on several columns
  12. Using spread with duplicate identifiers for rows
  13. filter for complete cases in data.frame using dplyr (case-wise deletion)
  14. Change value of variable with dplyr
  15. sample rows of subgroups from dataframe with dplyr
  16. Assigning Dates to Fiscal Year
  17. filter function in dplyr errors: object ‘name’ not found
  18. Create a ranking variable with dplyr?
  19. How to pass dynamic column names in dplyr into custom function?
  20. R – Group by variable and then assign a unique ID [duplicate]
  21. Sparklyr: how to center a Spark table based on column?
  22. R sum a variable by two groups [duplicate]
  23. Join two data frames in R based on closest timestamp
  24. Conditionally Count in dplyr
  25. data.table row-wise sum, mean, min, max like dplyr?
  26. Update/Replace Values in Dataframe with Tidyverse Join
  27. dplyr: put count occurrences into new variable [duplicate]
  28. Add row in each group using dplyr and add_row()
  29. How to replace certain values in a specific rows and columns with NA in R?
  30. Add margin row totals in dplyr chain

Leave a Comment