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
Is there any R package which I can use for the above calculation?
On Tue, Jun 3, 2008 at 12:02 AM, Marc Schwartz <[EMAIL PROTECTED]>
wrote:
> on 06/02/2008 08:45 AM Jason Lee wrote:
>
>> Hi,
>>
>> I have a data frame which format is like below:-
>>
>> X Y Z
>> 131 22.2 3.4 4.4
>> 150 20.0 12.2 4.5
>>
>> etc...
>>
>> And I have sorted the data frame. However, I would like to grab one of
>> these
>> elements in the data frame. Also, i would like to number these rows so
>> that
>> when i grab a particular line let say 150, it is able to return me the
>> position of the row rather than the "150". Let say in this example, when i
>> grab a value of 150, it gives me 2 rather than 150.
>>
>>
>> I tried to add anohter extra column of number which is data$NUMBER =
>> row.names(data) on the sorted data but it seems not giving what I wanted
>> which is the "position" of the row 150.
>>
>> Please advise. Thanks.
>>
>
> Is this what you want?
>
> > DF
> X Y Z
> 131 22.2 3.4 4.4
> 150 20.0 12.2 4.5
>
>
> > which(row.names(DF) == 150)
> [1] 2
>
>
> See ?which
>
> HTH,
>
> Marc Schwartz
>
>
[[alternative HTML version deleted]]
______________________________________________
R-help@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.
