# 3.17. Predicting House Prices on Kaggle¶

The previous chapters introduced a number of basic tools to build deep
networks and to perform capacity control using dimensionality, weight
decay and dropout. It’s time to put our knowledge to good use by
participating in a Kaggle competition. Predicting house
prices
is the perfect start, since its data is fairly generic and doesn’t have
much regular structure in the way text of images do. Note that the
dataset is *not* the Boston housing
dataset
of Harrison and Rubinfeld, 1978. Instead, it consists of the larger and
more fully-featured dataset of house prices in Ames, IA covering
2006-2010. It was collected by Bart de
Cock in 2011. Due to its
larger size it presents a slightly more interesting estimation problem.

In this chapter we will apply what we’ve learned so far. In particular, we will walk you through details of data preprocessing, model design, hyperparameter selection and tuning. We hope that through a hands-on approach you will be able to observe the effects of capacity control, feature extraction, etc. in practice. Such experience is vital if you want to become an experienced data scientist.

## 3.17.1. Kaggle¶

Kaggle is a popular platform for machine learning competitions. It combines data, code and users in a way to allow for both collaboration and competition. For instance, you can see the code that (some) competitors submitted and you can see how well you’re doing relative to everyone else. If you want to participate in one of the competitions, you need to register for an account. So it’s best to do this now.

On the House Prices Prediction page you can find the data set (under the data tab), submit predictions, see your ranking, etc.; You can find it at the URL below:

## 3.17.2. Accessing and Reading Data Sets¶

The competition data is separated into training and test sets. Each record includes the property values of the house and attributes such as street type, year of construction, roof type, basement condition. The data includes multiple datatypes, including integers (year of construction), discrete labels (roof type), floating point numbers, etc.; Some data is missing and is thus labeled ‘na’. The price of each house, namely the label, is only included in the training data set (it’s a competition after all). The ‘Data’ tab on the competition tab has links to download the data.

We will read and process the data using `pandas`

, an efficient data
analysis toolkit. Make
sure you have `pandas`

installed for the experiments in this section.

```
In [1]:
```

```
# If pandas is not installed, please uncomment the following line:
# !pip install pandas
%matplotlib inline
import d2l
from mxnet import autograd, gluon, init, nd
from mxnet.gluon import data as gdata, loss as gloss, nn
import numpy as np
import pandas as pd
```

For convenience we already downloaded the data and stored it in the
`../data`

directory. To load the two CSV (Comma Separated Values)
files containing training and test data respectively we use Pandas.

```
In [2]:
```

```
train_data = pd.read_csv('../data/kaggle_house_pred_train.csv')
test_data = pd.read_csv('../data/kaggle_house_pred_test.csv')
```

The training data set includes 1,460 examples, 80 features, and 1 label., the test data contains 1,459 examples and 80 features.

```
In [3]:
```

```
print(train_data.shape)
print(test_data.shape)
```

```
(1460, 81)
(1459, 80)
```

Let’s take a look at the first 4 and last 2 features as well as the label (SalePrice) from the first 4 examples:

```
In [4]:
```

```
train_data.iloc[0:4, [0, 1, 2, 3, -3, -2, -1]]
```

```
Out[4]:
```

Id | MSSubClass | MSZoning | LotFrontage | SaleType | SaleCondition | SalePrice | |
---|---|---|---|---|---|---|---|

0 | 1 | 60 | RL | 65.0 | WD | Normal | 208500 |

1 | 2 | 20 | RL | 80.0 | WD | Normal | 181500 |

2 | 3 | 60 | RL | 68.0 | WD | Normal | 223500 |

3 | 4 | 70 | RL | 60.0 | WD | Abnorml | 140000 |

We can see that in each example, the first feature is the ID. This helps the model identify each training example. While this is convenient, it doesn’t carry any information for prediction purposes. Hence we remove it from the dataset before feeding the data into the network.

```
In [5]:
```

```
all_features = pd.concat((train_data.iloc[:, 1:-1], test_data.iloc[:, 1:]))
```

## 3.17.3. Data Preprocessing¶

As stated above, we have a wide variety of datatypes. Before we feed it into a deep network we need to perform some amount of processing. Let’s start with the numerical features. We begin by replacing missing values with the mean. This is a reasonable strategy if features are missing at random. To adjust them to a common scale we rescale them to zero mean and unit variance. This is accomplished as follows:

To check that this transforms \(x\) to data with zero mean and unit
variance simply calculate
\(\mathbf{E}[(x-\mu)/\sigma] = (\mu - \mu)/\sigma = 0\). To check
the variance we use \(\mathbf{E}[(x-\mu)^2] = \sigma^2\) and thus
the transformed variable has unit variance. The reason for ‘normalizing’
the data is that it brings all features to the same order of magnitude.
After all, we do not know *a priori* which features are likely to be
relevant. Hence it makes sense to treat them equally.

```
In [6]:
```

```
numeric_features = all_features.dtypes[all_features.dtypes != 'object'].index
all_features[numeric_features] = all_features[numeric_features].apply(
lambda x: (x - x.mean()) / (x.std()))
# after standardizing the data all means vanish, hence we can set missing values to 0
all_features = all_features.fillna(0)
```

Next we deal with discrete values. This includes variables such as ‘MSZoning’. We replace them by a one-hot encoding in the same manner as how we transformed multiclass classification data into a vector of \(0\) and \(1\). For instance, ‘MSZoning’ assumes the values ‘RL’ and ‘RM’. They map into vectors \((1,0)\) and \((0,1)\) respectively. Pandas does this automatically for us.

```
In [7]:
```

```
# Dummy_na=True refers to a missing value being a legal eigenvalue, and creates an indicative feature for it.
all_features = pd.get_dummies(all_features, dummy_na=True)
all_features.shape
```

```
Out[7]:
```

```
(2919, 354)
```

You can see that this conversion increases the number of features from
79 to 331. Finally, via the `values`

attribute we can extract the
NumPy format from the Pandas dataframe and convert it into MXNet’s
native representation - NDArray for training.

```
In [8]:
```

```
n_train = train_data.shape[0]
train_features = nd.array(all_features[:n_train].values)
test_features = nd.array(all_features[n_train:].values)
train_labels = nd.array(train_data.SalePrice.values).reshape((-1, 1))
```

## 3.17.4. Training¶

To get started we train a linear model with squared loss. This will obviously not lead to a competition winning submission but it provides a sanity check to see whether there’s meaningful information in the data. It also amounts to a minimum baseline of how well we should expect any ‘fancy’ model to work.

```
In [9]:
```

```
loss = gloss.L2Loss()
def get_net():
net = nn.Sequential()
net.add(nn.Dense(1))
net.initialize()
return net
```

House prices, like shares, are relative. That is, we probably care more about the relative error \(\frac{y - \hat{y}}{y}\) than about the absolute error. For instance, getting a house price wrong by USD 100,000 is terrible in Rural Ohio, where the value of the house is USD 125,000. On the other hand, if we err by this amount in Los Altos Hills, California, we can be proud of the accuracy of our model (the median house price there exceeds 4 million).

One way to address this problem is to measure the discrepancy in the logarithm of the price estimates. In fact, this is also the error that is being used to measure the quality in this competition. After all, a small value \(\delta\) of \(\log y - \log \hat{y}\) translates into \(e^{-\delta} \leq \frac{\hat{y}}{y} \leq e^\delta\). This leads to the following loss function:

```
In [10]:
```

```
def log_rmse(net, features, labels):
# To further stabilize the value when the logarithm is taken, set the value less than 1 as 1.
clipped_preds = nd.clip(net(features), 1, float('inf'))
rmse = nd.sqrt(2 * loss(clipped_preds.log(), labels.log()).mean())
return rmse.asscalar()
```

Unlike in the previous sections, the following training functions use the Adam optimization algorithm. Compared to the previously used mini-batch stochastic gradient descent, the Adam optimization algorithm is relatively less sensitive to learning rates. This will be covered in further detail later on when we discuss the details on Optimization Algorithms in a separate chapter.

```
In [11]:
```

```
def train(net, train_features, train_labels, test_features, test_labels,
num_epochs, learning_rate, weight_decay, batch_size):
train_ls, test_ls = [], []
train_iter = gdata.DataLoader(gdata.ArrayDataset(
train_features, train_labels), batch_size, shuffle=True)
# The Adam optimization algorithm is used here.
trainer = gluon.Trainer(net.collect_params(), 'adam', {
'learning_rate': learning_rate, 'wd': weight_decay})
for epoch in range(num_epochs):
for X, y in train_iter:
with autograd.record():
l = loss(net(X), y)
l.backward()
trainer.step(batch_size)
train_ls.append(log_rmse(net, train_features, train_labels))
if test_labels is not None:
test_ls.append(log_rmse(net, test_features, test_labels))
return train_ls, test_ls
```

## 3.17.5. k-Fold Cross-Validation¶

The k-fold cross-validation was introduced in the section where we discussed how to deal with “Model Selection, Underfitting and Overfitting”. We will put this to good use to select the model design and to adjust the hyperparameters. We first need a function that returns the i-th fold of the data in a k-fold cros-validation procedure. It proceeds by slicing out the i-th segment as validation data and returning the rest as training data. Note - this is not the most efficient way of handling data and we would use something much smarter if the amount of data was considerably larger. But this would obscure the function of the code considerably and we thus omit it.

```
In [12]:
```

```
def get_k_fold_data(k, i, X, y):
assert k > 1
fold_size = X.shape[0] // k
X_train, y_train = None, None
for j in range(k):
idx = slice(j * fold_size, (j + 1) * fold_size)
X_part, y_part = X[idx, :], y[idx]
if j == i:
X_valid, y_valid = X_part, y_part
elif X_train is None:
X_train, y_train = X_part, y_part
else:
X_train = nd.concat(X_train, X_part, dim=0)
y_train = nd.concat(y_train, y_part, dim=0)
return X_train, y_train, X_valid, y_valid
```

The training and verification error averages are returned when we train \(k\) times in the k-fold cross-validation.

```
In [13]:
```

```
def k_fold(k, X_train, y_train, num_epochs,
learning_rate, weight_decay, batch_size):
train_l_sum, valid_l_sum = 0, 0
for i in range(k):
data = get_k_fold_data(k, i, X_train, y_train)
net = get_net()
train_ls, valid_ls = train(net, *data, num_epochs, learning_rate,
weight_decay, batch_size)
train_l_sum += train_ls[-1]
valid_l_sum += valid_ls[-1]
if i == 0:
d2l.semilogy(range(1, num_epochs + 1), train_ls, 'epochs', 'rmse',
range(1, num_epochs + 1), valid_ls,
['train', 'valid'])
print('fold %d, train rmse: %f, valid rmse: %f' % (
i, train_ls[-1], valid_ls[-1]))
return train_l_sum / k, valid_l_sum / k
```

## 3.17.6. Model Selection¶

We pick a rather un-tuned set of hyperparameters and leave it up to the reader to improve the model considerably. Finding a good choice can take quite some time, depending on how many things one wants to optimize over. Within reason the k-fold crossvalidation approach is resilient against multiple testing. However, if we were to try out an unreasonably large number of options it might fail since we might just get lucky on the validation split with a particular set of hyperparameters.

```
In [14]:
```

```
k, num_epochs, lr, weight_decay, batch_size = 5, 100, 5, 0, 64
train_l, valid_l = k_fold(k, train_features, train_labels, num_epochs, lr,
weight_decay, batch_size)
print('%d-fold validation: avg train rmse: %f, avg valid rmse: %f'
% (k, train_l, valid_l))
```

```
fold 0, train rmse: 0.170112, valid rmse: 0.157228
fold 1, train rmse: 0.162246, valid rmse: 0.189564
fold 2, train rmse: 0.163723, valid rmse: 0.167999
fold 3, train rmse: 0.167737, valid rmse: 0.154525
fold 4, train rmse: 0.162894, valid rmse: 0.182875
5-fold validation: avg train rmse: 0.165342, avg valid rmse: 0.170438
```

You will notice that sometimes the number of training errors for a set of hyper-parameters can be very low, while the number of errors for the \(K\)-fold cross validation may be higher. This is most likely a consequence of overfitting. Therefore, when we reduce the amount of training errors, we need to check whether the amount of errors in the k-fold cross-validation have also been reduced accordingly.

## 3.17.7. Predict and Submit¶

Now that we know what a good choice of hyperparameters should be, we might as well use all the data to train on it (rather than just \(1-1/k\) of the data that is used in the crossvalidation slices). The model that we obtain in this way can then be applied to the test set. Saving the estimates in a CSV file will simplify uploading the results to Kaggle.

```
In [15]:
```

```
def train_and_pred(train_features, test_feature, train_labels, test_data,
num_epochs, lr, weight_decay, batch_size):
net = get_net()
train_ls, _ = train(net, train_features, train_labels, None, None,
num_epochs, lr, weight_decay, batch_size)
d2l.semilogy(range(1, num_epochs + 1), train_ls, 'epochs', 'rmse')
print('train rmse %f' % train_ls[-1])
# apply the network to the test set
preds = net(test_features).asnumpy()
# reformat it for export to Kaggle
test_data['SalePrice'] = pd.Series(preds.reshape(1, -1)[0])
submission = pd.concat([test_data['Id'], test_data['SalePrice']], axis=1)
submission.to_csv('submission.csv', index=False)
```

Let’s invoke the model. A good sanity check is to see whether the predictions on the test set resemble those of the k-fold crossvalication process. If they do, it’s time to upload them to Kaggle.

```
In [16]:
```

```
train_and_pred(train_features, test_features, train_labels, test_data,
num_epochs, lr, weight_decay, batch_size)
```

```
train rmse 0.162318
```

A file, `submission.csv`

will be generated by the code above (CSV is
one of the file formats accepted by Kaggle). Next, we can submit our
predictions on Kaggle and compare them to the actual house price (label)
on the testing data set, checking for errors. The steps are quite
simple:

- Log in to the Kaggle website and visit the House Price Prediction Competition page.
- Click the “Submit Predictions” or “Late Submission” button on the right.
- Click the “Upload Submission File” button in the dashed box at the bottom of the page and select the prediction file you wish to upload.
- Click the “Make Submission” button at the bottom of the page to view your results.

## 3.17.8. Summary¶

- Real data often contains a mix of different datatypes and needs to be preprocessed.
- Rescaling real-valued data to zero mean and unit variance is a good default. So is replacing missing values with their mean.
- Transforming categorical variables into indicator variables allows us to treat them like vectors.
- We can use k-fold cross validation to select the model and adjust the hyper-parameters.
- Logarithms are useful for relative loss.

## 3.17.9. Problems¶

- Submit your predictions for this tutorial to Kaggle. How good are your predictions?
- Can you improve your model by minimizing the log-price directly? What happens if you try to predict the log price rather than the price?
- Is it always a good idea to replace missing values by their mean? Hint - can you construct a situation where the values are not missing at random?
- Find a better representation to deal with missing values. Hint - What happens if you add an indicator variable?
- Improve the score on Kaggle by tuning the hyperparameters through k-fold crossvalidation.
- Improve the score by improving the model (layers, regularization, dropout).
- What happens if we do not standardize the continuous numerical features like we have done in this section?