Re: [R] Problem in selecting rows in R

2016-03-20 Thread Kristi Glover
From: Boris Steipe Sent: March 20, 2016 9:21 AM To: Kristi Glover Cc: R-help Subject: Re: [R] Problem in selecting rows in R Don't post in HTML, but thanks for providing dput() outout. This code tries to follow your specifications, assuming by "time period" you mean days. The

Re: [R] Problem in selecting rows in R

2016-03-20 Thread Boris Steipe
Don't post in HTML, but thanks for providing dput() outout. This code tries to follow your specifications, assuming by "time period" you mean days. The result doesn't look like your desired example though, because that is not compatible with your specs and I can't guess what you want to do diff

Re: [R] Problem in selecting rows in R

2016-03-20 Thread Bert Gunter
Your example is wrong: What happened to Sp2 on 1/29? You have also apparently mixed up lower and upper case: "Sp1", "SP3" . This will likely cause you great grief, so try to avoid or fix this in your work. Anyway, there are tons of ways to do this. dplyR is particularly good at this sort of thin

[R] Problem in selecting rows in R

2016-03-20 Thread Kristi Glover
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 thi

Re: [R] Problem in selecting rows in R

2016-03-20 Thread Michael Dewey
Dear Kristi You do not say what you have tried but I would have thought the key to a solution was to split your problem up by site and write a function to select the last observation within each site. I am not quite clear whether this is the last in time or the last occurring row so I just gi