Output - Aster Analytics

Teradata Aster Analytics Foundation User Guide

Product
Aster Analytics
Release Number
6.21
Published
November 2016
Language
English (United States)
Last Update
2018-04-14
dita:mapPath
kiu1466024880662.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1021
lifecycle
previous
Product Category
Software

The function call creates two tables, a model table 'iris_attribute_output' and an intermediate splits table 'splits_small'.

Single_Tree_Drive Example 1 Output Message
message
Input tables:"iris_attribute_train", "iris_response_train"

Output model table: "iris_attribute_output"

Depth of the tree is:6

The following query returns the output shown in the table iris_attribute_output:

SELECT * FROM iris_attribute_output ORDER BY 1;
Single_Tree_Drive Example 1 Output Table iris_attribute_output (Columns 1-6)
node_id node_size node_gini(p) node_entropy node_chisq_pv node_label
0 120 0.666666666666667 1.58496250072116 1 1
2 80 0.5 1 1 2
5 39 0.0499671268902038 0.172036949353113 1 2
6 41 0.0928019036287924 0.281193796432043 1 3
14 37 0.0525931336742148 0.179256066928321 1 3
30 24 0.0798611111111112 0.249882292833186 1 3
61 14 0.13265306122449 0.371232326640875 1 3
Single_Tree_Drive Example 1 Output Table iris_attribute_output (Columns 7-11)
node_majorvotes split_value split_gini(p) split_entropy split_chisq_pv
40 3 0.333333333333333 0.666666666666666 0
40 1.70000004768372 0.0719199499687304 0.227979833481065 1.11022302462516e-16
38 4.90000009536743 0.0384615384615385 0.0832080127650393 0.00272911340977045
39 4.90000009536743 0.0840474620962426 0.240916755467913 0.0492232443463754
36 2.90000009536743 0.0518018018018018 0.162085811567472 0.455587679837851
23 3.20000004768372 0.0773809523809524 0.216552190540511 0.387955122826146
13 6.30000019073486 0.131868131868132 0.363297594798595 0.773484680980946
Single_Tree_Drive Example 1 Output Table iris_attribute_output (Columns 12-19)
left_id left_size left_label left_majorvotes right_id right_size right_label right_majorvotes
1 40 1 40 2 80 2 40
5 39 2 38 6 41 3 39
11 35 2 35 12 4 2 3
13 4 3 3 14 37 3 36
29 13 3 13 30 24 3 23
61 14 3 13 62 10 3 10
123 1 3 1 124 13 3 12
Single_Tree_Drive Example 1 Output Table iris_attribute_output (Columns 20-22)
left_bucket right_bucket attribute
    petal_length
    petal_width
    petal_length
    petal_length
    sepal_width
    sepal_width
    sepal_length

The following query returns the output shown in the following table:

SELECT * FROM splits_small ORDER BY 1;
Single_Tree_Drive Example 1 Output Table splits_small
attribute percentile attrvalue
petal_length 33.3333333333333 3
petal_length 66.6666666666667 4.90000009536743
petal_length 100 6.90000009536743
petal_width 33.3333333333333 1
petal_width 66.6666666666667 1.70000004768372
petal_width 100 2.5
sepal_length 33.3333333333333 5.40000009536743
sepal_length 66.6666666666667 6.30000019073486
sepal_length 100 7.90000009536743
sepal_width 33.3333333333333 2.90000009536743
sepal_width 66.6666666666667 3.20000004768372
sepal_width 100 4.40000009536743