Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

How to Use aggregate Function in R

  • Last Updated : 19 Dec, 2021

In this article, we will discuss how to use aggregate function in R Programming 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.

Example 1: R program to create with 4 columns and group with subjects and get the aggregates like minimum, sum, and maximum.

R




# create a dataframe with 4 columns
data = data.frame(subjects=c("java", "python", "java",
                             "java", "php", "php"),
                  id=c(1, 2, 3, 4, 5, 6),
                  names=c("manoj", "sai", "mounika",
                          "durga", "deepika", "roshan"),
                  marks=c(89, 89, 76, 89, 90, 67))
  
# display
print(data)
  
# aggregate sum of marks with subjects
print(aggregate(data$marks, list(data$subjects), FUN=sum))
  
# aggregate minimum  of marks with subjects
print(aggregate(data$marks, list(data$subjects), FUN=min))
  
# aggregate maximum of marks with subjects
print(aggregate(data$marks, list(data$subjects), FUN=max))

Output:

Example 2: R program to create with 4 columns and group with subjects and get the average (mean).

R




# create a dataframe with 4 columns
data = data.frame(subjects=c("java", "python", "java",
                             "java", "php", "php"),
                  id=c(1, 2, 3, 4, 5, 6),
                  names=c("manoj", "sai", "mounika",
                          "durga", "deepika", "roshan"),
                  marks=c(89, 89, 76, 89, 90, 67))
  
# display
print(data)
  
# aggregate average of marks with subjects
print(aggregate(data$marks, list(data$subjects), FUN=mean))

Output:


My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!