Order Data Frame Variable Based On Another Column in R (Example Code)
On this page you’ll learn how to order a data frame variable based on another column in R.
Introduction of Example Data
data(iris) # Example data 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) # Example data 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: How to Order the Rows of a Data Frame Based On Multiple Columns
iris_sort <- iris[order(iris$Sepal.Length, # Sorting a data frame based on multiple variables iris$Petal.Length), ] head(iris_sort) # Sepal.Length Sepal.Width Petal.Length Petal.Width Species # 14 4.3 3.0 1.1 0.1 setosa # 39 4.4 3.0 1.3 0.2 setosa # 43 4.4 3.2 1.3 0.2 setosa # 9 4.4 2.9 1.4 0.2 setosa # 42 4.5 2.3 1.3 0.3 setosa # 23 4.6 3.6 1.0 0.2 setosa |
iris_sort <- iris[order(iris$Sepal.Length, # Sorting a data frame based on multiple variables iris$Petal.Length), ] head(iris_sort) # Sepal.Length Sepal.Width Petal.Length Petal.Width Species # 14 4.3 3.0 1.1 0.1 setosa # 39 4.4 3.0 1.3 0.2 setosa # 43 4.4 3.2 1.3 0.2 setosa # 9 4.4 2.9 1.4 0.2 setosa # 42 4.5 2.3 1.3 0.3 setosa # 23 4.6 3.6 1.0 0.2 setosa
Related Tutorials
Have a look at the following R tutorials. They discuss similar topics as this post: