How to Group_By months from this data frame

Question

This data frame has two columns, Date and sum_pips. I've been trying to group_by each month and find the total sum_pips for each month. For example, all the June's in this data frame equal to a sum of 2700 pips. Hopefully that makes sense

Answer 1

One approach would be to use the month() function from the lubridate package, which teases out the months from date-formatted variables as follows:

Sample data

set.seed(123)
df <- data.frame(Date = seq(as.Date("2022/1/1"), by = "day", length.out = 100),
                 sum_pips = rnbinom(100, mu = 55,  size = 0.75))

Code

library(dplyr)
library(lubridate)

df %>% 
  group_by(month(Date)) %>% 
  summarize(sum_all_pips = sum(sum_pips))

Output:

#   `month(Date)` sum_all_pips
#           <dbl>        <dbl>
# 1             1         1387
# 2             2         1663
# 3             3         1783
# 4             4          803