How to use aggregate() method in Base R In R Language
aggregate() function is used to get the summary statistics of the data by group. The statistics include mean, min, sum. max etc.
Syntax: aggregate(dataframe$aggregate_column, list(dataframe$group_column), FUN)
where
- dataframe is the input dataframe.
- aggregate_column is the column to be aggregated in the dataframe.
- group_column is the column to be grouped with FUN.
- FUN represents sum/mean/min/ max.
R
# creating data frame df <- data.frame (Sub = c ( 'Math' , 'Math' , 'Phy' , 'Phy' , 'Phy' , 'Che' , 'Che' ), Marks = c (8, 2, 4, 9, 9, 7, 1), Add_on = c (3, 1, 9, 4, 7, 8, 2)) aggregate (df$Marks, list (df$Sub), FUN=sum) aggregate (df$Add_on, list (df$Sub), FUN=sum) |
Output:
Group.1 x Che 8 Math 10 Phy 22 Group.1 x Che 10 Math 4 Phy 20
How to Calculate the Sum by Group in R?
In this article, we are going to see how to calculate the Sum by Group in R Programming Language.
Data for Demonstration
R
# creating data frame df <- data.frame (Sub = c ( 'Math' , 'Math' , 'Phy' , 'Phy' , 'Phy' , 'Che' , 'Che' ), Marks = c (8, 2, 4, 9, 9, 7, 1), Add_on = c (3, 1, 9, 4, 7, 8, 2)) # view dataframe df |
Output:
Sub Marks Add_on Math 8 3 Math 2 1 Phy 4 9 Phy 9 4 Phy 9 7 Che 7 8 Che 1 2