Re: [R] merge(join) problem

2011-08-16 Thread Ista Zahn
On Tue, Aug 16, 2011 at 6:40 PM, Sam Steingold wrote: >> * Ista Zahn [2011-08-16 18:31:00 -0400]: >> On Tue, Aug 16, 2011 at 6:29 PM, Ista Zahn wrote: >>> Hi Tia, > > "tia" == "thanks in advance" :-) *facepalm* Thanks Sam, one day I'll learn internet acronyms... > >> AB3 <- AB2[order(AB$Time,

Re: [R] merge(join) problem

2011-08-16 Thread Sam Steingold
> * Ista Zahn [2011-08-16 18:31:00 -0400]: > On Tue, Aug 16, 2011 at 6:29 PM, Ista Zahn wrote: >> Hi Tia, "tia" == "thanks in advance" :-) > AB3 <- AB2[order(AB$Time, decreasing=TRUE), ] > AB4 <- AB3[!duplicated(AB3[c("Name", "Open")]), ] thanks! -- Sam Steingold (http://sds.podval.org/) on

Re: [R] merge(join) problem

2011-08-16 Thread Ista Zahn
On Tue, Aug 16, 2011 at 6:29 PM, Ista Zahn wrote: > Hi Tia, > > On Tue, Aug 16, 2011 at 6:00 PM, Sam Steingold wrote: >> I have two datasets: >> A with columns Open and Name (and many others, irrelevant to the merge) >> B with columns Time and Name (and many others, irrelevant to the merge) >> >>

Re: [R] merge(join) problem

2011-08-16 Thread Ista Zahn
Hi Tia, On Tue, Aug 16, 2011 at 6:00 PM, Sam Steingold wrote: > I have two datasets: > A with columns Open and Name (and many others, irrelevant to the merge) > B with columns Time and Name (and many others, irrelevant to the merge) > > I want the dataset AB with all these columns > Open from A -

[R] merge(join) problem

2011-08-16 Thread Sam Steingold
I have two datasets: A with columns Open and Name (and many others, irrelevant to the merge) B with columns Time and Name (and many others, irrelevant to the merge) I want the dataset AB with all these columns Open from A - a difftime (time of day) Time from B - a difftime (time of day) Name (same