TD_ClassificationEvaluator Input Table
id observed_value predicted_value --- -------------- --------------- 5 setosa setosa 10 setosa setosa 15 setosa setosa 20 setosa setosa 25 setosa setosa 30 setosa setosa 35 setosa setosa 40 setosa setosa 45 setosa setosa 50 setosa setosa 55 versicolor versicolor 60 versicolor versicolor 65 versicolor versicolor 70 versicolor versicolor 75 versicolor versicolor 80 versicolor versicolor 85 virginica versicolor 90 versicolor versicolor 95 versicolor versicolor 100 versicolor versicolor 105 virginica virginica 110 virginica virginica 115 virginica virginica 120 versicolor virginica 125 virginica virginica 130 versicolor virginica 135 versicolor virginica 140 virginica virginica 145 virginica virginica 150 virginica virginica
TD_ClassificationEvaluator SQL Call
SELECT * FROM TD_ClassificationEvaluator (
ON iris_pred AS InputTable
OUT TABLE OutputTable (additional_metrics)
USING
ObservationColumn ('observed_value')
PredictionColumn ('predicted_value')
Labels ('setosa','versicolor','virginica')
) AS dt ORDER BY SeqNum;
TD_ClassificationEvaluator Output Table
Primary Output Table:
SeqNum Prediction Mapping CLASS_1 CLASS_2 CLASS_3 Precision Recall F1 Support ------ ----------- -------- -------- ------- -------- --------------------- --------------------- --------------------- -------- 0 setosa CLASS_1 10 0 0 1.00000000000000E 000 1.00000000000000E 000 1.00000000000000E 000 10 1 versicolor CLASS_2 0 9 1 9.00000000000000E-001 7.50000000000000E-001 8.18181818181818E-001 12 2 virginica CLASS_3 0 3 7 7.00000000000000E-001 8.75000000000000E-001 7.77777777777778E-001 8
TD_ClassificationEvaluator Output Table
Secondary Output Table:
SeqNum Metric MetricValue ------ -------------- ---------------------- 1 Accuracy 8.66666666666667E-001 2 Micro-Precision 8.66666666666667E-001 3 Micro-Recall 8.66666666666667E-001 4 Micro-F1 8.66666666666667E-001 5 Macro-Precision 8.66666666666667E-001 6 Macro-Recall 8.75000000000000E-001 7 Macro-F1 8.65319865319865E-001 8 Weighted-Precision 8.80000000000000E-001 9 Weighted-Recall 8.66666666666667E-001 10 Weighted-F1 8.68013468013468E-001