Code
lfst_r_lfu3rt %>%
left_join(sex, by = "sex") %>%
group_by(sex, Sex) %>%
summarise(Nobs = n()) %>%
arrange(-Nobs) %>%
{if (is_html_output()) print_table(.) else .}| sex | Sex | Nobs |
|---|---|---|
| T | Total | 538514 |
| M | Males | 535237 |
| F | Females | 535180 |
Data - Eurostat
lfst_r_lfu3rt %>%
left_join(sex, by = "sex") %>%
group_by(sex, Sex) %>%
summarise(Nobs = n()) %>%
arrange(-Nobs) %>%
{if (is_html_output()) print_table(.) else .}| sex | Sex | Nobs |
|---|---|---|
| T | Total | 538514 |
| M | Males | 535237 |
| F | Females | 535180 |
lfst_r_lfu3rt %>%
left_join(age, by = "age") %>%
group_by(age, Age) %>%
summarise(Nobs = n()) %>%
arrange(-Nobs) %>%
{if (is_html_output()) print_table(.) else .}| age | Age | Nobs |
|---|---|---|
| Y_GE15 | 15 years or over | 190797 |
| Y_GE25 | 25 years or over | 188008 |
| Y15-74 | From 15 to 74 years | 157111 |
| Y15-29 | From 15 to 29 years | 155968 |
| Y15-24 | From 15 to 24 years | 155331 |
| Y20-64 | From 20 to 64 years | 154367 |
| Y45-54 | From 45 to 54 years | 152101 |
| Y25-34 | From 25 to 34 years | 152062 |
| Y35-44 | From 35 to 44 years | 151872 |
| Y55-64 | From 55 to 64 years | 151314 |
lfst_r_lfu3rt %>%
left_join(geo, by = "geo") %>%
group_by(geo, Geo) %>%
summarise(Nobs = n()) %>%
arrange(-Nobs) %>%
{if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}lfst_r_lfu3rt %>%
filter(time == "2015",
nchar(geo) == 4,
sex == "T",
age == "Y20-64") %>%
left_join(geo, by = "geo") %>%
select(geo, Geo, unemployment = values) %>%
{if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}lfst_r_lfu3rt %>%
filter(time == "2015",
nchar(geo) == 4,
sex == "T",
age == "Y20-64") %>%
right_join(europe_NUTS2, by = "geo") %>%
filter(long >= -15, lat >= 33) %>%
ggplot(., aes(x = long, y = lat, group = group, fill = values/100)) +
geom_polygon() + coord_map() +
scale_fill_viridis_c(na.value = "white",
labels = scales::percent_format(accuracy = 1),
direction = -1,
breaks = 0.01*seq(0, 50, 5),
values = c(0, 0.1, 0.2, 0.3, 0.4, 0.5, 1)) +
theme_void() + theme(legend.position = c(0.25, 0.85)) +
labs(fill = "Unemployment (%)")