hi,
I am using timeseries algorithm.I am training my model like the following
Date StudId Perf
5/1/2005 001 99
5/10/005 001 97.6
6/1/2005 001 94
6/10/2005 001 99
6/30/005 001 96
10/1/2005 001 100
Like that.
I need prediction Output like following
Date StudId Perf
10/1/2005 001 99
11/10/005 001 97.6
12/1/2005 001 94
1/10/2006 001 99
... how to write prediction query for this.
Thanks
Karthik.
have you tried a statement like below?
SELECT FLATTENED PredictTimeSeries(Perf) FROM Model?
I assume your model has Date as KEY TIME and StuId as KEY, right?
|||yes bodgan,you are right.|||So, does the query I suggested work correctly? Or are there different kind of results that you are looking for?|||no bodgan,
the problem is the data.please look at the data, i am using to train and mt expected prediction result.I am expecting the prediction result so that the date values should be in a monthly interval.
Now I am getting results like this
Date StuId perf
10/1/2006 001 94
10/15/2006 001 99
11/10/2006 001 100
11/31/2006 001 75 Like that.
I need
Date StuId perf
10/1/2006 001 94
11/1/2006 001 99
12/1/2006 001 100
1/1/2007 001 75 Like that.
Thanks,
Karthik
|||I see. With the specified input, you cannot get these results. The forecasting works by predicting the next N steps of the series. In order to get the results you want, your inputs should use 10/1/2006, 11/1/2006 and so on. A solution could be to average the values, per month, for each student ID. After that, as long as your input contains one entry (per student) per month, the prediction will result in one result per month per student
No comments:
Post a Comment