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