Is this what you want?
> x <- read.table(textConnection("Score Name
+ 88 000019_0070
+ 88 000019_0070
+ 87 000019_0070
+ 79 002127_0658
+ 79 002127_0658
+ 77 002127_0658"), header=TRUE)> # return best scores
> best <- by(x, x$Name, function(.nam){
+ .nam[which(.nam$Score == max(.nam$Score)),]
+ })> do.call('rbind', best)
Score Name
000019_0070.1 88 000019_0070
000019_0070.2 88 000019_0070
002127_0658.4 79 002127_0658
002127_0658.5 79 002127_0658>
On 10/10/07, Jo?o Fadista <Joao.Fadista at agrsci.dk>
wrote:> Dear all,
>
> I would like to be able to subset a data.frame in a special way. I will put
here an example:
>
> Score Name
> 88 000019_0070
> 88 000019_0070
> 87 000019_0070
> 79 002127_0658
> 79 002127_0658
> 77 002127_0658
>
> So, for the above example I would like to have a new data.frame that has
only the best "Score" for each "Name":
>
> Score Name
> 88 000019_0070
> 88 000019_0070
> 79 002127_0658
> 79 002127_0658
>
>
>
> Thanks in advance.
> Best regards,
> Jo?o Fadista
>
>
>
>
>
>
>
> [[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.
>
>
--
Jim Holtman
Cincinnati, OH
+1 513 646 9390
What is the problem you are trying to solve?