Date Duplication in time series forecasting

Sunayana_Parikh
Level 1
Date Duplication in time series forecasting

Hello There, 

I am working on data having multiple orders at same date-time because those orders were placed in bunch so how could i solve duplicate datetime issue in this case to have proper data for time series forecasting. 

Thank you so much in advance


Operating system used: windows


Operating system used: windows

0 Kudos
1 Reply
StanG
Dataiker

Hi,

In the time series forecasting page, there is a Duplicate timestamps handling parameter that allows you to drop these duplicated timestamps or take their average value. This happens during the resampling.

However, in your case, if you want to forecast the total sales per day (sum all orders in a day) for instance, you should probably first create a column with dates truncated to a day frequency and then do a groupby recipe (groupby per day and take the sum of orders amounts) before forecasting.

 

 

Labels

?
Labels (1)
A banner prompting to get Dataiku