ConfusionMatrix Output - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.10
1.1
Published
October 2019
Language
English (United States)
Last Update
2019-12-31
dita:mapPath
ima1540829771750.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

Output Message Schema

Column Data Type Description
message VARCHAR Reports whether function succeeded and output result to output tables.

CountTable Schema

This table is a confusion matrix (also called a contingency table).

Column Data Type Description
observation VARCHAR Unique value of observed_column in input table.
predicted_class VARCHAR [Column appears once for each specified class.] Number of times that items in observed_column were classified as predicted_class.

StatTable Schema

This table has overall statistics.

Column Data Type Description
key VARCHAR Statistic name from this list:
  • Accuracy
  • 95% CI
  • Null Error Rate
  • P-Value [Acc > NIR]
  • Kappa
  • McNemar Test P-Value

For formulas function uses for Kappa and Null Error Rate, see ConfusionMatrix Output.

value VARCHAR Statistic value.

AccuracyTable Schema

Column Data Type Description
measure VARCHAR Each row contains one of these statistic names:
  • Sensitivity
  • Specificity
  • Pos Pred Value
  • Neg Pred Value
  • Prevalence
  • Detection Rate
  • Detection Prevalence
  • Balanced Accuracy

For formulas function uses for these statistics, see ConfusionMatrix Output.

predicted_class VARCHAR Values of statistics for class.

With Classes syntax element, column appears once for each specified class. Without Classes syntax element, column appears once for each unique observed_column value.