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 test table, housing_test, is test data on a sample of 54 homes. The example uses the Gaussian model glm_housing_model from GLM Example 3 to evaluate the prediction for these new homes, comparing the prediction with the original price information with root mean square error evaluation (RMSE).

GLMPredict Example 2 Input Table housing_test (Columns 1-7)
sn price lotsize bedrooms bathrms stories driveway
13 27000 1700 3 1 2 yes
16 37900 3185 2 1 1 yes
25 42000 4960 2 1 1 yes
38 67000 5170 3 1 4 yes
53 68000 9166 2 1 1 yes
104 132000 3500 4 2 2 yes
111 43000 5076 3 1 1 no
117 93000 3760 3 1 2 yes
132 44500 3850 3 1 2 yes
140 43000 3750 3 1 2 yes
142 40000 2650 3 1 2 yes
157 60000 2953 3 1 2 yes
161 63900 3162 3 1 2 yes
... ... ... ... ... ... ...
GLMPredict Example 2 Input Table housing_test (Columns 8-14)
recroom fullbase gashw airco garagepl prefarea homestyle
no no no no 0 no Classic
no no no yes 0 no Classic
no no no no 0 no Classic
no no no yes 0 no Eclectic
no yes no yes 2 no Eclectic
no no yes no 2 no bungalow
no no no no 0 no Classic
no no yes no 2 no Eclectic
no no no no 0 no Classic
no no no no 0 no Classic
no yes no no 1 no Classic
no yes no yes 0 no Eclectic
no no no yes 1 no Eclectic
... ... ... ... ... ... ...