LFS by sex and age - LFS_D

Data - OECD

Info

SEX

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

AGE

Code
LFS_D %>%
  left_join(LFS_D_var$AGE, by = "AGE") %>%
  group_by(AGE, Age) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  print_table_conditional()

SERIES

Code
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

COUNTRY

Code
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 .}

obsTime

Code
LFS_D %>%
  group_by(obsTime) %>%
  summarise(Nobs = n()) %>%
  arrange(desc(obsTime)) %>%
  print_table_conditional()

Employment in Millions

Code
LFS_D %>%
  filter(SERIES == "E", 
         AGE == "1564",
         SEX == "MW",
         COUNTRY %in% c("ITA", "DEU", "GRC", "ESP", "PRT", "FRA")) %>%
  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))