The updates in 9.9 power advanced use cases and offer productivity enhancements for users who prefer to code.


Why HoltWinters Forecast returns null?

DylanZZZDylanZZZ Member Posts: 2 Newbie
Simple Process

Only one attribute with no missing

Param of Holt-Winters

Param of Apply Forecast

However, it gives nan prediction

What happens??


  • DylanZZZDylanZZZ Member Posts: 2 Newbie
    I have figured out. That's because there are zeros in data. So, how to train model with zero value?
  • yyhuangyyhuang Administrator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 332  RM Data Scientist
    Hi @DylanZZZ,

    Glad to see you figured out by your self. The trick to handle zeros could be, re-scale data and add a small "error" to every example. For instance, using the formula

    b0*10+0.01   ------>> b0'

    to transform your original input b0, and make all zeros become 0.01 or even smaller (anything > 0 works).

    You will forecast the new re-scaled value, and inverse it back using (b0' - 0.01)/10

    Hope it helps.

  • David_ADavid_A Administrator, Moderator, Employee, RMResearcher, Member Posts: 270  RM Research

    I think the problem in your case is a combination of a very short seasonality value (are you sure about this, it would mean you have a pattern of length two in your data) and the zero values. In that case you will get segments in the model training, where very likely a division by zero or something similar happens.

Sign In or Register to comment.