7.00.02 - Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Last Update
2018-04-17

This query returns the following table:

SELECT * FROM shapelets_predict ORDER BY 1;

The column stock_category contains the original category.

SupervisedShapeletClassifier Example Output Table shapelets_predict
id predicted_category stock_category
5 Technology Technology
5 Technology Technology
5 Technology Technology
5 Technology Technology
5 Technology Technology
5 Technology Technology
5 Technology Technology
5 Technology Technology
5 Technology Technology
5 Technology Technology
6 Technology Technology
6 Technology Technology
6 Technology Technology
6 Technology Technology
6 Technology Technology
6 Technology Technology
6 Technology Technology
6 Technology Technology
6 Technology Technology
6 Technology Technology
7 Healthcare Healthcare
7 Healthcare Healthcare
7 Healthcare Healthcare
7 Healthcare Healthcare
7 Healthcare Healthcare
7 Healthcare Healthcare
7 Healthcare Healthcare
7 Healthcare Healthcare
7 Healthcare Healthcare
7 Healthcare Healthcare
7 Healthcare Healthcare
8 Healthcare Healthcare
8 Healthcare Healthcare
8 Healthcare Healthcare
8 Healthcare Healthcare
8 Healthcare Healthcare
8 Healthcare Healthcare
8 Healthcare Healthcare
8 Healthcare Healthcare
8 Healthcare Healthcare

This query returns the prediction accuracy:

SELECT (SELECT COUNT(id) FROM shapelets_predict
  WHERE predicted_category = stock_category)/
    (SELECT COUNT(id) FROM shapelets_predict) AS prediction_accuracy;

prediction_accuracy
-------------------
1.00000000000000000000
(1 row)

The prediction accuracy is 100% because the predicted and original categories are the same.