27
$\begingroup$

What's the best way to split time series data into train/test/validation sets, where the validation set would be used for hyperparameter tuning?

We have 3 years' worth of daily sales data, and our plan is to use 2015-2016 as the training data, then randomly sample 10 weeks from the 2017 data to be used as the validation set, and another 10 weeks from 2017 data for the test set. We'll then do a walk forward on each of the days in the test and validation set.

$\endgroup$

3 Answers 3

26
$\begingroup$

You should use a split based on time to avoid the look-ahead bias. Train/validation/test in this order by time.

The test set should be the most recent part of data. You need to simulate a situation in a production environment, where after training a model you evaluate data coming after the time of creation of the model. The random sampling you use for validation and training is therefore not good idea.

$\endgroup$
1
  • $\begingroup$ Note that there's a con to ordering training and validation sets strictly in time: there will be a gap between training and testing sets, meaning the relationship between training and validation sets will not be the same as the relationship between training and testing sets. An alternative is to sample testing set as the latest x samples. Then randomly sample training and validation sets from the remaining data. $\endgroup$ Commented May 3, 2023 at 18:06
19
$\begingroup$

I think the most complete way to leverage your time-series data for training/validation/testing/prediction is this:

enter image description here

Is the picture self explanatory? If not, please comment and I will add more text...

$\endgroup$
6
  • 1
    $\begingroup$ I found your chart very useful, as I'm in trouble with the same topic. 1.Not sure I got the second step of the chart. What do the V and T squares mean? V should not always be later than T? 2.are we saying that, after best model selection, for tomorrow's forecast, we use all data and get the right parameters using the best model, but using the full data-set ? Thanks! Gioele $\endgroup$
    – Gioele
    Commented Feb 18, 2021 at 14:17
  • 3
    $\begingroup$ Where does this picture come from ? $\endgroup$
    – manu190466
    Commented Feb 18, 2021 at 14:42
  • 1
    $\begingroup$ @Gioele 1. T=Training samples V=Validation samples. 2. yes, you try to reuse the historical data as much as possible, first to select the best model and then to fit the best model. $\endgroup$
    – elemolotiv
    Commented Feb 19, 2021 at 22:30
  • 2
    $\begingroup$ @manu190466 it's my personal attempt to combine available approaches: cross-validation to select the best model today, backtest to fit the selected model, walkforward analysis to check if the whole idea would have worked in history, day after day until today $\endgroup$
    – elemolotiv
    Commented Feb 19, 2021 at 22:33
  • $\begingroup$ Hm... I think a bit of an issue is in this graph. IT assumes we have decided on the best model beforehand. If we know which model we want to use, this graph is fine and we just report its performance; if we try to use this graph/schematic to compare models though and then report the performance of the best model then this graph has an optimism issue. That is because the model performance is reported using the same dataset used to select the best model, so we have "overfitted" that dataset. $\endgroup$
    – usεr11852
    Commented Oct 20, 2022 at 15:07
8
$\begingroup$

"walk-forward"

In the following, "validation set" was replaced with "testing set" to be aligned with the naming in this Q/A.

Instead of creating only one set of a training/testing set, you could create more of such sets.

The first training set could be, say, 6 months data (first semester of 2015) and the testing set would then be the next three months (July-Aug 2015). The second training set would be a combination of the first training and testing set. The testing set is then the next three months (Sept-Oct 2015). And so on.

This walk over time is a bit like the k-fold cross-validation where the training sets are a combination of the previous training and validation set, and that put together. Only that in this model, this happens by walking through time to check more than one prediction, and in this model, the training and testing set are put together, not the training and validation set. You have validation by default, in the model, if you walk through time with more than one prediction. The metrics of these predictions can be put against each other.

This is the walk-forward model, see a comment below. The model image mixes up testing set with validation set. Normally, this naming issue does not matter, but here, it does, since it stands against the naming of the rest. If you then allow to make an additional k-fold validation from the testing set, you have the three sets that the question asks for. And yes, you do not need that validation set if you make a "walk-forward" with enough steps.

Thus, even if this model needs only training and testing set, it can still be an answer to the question that asks for the three sets. Since the validation set can be seen as being replaced by the "walk-forward". And it still also allows small k-fold validation as splits from the testing set, so that you could see it as 3+1 sets in the end.

$\endgroup$
4
  • 3
    $\begingroup$ Downvote. The training set is split "k-fold" into training and validation set (T&V in the image of the other answer), no need to put the validation set at the end of time, since then, you always lose the most recent months for training the model and sacrifice them just to get the best validation during training. This will make the model training set "outdated" in relation to the testing set's evaluations. Validation should accompany the training set and not create a new full split, therefore "cross-validation". You recommend an uncrossed "end-of-training-time validation", not recommended! $\endgroup$ Commented May 22, 2021 at 20:51
  • $\begingroup$ This method is called walk forward. In the last "fold", you can remove validation and use all data as training data. That way, it use the latest data. See this explanation: towardsdatascience.com/… $\endgroup$ Commented Apr 2, 2022 at 2:40
  • $\begingroup$ @MuhammadYasirroni I searched for this "walk forward" name for so long, see Does the training+testing set have to be different from the predicting set (so that you need to apply a time-shift to ALL columns)? - Stack Overflow!! The model has just two sets, against the question (and calls "test set" a "validation set"...). It is surely the best model for labels that become features afterwards. No validation set needed, but k-fold can be split from the testing set as long as the test data stays biased "forward" in time. Will upvote again at edit. $\endgroup$ Commented Jan 6, 2023 at 1:16
  • $\begingroup$ See Can / should I use past (e.g. monthly) label columns from a database as features in an ML prediction (no time-series!)? for the main "walk-forward" image with changed namings on it so that validation set is not mixed up with the testing set. $\endgroup$ Commented Jan 6, 2023 at 17:48

Not the answer you're looking for? Browse other questions tagged or ask your own question.