16.20 - DecisionTreePredict例2: ROCの入力の作成 - Teradata Vantage NewSQL Engine

Teradata Vantage™ - NewSQL Engineの分析関数

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
プログラミング リファレンス
featnum
B035-1206-162K-JPN

この例では、ML Engine ROC関数の入力を作成します。

SQL呼び出し

SELECT * FROM DecisionTreePredict (
  ON iris_attribute_test AS AttributeTable PARTITION BY pid ORDER BY attribute
  ON iris_attribute_output AS Model DIMENSION
  USING
  AttrTableGroupByColumns ('attribute')
  AttrTablePIDColumns ('pid')
  AttrTableValColumn ('attrvalue') 
  OutputResponseProbDist ('true')
  Responses ('1','2','3')
) AS dt ORDER BY pid;

出力

pid pred_label prob_for_label_1 prob_for_label_2 prob_for_label_3
5 1 0.95348 0.02326 0.02326
10 1 0.95348 0.02326 0.02326
15 1 0.95348 0.02326 0.02326
20 1 0.95348 0.02326 0.02326
25 1 0.95348 0.02326 0.02326
30 1 0.95348 0.02326 0.02326
35 1 0.95348 0.02326 0.02326
40 1 0.95348 0.02326 0.02326
45 1 0.95348 0.02326 0.02326
50 1 0.95348 0.02326 0.02326
55 2 0.02632 0.94736 0.02632
60 2 0.02632 0.94736 0.02632
65 2 0.02632 0.94736 0.02632
70 2 0.02632 0.94736 0.02632
75 2 0.02632 0.94736 0.02632
80 2 0.02632 0.94736 0.02632
85 2 0.02632 0.94736 0.02632
90 2 0.02632 0.94736 0.02632
95 2 0.02632 0.94736 0.02632
100 2 0.02632 0.94736 0.02632
105 3 0.06250 0.12500 0.81250
110 3 0.07692 0.07692 0.84616
115 3 0.06250 0.06250 0.87500
120 3 0.14286 0.57143 0.28571
125 3 0.07692 0.07692 0.84616
130 3 0.14286 0.57143 0.28571
135 3 0.14286 0.57143 0.28571
140 3 0.06250 0.12500 0.81250
145 3 0.07692 0.07692 0.84616
150 3 0.25000 0.25000 0.50000