---
title: "Repair Isn't the Problem — The System Is"
subtitle: "Even easy-to-fix products fail in Repair Cafes — not due to skill, but due to missing parts, unclear diagnostics, and cost barriers"
description: "Analysis of 178,000+ repair records from the global Repair Monitor dataset, examining why products rated as easy to fix still fail at Repair Cafes worldwide. A two-panel visualization contrasts repairability scores against actual repair outcomes by product category, revealing that system constraints — primarily missing spare parts — explain failure far more than volunteer skill or product difficulty. Built with ggplot2, patchwork, and binom in R."
date: "2026-04-04"
author:
- name: "Steven Ponce"
url: "https://stevenponce.netlify.app"
citation:
url: "https://stevenponce.netlify.app/data_visualizations/TidyTuesday/2026/tt_2026_14.html"
categories: ["TidyTuesday", "2026"]
tags: [
"Repair Cafe",
"Circular Economy",
"Right to Repair",
"Consumer Products",
"Repairability",
"Scatter Plot",
"Bar Chart",
"Two-Panel Layout",
"patchwork",
"ggrepel",
"binom",
"Wilson Confidence Intervals",
"Supply Chain",
"Sustainability"
]
image: "thumbnails/tt_2026_14.png"
format:
html:
toc: true
toc-depth: 5
code-link: true
code-fold: true
code-tools: true
code-summary: "Show code"
editor_options:
chunk_output_type: inline
execute:
freeze: true
cache: true
error: false
message: false
warning: false
eval: true
---
{#fig-1}
### [**Steps to Create this Graphic**]{.mark}
#### [1. Load Packages & Setup]{.smallcaps}
```{r}
#| label: load
#| warning: false
#| message: false
#| results: "hide"
## 1. LOAD PACKAGES & SETUP ----
suppressPackageStartupMessages({
if (!require("pacman")) install.packages("pacman")
pacman::p_load(
tidyverse, ggtext, showtext, janitor, ggrepel,
scales, glue, skimr, patchwork, binom
)
})
### |- figure size ----
camcorder::gg_record(
dir = here::here("temp_plots"),
device = "png",
width = 12,
height = 8,
units = "in",
dpi = 320
)
# Source utility functions
suppressMessages(source(here::here("R/utils/fonts.R")))
source(here::here("R/utils/social_icons.R"))
source(here::here("R/utils/image_utils.R"))
source(here::here("R/themes/base_theme.R"))
```
#### [2. Read in the Data]{.smallcaps}
```{r}
#| label: read
#| include: true
#| eval: true
#| warning: false
tt <- tidytuesdayR::tt_load(2026, week = 14)
repairs <- tt$repairs |> clean_names()
repairs_text <- tt$repairs_text|> clean_names()
rm(tt)
```
#### [3. Examine the Data]{.smallcaps}
```{r}
#| label: examine
#| include: true
#| eval: true
#| results: 'hide'
#| warning: false
glimpse(repairs)
glimpse(repairs_text)
```
#### [4. Tidy Data]{.smallcaps}
```{r}
#| label: tidy
#| warning: false
### |- Panel A: potential vs. outcome ----
# Binary outcome: repaired = "yes" only; everything else = not repaired
panel_a_data <- repairs |>
filter(!is.na(repairability)) |>
mutate(fixed = repaired == "yes") |>
group_by(category) |>
summarise(
n = n(),
median_repair = median(repairability, na.rm = TRUE),
n_fixed = sum(fixed, na.rm = TRUE),
.groups = "drop"
) |>
# Wilson CI on success rate — more reliable than raw proportion at small n
mutate(
ci = map2(n_fixed, n, ~ binom.wilson(.x, .y)),
pct_fixed = map_dbl(ci, ~ .x$mean),
pct_lower = map_dbl(ci, ~ .x$lower),
pct_upper = map_dbl(ci, ~ .x$upper)
) |>
filter(n >= 200) |>
# Quadrant flag: high repairability (≥ 6) but low fix rate (< 50%)
mutate(
quadrant = case_when(
median_repair >= 6 & pct_fixed < 0.50 ~ "system_failure",
median_repair >= 6 & pct_fixed >= 0.50 ~ "system_works",
median_repair < 6 & pct_fixed < 0.50 ~ "expected",
median_repair < 6 & pct_fixed >= 0.50 ~ "skilled_volunteers",
TRUE ~ "other"
),
category_clean = str_to_title(
str_wrap(str_replace_all(category, "_", " "), width = 22)
)
)
# Top "system failure" categories to label
label_cats <- panel_a_data |>
filter(quadrant == "system_failure") |>
slice_max(n, n = 6)
# Also label the top "system works" anchor point
label_works <- panel_a_data |>
filter(quadrant == "system_works") |>
slice_max(pct_fixed, n = 2)
panel_a_labels <- bind_rows(label_cats, label_works)
### |- Panel B: failure reasons ----
panel_b_data <- repairs_text |>
filter(!is.na(failure_reasons), failure_reasons != "") |>
# failure_reasons is a comma-delimited list
separate_rows(failure_reasons, sep = ",") |>
mutate(
failure_reasons = str_squish(str_to_lower(failure_reasons))
) |>
filter(failure_reasons != "", failure_reasons != "na") |>
# Group semantically similar reasons
mutate(
reason_group = case_when(
str_detect(failure_reasons, "spare part|parts not|no parts|onderdeel") ~
"Spare parts unavailable",
str_detect(failure_reasons, "unidentified|unknown|not found|unclear") ~
"Failure unidentified",
str_detect(failure_reasons, "cost|expensive|not worth|economisch") ~
"Not cost-effective",
str_detect(failure_reasons, "time|too long|no time") ~
"Insufficient time",
str_detect(failure_reasons, "skill|expertise|knowledge|competence") ~
"Skill / expertise gap",
str_detect(failure_reasons, "owner|customer|taken away|meegenomen") ~
"Owner decision",
str_detect(failure_reasons, "safety|gevaar|dangerous") ~
"Safety concern",
str_detect(failure_reasons, "irreparable|beyond repair|too damaged") ~
"Irreparable damage",
TRUE ~ "Other"
)
) |>
filter(reason_group != "Other") |>
count(reason_group, sort = TRUE) |>
mutate(
pct = n / sum(n),
reason_group = fct_reorder(reason_group, pct),
bar_fill = if_else(
reason_group == fct_reorder(reason_group, pct) |>
levels() |>
last(),
"accent", "neutral"
)
)
```
#### [5. Visualization Parameters]{.smallcaps}
```{r}
#| label: params
#| include: true
#| warning: false
### |- plot aesthetics ----
colors <- get_theme_colors(
palette = c(
"system_failure" = "#C26A3D",
"system_works" = "#3B4252",
"expected" = "#9BA8B5",
"skilled_volunteers" = "#5F7A8A",
"ref_line" = "#4A4A4A",
"bar_accent" = "#C26A3D",
"bar_neutral" = "#B0B7BF"
)
)
### |- titles and caption ----
title_text <- str_glue("Repair Isn't the Problem — The System Is")
subtitle_text <- str_glue(
'Even **"easy-to-fix"** products fail in Repair Cafes — not due to **skill**,',
" but due to **missing parts**, **unclear diagnostics**, and **cost barriers**"
)
caption_text <- create_social_caption(
tt_year = 2026,
tt_week = 14,
source_text = "Repair Monitor (repaircafes.org) · Bubble size = repair attempts"
)
panel_a_title <- "Potential vs. Outcome"
panel_a_sub <- "High repairability scores don't guarantee a fix.\nAmber points identify categories where the system falls short."
panel_b_title <- 'Why **"Repairable"** Items Still Fail'
panel_b_sub <- "When volunteers can't fix it, the cause is rarely skill.\nAmber bars reflect systemic constraints beyond the cafe."
### |- fonts ----
setup_fonts()
fonts <- get_font_families()
#### |- plot theme ----
base_theme <- create_base_theme(colors)
weekly_theme <- extend_weekly_theme(
base_theme,
theme(
# Panel
panel.grid.major.y = element_line(color = "gray92", linewidth = 0.3),
panel.grid.major.x = element_line(color = "gray92", linewidth = 0.3),
panel.grid.minor = element_blank(),
panel.spacing = unit(1.2, "lines"),
# Axes
axis.title = element_text(
size = 9, color = "gray30",
family = fonts$text
),
axis.text = element_text(
size = 8, color = "gray40",
family = fonts$text
),
axis.ticks = element_blank(),
# Legend
legend.position = "none",
# Strip (if used)
strip.text = element_text(
size = 9, face = "bold",
family = fonts$title
)
)
)
theme_set(weekly_theme)
```
#### [6. Plot]{.smallcaps}
```{r}
#| label: plot
#| warning: false
### |- Panel A: scatter — repairability vs. fix rate ----
p_a <- panel_a_data |>
ggplot(aes(x = median_repair, y = pct_fixed)) +
# Geoms
annotate(
"rect",
xmin = 6, xmax = Inf, ymin = -Inf, ymax = 0.50,
fill = "#C26A3D", alpha = 0.04
) +
geom_vline(
xintercept = 6, color = colors$palette["ref_line"],
linetype = "dashed", linewidth = 0.4, alpha = 0.6
) +
geom_hline(
yintercept = 0.50, color = colors$palette["ref_line"],
linetype = "dashed", linewidth = 0.4, alpha = 0.6
) +
geom_linerange(
aes(
ymin = pct_lower, ymax = pct_upper,
color = quadrant
),
linewidth = 0.5, alpha = 0.4
) +
geom_point(
aes(size = n, color = quadrant, fill = quadrant),
shape = 21, stroke = 0.5, alpha = 0.75
) +
geom_text_repel(
data = panel_a_labels,
aes(label = category_clean, color = quadrant),
size = 2.2,
family = fonts$text,
lineheight = 0.9,
max.overlaps = 20,
box.padding = 0.4,
point.padding = 0.3,
segment.color = "gray75",
segment.size = 0.25,
seed = 123
) +
# Annotate
annotate("text",
x = 1.1, y = 0.97,
label = "Expert-driven\nsuccess",
hjust = 0, vjust = 1, size = 2.2, color = "gray65",
fontface = "italic", lineheight = 0.9, family = fonts$text
) +
annotate("text",
x = 6.1, y = 0.97,
label = "System works",
hjust = 0, vjust = 1, size = 2.2, color = "gray65",
fontface = "italic", family = fonts$text
) +
annotate("text",
x = 1.1, y = 0.03,
label = "Expected\ndifficulty",
hjust = 0, vjust = 0, size = 2.2, color = "gray65",
fontface = "italic", lineheight = 0.9, family = fonts$text
) +
annotate("text",
x = 7.5, y = 0.30,
label = "System\nconstraint",
hjust = 0.5, vjust = 0.5, size = 2.3, color = "#C26A3D",
fontface = "bold.italic", lineheight = 0.9, family = fonts$text
) +
annotate("text",
x = 6.08, y = 0.53,
label = "≥6 = repairable",
hjust = 0, vjust = 0, size = 2.0, color = "gray45",
fontface = "italic", family = fonts$text
) +
annotate("text",
x = 1.1, y = 0.52,
label = "50% success threshold",
hjust = 0, vjust = 0, size = 2.0, color = "gray45",
fontface = "italic", family = fonts$text
) +
annotate("text",
x = 9.5, y = 0.44,
label = "← Amber zone:\nsee breakdown →",
hjust = 0.5, vjust = 1, size = 2.1, color = "#C26A3D",
fontface = "italic", lineheight = 0.95, family = fonts$text
) +
# Scales
scale_color_manual(values = c(
"system_failure" = unname(colors$palette["system_failure"]),
"system_works" = unname(colors$palette["system_works"]),
"expected" = unname(colors$palette["expected"]),
"skilled_volunteers" = unname(colors$palette["skilled_volunteers"])
)) +
scale_fill_manual(values = c(
"system_failure" = unname(colors$palette["system_failure"]),
"system_works" = unname(colors$palette["system_works"]),
"expected" = unname(colors$palette["expected"]),
"skilled_volunteers" = unname(colors$palette["skilled_volunteers"])
)) +
scale_size_continuous(range = c(2, 9)) +
scale_x_continuous(
name = "Median Repairability Score (≥6 = generally considered repairable)",
limits = c(1, 10),
breaks = 1:10
) +
scale_y_continuous(
name = "% Successfully Repaired",
labels = percent_format(accuracy = 1),
limits = c(0, 1)
) +
# Labs
labs(
title = panel_a_title,
subtitle = panel_a_sub
) +
# Theme
theme(
plot.title = element_text(
size = 11, face = "bold",
family = fonts$title, color = "gray15"
),
plot.subtitle = element_text(
size = 8, color = "gray40",
family = fonts$text, lineheight = 1.3,
margin = margin(b = 8)
)
)
### |- Panel B: failure reasons bar chart ----
p_b <- panel_b_data |>
ggplot(aes(x = pct, y = reason_group, fill = bar_fill)) +
# Geoms
geom_col(width = 0.7) +
geom_text(
aes(label = percent(pct, accuracy = 1)),
hjust = -0.15,
size = 2.8,
color = "gray30",
family = fonts$text
) +
# Scales
scale_fill_manual(
values = c(
"accent" = unname(colors$palette["bar_accent"]),
"neutral" = unname(colors$palette["bar_neutral"])
)
) +
scale_x_continuous(
labels = percent_format(accuracy = 1),
expand = expansion(mult = c(0, 0.15))
) +
# Labs
labs(
x = "Share of recorded failure reasons",
y = NULL,
title = panel_b_title,
subtitle = panel_b_sub
) +
# Theme
theme(
panel.grid.major.x = element_line(color = "gray92", linewidth = 0.3),
panel.grid.major.y = element_blank(),
plot.title = element_markdown(
size = 11, face = "bold",
family = fonts$title, color = "gray15"
),
plot.subtitle = element_text(
size = 8, color = "gray40",
family = fonts$text, lineheight = 1.3,
margin = margin(b = 8)
),
axis.text.y = element_text(
size = 8.5, color = "gray25",
family = fonts$text
)
)
### |- Combined layout ----
combined_plots <- p_a + p_b +
plot_layout(widths = c(1.4, 1)) +
plot_annotation(
title = title_text,
subtitle = subtitle_text,
caption = caption_text,
theme = theme(
plot.title = element_text(
size = 20,
face = "bold",
family = fonts$title,
color = "gray10",
margin = margin(b = 6)
),
plot.subtitle = element_markdown(
size = 12,
family = fonts$text,
color = "gray35",
lineheight = 1.35,
margin = margin(b = 14)
),
plot.caption = element_markdown(
size = 7,
family = fonts$text,
color = "gray55",
hjust = 0.5,
margin = margin(t = 12)
),
plot.background = element_rect(fill = "gray98", color = NA),
plot.margin = margin(20, 20, 12, 20)
)
)
```
#### [7. Save]{.smallcaps}
```{r}
#| label: save
#| warning: false
### |- plot image ----
save_plot_patchwork(
plot = combined_plots,
type = "tidytuesday",
year = 2026,
week = 14,
width = 12,
height = 8
)
```
#### [8. Session Info]{.smallcaps}
::: {.callout-tip collapse="true"}
##### Expand for Session Info
```{r, echo = FALSE}
#| eval: true
#| warning: false
sessionInfo()
```
:::
#### [9. GitHub Repository]{.smallcaps}
::: {.callout-tip collapse="true"}
##### Expand for GitHub Repo
The complete code for this analysis is available in [`tt_2026_14.qmd`](https://github.com/poncest/personal-website/blob/master/data_visualizations/TidyTuesday/2026/tt_2026_14.qmd).
For the full repository, [click here](https://github.com/poncest/personal-website/).
:::
#### [10. References]{.smallcaps}
::: {.callout-tip collapse="true"}
##### Expand for References
1. **Data Source:**
- TidyTuesday 2026 Week 14: [Repair Cafes Worldwide
](https://github.com/rfordatascience/tidytuesday/blob/main/data/2026/2026-04-07/readme.md)
:::
#### [11. Custom Functions Documentation]{.smallcaps}
::: {.callout-note collapse="true"}
##### 📦 Custom Helper Functions
This analysis uses custom functions from my personal module library for efficiency and consistency across projects.
**Functions Used:**
- **`fonts.R`**: `setup_fonts()`, `get_font_families()` - Font management with showtext
- **`social_icons.R`**: `create_social_caption()` - Generates formatted social media captions
- **`image_utils.R`**: `save_plot()` - Consistent plot saving with naming conventions
- **`base_theme.R`**: `create_base_theme()`, `extend_weekly_theme()`, `get_theme_colors()` - Custom ggplot2 themes
**Why custom functions?**\
These utilities standardize theming, fonts, and output across all my data visualizations. The core analysis (data tidying and visualization logic) uses only standard tidyverse packages.
**Source Code:**\
View all custom functions → [GitHub: R/utils](https://github.com/poncest/personal-website/tree/master/R)
:::