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

Peter Ehlers ehlers at ucalgary.ca
Mon Nov 16 21:16:48 CET 2009


I would use pkg:plyr, but just to show how
versatile R is:

ind <- cumsum(rle(as.numeric(dat$Name))$lengths)
dat[ind, ]

where I'm assuming that your data frame is
called 'dat'.

  -Peter Ehlers

Hao Cen 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