Load data

data <- read_rds('../../temp/data_reg.rds')

In between: Check dropouts

data_dropout <- data %>%
  group_by(AID) %>%
  mutate(dropout = year == max(year, na.rm = TRUE)) %>%
  ungroup() %>%
  filter(year <= 2019) %>%
  mutate(seniority_bin = case_when(
      seniority <= 5 ~ "1 early",
      seniority > 5 & seniority <= 10 ~ "2 mid",
      seniority > 10 & seniority <= 15 ~ "3 mid late",
      seniority > 15 ~ "4 late",
  )
  )
data_dropout %>% 
  filter(year >= 2015, year <2020) %>%
  count(year, dropout) %>%
  group_by(year) %>%
  mutate(n = n / sum(n)) %>%
  ungroup() %>%
  mutate(year = year %>% as.character()) %>%
  filter(dropout == TRUE) %>%
  ggplot(aes(x = year, y = n)) +
  geom_col()

n_dropout <- data_dropout %>%
  filter(dropout == TRUE, type == 'switcher') %>%
  count(year, seniority_bin) %>% 
  group_by(year) %>%
  mutate(pct = n / sum(n)) %>%
  ungroup()
n_dropout %>%
  mutate(year = year %>% as.character()) %>%
  ggplot(aes(x = year, y = n, fill = seniority_bin, col = seniority_bin)) +
  geom_col() +
  labs(title = 'Dropouts total')

n_dropout %>%
  mutate(year = year %>% as.character()) %>%
  ggplot(aes(x = year, y = pct, fill = seniority_bin, col = seniority_bin)) +
  geom_col() +
  labs(title = 'Dropouts total')

LS0tCnRpdGxlOiAnUHJpdmF0aXphdGlvbiBvZiBBSSByZXNlYXJjaDogRGVzY3JpcHRpdmVzcycKYXV0aG9yOiAiRGFuaWVsIFMuIEhhaW4gKGRzaEBidXNpbmVzcy5hYXUuZGspIgpkYXRlOiAiVXBkYXRlZCBgciBmb3JtYXQoU3lzLnRpbWUoKSwgJyVCICVkLCAlWScpYCIKb3V0cHV0OgogIGh0bWxfbm90ZWJvb2s6CiAgICBjb2RlX2ZvbGRpbmc6IGhpZGUKICAgIGRmX3ByaW50OiBwYWdlZAogICAgdG9jOiB0cnVlCiAgICB0b2NfZGVwdGg6IDIKICAgIHRvY19mbG9hdDoKICAgICAgY29sbGFwc2VkOiBmYWxzZQogICAgdGhlbWU6IGZsYXRseQotLS0KCmBgYHtyIHNldHVwLCBpbmNsdWRlPUZBTFNFfQojIEtuaXRyIG9wdGlvbnMKIyMjIEdlbmVyaWMgcHJlYW1ibGUKcm0obGlzdCA9IGxzKGFsbC5uYW1lcyA9IFRSVUUpKSAjd2lsbCBjbGVhciBhbGwgb2JqZWN0cyBpbmNsdWRlcyBoaWRkZW4gb2JqZWN0cy4KZ2MoKSAjZnJlZSB1cCBtZW1yb3J5IGFuZCByZXBvcnQgdGhlIG1lbW9yeSB1c2FnZS4KZ3JhcGhpY3Mub2ZmKCkKClN5cy5zZXRlbnYoTEFORyA9ICJlbiIpICMgRm9yIGVuZ2xpc2ggbGFuZ3VhZ2UKb3B0aW9ucyhzY2lwZW4gPSA1KSAjIFRvIGRlYWN0aXZhdGUgYW5ub3lpbmcgc2NpZW50aWZpYyBudW1iZXIgbm90YXRpb24KCiMjIyBMb2FkIHBhY2thZ2VzCmxpYnJhcnkodGlkeXZlcnNlKSAjIENvbGxlY3Rpb24gb2YgYWxsIHRoZSBnb29kIHN0dWZmIGxpa2UgZHBseXIsIGdncGxvdDIgZWN0LgpsaWJyYXJ5KG1hZ3JpdHRyKSAjIEZvciBleHRyYS1waXBpbmcgb3BlcmF0b3JzIChlZy4gJTw+JSkKCiMgRGVzY3JpcHRpdmVzCiNsaWJyYXJ5KHNraW1yKQpsaWJyYXJ5KHN0YXJnYXplcikKCiMgVml6CmxpYnJhcnkocGF0Y2h3b3JrKQoKIyBTdXJ2aXZhbCBhbmFseXNpcwpsaWJyYXJ5KHN1cnZpdmFsKQpsaWJyYXJ5KHN1cnZtaW5lcikKbGlicmFyeShnZ2ZvcnRpZnkpCmBgYAoKIyBMb2FkIGRhdGEKCmBgYHtyfQpkYXRhIDwtIHJlYWRfcmRzKCcuLi8uLi90ZW1wL2RhdGFfcmVnLnJkcycpCmBgYAoKCiMgSW4gYmV0d2VlbjogQ2hlY2sgZHJvcG91dHMKCmBgYHtyfQpkYXRhX2Ryb3BvdXQgPC0gZGF0YSAlPiUKICBncm91cF9ieShBSUQpICU+JQogIG11dGF0ZShkcm9wb3V0ID0geWVhciA9PSBtYXgoeWVhciwgbmEucm0gPSBUUlVFKSkgJT4lCiAgdW5ncm91cCgpICU+JQogIGZpbHRlcih5ZWFyIDw9IDIwMTkpICU+JQogIG11dGF0ZShzZW5pb3JpdHlfYmluID0gY2FzZV93aGVuKAogICAgICBzZW5pb3JpdHkgPD0gNSB+ICIxIGVhcmx5IiwKICAgICAgc2VuaW9yaXR5ID4gNSAmIHNlbmlvcml0eSA8PSAxMCB+ICIyIG1pZCIsCiAgICAgIHNlbmlvcml0eSA+IDEwICYgc2VuaW9yaXR5IDw9IDE1IH4gIjMgbWlkIGxhdGUiLAogICAgICBzZW5pb3JpdHkgPiAxNSB+ICI0IGxhdGUiLAogICkKICApCmBgYAoKCmBgYHtyfQpkYXRhX2Ryb3BvdXQgJT4lIAogIGZpbHRlcih5ZWFyID49IDIwMTUsIHllYXIgPDIwMjApICU+JQogIGNvdW50KHllYXIsIGRyb3BvdXQpICU+JQogIGdyb3VwX2J5KHllYXIpICU+JQogIG11dGF0ZShuID0gbiAvIHN1bShuKSkgJT4lCiAgdW5ncm91cCgpICU+JQogIG11dGF0ZSh5ZWFyID0geWVhciAlPiUgYXMuY2hhcmFjdGVyKCkpICU+JQogIGZpbHRlcihkcm9wb3V0ID09IFRSVUUpICU+JQogIGdncGxvdChhZXMoeCA9IHllYXIsIHkgPSBuKSkgKwogIGdlb21fY29sKCkKYGBgCgoKYGBge3J9Cm5fZHJvcG91dCA8LSBkYXRhX2Ryb3BvdXQgJT4lCiAgZmlsdGVyKGRyb3BvdXQgPT0gVFJVRSwgdHlwZSA9PSAnc3dpdGNoZXInKSAlPiUKICBjb3VudCh5ZWFyLCBzZW5pb3JpdHlfYmluKSAlPiUgCiAgZ3JvdXBfYnkoeWVhcikgJT4lCiAgbXV0YXRlKHBjdCA9IG4gLyBzdW0obikpICU+JQogIHVuZ3JvdXAoKQpgYGAKCmBgYHtyfQpuX2Ryb3BvdXQgJT4lCiAgbXV0YXRlKHllYXIgPSB5ZWFyICU+JSBhcy5jaGFyYWN0ZXIoKSkgJT4lCiAgZ2dwbG90KGFlcyh4ID0geWVhciwgeSA9IG4sIGZpbGwgPSBzZW5pb3JpdHlfYmluLCBjb2wgPSBzZW5pb3JpdHlfYmluKSkgKwogIGdlb21fY29sKCkgKwogIGxhYnModGl0bGUgPSAnRHJvcG91dHMgdG90YWwnKQpgYGAKCmBgYHtyfQpuX2Ryb3BvdXQgJT4lCiAgbXV0YXRlKHllYXIgPSB5ZWFyICU+JSBhcy5jaGFyYWN0ZXIoKSkgJT4lCiAgZ2dwbG90KGFlcyh4ID0geWVhciwgeSA9IHBjdCwgZmlsbCA9IHNlbmlvcml0eV9iaW4sIGNvbCA9IHNlbmlvcml0eV9iaW4pKSArCiAgZ2VvbV9jb2woKSArCiAgbGFicyh0aXRsZSA9ICdEcm9wb3V0cyB0b3RhbCcpCmBgYAoK