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 |