Date Duplication in time series forecasting

Sunayana_Parikh
Sunayana_Parikh Registered Posts: 3

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

Answers

  • StanG
    StanG Dataiker, Registered Posts: 52 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.

Setup Info
    Tags
      Help me…