How to sort data in R I want price column to be sorted and want the respective names to be displayed beside it

Question

Names                PRICE        
Sony LED 32          25000
Samsung LED 32       25500
LG LED 32            23000

I want Price column to be sorted in descending order and respective names displayed along its side in the given below manner :-

Samsung LED 32       25500
Sony LED 32          25000
LG LED 32            23000

score 0 · Answer 1 · answered Jan 18 '17 at 03:09

0

You can get the order of the data using the order function. Then use that to display all fields in that order.

df
           Names PRICE
1    Sony LED 32 25000
2 Samsung LED 32 25500
3      LG LED 32 23000

df[order(df$Names, decreasing = TRUE),]
           Names PRICE
1    Sony LED 32 25000
2 Samsung LED 32 25500
3      LG LED 32 23000

If you want to save it sorted (not just print it) use

df = df[order(df$Names, decreasing = TRUE),]

answered Jan 18 '17 at 03:09

G5W

36,531
10
47
80

can we use sort function for the above query – abhishek mathpal Jan 18 '17 at 18:45
Sort would reorder the data based on PRICE, but not tell you how to move the Names to the corresponding place. – G5W Jan 18 '17 at 18:47
is there any way by using sort we can attach respective names column to it? – abhishek mathpal Jan 18 '17 at 18:58
I do not see how to do it that way. That is why I used order. – G5W Jan 18 '17 at 19:01
im thinking that we paste the two columns and make text =0 somehow can we do that? – abhishek mathpal Jan 18 '17 at 19:07
is it possible or im just a peterpan in fairy land? – abhishek mathpal Jan 18 '17 at 19:08
The problem is that the sort order for the names is different from the sort order for the prices. You need to move the names according to the values in PRICE. Besides, what is the problem with what I suggested? It is just one line of code? – G5W Jan 18 '17 at 19:09
its perfectly fine awesome i dont have any problem with that its just like having modes of transportation – abhishek mathpal Jan 18 '17 at 19:12

How to sort data in R I want price column to be sorted and want the respective names to be displayed beside it

1 Answers1