The input table contains data about houses—categorical data in the column type and numerical data in the columns price, lotsize, bedrooms, bathrooms, and stories. The column id identifies the rows. The table has some NULL values.
type | id | price | lotsize | bedrooms | bathrms | stories |
---|---|---|---|---|---|---|
classic | 1 | 42000 | 5850 | 3 | 1 | 2 |
classic | 2 | 4000 | 2 | 1 | 1 | |
classic | 3 | 49500 | 3060 | 3 | 1 | 1 |
classic | 4 | 60500 | 6650 | 3 | 1 | 2 |
classic | 5 | 61000 | 6360 | 2 | 1 | 1 |
bungalow | 6 | 66000 | 4160 | 2 | 1 | 1 |
bungalow | 7 | 66000 | 3880 | 2 | 2 | |
bungalow | 8 | 69000 | 4160 | 3 | 1 | 3 |
bungalow | 9 | 83800 | 4800 | 3 | 1 | 1 |
bungalow | 10 | 88500 | 5500 | 3 | 2 | 4 |