library(tidyverse)
library(jsonlite)
library(tibbletime)
library(forecast)
library(tscount)

roll_mean_na_rm <- rollify(~mean(.x, na.rm = TRUE), window = 7, na_value = 0)
date_transform <- function(x) {format(lubridate::date_decimal(x), "%Y-%m-%d")}

base <- read_rds("vermelho.rds")

Série

base %>% 
  ggplot() + 
  geom_point(aes(x = Data, y = Vermelho), alpha = .5) + 
  geom_line(aes(x = Data, y = MM7), color = 'red', alpha = .75, size = 1) +
  ggtitle("Número de rótulos vermelhos por dia") +
  labs(x = 'Data', y = 'Quantidade')  +
  scale_x_continuous(labels = date_transform)

Exponential smoothing state space model

serie <- ts(base$MM7,     # random data
            start = c(2020, as.numeric(format(base$Data[1], "%j"))),
            frequency = 365)

fit <- ets(serie) 

summary(fit)
## ETS(A,Ad,N) 
## 
## Call:
##  ets(y = serie) 
## 
##   Smoothing parameters:
##     alpha = 0.9999 
##     beta  = 0.3252 
##     phi   = 0.8 
## 
##   Initial states:
##     l = -33.401 
##     b = 15.6853 
## 
##   sigma:  19.4968
## 
##      AIC     AICc      BIC 
## 4328.711 4328.945 4352.110 
## 
## Training set error measures:
##                     ME    RMSE      MAE MPE MAPE MASE       ACF1
## Training set 0.1672968 19.3628 7.187017 NaN  Inf  NaN 0.01668646
fc <- forecast(fit, h = 15)
autoplot(fc) + labs(x = 'Data', y = 'Série') + lims(y = c(0,750)) +
  scale_x_continuous(labels = date_transform)

TBATS model (Exponential smoothing state space model with Box-Cox transformation, ARMA errors, Trend and Seasonal components)

fit <- tbats(serie)
fit
## TBATS(1, {0,0}, -, {<365,6>})
## 
## Call: tbats(y = serie)
## 
## Parameters
##   Alpha: 1.192475
##   Gamma-1 Values: 3.486219e-05
##   Gamma-2 Values: -0.0005972896
## 
## Seed States:
##              [,1]
##  [1,]  48.8955375
##  [2,]  42.0213922
##  [3,] -10.7779424
##  [4,]   3.8834271
##  [5,] -65.1256648
##  [6,] -46.7570375
##  [7,]   0.9967154
##  [8,] 108.5109007
##  [9,] 119.6087389
## [10,]  97.7172232
## [11,]  14.8743958
## [12,] -11.5942289
## [13,] -28.9606528
## 
## Sigma: 18.86962
## AIC: 4329.876
fc <- forecast(fit, h = 15)
autoplot(fc) + labs(x = 'Data', y = 'Série') + lims(y = c(0,750)) +
  scale_x_continuous(labels = date_transform)

Best ARIMA model to univariate time series

fit <- auto.arima(serie, max.order = 50)
summary(fit)
## Series: serie 
## ARIMA(2,1,3) 
## 
## Coefficients:
##         ar1      ar2      ma1     ma2     ma3
##       1.354  -0.7923  -1.1473  0.7145  0.1440
## s.e.  0.158   0.1162   0.1673  0.1086  0.0774
## 
## sigma^2 estimated as 343.3:  log likelihood=-1577.32
## AIC=3166.64   AICc=3166.87   BIC=3190.02
## 
## Training set error measures:
##                     ME     RMSE      MAE         MPE     MAPE MASE        ACF1
## Training set 0.2739805 18.37669 7.620762 -0.04789548 5.965154  NaN 0.001669218
fc <- forecast(fit, h = 15)
autoplot(fc) + labs(x = 'Data', y = 'Série') + lims(y = c(0,750)) +
  scale_x_continuous(labels = date_transform)

Fourier terms for modelling seasonality

z <- fourier(serie, K=5)
zf <- fourier(serie, K=5, h=15)
fit <- auto.arima(serie, xreg=z, seasonal=FALSE, max.order = 50)
summary(fit)
## Series: serie 
## Regression with ARIMA(4,0,0) errors 
## 
## Coefficients:
##          ar1      ar2      ar3      ar4  intercept   S1-365   C1-365   S2-365
##       1.1440  -0.1119  -0.0270  -0.1085   134.7771  49.0554  41.8056  89.2761
## s.e.  0.0519   0.0793   0.0792   0.0523     9.0668  12.9284  12.7041  12.9111
##         C2-365   S3-365   C3-365   S4-365    C4-365    S5-365    C5-365
##       -13.2372  78.0779   0.4739  -4.1868  -64.3721  -26.9530  -43.9870
## s.e.   12.6852  12.8789  12.6507  12.8264   12.5961   12.7469   12.5158
## 
## sigma^2 estimated as 340.2:  log likelihood=-1575.36
## AIC=3182.71   AICc=3184.28   BIC=3245.11
## 
## Training set error measures:
##                      ME     RMSE      MAE  MPE MAPE MASE        ACF1
## Training set 0.09884862 18.06232 7.920069 -Inf  Inf  NaN 0.002519252
fc <- forecast(fit, xreg=zf, h=15)
autoplot(fc) +
  scale_x_continuous(labels = date_transform)