ConfusionMatrix Example - Teradata Vantage

Input

The input table, iris_category_expect_predict, contains 30 rows of expected and predicted values for different species of the flower iris. The predicted values can be derived from any of the classification functions, such as SparseSVMPredictor. The raw iris data set has four prediction attributes - sepal_length, sepal_width, petal_length, petal_width grouped into 3 species - setosa, versicolor, virginica.

SQL Call

SELECT * FROM ConfusionMatrix (
  ON iris_category_expect_predict PARTITION BY 1
  OUT TABLE CountTable (count_output)
  OUT TABLE StatTable (stat_output)
  OUT TABLE AccuracyTable (acc_output)
  USING
  ObservationColumn ('expected_value')
  PredictColumn ('predicted_value')
) AS dt;

Output

Success !
The result has been outputted to output tables

This query returns the following table:

SELECT * FROM count_output;

This query returns the following table:

SELECT * FROM stat_output;

This query returns the following table:

SELECT * FROM acc_output;