How to Get the Minimum & Maximum by Group in a Data Frame in R (2 Examples)
In this tutorial, I’ll illustrate how to find the minimum and maximum by data frame groups in the R programming language.
Creation of Example Data
data(iris) # Loading iris data frame head(iris) # Sepal.Length Sepal.Width Petal.Length Petal.Width Species # 1 5.1 3.5 1.4 0.2 setosa # 2 4.9 3.0 1.4 0.2 setosa # 3 4.7 3.2 1.3 0.2 setosa # 4 4.6 3.1 1.5 0.2 setosa # 5 5.0 3.6 1.4 0.2 setosa # 6 5.4 3.9 1.7 0.4 setosa |
data(iris) # Loading iris data frame head(iris) # Sepal.Length Sepal.Width Petal.Length Petal.Width Species # 1 5.1 3.5 1.4 0.2 setosa # 2 4.9 3.0 1.4 0.2 setosa # 3 4.7 3.2 1.3 0.2 setosa # 4 4.6 3.1 1.5 0.2 setosa # 5 5.0 3.6 1.4 0.2 setosa # 6 5.4 3.9 1.7 0.4 setosa
Example 1: Calculating Min & Max by Group Using aggregate() Function
aggregate(formula = Sepal.Length ~ Species, # Returning min by group data = iris, FUN = min) # Species Sepal.Length # 1 setosa 4.3 # 2 versicolor 4.9 # 3 virginica 4.9 |
aggregate(formula = Sepal.Length ~ Species, # Returning min by group data = iris, FUN = min) # Species Sepal.Length # 1 setosa 4.3 # 2 versicolor 4.9 # 3 virginica 4.9
Example 2: Calculate Min & Max by Group Using Base R
aggregate(formula = Sepal.Length ~ Species, # Returning max by group data = iris, FUN = max) # Species Sepal.Length # 1 setosa 5.8 # 2 versicolor 7.0 # 3 virginica 7.9 |
aggregate(formula = Sepal.Length ~ Species, # Returning max by group data = iris, FUN = max) # Species Sepal.Length # 1 setosa 5.8 # 2 versicolor 7.0 # 3 virginica 7.9
Further Resources & Related Tutorials
In addition, you may want to have a look at some of the other articles on my website.