Search code examples
rdplyrtidyrplyrlubridate

How to get the last three months data using dplyr in R

I have data like this:

library(lubridate)
library(dplyr)

set.seed(2021)
gen_date <- seq(ymd_h("2021-01-01-00"), ymd_h("2021-09-30-23"), by = "hours")
hourx <- hour(gen_date)
datex <- date(gen_date)
sales <- round(runif(length(datex), 10, 50), 0)*100
mydata <- data.frame(datex, hourx, sales)

How do i get the last three months data using dplyr? or How do i get the last six months data using dplyr?. What i want is full data from "2021-06-01" to "2021-09-30". Thank You.

Solution

  • You may try

    library(xts)

x <- mydata %>%
  mutate(month = month(datex)) %>%
  filter(month %in% last(unique(month), 3))
unique(x$month)
[1] 7 8 9