Time series extrapolation with at least one row
I need to calculate the rolling average of orders by customers.
I'm working with the Time Series resampling recipe.
I have sometimes only one order for customers and in this case the extrapolation, with constant value = 0 after the order date, is not calculated.
how to have a calculated extrapolation with at least one row ?
Best Answer
-
Hi,
Series with only 1 row are ignored because interpolation on them is not possible, this is a known limitation. In our case, I'll advise you to manually create 2 extra rows for the first and last date with 0 as value for each series and select "no extrapolation" (but keep interpolation) to be sure they are all interpolated between these 2 dates only.
Answers
-
thanks for the advice
I understand that interpolation is not possible but I thought extrapolation worked.
Can you help me create these extra rows for each customer ?
-
I do it with a python recipe
that works
thanks