How to sort a data frame in R by multiple columns together?

We can sort a data frame by multiple columns using order function.

Example

Consider the below data frame −

> df  df
x1 x2 x3 x4
1 Hi A 4 9
2 Med B 7 5
3 Hi D 5 7
4 Low C 3 4

Let’s say we want to sort the data frame by column x4 in descending order then by column x1 in ascending order.

It can be done follows −

> df[with(df, order(-x4, x1)), ]
x1 x2 x3 x4
1 Hi A 4 9
3 Hi D 5 7
2 Med B 7 5
4 Low C 3 4

We can do it by using column index as well −

> df[order(-df[,4], df[,1]), ]
x1 x2 x3 x4
1 Hi A 4 9
3 Hi D 5 7
2 Med B 7 5
4 Low C 3 4