我试图在我的datatable中创建多个列,这些列表示按行匹配给定模式的列的总和.
df <- data.frame(first_column = c("Alpha", "Beta", "Charlie", "Tango", "Alpha, Beta,Alpha", "Alpha,Beta,Charlie", 'Tango,Tango,Tango,Tango', 'Tango,Tango,Tango, Tango', 'Tango,Tango,Tango, Tango , Alpha,Beta,Charlie, Alpha, Alpha ,Alpha '),
number_1 = 1:9,
number_2 = 11:19,
number_3 = 2:10,
number_4 = 12:20)
testing <- df %>%
mutate(number_1 = as.numeric(number_1),
number_2 = as.numeric(number_2))%>%
as.data.table
testing3 = testing[,`:=` ("Total 1" = Reduce(`+`, grep("number_1|number_2", names(testing), value = TRUE)),
"Total 2" = Reduce(`+`, grep("number_3|number_4", names(testing), value = TRUE)))]
这就是我一直试图go 做的,但都没有用.我应该看到的是总共1排1,12和总共2排1,14
但我不能这样做.