7.00.02 - Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
KMeans Example 4 Results Message Table
clusterid price speed hd ram screen size withinss
0 1510.0854271357 39.9145728643 239.6783919598 3.9939698492 14.224120603 995 3.78087315477371E7
1 3804.3660130719 63.5294117647 555.9346405229 11.8954248366 15.2679738562 153 2.9924035307189E7
2 2450.5174180328 53.5676229508 375.3278688525 8.3114754098 14.6270491803 976 3.3481207880125E7
3 2347.8198198198 64.7027027027 880.2702702703 14.9189189189 15.1681681682 333 1.99780178258257E7
4 2008.3631889764 44.7716535433 230.8828740157 4.7933070866 14.3818897638 1016 2.92639514901571E7
5 3003.3223140496 60.8595041322 1077.520661157 23.0743801653 14.9752066116 242 1.98665569917355E7
6 2941.2778625954 60.0106870229 445.1160305344 12.2320610687 14.8595419847 655 2.93420013404598E7
7 1863.894984326 59.8761755486 523.7539184953 7.1849529781 14.6943573668 638 2.41424811222563E7
  Converged: False    
  NumberofIterations: 10    
  Numberofclusters: 8    
  Outputtable: "kmeanssample_output"    
  ClusteredOutputtable: "kmeanssample_clusteredoutput"    
  Total_WithinSS: 2.2380698350548548E8    
  Between_SS: 1.8147805090194747E9    

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

SELECT * FROM kmeanssample_output ORDER BY clusterid;
KMeans Example 4 Output Table kmeanssample_output
clusterid price speed hd ram screen size withinss
0 1510.08542713568 39.9145728643216 239.678391959799 3.99396984924623 14.2241206030151 995 37808731.5477371
1 3804.3660130719 63.5294117647059 555.934640522876 11.8954248366013 15.2679738562092 153 29924035.307189
2 2450.51741803279 53.5676229508197 375.327868852459 8.31147540983607 14.6270491803279 976 33481207.880125
3 2347.81981981982 64.7027027027027 880.27027027027 14.9189189189189 15.1681681681682 333 19978017.8258257
4 2008.36318897638 44.7716535433071 230.882874015748 4.79330708661417 14.3818897637795 1016 29263951.4901571
5 3003.32231404959 60.8595041322314 1077.52066115702 23.0743801652893 14.9752066115702 242 19866556.9917355
6 2941.27786259542 60.0106870229008 445.116030534351 12.2320610687023 14.8595419847328 655 29342001.3404598
7 1863.89498432602 59.8761755485893 523.753918495298 7.18495297805643 14.6943573667712 638 24142481.1222563

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

SELECT * FROM kmeanssample_clusteredoutput ORDER BY id;
KMeans Example 4 Output Table kmeanssample_clusteredoutput
id clusterid
1 0
2 4
3 0
4 4
5 6
6 1
7 0
8 4
9 4
12 2
13 4
14 2
16 4
17 0
18 2
19 4
20 1
... ...