A R function to deal with datasets with a double header
✓ Published0🌍 Public
LLuisSevillano
Last edited Aug 8, 2019
Created on Aug 7, 2019
This visualization displays unemployment rates by age group and gender across Spanish autonomous communities over time, using small multiples. The R script reads an Excel file with a double header, then cleans it using the `tidyverse`, `janitor` for removing empty rows and columns, and `readxl` for data loading. The `combineHeaders()` custom function merges the two header rows by filling empty cells and pasting values together. The final plot uses `ggplot2` with `geom_line` for time series, faceted by community, and applies a custom color scale and minimal theme.
AI-generated description