This query returns the following table:
SELECT * FROM shapelets_predict ORDER BY 1;
The column stock_category contains the original category.
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.