我想對某些行的值求和。例如,雖然ID是相同的,但當字母是a和b時,我們將對值求和。
ID <- c(1,1,1,8,8,8,2,2,2,5,5,5,7,7,7)
letter <- c("a","b","c","a","b","c","a","b","c","a","b","c","a","b","c")
value <- c(111,75,94,37,85,86,76,55,72,62,56,35,85,44,65)
dataframe <- data.frame(ID,letter,value)
結果如下
ID letter value
1 1 a 111
2 1 b 75
3 1 c 94
4 8 a 37
5 8 b 85
6 8 c 86
7 2 a 76
8 2 b 55
9 2 c 72
10 5 a 62
11 5 b 56
12 5 c 35
13 7 a 85
14 7 b 44
15 7 c 65
有了
dplyr
你可以做到這一點或者更緊湊