Skip to content
Prev 200458 / 398503 Next

extracting the last row of each group in a data frame

On Nov 16, 2009, at 2:42 PM, Hao Cen wrote:

            
by(dfname$Value, dfname$Name, tail, 1) #which gets you a list

Or:

aggregate(dfname$Value, list(dfname$Name), tail, 1)  #which returns a  
data.frame
   Group.1 x
1       A 3
2       B 8
3       C 2
4       D 3