Recursive Row Loop for Sales Forecasting

[mlauber71]

I would like to point you to a few resources where they tried to predict future sales at a german retail chain on Kaggle. Maybe you might get some useful insights.

One thing to consider might be special things like (regional) holidays or events like easter that will not be at the same date every year, and the holidays might not only affect the day itself but the days before and after. You might want to take that into account.

Trying to predict future sales on Kaggle

Rossmann Store Sales

Interview with winner

Kaggle Blog – Medium

Impute Data with R’s Amelia
(I have an article about Amelia and time series imputation somewhere in the internal forum at the office, might look that one up)

using amelia to deal with missing values

I used R’s Amelia to impute a few missing values. I have attached a sample workflow. The steps basically are: you have a flat file with a variable “Target” 0/1 and string as well as numeric variables you decide which variables need imputation (the blue frames) you create an artificial ID variable you send the data you want to impute to R and Amelia and run 10 iterations you read back the resulting CSV file into KNIME and take the mean value as the newly imputed value you bring back together th…

Tutorial on 5 Powerful R Packages used for imputing missing values