clusterid | price speed hd ram screen | size | withinss |
---|---|---|---|
0 | 2861.5646437995 57.7915567282 428.9525065963 11.746701847 14.7941952507 | 758 | 3.23717069498672E7 |
1 | 1463.1038461539 39.1371794872 236.5679487179 3.9282051282 14.208974359 | 780 | 2.45706992256417E7 |
2 | 2392.8843069874 52.4788087056 334.5612829324 7.3195876289 14.5841924399 | 873 | 2.60713860412369E7 |
3 | 3636.914893617 65.4723404255 615.4042553191 13.6340425532 15.1276595745 | 235 | 5.03470581617022E7 |
4 | 2095.0655462185 53.6352941176 512.6991596639 8.6588235294 14.7210084034 | 595 | 2.04614168806725E7 |
5 | 2689.9612756264 62.9225512528 980.2961275626 19.5353075171 15.15261959 | 439 | 5.32294371890669E7 |
6 | 1762.2406947891 64.9081885856 595.4863523573 7.0967741935 14.682382134 | 403 | 1.95361545012407E7 |
7 | 1891.4 42.9837837838 197.0627027027 4.08 14.3221621622 | 925 | 2.13319771956758E7 |
Converged: False | |||
NumberofIterations: 10 | |||
Numberofclusters: 8 | |||
Outputtable: "kmeanssample_centroid" | |||
Total_WithinSS: 2.479198361451039E8 | |||
Between_SS: 1.790667656379848E9 |
The following query returns the output shown in the following table:
SELECT * FROM kmeanssample_centroid;
clusterid | price speed hd ram screen | size | withinss |
---|---|---|---|
0 | 2861.5646437995 57.7915567282 428.9525065963 11.746701847 14.7941952507 | 758 | 3.23717069498672E7 |
1 | 1463.1038461539 39.1371794872 236.5679487179 3.9282051282 14.208974359 | 780 | 2.45706992256417E7 |
2 | 2392.8843069874 52.4788087056 334.5612829324 7.3195876289 14.5841924399 | 873 | 2.60713860412369E7 |
3 | 3636.914893617 65.4723404255 615.4042553191 13.6340425532 15.1276595745 | 235 | 5.03470581617022E7 |
4 | 2095.0655462185 53.6352941176 512.6991596639 8.6588235294 14.7210084034 | 595 | 2.04614168806725E7 |
5 | 2689.9612756264 62.9225512528 980.2961275626 19.5353075171 15.15261959 | 439 | 5.32294371890669E7 |
6 | 1762.2406947891 64.9081885856 595.4863523573 7.0967741935 14.682382134 | 403 | 1.95361545012407E7 |
7 | 1891.4 42.9837837838 197.0627027027 4.08 14.3221621622 | 925 | 2.13319771956758E7 |