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
Answers
-
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.
