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