[R] select the last row by id group
Tony Chu
gatony at gmail.com
Mon Jun 12 19:34:33 CEST 2006
Dear R users:
I have a small test dataframe as the follows :
math = c(80,75,70,65,65,70)
reading = c(65,70,88,NA,90,NA)
id = c('001','001','001','002','003','003')
score = data.frame(id, reading, math)
> score
id reading math
1 001 65 80
2 001 70 75
3 001 88 70
4 002 NA 65
5 003 90 65
6 003 NA 70
Could someone advise me tips about how to select the last row from
each id group of 001, 002, & 003?
In other words, the rows I need are :
id reading math
3 001 88 70
4 002 NA 65
6 003 NA 70
I tried function sebset but could not go very far. Thanks !
More information about the R-help
mailing list