Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Time series extrapolation with at least one row
Added on October 17, 2023 1:43PM
Likes: 0
Replies: 3
EdBerth
Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 15 ✭✭✭
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