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 |
|
|