我在R中有以下数据帧.我创建了一个名为"Average"的新列,它取我的数据帧中前三列的平均值,但我想使用列索引(例如列2,3,4)而不是列名.有没有办法做到这一点?
library(tidyverse)
data <- structure(list(Model = c("Adjusted Compnents Model", "ARIMA",
"STIF Model"), `2021-11-30` = c(0.2, 0.1, 0.3), `2021-12-31` = c(0.2,
0.3, 0), `2022-01-31` = c(0.2, 0.5, 0.3), `2022-02-28` = c(0.1,
0.3, 0.1), `2022-03-31` = c(0.1, 0.2, 0.1), `2022-04-30` = c(0.2,
0.1, 0.1)), class = c("tbl_df", "tbl", "data.frame"), row.names = c(NA,
-3L))
data %>%
mutate(Average = mean(`2021-11-30`:`2022-01-31`), .after = 4)