Используя этот набор данных:
sex <- c("M","F","M","M","F","F","F","M","M","F")
school <- c("north","north","central","south","south","south","central","north","north","south")
school_type <- c("high","high","primary","secondary","secondary","secondary","primary","high", "high","secondary")
days_missed <- c(5,1,2,0,7,1,3,2,4,15)
df <- data.frame(sex, school, school_type,days_missed, stringsAsFactors = F)
col1 <- c( 'school_type')
col2 <- c('school','sex')
Можем ли мы разделить фрейм данных на col1
, а затем сгруппировать каждый полученный фрейм данных на col2
, чтобы создать вывод, например:
$high .x
school sex sum
north F 1
north M 11
$primary .x
school sex sum
central F 3
central M 2
$seconday .x
school sex sum
south F 23
south M 0
Я старался:
purrr::map(.x=col1, .f = ~df %>% group_by_at(.x) %>%group_by(col2) %>% summarise(sum = sum(days_missed)))
Вход и предложения приветствуются