Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
lifecycle
previous
Product Category
Software

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.