Involuntary part time workers - INVPT_D

Data - OECD

EMPSTAT

Code
INVPT_D %>%
  left_join(INVPT_D_var$EMPSTAT, by = "EMPSTAT") %>%
  group_by(EMPSTAT, Empstat) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  print_table_conditional()
EMPSTAT Empstat Nobs
TE Total employment 23290
DE Dependent employment 20025

SEX

Code
INVPT_D %>%
  left_join(INVPT_D_var$SEX, by = "SEX") %>%
  group_by(SEX, Sex) %>%
  summarise(Nobs = n()) %>%
  print_table_conditional()
SEX Sex Nobs
MEN Men 14291
MW All persons 14558
WOMEN Women 14466

AGE

Code
INVPT_D %>%
  left_join(INVPT_D_var$AGE, by = "AGE") %>%
  group_by(AGE, Age) %>%
  summarise(Nobs = n()) %>%
  print_table_conditional()
AGE Age Nobs
1524 15 to 24 7362
1564 15 to 64 7412
2554 25 to 54 7356
5564 55 to 64 7255
6599 65+ 6518
900000 Total 7412

COUNTRY

Code
INVPT_D %>%
  left_join(INVPT_D_var$COUNTRY, by = "COUNTRY") %>%
  group_by(COUNTRY, Country) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  mutate(Flag = gsub(" ", "-", str_to_lower(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
INVPT_D %>%
  group_by(obsTime) %>%
  summarise(Nobs = n()) %>%
  arrange(desc(obsTime)) %>%
  print_table_conditional()

Share of involuntary part-timers (% of part-time employment)

Table

Code
INVPT_D %>%
  filter(SEX == "MW",
         EMPSTAT == "TE",
         AGE == "900000") %>%
  left_join(INVPT_D_var$COUNTRY, by = "COUNTRY") %>%
  group_by(COUNTRY, Country) %>%
  summarise(Nobs = n(),
            obsTime = last(obsTime),
            obsValue = last(obsValue)) %>%
  arrange(-obsValue) %>%
  mutate(Flag = gsub(" ", "-", str_to_lower(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 .}