Sorting a Data frame on R

Question

I have a data frame, class, with 3 columns (user, lab_id, score). Some lines have the same user, and the same lab_id, and some are unique rows. I want to sort the rows to go in order of user, then lab_id and the score, where score would be going in decreasing order.

So I type:

sort.class<-class[order("class$user","class$lab_id","-class$totalScore"),]

But this just gives me a data frame with only 1 row, which I know is impossible.

Ultimately, these sorts of questions are really user error, and you can try to do some debugging on your own. For example, using the inbuilt dataset "mtcars", what do you get when you run order("mtcars$mpg", "mtcars$cyl", "-mtcars$disp")? Yup. 1. So if you tried to sort by that, you would be essentially doing the equivalent of mtcars[1, ], which would return a single row. — A5C1D2H2I1M1N2O1R2T1
– A5C1D2H2I1M1N2O1R2T1, Commented Jul 2, 2013 at 16:39

David Robinson · Accepted Answer · 2013-07-02 16:29:02Z

3

Don't put those arguments to order in quotes:

sort.class<-class[order(class$user,class$lab_id,-class$totalScore),]

answered Jul 2, 2013 at 16:29

David Robinson

78.8k16 gold badges172 silver badges189 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sorting a Data frame on R

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related