7.00.02 - Input - 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)

The input table of test data, computers_test1, contains attributes of personal computers (price, speed, hard disk size, RAM, and screen size). This table has over 1000 rows. If a row contains a null value, KMeansPlot assigns the cluster ID -1 to that row.

The table of cluster centroids, kmeanssample_centroid, was output by the KMeans function.

KMeansPlot Example Input Table computers_test1
id price speed hd ram screen
10 2575 50 210 4 15
11 2195 33 170 8 15
15 2699 50 212 8 14
29 3095 33 340 16 14
30 3244 66 245 8 14
38 3795 66 500 8 14
45 3495 50 340 16 14
46 2695 33 245 8 14
48 1749 25 120 4 14
51 2499 33 170 4 14
52 2395 33 130 4 14
59 2945 66 210 8 17
65 2195 66 85 2 14
66 1495 25 170 4 14
70 3095 66 245 8 14
86 1999 33 120 8 14
91 2975 50 210 4 17
92 2145 66 130 4 14
93 2420 33 170 8 15
94 2505 50 210 8 14
104 2999 66 330 4 15
... ... ... ... ... ...
KMeansPlot Example Input Table kmeanssample_centroid
clusterid price speed hd ram screen size withinss
0 2224.57057057057 51.7417417417417 335.113113113113 6.63863863863864 14.5755755755756 999 31124476.9549561
1 1854.76587795766 42.0884184308842 195.638854296389 4.01743462017435 14.3013698630137 803 14330020.7995024
2 1799.80802792321 59.4502617801047 521.869109947644 7.0087260034904 14.6212914485166 573 21619217.6753922
3 2692.29752953813 55.0601503759398 406.770139634801 10.2556390977444 14.7948442534909 931 41217046.99893
4 1452.08707482993 38.9197278911565 236.696598639456 3.94285714285714 14.2068027210884 735 22305606.1986394
5 2327.02958579882 65.491124260355 897.396449704142 14.9585798816568 15.1479289940828 338 22052669.0769224
6 3060.36743215031 62.6179540709812 784.100208768267 18.321503131524 14.8329853862213 479 62626318.7348671
7 3812.38 62.92 543.633333333333 11.8133333333333 15.3066666666667 150 29785847.880002