T202 |>
filter(sex == "E",
sector %in% c("TAZ", "T"),
grepl("D", geo),
date == as.Date("2018-12-31")) |>
mutate(CODE_DEPT = gsub("D", "", geo)) |>
select(CODE_DEPT, sector, date, value) |>
spread(sector, value) |>
mutate(value = TAZ / T) |>
left_join(departements_details, by = "CODE_DEPT") |>
left_join(departements, by = "CODE_DEPT") |>
ggplot() + aes(long, lat, group = group, fill = value) +
coord_equal() + theme_void() + geom_polygon() +
scale_fill_viridis_c(na.value = "white",
direction = -1,
name = "Agriculture (AZ)",
breaks = 0.01*seq(0, 90, 1),
labels = percent_format(accuracy = 1)) +
labs(x = "", y = "", title = "") +
theme(axis.text.x = element_blank(),
axis.text.y = element_blank())