# 4 Common Machine Learning Data Transforms for Time Series Forecasting

Time series data often requires some preparation prior to being modeled with machine learning algorithms.

For example, differencing operations can be used to remove trend and seasonal structure from the sequence in order to simplify the prediction problem. Some algorithms, such as neural networks, prefer data to be standardized and/or normalized prior to modeling.

Any transform operations applied to the series also require a similar inverse transform to be applied on the predictions. This is required so that the resulting calculated performance measures are in the same scale as the output variable and can be compared to classical forecasting methods.

In this post, you will discover how to perform and invert four common data transforms for time series data in machine learning.

After reading this post, you will know:

• How to transform and inverse the transform for four methods in Python.
• Important considerations when using transforms on training and test datasets.
• The suggested order for transforms when multiple operations are required on a dataset.

Kick-start your project with my new book Deep Learning for Time Series Forecasting, including step-by-step tutorials and the Python source code files for all examples.

Let’s get started. 4 Common Machine Learning Data Transforms for Time Series Forecasting
Photo by Wolfgang Staudt, some rights reserved.

## Overview

This tutorial is divided into three parts; they are:

1. Transforms for Time Series Data
2. Considerations for Model Evaluation
3. Order of Data Transforms

## Transforms for Time Series Data

Given a univariate time series dataset, there are four transforms that are popular when using machine learning methods to model and make predictions.

They are:

• Power Transform
• Difference Transform
• Standardization
• Normalization

Let’s take a quick look at each in turn and how to perform these transforms in Python.

We will also review how to reverse the transform operation as this is required when we want to evaluate the predictions in their original scale so that performance measures can be compared directly.

Are there other transforms you like to use on your time series data for modeling with machine learning methods?
Let me know in the comments below.

### Need help with Deep Learning for Time Series?

Take my free 7-day email crash course now (with sample code).

Click to sign-up and also get a free PDF Ebook version of the course.

### Power Transform

A power transform removes a shift from a data distribution to make the distribution more-normal (Gaussian).

On a time series dataset, this can have the effect of removing a change in variance over time.

Popular examples are the log transform (positive values) or generalized versions such as the Box-Cox transform (positive values) or the Yeo-Johnson transform (positive and negative values).

For example, we can implement the Box-Cox transform in Python using the boxcox() function from the SciPy library.

By default, the method will numerically optimize the lambda value for the transform and return the optimal value.

The transform can be inverted but requires a custom function listed below named invert_boxcox() that takes a transformed value and the lambda value that was used to perform the transform.

A complete example of applying the power transform to a dataset and reversing the transform is listed below.

Running the example prints the original dataset, the results of the power transform, and the original values (or close to it) after the transform is inverted.

### Difference Transform

A difference transform is a simple way for removing a systematic structure from the time series.

For example, a trend can be removed by subtracting the previous value from each value in the series. This is called first order differencing. The process can be repeated (e.g. difference the differenced series) to remove second order trends, and so on.

A seasonal structure can be removed in a similar way by subtracting the observation from the prior season, e.g. 12 time steps ago for monthly data with a yearly seasonal structure.

A single differenced value in a series can be calculated with a custom function named difference() listed below. The function takes the time series and the interval for the difference calculation, e.g. 1 for a trend difference or 12 for a seasonal difference.

Again, this operation can be inverted with a custom function that adds the original value back to the differenced value named invert_difference() that takes the original series and the interval.

We can demonstrate this function below.

Running the example prints the original dataset, the results of the difference transform, and the original values after the transform is inverted.

Note, the first “interval” values will be lost from the sequence after the transform. This is because they do not have a value at “interval” prior time steps, therefore cannot be differenced.

### Standardization

Standardization is a transform for data with a Gaussian distribution.

It subtracts the mean and divides the result by the standard deviation of the data sample. This has the effect of transforming the data to have mean of zero, or centered, with a standard deviation of 1. This resulting distribution is called a standard Gaussian distribution, or a standard normal, hence the name of the transform.

We can perform standardization using the StandardScaler object in Python from the scikit-learn library.

This class allows the transform to be fit on a training dataset by calling fit(), applied to one or more datasets (e.g. train and test) by calling transform() and also provides a function to reverse the transform by calling inverse_transform().

A complete example is applied below.

Running the example prints the original dataset, the results of the standardize transform, and the original values after the transform is inverted.

Note the expectation that data is provided as a column with multiple rows.

### Normalization

Normalization is a rescaling of data from the original range to a new range between 0 and 1.

As with standardization, this can be implemented using a transform object from the scikit-learn library, specifically the MinMaxScaler class. In addition to normalization, this class can be used to rescale data to any range you wish by specifying the preferred range in the constructor of the object.

It can be used in the same way to fit, transform, and inverse the transform.

A complete example is listed below.

Running the example prints the original dataset, the results of the normalize transform, and the original values after the transform is inverted.

## Considerations for Model Evaluation

We have mentioned the importance of being able to invert a transform on the predictions of a model in order to calculate a model performance statistic that is directly comparable to other methods.

Additionally, another concern is the problem of data leakage.

Three of the above data transforms estimate coefficients from a provided dataset that are then used to transform the data. Specifically:

• Power Transform: lambda parameter.
• Standardization: mean and standard deviation statistics.
• Normalization: min and max values.

These coefficients must be estimated on the training dataset only.

Once estimated, the transform can be applied using the coefficients to the training and the test dataset before evaluating your model.

If the coefficients are estimated using the entire dataset prior to splitting into train and test sets, then there is a small leakage of information from the test set to the training dataset. This can result in estimates of model skill that are optimistically biased.

As such, you may want to enhance the estimates of the coefficients with domain knowledge, such as expected min/max values for all time in the future.

Generally, differencing does not suffer the same problems. In most cases, such as one-step forecasting, the lag observations are available to perform the difference calculation. If not, the lag predictions can be used wherever needed as a proxy for the true observations in difference calculations.

## Order of Data Transforms

You may want to experiment with applying multiple data transforms to a time series prior to modeling.

This is quite common, e.g. to apply a power transform to remove an increasing variance, to apply seasonal differencing to remove seasonality, and to apply one-step differencing to remove a trend.

The order that the transform operations are applied is important.

Intuitively, we can think through how the transforms may interact.

• Power transforms should probably be performed prior to differencing.
• Seasonal differencing should be performed prior to one-step differencing.
• Standardization is linear and should be performed on the sample after any nonlinear transforms and differencing.
• Normalization is a linear operation but it should be the final transform performed to maintain the preferred scale.

As such, a suggested ordering for data transforms is as follows:

1. Power Transform.
2. Seasonal Difference.
3. Trend Difference.
4. Standardization.
5. Normalization.

Obviously, you would only use the transforms required for your specific dataset.

Importantly, when the transform operations are inverted, the order of the inverse transform operations must be reversed. Specifically, the inverse operations must be performed in the following order:

1. Normalization.
2. Standardization.
3. Trend Difference.
4. Seasonal Difference.
5. Power Transform.

This section provides more resources on the topic if you are looking to go deeper.

## Summary

In this post, you discovered how to perform and invert four common data transforms for time series data in machine learning.

Specifically, you learned:

• How to transform and inverse the transform for four methods in Python.
• Important considerations when using transforms on training and test datasets.
• The suggested order for transforms when multiple operations are required on a dataset.

Do you have any questions?

## Develop Deep Learning models for Time Series Today! #### Develop Your Own Forecasting models in Minutes

...with just a few lines of python code

Discover how in my new Ebook:
Deep Learning for Time Series Forecasting

It provides self-study tutorials on topics like:
CNNs, LSTMs, Multivariate Forecasting, Multi-Step Forecasting and much more...

### 89 Responses to 4 Common Machine Learning Data Transforms for Time Series Forecasting

1. Grace Wang September 13, 2018 at 7:33 pm #

Thank you so much. I want to know how to use Yeo-Johnson transform, because my data contains negative values.

• Jason Brownlee September 14, 2018 at 6:35 am #

Sorry, I don’t have a worked example at this stage.

2. mk December 29, 2018 at 1:18 pm #

If I split own dataset into 6 parts by signal processing,each part use Normalization.How to make sure scale.

• Jason Brownlee December 30, 2018 at 5:36 am #

Perhaps prepare any data scaling on training data only.

3. mk December 29, 2018 at 1:46 pm #

If I have new datas out of train and test,how to deal with new datas as input for model.

• Jason Brownlee December 30, 2018 at 5:36 am #

Prepare new data in the same way as the training dat prior to using it as input for making a prediction.

• mk December 31, 2018 at 11:40 pm #

How to find my reply?I can‘t find my reply in the Website after shutting down Browser.

• Firas August 8, 2019 at 11:25 am #

use the sane aproach and coeffeciebt that you have already utlized it to pre-processing training set data

4. Tharanga March 14, 2019 at 4:07 pm #

dear sir,

sir i used 2014-2019 data set to train a ML time series model.can i use that model for forecast new data set.

thank you.

• Jason Brownlee March 15, 2019 at 5:23 am #

Sure.

• Tharanga March 15, 2019 at 2:48 pm #

please can you send me some tutorials using R.

thank u.

• Jason Brownlee March 16, 2019 at 7:47 am #

Sorry, I don’t have time series forecasting tutorials in R.

I do have Python examples here:
https://machinelearningmastery.com/start-here/#timeseries

• Tharanga March 18, 2019 at 3:09 pm #

ok thank u.

5. Ahmed May 4, 2019 at 9:17 am #

I am quite confused about PT and Standard Scaling. Power Transform will (or at least should) give the same result as Standard Scaling as the primary goal for both of them is to make data follow the gaussian distribution.

What is the point of doing PT -> Standardization? Seems like they are essentially the same thing

• Ahmed May 4, 2019 at 9:52 am #

Jason,

I figured it out. Thank you.

• Jason Brownlee May 5, 2019 at 6:20 am #

No problem.

• Jason Brownlee May 5, 2019 at 6:20 am #

Not quite, power transform will shift the shape of the Gaussian, standardization will only force the data to a standard Gaussian – it could still be skewed.

6. SamFlynn May 16, 2019 at 2:10 am #

Hi Jason,
Could trend differencing make results worse working with LSTM

I difference and then standardize the data in one case and the other is only standardizing.

https://imgur.com/a/fRSlWNM

Thanks!
Sam

• Jason Brownlee May 16, 2019 at 6:34 am #

It may or may not help. Try modeling with and without differencing and compare results.

7. ami May 24, 2019 at 5:55 pm #

Hi Jason,
We apply difference (data, interval) which data=TRAINING SET. After fitting we have a model in “difference” form. So, we need to convert them to the original data for training, validation and test sets (CALCULATED BY MODEL) to compare with observed data. We can use
invert_difference(orig_data, diff_data, interval) which
diff_data are available but we don’t have orig_data for all three sets! In fact, we invert the diff to calculate the original data!
Could you please explain it? Thanks

• Jason Brownlee May 25, 2019 at 7:44 am #

es, the differencing can be inverted on forecasts by propagating the inversion from training data through to test data, e.g. the last real observation from training will help to invert the first forecast observation.

• Sam October 11, 2019 at 10:34 am #

Do you have any example for this Jason?

• Jason Brownlee October 11, 2019 at 10:37 am #

Yes, the above tutorial does this.

8. Leen June 26, 2019 at 4:22 am #

Hello Jason,

Regarding standardization, if we have X_train, y_train, X_test, y_test:

1) if the problem is time series forecasting, and we have standardized X_train and X_test prior to fitting, should we inverse-standardize the training again prior to forecasting (after model.fit() and exactly before model.predict()) ? or should we inverse-standardize ONLY the forecasted values?

2) should we consider standardizing y_train and y_test ? or is it useless ? I have been reading around some codes here and there on the internet, and I find examples of both.

• Jason Brownlee June 26, 2019 at 6:46 am #

Scaling should be inverted on the predictions prior to estimating model performance.

We don’t need the inputs and the choice to invert or not invert them does not effect model skill.

If you’re unsure of whether to perform transform, then evaluate the model with and without it and compare skill.

• Sana May 20, 2020 at 7:38 pm #

Hi Jason,
how can I invert predictions before calculating the train error?

• Jason Brownlee May 21, 2020 at 6:15 am #

The above tutorial shows you.

• sana May 22, 2020 at 4:58 pm #

so I fit my model using the scaled data in the training set, calculate my predictions in the train set using the scaled train data, inverse scale the train predictions, then obtain the train mse using the inverse values of the actual train data set and the inverse values of the predicted train data set.
is this correct

• Jason Brownlee May 23, 2020 at 6:14 am #

Sounds good, I think!

9. Gizo August 12, 2019 at 4:47 am #

Thank you very much, Jason.

I am using a multivariate data for multistep time series prediction using python.
can i follow the same procedure as univariate? or use any other procedure?

Thanks.

• Jason Brownlee August 12, 2019 at 6:40 am #

Perhaps try and compare?

If there is dependency between the variates, then modeling them together will result in better performance.

10. Gizo August 12, 2019 at 3:57 pm #

i found an error on this code, (my data has 5 variables)

dataframe = DataFrame(series.values)
dataframe.columns = [‘P2P’, ‘IM’, ‘VoIP’, ‘Streaming’, ‘SNS’]
x = sqrt(dataframe.columns)

ValueError: Length mismatch: Expected axis has 1 elements, new values have 5 elements

• Jason Brownlee August 13, 2019 at 6:06 am #

The error suggests the data and the columns in your example do not match.

11. Elsa August 25, 2019 at 1:56 pm #

Jason, do you have any recommendations for time series classification’s data preparation? Thank you.

• Jason Brownlee August 26, 2019 at 6:09 am #

Yes, I have a few posts on the topic. Perhaps compare results with and without scaling the inputs, and with and without making the inputs stationary.

• Elsa August 26, 2019 at 10:08 am #

12. Carol September 27, 2019 at 1:46 am #

Hi, I have a time series with both negative and zero values, what to do for pre processing ?

I also have some values that looks like outliers, is there a way to substitue them for others, maybe for the mean between the neighboors?

• Jason Brownlee September 27, 2019 at 8:04 am #

Perhaps test a range of different data preparations.

Standardizing, normalizing, power transforms are a great start, and also making the series stationary.

Try removing candidate outliers and see if it improves the model.

13. Karan Sehgal October 8, 2019 at 8:56 pm #

Hi Jason,

Steps to be followed –

Power Transform.
Seasonal Difference.
Trend Difference.
Standardization.
Normalization.

1) My question is, do we need to create separate variables for all the above steps ( like Power Transformation for – 1st column, Seasonal Difference – 2nd Column and so on) or all the steps need to be followed for creating one column only ? and then we can create a lag out of that variable ?

2) Do we need to do the above steps on Y variables also ?

• Jason Brownlee October 9, 2019 at 8:13 am #

No, they are all applied to the same data.

Yes, the steps would be applied – as needed – to each variable.

• Karan Sehgal October 10, 2019 at 5:04 am #

Hi Jason,

I am still not clear with the above answer.

“they are all applied to the same data” so basically you mean to say that, I need to create one variable and should do all the transformation on that variable only – like (Power Transform, Seasonal Difference, Trend Difference, Standardization, Normalization) ?

Then the transformed variable will be used as Y and we will make X variables by making lagged variables of that Y variable ?

• Jason Brownlee October 10, 2019 at 7:06 am #

yes.

14. Karan Sehgal October 9, 2019 at 5:30 am #

HI JASON,

WE NEED TO TRANSFORM THE Y VARIABLE AND THEN USE THE LAGGED FORM OF Y VARIABLE AS X VARIABLES ?

• Jason Brownlee October 9, 2019 at 8:15 am #

Yes.

15. Jiggy October 30, 2019 at 9:17 pm #

Hi, I have a question, regarding scaling the data afterwards using inverse transform on the data.

When we train and test the LSTM model we get the predicted results but the results which we get are not the real value, they are scaled value. So how to get the real value back to compare the predicted results with the real data.

Thank you so much!

• Jason Brownlee October 31, 2019 at 5:28 am #

You must inverse the scaling on the test set and predictions then calculate error – as described above.

16. Siri December 12, 2019 at 5:09 am #

Hi Jason,

I am building my LSTM model with windows for the train and test data and was not able to obtain a good prediction when using the MinMaxScalar method fro prediction. The method I found is to normalize each window/segment by dividing every value of the window by the first one, so in this case the prediction of the last value will be the relative change with respect to the initial value of the window. However, I am not sure how to denormalize my data at the end.

• Jason Brownlee December 12, 2019 at 6:33 am #

Inverse the process you applied to normalize the data.

If you are unsure, perhaps play around with a standalone example in python or excel until you understand the forward and backward process.

17. Kasmiri May 1, 2020 at 4:14 am #

Great tutorial!

Jason can you please clear me that, can we transform our time series data into wavelet transform similarly to this tutorial?

• Jason Brownlee May 1, 2020 at 6:45 am #

Perhaps, I don’t have an example, sorry.

• Timi March 6, 2022 at 3:07 am #

Hi Kasmiri, Where you able to transform it

18. Mina May 26, 2020 at 3:15 pm #

Hello Jason, I have a dataset contains position of vehicles in the city sampled at every time interval, So this time series does not have any special pattern and it is not Gaussian and there is no seasonality. Can I use only normalization to re-scale my values

• Jason Brownlee May 27, 2020 at 7:43 am #

Perhaps try scaling the inputs and compare performance to a model fit on the raw data.

19. Jon June 6, 2020 at 1:23 am #

Thanks for integrating these different transforms all in one tutorial Jason. That’s really helpful, especially the order of them.

Do you discuss, anywhere on your site, which methods these might be used with and why? Is stationarity the only reason? Or is it about trying to maximise the signal:noise, in which case could we almost wrap any method inside a transform-inverse? Sorry if im being stupid and missing a really obvious point.

• Jon June 6, 2020 at 2:03 am #

Essentially are we trying to transform the training data closer to a Gaussian distrbution (in a way that can be methodically inverted) for algorithms and methods which assume or prefer that? And then possibly standardize and normalize that Gaussian distribution for those algos and methods which require it?

• Jason Brownlee June 6, 2020 at 7:57 am #

Yes, sure.

• Jason Brownlee June 6, 2020 at 7:55 am #

Great question.

I recommend the approach of using the transforms or sequences of transforms as treatments, test each and discover which results in a skilful model.

We don’t have good theories of what models/representations to use when and often good/best results come when expectations of algorithms are ignored or violated.

20. Jon June 10, 2020 at 1:40 am #

Thanks Jason. So rather than only exploring the problem situation manually via the potentially vast number of permutations of transformations (probably with visualizations), it might be worthwhile also pursuing something like:

forea permutation of transformations (which could be a very large number):
forea forecasting method you want to try:
fit the model

then compare the accuracy of all those?

What do you mean by “treatments” please?

• Jason Brownlee June 10, 2020 at 6:18 am #

Yes. Treatments are different ways of preparing the data in an attempt to best expose the unknown underlying structure of the problem to the learning algorithms.

• Jon June 19, 2020 at 11:30 pm #

With regards to wrapping model fitting inside a box of treatments, apart from all the possible combinations of transformations, i realise that of course some can be done multiple times, like differencing or taking logs. Does the order also matter, ie do we actually care about all permuations rather than just all combinations? Sorry, my brain is a bit fried today.

• Jason Brownlee June 20, 2020 at 6:14 am #

Yes, I think order matters and I suggest an order in the tutorial.

I don’t think multiple treatments are required.

• Jon June 19, 2020 at 11:40 pm #

Thanks for all the answers Jason. I hope you don’t mind the questions still coming. As a seperate question to the one above about whether order matters, i’ve also realised what a task automating these treatments could be, especially if we include a much wider set of possible tranformations. Do you know of some common / standard alogrithm for searching this space of transformation permutations?

• Jason Brownlee June 20, 2020 at 6:15 am #

Grid search is a good start, bayes optimization is common as is a random search. Can’t beat a GA/GP or even simple hill climber if you have a zillion options.

21. Jon June 10, 2020 at 1:56 am #

Are these transformations less useful for deep learning than for other machine learning methods, like regression and other statistical modelling methods?

• Jason Brownlee June 10, 2020 at 6:19 am #

Maybe. Modern neural nets are quite robust.

Try them and see.

• Jon June 13, 2020 at 1:39 am #

For neural nets, do transformations take away data which they could use to learn some complexity, ie transformations may even be undesirable in their case?

• Jason Brownlee June 13, 2020 at 6:08 am #

Perhaps, but almost certainly not.

• Marina June 17, 2020 at 7:57 am #

Hi Jon and Jason, I was actually going through all the comments looking for exactly the same as Jon’s question, because my stocks market prediction results improved 15-20% with lag-1 differencing on regression-type models and trees, but got substantially worse with a simple neural net (MLP). So far I haven’t tried RNN or combined methods, but so far it seems like NN didn’t like differencing and prefer going with scaling, with this particular problem. I will definitely build my study around having a robust “treatment boxes” system and try different permutations of them for different models.
Thank you both,
BR

• Jason Brownlee June 17, 2020 at 1:41 pm #

Happy to hear it.

Also, I don’t believe stocks can be predicted in a cost effective manner:
https://machinelearningmastery.com/faq/single-faq/can-you-help-me-with-machine-learning-for-finance-or-the-stock-market

• Marina August 4, 2020 at 8:39 pm #

Agree with you, thank you for your feedback. As for me, I’m only using stocks data from educational point of view. Actually I also got a technical question related to your article.
If we apply differencing to the whole dataset prior to splitting into training and validation and we keep the history value for the future inverse differencing, is it correct actually to use this history value to inverse-difference our predicted values from test set? Or do we need to keep history values for each train or test intervals?
Using the following example:
Original outcome: [3, 2, 5, 1, 6, 2, 7, 9, 8]
Entire differenced outcome: [-1, 3, -4, 5, -4, 5, 2, -1]
History value: 3
Outcome train: [-1, 3, -4, 5, -4, 5]
Outcome test: [ 2, -1]
Forecasted outcome: say it’s [1, -1]
How do I inverse difference this forecasted outcome only for the test set? I think using history value 3 would not be correct and we should use history value 7 (see the original outcome). Using 3 we would get and undifferenced predicted values [4, 2], while using 7 we would get [8, 6], there quite some difference.

Thank you very much in advance.

• Jason Brownlee August 5, 2020 at 6:10 am #

You can difference after the split, it can just be a pain. Perhaps you should to ensure you are avoiding leakage.

22. Lahan O October 2, 2020 at 4:11 am #

Hello Jason,
Do ypu have any advice for performing an inverse box-cox transform on a dataset when the optimal lambda given is in the -2 to -3 range. The error I get is that from the formula:
exp(log(lam * value + 1) / lam)
is that python cannot perform the log of a negative number and thus throws an error.

• Jason Brownlee October 2, 2020 at 6:04 am #

Perhaps add a constant to data prior to the log, then subtract after the invert.

23. Teun J. December 17, 2020 at 2:43 am #

Dear Mr. Brownlee,

I would like to determine the theoretical ‘current’ performance of an inventory system. In order to do this I want to determine the variance of this time series which has a trend and seasonality.

The time series is additive. Considering the above mentioned principles I was wondering if the variance is the same over all values? If not, is it possible to calculate the variance per period by also performing the inverse transform operations?

Kind regards,
Teun J.

• Jason Brownlee December 17, 2020 at 6:38 am #

Calculating variance for a single observation does not make sense to me, sorry. Not sure I can help.

24. Teun J. December 17, 2020 at 9:11 pm #

Dear Mr. Brownlee,

I am sorry for the unclear phrased question. I am not aiming to calculate the variance of a single observation. However, it seems odd to me to have the same variance in every time interval when the demand values differ a lot.

i.e. the variance is 100, in periods with a demand of 50 this is a lot more significant compared to periods with demand 500? I was wondering how to handle this.

Kind regards,
Teun J.

• Jason Brownlee December 18, 2020 at 7:17 am #

Sometimes a large variance in a variable can be addressed with a power transform. Perhaps try it and compare the resulting distribution to the distribution of the raw data.

25. Marc Duquesnoy February 23, 2021 at 2:13 am #

thank you for this nice explaination !

I am wondering if it make sense to inverse the logarithm value of the prediction (from a ML model) to get back to the original value ? I mean, physically speaking, does it make sense ?

Since when I got a trustable fitting model like log(y) = f(x), and I compare log(y_real) vs log(y_pred), I have a straight line as commly described a good model. But if I compared exponential of these values this totaly poor ! Thus I don’t really know if we are oblige to stay with the logarithm value

Best regards,

Marc

• Jason Brownlee February 23, 2021 at 6:23 am #

Yes. If you take the log, you need to e^x to get back to original units.

26. Fatima August 28, 2021 at 7:12 pm #

i am detecting anomaly on automated vehicles time series data, the data features are in-vehicle speed,GPS speed,in-vehicle acceleration,time series data have stationary. i want to know can i use difference preprocessing on automated vehicles data?thank you so much.

• Adrian Tam August 28, 2021 at 11:07 pm #

If you have stationary data, why you want to do difference? The data does not prevent you, but you need to justify why you want to do that.

27. shy-tan February 2, 2022 at 7:41 pm #

Hi Jason. Great explanation. Just one confusion, normally we use standardization and normalization with first splitting the data in train-test and then finding the mean and std metrics on just the train data for transformation. But this workflow for me doesn’t make sense for differencing transformation, I’m confused how to transform my data – before splitting or afterwards? I have found just one implementation of such code on Kaggle where the author has done transformation on the whole dataset before splitting. So I guess thats the way to go.

Also, I’ve been trying and coming up with different functions to transform my data but I get stuck at the inverse transform part. I have tried cumsum() and rolling sum with negative shifts but inverse transformations are not correct.

However, your code with modifications is working almost correctly – can I use your function in my project please?

• James Carmichael February 4, 2022 at 10:31 am #

Do Normalization after splitting into train and test/validation. The reason is to avoid any data leakage.

Data Leakage:

Data leakage is when information from outside the training dataset is used to create the model. This additional information can allow the model to learn or know something that it otherwise would not know and in turn invalidate the estimated performance of the mode being constructed.

28. Chris March 30, 2022 at 1:15 pm #

Hi Jason，
Really appreciate the content of your blog, they are wonderful.

I have a question that is not too clear about univariate time series forecasting, and that is how exactly is the order of dividing the data set, supervised processing, and normalizing the data?

• James Carmichael March 31, 2022 at 9:26 am #

29. Chris March 30, 2022 at 1:21 pm #

a=dividing the data set, b=supervised processing, and c=normalizing the data

My understanding of the order of the three of them is c-b-a

Not sure if this is correct

• James Carmichael March 31, 2022 at 9:25 am #

30. Chris March 30, 2022 at 2:52 pm #

Hi Jason,
In case you didn’t see my question, I’ll leave another message

First of all your blog content is really great, it really helps so many people!

My question is about the univariate multi-step prediction model, and I am not quite sure about the order of the following three steps:
a)Dividing the data set
b)Normalization data
c)Supervised processing
What exactly is the order of these three?

• 