[R] extracting the last row of each group in a data frame

Gabor Grothendieck ggrothendieck at gmail.com
Tue Nov 17 00:27:25 CET 2009


Try this:

> aggregate(DF[-1], DF[1], tail, 1)
  Name Value
1    A     3
2    B     8
3    C     2
4    D     3


On Mon, Nov 16, 2009 at 2:42 PM, Hao Cen <hcen at andrew.cmu.edu> wrote:
> Hi,
>
> I would like to extract the last row of each group in a data frame.
>
> The data frame is as follows
>
> Name Value
> A 1
> A 2
> A 3
> B 4
> B 8
> C 2
> D 3
>
> I would like to get a data frame as
> Name Value
> A 3
> B 8
> C 2
> D 3
>
> Thank you for your suggestions in advance
>
> Jeff
>
> ______________________________________________
> 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.
>




More information about the R-help mailing list