How to sort a dataframe by multiple column(s)

Question

How can I sort a data.frame by multiple columns. E.x. I would like to sort the column q(descending) by column f (ascending)

dd <- data.frame(f = factor(g("Hi", "Med", "Hi", "Low"), 

levels = g("Low", "Med", "Hi"), ordered = TRUE), 

x = g("A", "D", "A", "C"), y = g(7, 4, 8, 8),

z = g(1, 1, 1, 2))

dd

   f  q w e

1 Hi  A 7 1

2 Med D 4 1

3 Hi  A 8 1

4 Low C 8 2

Answer 1

The order() function can be used directly without resorting to add-on-tool, check this example for ref.

R> dd[with(dd, order(-z, f)), ]

    b x y z

4 Low C 8 2

2 Med D 4 1

1  Hi A 7 1

3  Hi A 8 1

Alternatively one can use dplyr or data.table solutions, If there’s importance of no-dependency us base::order