Hi Mark. Have a look at the commands: merge and cbind I believe they may hold the key.
I hope this helps :-) Tal On Mon, May 4, 2009 at 5:38 AM, Mark Na <mtb...@gmail.com> wrote: > Dear R-helpers, > > I have a dataframe called "trackpoints" with several columns including > a column called "time", eg: > > > trackpoints > time > 1 12:00:00 > 2 12:00:01 > 3 12:00:02 > . > . > . > 298 12:04:57 > 299 12:04:58 > 300 12:04:59 > > I also have a dataframe called "data" that contains columns called > "ID", "start" and "stop", eg: > > > data > ID start stop > 1 1 12:00:00 12:01:30 > 2 2 12:02:16 12:03:01 > 3 3 12:03:58 12:04:31 > > I wish to make a dataframe called "extracted" containing only the rows > in "trackpoints" with a value of "time" bounded by the times in > data$start and data$stop and a column called "ID" containing the value > from data$ID, eg: > > > extracted > Time ID > 1 12:00:00 1 > 2 12:00:01 1 > 3 12:00:02 1 > . > . > . > 89 12:01:28 1 > 90 12:01:29 1 > 91 12:01:30 1 > > I have the vague notion that I might have to loop this, but I think it > would be cleaner to use logical subscripts, if possible. > I'd appreciate any help you might be able to provide. > > Thanks! Mark Na > > ______________________________________________ > R-help@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. > -- ---------------------------------------------- My contact information: Tal Galili Phone number: 972-50-3373767 FaceBook: Tal Galili My Blogs: http://www.r-statistics.com/ http://www.talgalili.com http://www.biostatistics.co.il [[alternative HTML version deleted]] ______________________________________________ R-help@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.
