Hi R Users,
Some individuals recorded multiple within a time period. But, I want to select
the row of last site within each time period for each individual. I spent a
substantial time, but no luck in selecting the rows. Would you give me a hint
for this one? I have a very large data set, but this is just an example.
Thanks for your help.
I want to get dat2 from dat1.
dat1<-structure(list(sn = 1:16, Species = structure(c(1L, 1L, 1L, 1L, 1L, 2L,
2L, 2L, 3L, 3L, 4L, 5L, 5L, 5L, 5L, 5L), .Label = c("Sp1",
"Sp2", "SP3", "Sp4", "Sp5"), class = "factor"), Observed.site = structure(c(1L,
3L, 1L, 2L, 1L, 2L, 4L, 3L, 1L, 2L, 2L, 3L, 5L, 4L, 1L, 3L), .Label = c("SiteA",
"SiteB", "SiteC", "SiteD", "SIteD"), class = "factor"), Time = structure(c(1L,
5L, 6L, 6L, 6L, 2L, 3L, 11L, 8L, 10L, 1L, 1L, 4L, 4L, 7L, 9L), .Label =
c("1/15/15",
"1/17/15", "1/29/15", "2/17/15", "2/25/15", "2/27/15", "2/28/15", "3/27/15",
"3/5/15", "4/19/15", "7/3/15"), class = "factor"),
Month = structure(c(3L, 2L, 2L, 2L, 2L, 3L, 2L, 4L, 4L, 1L, 3L, 3L, 2L, 2L,
2L, 4L), .Label = c("April", "Feb", "Jan",
"March"), class = "factor")), .Names = c("sn", "Species", "Observed.site",
"Time", "Month"), class = "data.frame", row.names = c(NA, -16L))
dat1
#---
dat2<-structure(list(sn = c(1L, 5L, 6L, 9L, 10L, 11L, 12L, 15L, 16L), Species =
structure(c(1L, 1L, 2L, 3L, 3L, 4L, 5L, 5L, 5L), .Label = c("Sp1",
"Sp2", "SP3", "Sp4", "Sp5"), class = "factor"), Observed.site = structure(c(1L,
1L, 2L, 1L, 2L, 2L, 3L, 1L, 3L), .Label = c("SiteA", "SiteB",
"SiteC"), class = "factor"), Time = structure(c(1L, 3L, 2L, 5L, 7L, 1L, 1L, 4L,
6L), .Label = c("1/15/15", "1/17/15", "2/27/15",
"2/28/15", "3/27/15", "3/5/15", "4/19/15"), class = "factor"), Month =
structure(c(3L, 2L, 3L, 4L, 1L, 3L, 3L, 2L, 4L), .Label = c("April",
"Feb", "Jan", "March"), class = "factor")), .Names = c("sn", "Species",
"Observed.site", "Time", "Month"), class = "data.frame", row.names = c(NA, -9L))
dat2
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
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.
