# Risk Bucketing

This notebook’s CI test result for us-west-2 is as follows. CI test results in other regions can be found at the end of the notebook.

One of the most common use cases for machine learning in financial services is estimating the probability of default on a loan.

Risk bucketing refers to the process of grouping borrowers with similar creditworthiness. Treating all borrowers equally will generally result in poor predictions, as the model cannot capture entirely different characteristics of the data all at once. By dividing borrowers into different groups based on risk characteristics, risk bucketing enables us to make accurate predictions.

Risk bucketing is a good example of an unsupervised clustering problem. The K-means algorithm (which we use here) is one way we can perform risk bucketing.

However, there is one major issue: how do we know the optimal number of risk buckets (clusters) to use for a given set of data/borrowers? This notebook demonstrates a number of techniques for calculating the optimal number of clusters: - The Elbow Method - Silhouette Scores - Gap Analysis

[ ]:

import pandas as pd
import boto3


Our data source is the well-known German Credit Risk data.

[ ]:

s3 = boto3.resource("s3")
s3_sample = s3.Object(
f"sagemaker-example-files-prod-{boto3.session.Session().region_name}",
"datasets/tabular/uci_statlog_german_credit_data/german_credit_data.csv",
).get()["Body"]


We drop the numeric columns dependents and existingcredits as we are not going to use them.

[ ]:

credit.drop(["dependents", "existingcredits"], inplace=True, axis=1)


Convert the job column, which contains categorical values, into a numerical one that contains ordinal values.

[ ]:

credit["job"].replace(
[
"unemployed",
"unskilled",
"skilled employee / official",
"management / highly skilled",
],
[0, 1, 2, 3],
inplace=True,
)

[ ]:

import matplotlib.pyplot as plt
import seaborn as sns

sns.set()
plt.rcParams["figure.figsize"] = (10, 6)


Drop all columns except for the following (numeric) ones: - Age - Job (ordinal ranging from 0=unemployed to 3=management / highly skilled) - Credit amount - Duration (the duration of the loan in months)

[ ]:

numerical_credit = credit.select_dtypes(exclude="O")


Plotting histograms of these four features, we can see that they are all positively skewed.

[ ]:

plt.figure(figsize=(10, 8))
k = 0
cols = numerical_credit.columns
for i, j in zip(range(len(cols)), cols):
k += 1
plt.subplot(2, 2, k)
plt.hist(numerical_credit.iloc[:, i])
plt.title(j)
plt.show()


## The Elbow Method

Our first method for estimating the optimal number of clusters is the Elbow Method. This involves calculating inertia which is the sum of the squared distances of observations from their closest centroid.

If we plot inertia against number of clusters (k) we can see an elbow (i.e. the curve starts to flatten out) around the value of k=4. This is an indication that increasing the number of clusters is undesirable (when traded-off against increased complexity).

Here we are using the KMeans algorithm from Sklearn, as it provides inertia as part of its output.

[ ]:

from sklearn.preprocessing import StandardScaler
from sklearn.cluster import KMeans
import numpy as np

[ ]:

scaler = StandardScaler()
scaled_credit = scaler.fit_transform(numerical_credit)

[ ]:

inertia = []
for k in range(1, 10):
kmeans = KMeans(n_clusters=k)
kmeans.fit(scaled_credit)
inertia.append(kmeans.inertia_)

[ ]:

plt.plot(range(1, 10), inertia, "bx-")
plt.xlabel("Number of Clusters (k)")
plt.ylabel("Inertia")
plt.title("The Elbow Method")
plt.show()


## Silhouette Scores

Silhouette scores take a value between 1 and -1. A value of 1 indicates an observation that is close to the correct centroid and correctly classified. A value of -1 shows that the observation is not correctly clustered.

The strength of the Silhouette Score is that it takes into account both the intra-cluster distance (how close observations are to their centroid) and the inter-cluster distance (how far apart the centroids are). The formula for Silhouette Score is as follows: $$Silhouette = \frac{x - y}{max(x, y)}$$ where x is the mean inter-cluster distance between clusters, and y is the mean intra-cluster distance.

In this case, we can see that the peak Silhouette score occurs when the number of clusters (k) is 2. This implies that it is not worth using more than 2 clusters.

[ ]:

from matplotlib import cm
import matplotlib.pyplot as plt
from sklearn.metrics import silhouette_score

[ ]:

silhouette_scores = []
for n_clusters in range(2, 10):
clusterer = KMeans(n_clusters=n_clusters)
preds = clusterer.fit_predict(scaled_credit)
centers = clusterer.cluster_centers_
silhouette_scores.append(silhouette_score(scaled_credit, preds))

[ ]:

plt.plot(range(2, 10), silhouette_scores, "bx-")
plt.xlabel("Number of Clusters (k)")
plt.ylabel("Silhouette Score")
plt.title("Silhouette Scores")
plt.show()


## Gap Analysis

Our final approach is gap analysis. This is based on the work of Tibshirani et al. (2001) which proposes finding the optimal number of clusters based on a reference distribution.

Our data consists of $$n$$ independent observations of $$p$$ features. The Euclidean distance between observations $$i$$ and $$i'$$ is: $$d_{ii'} = \sum_{j} (x_{ij} - x_{i'j})^2$$

And the sum of all pairwise distances for points in cluster r is: $$D_{r} = \sum_{i,i' \in C_{r}} d_{ii'}$$

Then the pooled, within-cluster sum of squares around the cluster mean is: $$W_{k} = \sum_{r=1}^k \frac{1}{2n_{r}}D_{r}$$

The idea of this approach is to standardize the graph of $$log(W_{k})$$ by comparing it with its expectation under an appropriate null reference distribution of the data. The expectation of $$W_{k}$$ is approximately $$log(pn/12) - (2/p)log(k) + constant$$

[ ]:

!pip install gap-stat


Import the OptimalK module for calculating the gap statistic.

[ ]:

from gap_statistic.optimalK import OptimalK


Calculate the gap statistic for various values of $$k$$ using parallelization.

[ ]:

optimalK = OptimalK(n_jobs=8, parallel_backend="joblib")
n_clusters = optimalK(scaled_credit, cluster_array=np.arange(1, 10))

[ ]:

gap_result = optimalK.gap_df


If we plot the resulting gap values, we observe a sharp increase up to the point where the gap value reaches its peak. In this case this corresponds to 5 clusters. The analysis suggests that this is the optimal number for clustering.

[ ]:

plt.plot(gap_result.n_clusters, gap_result.gap_value)
min_ylim, max_ylim = plt.ylim()
plt.axhline(np.max(gap_result.gap_value), color="r", linestyle="dashed", linewidth=2)
plt.title("Gap Analysis")
plt.xlabel("Number of Clusters")
plt.ylabel("Gap Value")
plt.show()


## K-Means Clustering

Due to their differing approaches, the three analyses above all provide a different value for the optimal number of clusters. It will require some trial and error to determine which is indeed the optimal number of clusters.

For example, let us proceed on the basis that the optimal number of clusters is two (as suggested by the Silhouette Scores).

We perform K-Means clustering to separate our observations into two.

[ ]:

kmeans = KMeans(n_clusters=2)
clusters = kmeans.fit_predict(scaled_credit)


Finally, we generate some plots to visualize the clusters in two dimensions. The plots show the observations (with color indicating the assigned cluster). Black crosses are used to show the position of the two centroids.

The first plot shows the relationship between the age and credit features. Here we can see that age is the more dispersed feature, with the centroids located vertically inline.

The second plot considers two continuous features: credit and duration. Here we observe two clearly separated clusters. This suggests that the duration feature is more volatile when compared with the credit feature.

Finally, the third plot examines the relationship between age and duration. It turns out that there are many overlapping observations across these two features.

[ ]:

plt.figure(figsize=(10, 12))
plt.subplot(311)
plt.scatter(scaled_credit[:, 2], scaled_credit[:, 1], c=kmeans.labels_, cmap="viridis")
plt.scatter(
kmeans.cluster_centers_[:, 2],
kmeans.cluster_centers_[:, 1],
s=80,
marker="x",
color="k",
)
plt.title("Age vs Credit")
plt.subplot(312)
plt.scatter(scaled_credit[:, 1], scaled_credit[:, 0], c=kmeans.labels_, cmap="viridis")
plt.scatter(
kmeans.cluster_centers_[:, 1],
kmeans.cluster_centers_[:, 0],
s=80,
marker="x",
color="k",
)
plt.title("Credit vs Duration")
plt.subplot(313)
plt.scatter(scaled_credit[:, 2], scaled_credit[:, 0], c=kmeans.labels_, cmap="viridis")
plt.scatter(
kmeans.cluster_centers_[:, 2],
kmeans.cluster_centers_[:, 0],
s=120,
marker="x",
color="k",
)
plt.title("Age vs Duration")
plt.show()


## Conclusion

In this notebook we have discussed why risk bucketing is necessary, and considered three different approaches to estimating the optimal number of risk buckets.

Having estimated the optimal number of risk buckets, we made use of K-Means clustering to split our observations between the target number of risk buckets.

The follow-on activity is to create models for estimating default risk for each risk bucket, with each model trained separately using the data corresponding to the corresponding risk bucket.

## Notebook CI Test Results

This notebook was tested in multiple regions. The test results are as follows, except for us-west-2 which is shown at the top of the notebook.