# Tidy Unsupervised Learning - Part I: Clustering Binary Data

I recently faced the challenge to extract a small number of typical respondent profiles from a large scale survey with multiple yes-no questions. This type of setting corresponds to a classification problem without knowing the true labels of the observations – also known as unsupervised learning. Since I regularly face tasks in this area, I decided to start an irregular series of blogs that touch upon practical aspects of unsupervised learning in R using tidy principles.

Technically speaking, I have a set of $$N$$ observations $$(x_1, x_2, ... , x_N)$$ of a random $$p$$-vector $$X$$ with joint density $$\text{Pr}(X)$$. The goal of classification is to directly infer the properties of this probability density without the help of the correct answers (or degree-of-error) for each observation. In this note I focus on cluster analysis that attempts to find convex regions of the $$X$$-space that contain modes of $$\text{Pr}(X)$$. This approach aims to tell whether $$\text{Pr}(X)$$ can be represented by a mixture of simpler densities representing distinct classes of observations.

Intuitively, I want to find clusters of the survey responses such that respondents within each cluster are more closely related to one another than respondents assigned to different clusters. There are many possible ways to achieve that, but I focus on the most popular and most approachable ones: $$K$$-means, $$K$$-modes, as well as agglomerative and divisive hierarchical clustering. AS we see below, the 4 models yield quite different results for clustering binary data.

I mainly use the tidyverse family of packages throughout this post. In case I call cluster models from other packages, I explicitly refer to them below.

library(tidyverse)

# Sample data

Let us start by creating some sample data where we basically exactly know which kind of answer profiles are out there. Later, we evaluate the cluster models according to how well they are doing in uncovering the clusters and assigning respondents to clusters. I assume that there are 4 yes/no questions labeled q1, q2, q3 and q4. In addition, there are 3 different answer profiles where cluster 1 answers positively to the first question only, cluster 2 answers positively to question 2 and 3 and cluster 3 answers all questions positively. I also define the the number of respondents for each cluster.

tbl.centers <- tibble(
cluster = factor(1:3),
respondents = c(250, 500, 200),
q1 = c(1, 0, 1),
q2 = c(0, 1, 1),
q3 = c(0, 1, 1),
q4 = c(0, 0, 1)
)

Alternatively, we could think of the yes/no questions as medical records that indicate whether the subject has a certain pre-condition or not.

Since it should be a bit tricky for the clustering models to find the actual response profiles, let us add some noise in the form of respondents that deviate from their assigned cluster profile. We find out below how the cluster algorithms are able to deal with this noise.

set.seed(123)
tbl.labelled_respondents <- tbl.centers %>%
mutate(
q1 = map2(respondents, q1, function(x, y) {rbinom(x, 1, max((y-0.1), 0.1))}),
q2 = map2(respondents, q2, function(x, y) {rbinom(x, 1, max((y-0.1), 0.1))}),
q3 = map2(respondents, q3, function(x, y) {rbinom(x, 1, max((y-0.1), 0.1))}),
q4 = map2(respondents, q4, function(x, y) {rbinom(x, 1, max((y-0.1), 0.1))})
) %>%
select(-respondents) %>%
unnest(cols = c(q1, q2, q3, q4))

The figure below visualizes the distribution of simulated question responses by cluster.

fig.labelled_respondents <- tbl.labelled_respondents %>%
pivot_longer(cols = -cluster, names_to = "question", values_to = "response") %>%
mutate(response = response == 1) %>%
ggplot(aes(x = response, y = question, color = cluster)) +
geom_jitter() +
theme_bw() +
labs(x = "Response", y = "Question", color = "Cluster",
title = "Visualization of simulated question responses by cluster")

# $$K$$-means clustering

The $$K$$-means algorithm is one of the most popular clustering methods (see also this tidymodels example). It is intended for situations in which all variables are of the quantitative type since it partitions all respondents into $$k$$ groups such that the sum of squares from respondents to the assigned cluster centers are minimized. For binary data, the Euclidean distance reduces to counting the number of variables on which two cases disagree.

This leads to a problem (which is also described here) because of an arbitrary cluster assignment after cluster initialization. The first chosen clusters are still binary data and hence observations have integer distances from each of the centers. The corresponding ties are hard to overcome in any meaningful way. Afterwards, the algorithm computes means in clusters and revisits assignments. Nonetheless, $$K$$-means might produce informative results in a fast and easy to interpret way. I hence include it in this post for comparison.

To run the $$K$$-means algorithm, we first drop the cluster column.

tbl.respondents <- tbl.labelled_respondents %>%
select(-cluster)

It is very straight-forward to run the built-in stats::kmeans clustering algorithm. I choose the parameter of maximum iterations to be 100 to increase the likeliness of getting the best fitting clusters. Since the data is fairly small and the algorithm is also quite fast, I see no harm in using a high number of iterations.

par.iter_max <- 100
lst.kmeans_example <- stats::kmeans(tbl.respondents, centers = 3, iter.max = par.iter_max)

The output of the algorithm is a list with different types of information including the assigned clusters for each respondent.

As we want to compare cluster assignment across different models and we repeatedly assign different clusters to respondents, I write up a helper function that adds assignments to the respondent data from above. The function shows that $$K$$-means and $$K$$-modes contain a field with cluster information. The two hierarchical cluster models, however, need to be cut a the desired number of clusters (more on that later).

fun.assign_clusters <- function(model, k = NULL) {
if (class(model)[1] %in% c("kmeans", "kmodes")) {
cluster_assignment <- model$cluster } if (class(model)[1] %in% c("agnes", "diana")) { if (is.null(k)) { stop("k required for hierarchical models!") } cluster_assignment <- stats::cutree(model, k = k) } clusters <- tbl.respondents %>% mutate(cluster = cluster_assignment) return(clusters) } In addition, I introduce a helper function that summarizes information by cluster. In particular, the function computes average survey responses (which correspond to proportion of yes answers in the current setting) and sorts the clusters according to the total number of positive answers. The latter helps us later to compare clusters across different models. fun.summarize_clusters <- function(model, k = NULL) { # Assign respondents to clusters clusters <- fun.assign_clusters(model = model, k = k) # Compute summary statistics by cluster out <- clusters %>% group_by(cluster) %>% summarize(across(matches("q"), mean, na.rm = T), assigned_respondents = n()) %>% select(-cluster) %>% # Rank clusters by total share of positive answers mutate(total = rowSums(across(matches("q")))) %>% arrange(-total) %>% mutate(k = row_number(), model = class(model)[1]) return(out) } We could easily introduce other summary statistics into the function, but the current specification is sufficient for the purpose of this note. tbl.kmeans_example <- fun.summarize_clusters(lst.kmeans_example) Since we do not know the true number of clusters in real-world settings, we want to compare the performance of clustering models for different numbers of clusters. Since we know that the true number of clusters is 3 in the current setting, let us stick to a maximum of 7 clusters. In practice, you might of course choose an arbitrary maximum number of clusters. par.k_min <- 1 par.k_max <- 7 lst.kmeans <- tibble(k = par.k_min:par.k_max) %>% mutate( kclust = map(k, ~kmeans(tbl.respondents, centers = .x, iter.max = par.iter_max)), ) A common heuristic to determine the optimal number of clusters is the elbow method where we plot the within-cluster sum of squared errors of an algorithm for increasing number of clusters. The optimal number of clusters corresponds to the point where adding another cluster does lead to much of an improvement anymore. In economic terms, we look for the point where the diminishing returns to an additional cluster are not worth the additional cost (assuming that we want the minimum number of clusters with optimal predictive power). The function below computes the within-cluster sum of squares for any cluster assignments. fun.compute_withinss <- function(model, k = NULL) { # Assign respondents to clusters clusters <- fun.assign_clusters(model = model, k = k) # Compute averages per cluster center centers <- clusters %>% group_by(cluster) %>% summarize_all(mean) %>% pivot_longer(cols = -cluster, names_to = "question", values_to = "cluster_mean") # Compute sum of squared differences from cluster centers out <- clusters %>% pivot_longer(cols = -cluster, names_to = "question", values_to = "response") %>% left_join(centers, by = c("cluster", "question")) %>% summarize(k = max(cluster), withinss = sum((response - cluster_mean)^2)) %>% mutate(model = class(model)[1]) return(out) } We can simply map the function across our list of $$K$$-means models. For better comparability, we normalize the within-cluster sum of squares for any number of cluster by the benchmark case of only having a single cluster. Moreover, we consider log-differences to because we care more about the percentage decrease in sum of squares rather than the absolute number. tbl.kmeans_logwithindiss <- lst.kmeans$kclust %>%
map(fun.compute_withinss) %>%
reduce(bind_rows) %>%
mutate(logwithindiss = log(withinss) - log(withinss[k == 1]))

# $$K$$-modes clustering

Since $$K$$-means is actually not ideal for binary (or hierarchical data in general), Huang (1997) came up with the $$K$$-modes algorithm. This clustering approach aims to partition respondents into $$k$$ groups such that the distance from respondents to the assigned cluster modes is minimized. A mode is a vector of elements that minimize the dissimilarities between the vector and each object of the data. Rather than using the Euclidean distance, $$K$$-modes uses simple matching distance between respondents to quantify dissimilarity which translates into counting the number of mismatches in all question responses in the current setting.

Fortunately, the klaR package provides an implementation of the $$K$$-modes algorithm that we can apply just like the $$K$$-means above.

lst.kmodes_example <- klaR::kmodes(tbl.respondents, iter.max = par.iter_max, modes = 3)
tbl.kmodes_example <- fun.summarize_clusters(lst.kmodes_example)

Similarly, we just map the model across different numbers of target cluster modes and compute the within-cluster sum of squares.

lst.kmodes <- tibble(k = par.k_min:par.k_max) %>%
mutate(
kclust = map(k, ~klaR::kmodes(tbl.respondents, modes = ., iter.max = par.iter_max))
)

tbl.kmodes_logwithindiss <- lst.kmodes\$kclust %>%
map(fun.compute_withinss) %>%
reduce(bind_rows) %>%
mutate(logwithindiss = log(withinss) - log(withinss[k == 1]))

Note that I computed the within-cluster sum of squared errors rather than using the within-cluster simple-matching distance provided by the function itself. The latter counts the number of differences from assigned respondents to their cluster modes. To have a fairer comparison to the other approaches, we

# Hierarchical clustering

As an alternative to computing optimal assignments for a given number of clusters, we might sometimes prefer to arrange the clusters into a natural hierarchy. This involves successively grouping the clusters themselves such that at each level of the hierarchy, clusters within the same group are more similar to each other than those in different groups. There are two fundamentally different approaches to hierarchical clustering that are fortunately implemented in the great cluster package.

Both hierarchical clustering approaches require a dissimilarity or distance matrix. Since we have binary data, we choose the asymmetric binary distance matrix based on the Jaccard distance. Intuitively, the Jaccard distance measures how far the overlap of responses between two groups is from perfect overlap.

mat.dissimiarity <- stats::dist(tbl.respondents, method = "binary")

Agglomerative clustering start at the bottom and at each level recursively merge a selected pair of clusters into a single cluster. This produces a clustering at the next higher level with one less cluster. The pair chosen for merging consist of the two clusters with the smallest within-cluster dissimilarity. On an intuitive level, agglomerative clustering is hence better in discovering small clusters.

The cluster package provides the agnes algorithm (AGglomerative NESting) that can easily applied to the dissimilarity matrix.

lst.agnes <- cluster::agnes(mat.dissimiarity, diss = TRUE, keep.diss = TRUE, method = "complete")

The function returns a clustering tree that we could plot (which I actually rarely found really helpful) or cut into different partitions using the stats::cutree function. This is why the helper functions from above need a number of target clusters as an input for hierarchical clustering models. However, the logic of the summary statistics are just as above.

tbl.agnes_example <- fun.summarize_clusters(lst.agnes, k = 3)
tbl.agnes_logwithindiss <- par.k_min:par.k_max %>%
map(~fun.compute_withinss(lst.agnes, .)) %>%
reduce(bind_rows) %>%
mutate(logwithindiss = log(withinss) - log(withinss[k == 1]))

Divisive methods start at the top and at each level recursively split one of the existing clusters at that level into two new clusters. The split is chosen such that two new groups with the largest between-group dissimilarity emerge. Intuitively speaking, divisive clustering is thus better in discovering large clusters.

The cluster package provides the diana algorithm (DIvise ANAlysis) for this clustering approach where the logic is basically the same as for the agnes model.

lst.diana <- cluster::diana(mat.dissimiarity, diss = TRUE, keep.diss = TRUE)
tbl.diana_example <- fun.summarize_clusters(lst.diana, k = 3)
tbl.diana_logwithindiss <-  par.k_min:par.k_max %>%
map(~fun.compute_withinss(lst.diana, .)) %>%
reduce(bind_rows) %>%
mutate(logwithindiss = log(withinss) - log(withinss[k == 1]))

# Model comparison

Let us start the model comparison by looking at the within cluster sum of squares for different numbers of clusters. The figure shows that the $$K$$-modes algorithm improves the fastest towards the true number of 3 clusters. The elbow method would suggest in this case to stick with 3 clusters for this algorithm.

For the other models, the picture is less clear: the curve of $$K$$-means would rather suggest having 2 or 4 clusters. But then again this might be the result of initial conditions as the $$K$$-means algorithm assigns respondents to clusters in a rather arbitrary way at cluster initialization. The divise model would also suggest 3 clusters as there is no improvement to using 4 clusters, but the overall sum of squares does not improve much suggesting a lot of mis-classification in the first 2 clusters. The agglomerative model exhibits the worst performance since it shows no clear suggestion for an optimal cluster and the first 2 clusters seem to be only marginally better than having a single cluster.

fig.dissimilarity <- bind_rows(tbl.kmeans_logwithindiss, tbl.kmodes_logwithindiss,
tbl.agnes_logwithindiss, tbl.diana_logwithindiss) %>%
ggplot(aes(x = k, y = logwithindiss, color = model, linetype = model)) +
geom_line() +
scale_x_continuous(breaks = par.k_min:par.k_max) +
theme_minimal() +
labs(x = "Number of Clusters", y = bquote(log(W[k])-log(W[1])), color = "Model", linetype = "Model",
title = "Within cluster sum of squares relative to benchmark case of one cluster")

Now, let us compare the proportion of positive responses within assigned clusters across models. Recall that I ranked clusters according to the total share of positive answers to ensure comparability. This approach is only possible in this type of setting where we can easily introduce such a ranking. The figure shows that all models are doing well in discovering the cluster with a single response. The cluster with 2 positive responses seems to be discovered by diana, $$K$$-means and $$K$$-modes, while agnes is clearly off. The cluster with only positive responses is again discovered by $$K$$-means and $$K$$-modes whereas the hierarchical models perform rather poorly. Overall, this picture again suggests that $$K$$-modes performs best for the current setting.

fig.proportions <- bind_rows(
tbl.kmeans_example,
tbl.kmodes_example,
tbl.agnes_example,
tbl.diana_example) %>%
select(-c(total, assigned_respondents)) %>%
pivot_longer(cols = -c(k, model), names_to = "question", values_to = "response") %>%
mutate(cluster = str_c("Cluster ", k)) %>%
ggplot(aes(x = response, y = question, fill = model)) +
geom_col(position = "dodge") +
facet_wrap(~cluster) +
theme_bw() +
scale_x_continuous(labels = scales::percent) +
geom_hline(yintercept = seq(1.5, length(unique(colnames(tbl.respondents)))-0.5, 1),
colour = 'black') +
labs(x = "Proportion of responses", y = "Question", fill = "Model",
title = "Proportion of positive responses within assigned clusters")

Finally, let us check how well each model assigns respondents to the true cluster which is obviously not possible in real unsupervised applications. The figure below shows the true number of respondents by cluster as a dashed box and the assigned respondents as bars. Again, agnes and diana do a pretty bad job for the current setting, while $$K$$-means and $$K$$-modes show quite simiar assignments that are not too far off from the true ones.

fig.assigned_respondents <- bind_rows(
tbl.kmeans_example,
tbl.kmodes_example,
tbl.agnes_example,
tbl.diana_example) %>%
mutate(cluster = str_c("Cluster ", k)) %>%
select(model, cluster, assigned_respondents) %>%
ggplot() +
geom_col(position = "dodge", aes(y = assigned_respondents, x = cluster, fill = model)) +
geom_col(data = tbl.labelled_respondents %>%
group_by(cluster = str_c("Cluster ", cluster)) %>%
summarize(assigned_respondents = n(),
model = "actual"), aes(y = assigned_respondents, x = cluster), fill = "white", color = "black", alpha = 0, linetype = "dashed") +
theme_bw() +
labs(x = NULL, y = "Number of assigned respondents", fill = "Model",
title = "Number of assigned respondents by cluster",
subtitle = "Dashed box indicates true number of respondents by cluster")

Let me end this post with a few words of caution: first, the ultimate outcome heavily depends on the seed chosen at the beginning of the post. The results might be quite different for other draws of respondents or initial conditions for clustering algorithms. Second, there are many more models out there that can be applied to the current setting. However, with this post I want to emphasize that it is important to consider different models at the same time and to compare them through a consistent set of measures. Ultimately, choosing the optimal number of clusters in practice requires a judgment call, but at least it can be informed as much as possible.

##### Christoph Scheuch
###### Director of Product

My interests include Product Management, Data Science, R and FinTech-related stuff. matter.