Involuntary part time workers - INVPT_D

Data - OECD

Author

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