Help with converting quarterly tsibble to monthly tsibble

General
1

Hello,

I have quarterly data and would like to convert it to monthly data where each month of the quarter is not same such as not using mean per quarter. In other words, hoping to see monthly data with some seasonality. Is there a way to get such data? Thanks for your help!

# Sample data
df <- data.frame(
  stringsAsFactors = FALSE,
       check.names = FALSE,
                 date = c("2019-01-01",
                          "2019-04-01","2019-07-01","2019-10-01","2020-01-01",
                          "2020-04-01","2020-07-01","2020-10-01","2021-01-01",
                          "2021-04-01","2021-07-01","2021-10-01"),
            `brand A` = c(21999,28022,30464,
                          26861,24990,17015,30381,29716,NA,NA,NA,NA),
            `brand B` = c(2211.94,2259.38,2243.29,
                          2246.55,2158.49,2086.65,2305.75,NA,NA,NA,NA,
                          NA),
            `brand C` = c(191125,191125,189738,
                          238556,263929,274390,282798,292390,302517,NA,NA,
                          NA)
   )

df  <-  df%>%
      mutate(date = ymd(date)) %>% 
       as_tsibble(index = date)
2

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.