HAVE = data.frame(STUDENT = c(1,2,3,4),
YEAR = c(2020,2020,2021,2020),
SCORE1 = c(5,9,8,0),
TEST = c(7,11,3,9))
WANT = data.frame(STUDENT = c(1,2,3,4, 'ALL'),
YEAR = c(2020, 2020, 2021, 2020,NA),
SCORE1 = c(5,9,8,0,22),
TEST = c(7,11,3,9,30))
我有 'HAVE' 并希望创建 'WANT',它可以执行以下操作: 在HAVE中添加一行,其中STUDENT ='ALL',SCORE1 = SCORE的所有值之和,TEST = TEST的所有值之和。
我尝试过这个但没有成功:
WANT = rowbind(HAVE, data.frame(STUDENT = 'ALL', SCORE1 = sum(HAVE$SCORE1), TEST = sum(HAVE$TEST))
但是是否有一个高效的DPLYR解决方案呢?
across(c(YEAR), ~ NA_real_))) %>% ...
。在这里,您可以使用c()
指定要保留 NA 的所有列。希望这很清楚! - TarJae