Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

how to generate simple transaction forecast with spark?

how to generate simple transaction forecast with spark?

New Contributor


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.



Don't have an account?
Coming from Hortonworks? Activate your account here