2

My Data is in this format(Both Multiple and Multivariate Timeseries)

enter image description here

I need to predict number of units sold is gonna be for every product across different stores(Store 1,Store 2,Store 3) using time-series model.

I have scaled down the number for easeness.

I am fairly new to Time Series. Please help me with the approach I need to take to solve this problem

Reproducible Data

import pandas as pd
df = pd.DataFrame({'Date': ['01-01-2020', '01-01-2020', '02-01-2020', '02-01-2020', '03-01-2020'], 
'SKU': [1, 2, 1, 2, 1, 2],
'Store1': [10, 12, 11, 14, 12, 15],
'Store2': [20, 12, 19, 17, 17, 13],
'Store3': [11, 17, 17, 11, 18, 17]})
Praneeth Pragallapati
  • 39
  • 6
  • Could you be more specific. Are you saying given store 1,2,3 sell item SKU-1 at prices 10,20,11, what is the most likely value that store 4 sells item SKU-1? That isn't time-series. – Bobby Ocean May 10 '20 at 20:04
  • These are the units that were sold. for the SKUs 1 and 2 across stores 1-3. I need to predict the future units to be sold in these 3 stores – Praneeth Pragallapati May 10 '20 at 20:06
  • Yes, but my question isn't answered, what are you trying to predict? – Bobby Ocean May 10 '20 at 20:08
  • Please [provide a reproducible data example](https://stackoverflow.com/questions/20109391/how-to-make-good-reproducible-pandas-examples?noredirect=1&lq=1). [Stack Overflow Discourages Screenshots](https://meta.stackoverflow.com/questions/303812/discourage-screenshots-of-code-and-or-errors). It is likely the question will be downvoted. You are discouraging assistance because no one wants to retype your data or code, and screenshots are often illegible. – Trenton McKinney May 10 '20 at 20:08
  • Ah, I see I miss understood, let me rephrase the question, are you tying to predict the number of units sold at store 4, given the number of units sold at store 1,2,3? – Bobby Ocean May 10 '20 at 20:10
  • No. I am trying to predict the number of units sold at stores 1,2,3 for future dates(Based on historic date) for the SKU 1 and 2 – Praneeth Pragallapati May 10 '20 at 20:13

1 Answers1

0

You could try using deep learning, boosting models, among others For traditional time series you'd need to train one model for each combination product-store

Jose Maria Ramos Ugalde
  • 1
  • Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community May 05 '22 at 00:13