Skip to content

How to sort a dataframe?

4 messages · Remko Duursma, Spencer Graves, Chuck Cleland +1 more

#
Dear R-helpers,

for the purpose of plotting a dataframe, i am trying to sort a dataframe by one column, for example

tester <- data.frame(one=c(3,2,1), two=c(2,3,1))

#> tester
#  one two
#1   3   2
#2   2   3
#3   1   1

# I want to sort "tester" by column "one", so that i get a dataframe
# that looks like:
#one two
#1    1
#2    3
#3    2

I know of 'sort' but it can only sort vectors.

Thanks for your help,

Remko Duursma
#
> tester[order(tester$one),]
   one two
3   1   1
2   2   3
1   3   2
 >
Spencer Graves
Remko Duursma wrote:
#
Remko Duursma wrote:
Remko:

   First examine the results of the following:

order(tester[,1])

   Then try this:

tester[order(tester[,1]),]

   See ?order.

hope it helps,

Chuck Cleland
#
Dear Remko,

Simply index the rows of the data frame by the order of elements in the 
first column:

 > tester[order(tester$one),]
   one two
3   1   1
2   2   3
1   3   2
 >

John
At 10:51 AM 4/7/2003 -0700, Remko Duursma wrote:

            
____________________________
John Fox
Department of Sociology
McMaster University
email: jfox at mcmaster.ca
web: http://www.socsci.mcmaster.ca/jfox