R 그룹별 합 구하기

1 개요

R 그룹별 합 구하기

• 대략 SQL의 "SELECT SUM(ea) GROUP BY fruit"

df <- read.csv( header=T, stringsAsFactors=FALSE, text="
day,fruit,ea
2019-06-01,apple,1
2019-06-11,apple,1
2019-06-21,banana,2
2019-07-01,apple,3
2019-07-11,banana,4
2019-08-25,orange,2
")

aggregate(ea ~ fruit, df, sum)
##    fruit ea
## 1  apple  5
## 2 banana  6
## 3 orange  2

tapply(df$ea, df$fruit, sum)
## apple banana orange 
##     5      6      2

2 같이 보기

• R tapply()
• R aggregate()

3 참고

• https://stackoverflow.com/questions/1660124/how-to-sum-a-variable-by-group