aggregate() Function in R – How to Summarize and Group Data Easily

🎯 Topic: aggregate() Function in R Programming

Overview (150+ words):

The aggregate() function in R is a concise and powerful tool to compute summary statistics (such as mean, sum, minimum, maximum, or count) for subsets of data defined by one or more grouping variables. It is especially useful when working with data frames and when you want to produce group-wise summaries without converting your data into other structures. aggregate() works by specifying a formula (e.g. value ~ group) or by giving the data and grouping variables separately via the by argument. For example, you can compute the average math score by class, the total science marks by gender, or the count of students by class. The function returns a data frame with the grouping variables and the computed summary values.

Unlike some piping workflows (e.g., dplyr::group_by() + summarize()), aggregate() is base R and therefore requires no additional packages. It is ideal for learners because the syntax is straightforward and it helps reinforce understanding of formulas and functions in R. Below we’ll create a sample dataset, show multiple examples (mean, sum, count), and explain each code chunk so students can follow along and practice.

Dataset: students_scores (Creation & Explanation)

We will use a simple but realistic dataset named students_scores. It contains 12 rows representing students in different classes and their scores in three subjects. Columns:

• StudentID – unique identifier for each student
• Class – class or grade (A or B)
• Gender – M (male) or F (female)
• Math, Science, English – numeric scores (0–100)

R code: Create the dataset

# Create the dataset in R
students_scores <- data.frame(
  StudentID = 1:12,
  Class     = c('A','A','A','A','B','B','B','B','A','B','A','B'),
  Gender    = c('M','F','M','F','M','F','M','F','F','M','M','F'),
  Math      = c(78,85,92,66,74,88,90,59,81,73,95,67),
  Science   = c(82,79,88,71,68,94,85,60,77,72,91,65),
  English   = c(75,88,81,69,80,86,78,64,83,70,90,72)
)

# View the dataset
print(students_scores)

Dataset explanation: Each row is a student. Notice the dataset mixes grouping variables (Class, Gender) and numeric variables (scores) we want to summarize. We’ll use aggregate() to get per-class averages, per-gender totals, and counts.

Example 1: Compute mean Math score by Class (aggregate with formula)

# Mean Math score by Class using formula notation
agg_mean_math_by_class <- aggregate(Math ~ Class, data = students_scores, FUN = mean)
print(agg_mean_math_by_class)

Explanation: The formula Math ~ Class tells R: compute a summary of Math for each level of Class. FUN = mean computes the average. The result is a small data frame with Class and the corresponding mean Math score. For instance, if Class A students have Math scores {78,85,92,66,81,95} the mean will be computed as the sum divided by 6.

Example 2: Compute mean of multiple columns by Class

# Mean of Math, Science, English by Class
agg_means_by_class <- aggregate(. ~ Class, data = students_scores[c('Class','Math','Science','English')], FUN = mean)
print(agg_means_by_class)

Explanation: Using . ~ Class means “apply the function to all other columns grouped by Class“. Here we’ll get mean values for Math, Science and English for each class. This is handy when summarizing several numeric columns at once.

Example 3: Sum of Science scores by Gender (Simplified Method using aggregate() formula)

This simplified method uses the formula format inside aggregate(). The expression Science ~ Gender means that the Science scores are grouped by Gender. This method is shorter, cleaner, and automatically assigns appropriate column names.

# Sum of Science scores by Gender (Simple formula method)
agg_sum_science_by_gender <- aggregate(Science ~ Gender, data = students_scores, sum)
print(agg_sum_science_by_gender)

Example 4: Sum of Science scores by Gender (Formula Method with Custom Output Column Name)

In this method, we still use the formula version of aggregate(), but we additionally rename the second column to TotalScience to make the output clearer. This approach is still simpler and more readable compared to writing by = list().

# Sum of Science scores by Gender with renamed output column
result <- aggregate(Science ~ Gender, data = students_scores, sum)
names(result)[2] <- "TotalScience"
print(result)

Explanation: Here we pass the vector to summarize (students_scores$Science) and grouping variables via by = list(Gender = ...). The result is a data frame showing the sum of Science scores for males and females.

Example 4: Counting rows (number of students) by Class

# Count number of students by Class
agg_count_by_class <- aggregate(StudentID ~ Class, data = students_scores, FUN = length)
colnames(agg_count_by_class)[2] <- 'Count'
print(agg_count_by_class)

Explanation: Using length as the function returns the number of rows in each group. This gives a simple frequency table of students per class. An alternative is to use table(students_scores$Class), but aggregate() keeps output in data frame format.

Example 5: Finding the Minimum and Maximum Math Scores for Each Class (Beginner-Friendly Method)

Instead of using a custom function that returns multiple values (which can be confusing for beginners), we can calculate the minimum and maximum Math scores separately and then combine the results. This approach is much easier to read and understand, especially for students learning Base R.

# Step 1: Find the minimum Math score in each Class
agg_math_min <- aggregate(Math ~ Class, data = students_scores, FUN = min)

# Step 2: Find the maximum Math score in each Class
agg_math_max <- aggregate(Math ~ Class, data = students_scores, FUN = max)

# Step 3: Combine both results side-by-side
agg_math_range <- cbind(agg_math_min, Math.max = agg_math_max$Math)

# Step 4: Print the final table
print(agg_math_range)

Explanation:
This method breaks the problem into small, simple steps:

• Step 1: aggregate() with min finds the lowest Math score in each Class.
• Step 2: Another aggregate() with max finds the highest Math score for each Class.
• Step 3: cbind() places the two results next to each other in a single data frame.
• Step 4: The result now clearly shows Class, Math.min, Math.max in an easy-to-read format.

This is the most beginner-friendly approach because each step has only one purpose. Students can clearly see how min and max are calculated and how both results are combined. It avoids advanced concepts such as functions returning vectors or converting list-like structures.

Good practices & tips

• If grouping variables are factors, aggregate() respects their levels. Convert character groups to factors when needed.
• For more complex summarization (multiple functions or tidy output), consider dplyr, but learn aggregate() first to understand grouping logic in base R.
• When using aggregate() on data frames with non-numeric columns, select only the numeric columns or use the formula . ~ Group with a subset of columns.

Practice Exercises (Self-assessment)

1. Using students_scores, compute the average English score for each Gender. Show the R code and the resulting data frame.
2. Find the total (sum) of Math scores for each Class and Gender combination (two grouping variables). Use aggregate() and explain the output.
3. Using aggregate(), produce a data frame that shows the mean and standard deviation of Science scores by Class. (Hint: you may need to run two aggregates or a custom function.)
4. Count how many students scored above 80 in Math in each Class (use an appropriate logical grouping inside aggregate() or create a helper column).

Answer Format (How to present answers)

Please present your answers like this for each exercise:

...R code here...

...expected printed output...

Explanation...

Answers (Example Solutions)

# R code
aggregate(English ~ Gender, data = students_scores, FUN = mean)

# Example output (approximate):
#   Gender English
# 1      F   79.0
# 2      M   79.6

# Explanation:
# The aggregate computes mean English score for F and M. Values show average across all students of that gender.

# R code
aggregate(Math ~ Class + Gender, data = students_scores, FUN = sum)

# Example output (approximate):
#   Class Gender Math
# 1     A      F  334
# 2     B      F  299
# 3     A      M  345
# 4     B      M  337

# Explanation:
# Summation grouped by both Class and Gender returns total Math scores for each subgroup.

# R code (two-step)
agg_mean_science <- aggregate(Science ~ Class, data = students_scores, FUN = mean)
agg_sd_science   <- aggregate(Science ~ Class, data = students_scores, FUN = sd)
merge(agg_mean_science, agg_sd_science, by = 'Class')

# Example output (approximate):
#   Class Science.x Science.y
# 1     A      82.5      7.1
# 2     B      75.3     12.2

# Explanation:
# We calculated mean and sd separately and merged them for readability.

# R code (helper column)
students_scores$MathOver80 <- students_scores$Math > 80
aggregate(MathOver80 ~ Class, data = students_scores, FUN = sum)

# Example output (approximate):
#   Class MathOver80
# 1     A          4
# 2     B          2

# Explanation:
# We created a logical column (TRUE/FALSE). Summing TRUEs counts students with Math > 80.

Final Notes for Students

The base R aggregate() function remains a great starting point for learning group-wise summaries and understanding how formulas and grouping work in R. Once comfortable with aggregate(), explore dplyr for more flexible and readable workflows: group_by() + summarize(). Keep practicing by creating small datasets and asking simple questions — data analysis is about curiosity and iteration.

Prepared for learners: concise, accessible, and ready to copy into your WordPress post without changing site layout.