• The problem

• Why typical forecast methods won't work

• Multiseasonal time series

• What to do

Forecasting the number of visitor to Nettebad Osnabrück having

• Visitors to the pool from 2005-03-20
• Some variables about the pool such as event, classes, availability of certain facilities etc.
• Weather data

https://inclass.kaggle.com/c/swimming-pool-visitor-forecasting

Is it a forecast problem

• It seems so, but looking at the lag plots

• It seems so, but looking at the lag plots

• It seems so, but looking at the lag plots

• It seems so, but looking at the lag plots

• And the autocorrelation plot

• Autocorrelation plot suggested weekly seasonality in the data
• The missing days were imputed and the time series is decomposed

• One could remove seasonality and do the prediction on the remainder, then add seasonaity

• The best RMSE I could get with this approach was 330.15

• As there are two kinds of sesonality, one can use multiseasonal time series and TBATS

• Reacehd rmse of 376

• School and bank holidays
• Weekday and month name to consider seasonality
• Weather data (temprature, wind, preception,...)
• New features
  • Monthly average temprature
  • Warmer than monthly average
  • Warmer than the previous day
  • Heat index
• Adjust prices by consumer price index (CPI)

• Train a random forest to get feature importnce
• Use the most important feature (99% cumulative importance)
• Use gradient boosting (XGboost) for the final prediction

• Adjust christmas and new years manually to the previous year value

• The final rmse is 247.33 (269.89 without manuall adjusment)