New Contributor
Posts: 1
Registered: ‎12-12-2017

how to generate simple transaction forecast with spark?


I am new to Spark, and I am trying to find the best and simplest way for providing some simple forecast for transactions.

Imagine I have a dataset (CSV) with fields as in the picture below, but with hundreds of products and dozens of clients.

How can I forecast what product (and ideally amount) will be ordered next week.



I have loaded the dataset in spark, I was also able to transpose the columns with rows, so that columns are: week of year, product, amount. I thought this may help for using time-series analysis like in but I couldn't find how to forecast the next event (week of year) for a product/client.


Any help how to proceed will be appreciated.