LFS by sex and age - LFS_D

Data - OECD

Author

Info

See also: LFS_SEXAGE_I_R, for indicators (Emp / Population, etc.)

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, 2100, 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))