[R] Conditional sorting

Dimitris Rizopoulos d.rizopoulos at erasmusmc.nl
Fri Jul 24 13:54:30 CEST 2009


try this:

d <- data.frame(RUN = rep(1:3, each = 3), ID = 1:9, AUC =
runif(9,1,100))

d[order(d$RUN, d$AUC), ]


I hope it helps.

Best,
Dimitris


Riley, Steve wrote:
> Greetings!
>  
> I am trying to figure out how to order a data frame by one variable
> conditioned on another. 
>  
> Here is an example of what I have:
>  
> d <- data.frame(RUN = rep(1:3, each = 3), ID = 1:9, AUC =
> runif(9,1,100))
>  
>> d
> RUN ID  AUC
>   1    1    70.2
>   1    2    86.5
>   1    3    20.1
>   2    4    74.3
>   2    5    53.6
>   2    6    67.6
>   3    7    99.9
>   3    8    47.3
>   3    9    41.3
> 
> Here is what I want (data frame sorted by AUC within RUN):
>  
>> d
> RUN ID  AUC
>   1    3    20.1
>   1    1    70.2
>   1    2    86.5
>   2    5    53.6
>   2    6    67.6
>   2    4    74.3
>   3    9    41.3
>   3    8    47.3
>   3    7    99.9
> 
> Here is  my version info:
>  
>> version
>                _                           
> platform       i386-pc-mingw32             
> arch           i386                        
> os             mingw32                     
> system         i386, mingw32               
> status                                     
> major          2                           
> minor          7.2                         
> year           2008                        
> month          08                          
> day            25                          
> svn rev        46428                       
> language       R                           
> version.string R version 2.7.2 (2008-08-25)
> 
>  
> Any thoughts you could provide would be greatly appreciated. Thanks and
> have a great day!
>  
> Steve
>  
> 
> Steve Riley, Pharm.D., Ph.D. 
> Clinical Pharmacology, Specialty Neuroscience
> Pfizer Specialty Care Business Unit
> Mail Stop MS 6025-B2110 
> 50 Pequot Ave
> New London, CT 06320
> 
> Steve.Riley at Pfizer.com 
> Tel:  (860) 732-1796
> Fax: (860) 686-5672
> 
>  
> 
> 	[[alternative HTML version deleted]]
> 
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
> 

-- 
Dimitris Rizopoulos
Assistant Professor
Department of Biostatistics
Erasmus University Medical Center

Address: PO Box 2040, 3000 CA Rotterdam, the Netherlands
Tel: +31/(0)10/7043478
Fax: +31/(0)10/7043014




More information about the R-help mailing list