[R] Need advise in grab the line number of sorted list in R

Philipp Pagel p.pagel at wzw.tum.de
Tue Jun 3 09:39:03 CEST 2008


On Tue, Jun 03, 2008 at 10:37:33AM +1000, Jason Lee wrote:
> Hi,
> 
> If there are more than one item having the same value, how can i use R to
> take the average of the position. E.g:-
> 
>        X     Y     Z
> 131 22.2 3.4   4.4
> 132 20.0 3.4   4.4==>Position 2 if queried
> 150  20.0 12.2 4.5 =>Position 3 if queried
> 134 20.0 3.4   4.4 ==> Position4 if queried
> 159  20.0 12.2 4.5==>Position 5 if queried
> 160  22.0 12.2 4.5
> 
> When I query 150 using which, it gives "3" but since in other position the
> value are same which is 20.0, how can i get the average of the position
> which is (2+3+4+5)/3

aggregate() will do what you want. A little warning: of course aggregate
will group by elements which are EXACTLY the same so make sure the
floats in columns X really behave the way you want. Otherwise you may
want to have a look at cut().

cu
	Philipp

-- 
Dr. Philipp Pagel
Lehrstuhl für Genomorientierte Bioinformatik
Technische Universität München
Wissenschaftszentrum Weihenstephan
85350 Freising, Germany
 
 and
 
Institut für Bioinformatik und Systembiologie / MIPS
Helmholtz Zentrum München -
Deutsches Forschungszentrum für Gesundheit und Umwelt
Ingolstädter Landstrasse 1
85764 Neuherberg, Germany
http://mips.gsf.de/staff/pagel



More information about the R-help mailing list