[R] Fuzzy merge using timestamps

2010-11-10 Thread Ian Craig
Greetings Supreme Council of R Masters, Like toddler, I have gotten my head stuck in the banisters of R ... again. Let it be know I am still a neophyte in the R-community forum world, so please don't flame me too bad. I have two sets of data, each with a set of timestamps. I would like to

Re: [R] Fuzzy merge using timestamps

2010-11-10 Thread Sarah Goslee
On Wed, Nov 10, 2010 at 12:57 PM, Ian Craig ian.jh...@gmail.com wrote: Greetings Supreme Council of R Masters, Nice. :) I have two sets of data, each with a set of timestamps.  I would like to somehow merge the datasets based on the timestamps and an individual identifier.  That is there are

[R] Fuzzy merge using timestamps

2010-11-10 Thread blurg
Let it be know I am still a neophyte in the R-community forum world, so please don't flame me too bad. I have two sets of data, each with a set of timestamps. I would like to somehow merge the datasets based on the timestamps and an individual identifier. That is there are several

Re: [R] Fuzzy merge using timestamps

2010-11-10 Thread Ian Craig
So here is a sample of the datasets. I have modified them for the purposes of circulating to solve this problem. I have already added the ID and key as seen in the code below. Any ideas? gpsdata gpsARC Protocol TrackUTCDate UTCTime LocalDate LocalTimey x Altitude_m

Re: [R] Fuzzy merge using timestamps

2010-11-10 Thread Sarah Goslee
Hi Ian, Did you see the second part of my request, for a simple reproducible example? At the very least, we need your merge and sort code, since it sounds like that's where the problem truly lies. Sarah On Wed, Nov 10, 2010 at 2:02 PM, Ian Craig ian.jh...@gmail.com wrote: So here is a sample

Re: [R] Fuzzy merge using timestamps

2010-11-10 Thread Ian Craig
The sorting for the times is below: checkTime - checkTimes[order(checkTimes$ARC,checkTimes$times, decreasing = FALSE),] After the merging data frame is created I use these two commands to merge the checkTime data frame with the other two dataframes: data_gps - merge(gpsdata,match, by=

[R] Fuzzy merge using timestamps

2010-11-08 Thread blurg
Greetings Supreme Council of R Masters, Like toddler, I have gotten my head stuck in the banisters of R ... again. Let it be know I am still a neophyte in the R-community forum world, so please don't flame me too bad. I have two sets of data, each with a set of timestamps. I would like to