The input table contains information about houses. All columns have numeric data types. The first three columns represent numeric values, but the other columns represent codes or categories. The following two tables are the input table itself and its schema description, respectively.
sn | price | lotsize | driveway | recroom | fullbase | gashw | airco | prefarea | homestyle |
---|---|---|---|---|---|---|---|---|---|
1 | 27000 | 1700 | 1 | 0 | 0 | 0 | 0 | 0 | 1 |
2 | 37900 | 3185 | 1 | 0 | 0 | 0 | 1 | 0 | 1 |
3 | 42000 | 4960 | 1 | 0 | 0 | 0 | 0 | 0 | 1 |
4 | 67000 | 5170 | 1 | 0 | 0 | 0 | 1 | 0 | 2 |
5 | 68000 | 9166 | 1 | 0 | 1 | 0 | 1 | 0 | 2 |
6 | 132000 | 3500 | 1 | 0 | 0 | 1 | 0 | 0 | 3 |
7 | 43000 | 5076 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
8 | 93000 | 3760 | 1 | 0 | 0 | 1 | 0 | 0 | 2 |
9 | 44500 | 3850 | 1 | 0 | 0 | 0 | 0 | 0 | 1 |
10 | 43000 | 3750 | 1 | 0 | 0 | 0 | 0 | 0 | 1 |
... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
To check the input data variable types, use this query: \d categorize_input
The query returns:
Table "public"."categorize_input" Column | Type | Modifiers ------------------------------- sn | integer | price | real | lotsize | real | driveway | integer | recroom | integer | fullbase | integer | gashw | integer | airco | integer | prefarea | integer | homestyle | integer | Table Type: fact Distribution Key: sn Compression Level: none Storage Type: row Persistence: permanent