Conditional sum in dplyr

Question

Hi I have a dataset that looks approximatively like this

Store shelf Revenue week
3       1     5054   52-2016
3       2     3564   52-2016
3       3     1260   52-2016
15      1     7000   1-2017
15      2     1236   1-2017
15      3     4596   1-2017

My aim is to make sum of revenues by store and week using dplyr

data %>% group_by(store, week) %>% mutate(R_sum = sum(Revenue))

Is this working? Thanks in advance

Your attempt should work. What is the issue you are facing? – Ronak Shah Jul 01 '20 at 09:46 — Ronak Shah, Jul 01 '20 at 09:46

score -1 · Answer 1 · answered Jul 01 '20 at 09:45

Use summarise for tasks like these instead of mutate

data %>%
  group_by(Store, week) %>%
  summarise(R_sum = sum(Revenue))

# A tibble: 2 x 3
# Groups:   Store [2]
#   Store week    R_sum
#   <int> <chr>   <int>
# 1     3 52-2016  9878
# 2    15 1-2017  12832

Conditional sum in dplyr

1 Answers1