Code
%>%
LFS_D left_join(LFS_D_var$SEX, by = "SEX") %>%
group_by(SEX, Sex) %>%
summarise(Nobs = n()) %>%
arrange(-Nobs) %>%
print_table_conditional()
SEX | Sex | Nobs |
---|---|---|
MW | All persons | 203421 |
MEN | Men | 203393 |
WOMEN | Women | 203349 |
Data - OECD
%>%
LFS_D left_join(LFS_D_var$SEX, by = "SEX") %>%
group_by(SEX, Sex) %>%
summarise(Nobs = n()) %>%
arrange(-Nobs) %>%
print_table_conditional()
SEX | Sex | Nobs |
---|---|---|
MW | All persons | 203421 |
MEN | Men | 203393 |
WOMEN | Women | 203349 |
%>%
LFS_D left_join(LFS_D_var$AGE, by = "AGE") %>%
group_by(AGE, Age) %>%
summarise(Nobs = n()) %>%
arrange(-Nobs) %>%
print_table_conditional()
%>%
LFS_D left_join(LFS_D_var$SERIES, by = "SERIES") %>%
group_by(SERIES, Series) %>%
summarise(Nobs = n()) %>%
arrange(-Nobs) %>%
print_table_conditional()
SERIES | Series | Nobs |
---|---|---|
E | Employment | 152700 |
P | Population | 152616 |
L | Labour Force | 152613 |
U | Unemployment | 152234 |
%>%
LFS_D left_join(LFS_D_var$COUNTRY, by = "COUNTRY") %>%
group_by(COUNTRY, Country) %>%
summarise(Nobs = n()) %>%
arrange(-Nobs) %>%
mutate(Flag = gsub(" ", "-", str_to_lower(gsub(" ", "-", Country))),
Flag = paste0('<img src="../../icon/flag/vsmall/', Flag, '.png" alt="Flag">')) %>%
select(Flag, everything()) %>%
if (is_html_output()) datatable(., filter = 'top', rownames = F, escape = F) else .} {
%>%
LFS_D group_by(obsTime) %>%
summarise(Nobs = n()) %>%
arrange(desc(obsTime)) %>%
print_table_conditional()
%>%
LFS_D filter(SERIES == "E",
== "1564",
AGE == "MW",
SEX %in% c("ITA", "DEU", "GRC", "ESP", "PRT", "FRA")) %>%
COUNTRY %>%
year_to_date filter(date >= as.Date("2000-01-01")) %>%
left_join(LFS_D_var$COUNTRY, by = "COUNTRY") %>%
arrange(date) %>%
ggplot(.) + geom_line(aes(x = date, y = obsValue/1000, color = Country, linetype = Country)) +
scale_color_manual(values = viridis(7)[1:6]) +
theme_minimal() + xlab("") + ylab("") +
scale_x_date(breaks = seq(1960, 2020, 1) %>% paste0("-01-01") %>% as.Date,
labels = date_format("%y")) +
theme(legend.position = c(0.3, 0.9),
legend.title = element_blank(),
legend.direction = "horizontal") +
scale_y_continuous(breaks = seq(0, 200, 5),
labels = scales::dollar_format(prefix = "", suffix = "M"),
limits = c(0, 60))