Output - Aster Analytics

Teradata AsterĀ® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
lifecycle
previous
Product Category
Software
KModes Example 2 Output Table
set_id summary between_cluster_error total_within_cluster_error pseudo_f
0 Number of Clusters: 3 189.040612061326 110.959387951497 16.4690218375959
  Number of Iterations: 3      
  Model Converged: true      
  Number of Data Points: 32.0      

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

SELECT * FROM kmodes_clusters1 ORDER BY 1;
KModes Example 2 Output Table kmodes_clusters1 (Columns 1-6)
set_id cluster_id mpg disp hp drat
0 0 -0.6870185315 0.45206321975 1.576108211 0.338404144
0 1 -0.694038285461538 0.884442002384615 0.440990547615385 -1.03517409530769
0 2 0.7847047892 -0.887066594 -0.802487331133333 0.8069097776
KModes Example 2 Output Table kmodes_clusters1 (Columns 7-13)
wt qsec cyl vs am gear carb
0.122897527 -1.592803813 8 S manual 5 4
0.806587495538462 -0.0892693328461538 8 S automatic 3 2
-0.731815169933333 0.502114438733333 4 V manual 4 2
KModes Example 2 Output Table kmodes_clusters1 (Columns 14-17)
within_cluster_ss cluster_weight distance_metric category_weights
12.1398871106861 4 EUCLIDEAN, OVERLAP [1.0, 1.0, 1.0, 1.0, 1.0]
39.4522701602673 13    
59.3672306805433 15