Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to find the subtotal in R?
By subtotal we mean finding the sum of values based on grouping column. For example, if we have a data frame called df that contains three numerical columns as x, y, z and one categorical column say Group then the subtotal of x, y, z for each category in Group can be found by using the command aggregate(cbind(x,y,z)~Group,data=df,FUN=sum).
Consider the below data frame −
Example
x1<-rpois(20,2)
x2<-rpois(20,2)
x3<-rpois(20,2)
Grp<-sample(c("I","II","III"),20,replace=TRUE)
df1<-data.frame(x1,x2,x3,Grp)
df1Output
x1 x2 x3 Grp 1 8 1 2 I 2 2 2 2 III 3 1 2 1 II 4 1 3 1 II 5 3 0 2 II 6 3 2 2 III 7 2 1 1 III 8 2 1 4 III 9 4 3 3 I 10 0 0 3 II 11 1 4 1 I 12 2 2 7 III 13 3 1 0 II 14 3 5 2 II 15 3 2 5 III 16 0 0 2 II 17 0 3 0 III 18 5 5 1 II 19 3 3 2 II 20 2 3 2 I
Finding the subtotal for categories in Grp −
Example
aggregate(cbind(x1,x2,x3)~Grp,data=df1,FUN=sum)
Output
Grp x1 x2 x3 1 I 15 11 8 2 II 19 19 14 3 III 14 13 21
Example
Category<-sample(c("First","Second","Third","Fourth"),20,replace=TRUE)
y1<-rpois(20,12)
y2<-rpois(20,12)
y3<-rpois(20,12)
y4<-rpois(20,12)
df2<-data.frame(Category,y1,y2,y3,y4)
df2Output
Category y1 y2 y3 y4 1 Second 14 15 16 12 2 Fourth 12 20 11 19 3 Fourth 18 8 15 10 4 First 12 7 14 11 5 First 5 17 15 16 6 First 15 10 9 12 7 Fourth 8 15 8 10 8 Third 17 15 14 11 9 Second 11 12 10 15 10 First 16 18 14 6 11 Fourth 14 11 10 12 12 Third 15 17 13 22 13 First 18 19 9 7 14 Second 13 16 16 10 15 Fourth 6 10 21 20 16 Fourth 8 12 14 13 17 Third 17 16 16 13 18 Second 8 11 14 9 19 First 10 9 16 10 20 Second 3 10 9 12
Finding the subtotal for categories in Category column of df2 −
Example
aggregate(cbind(y1,y2,y3,y4)~Category,data=df2,FUN=sum)
Output
Category y1 y2 y3 y4 1 First 76 80 77 62 2 Fourth 66 76 79 84 3 Second 49 64 65 58 4 Third 49 48 43 46
Updated on: 11-Feb-2021
447 Views
Advertisements