Re: [R] merge function while obviating duplicate columns XXXX

2013-03-11 Thread William Dunlap
id Name Age 1 2 Ken 45 2 3 Leo 49 Bill Dunlap Spotfire, TIBCO Software wdunlap tibco.com > -Original Message- > From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] On > Behalf > Of Dan Abner > Sent: Monday, March 11, 2013 2:02 PM > To:

Re: [R] merge function while obviating duplicate columns XXXX

2013-03-11 Thread Jeff Newmiller
intersect(names(data1),names(data2)) --- Jeff NewmillerThe . . Go Live... DCN:Basics: ##.#. ##.#. Live Go... Live: OO#.. Dead: OO

Re: [R] merge function while obviating duplicate columns XXXX

2013-03-11 Thread Dan Abner
Ok, let's say I only want the common columns from data1. Is there a succinct way of doing this for potentially hundreds of "in common" columns? On Mon, Mar 11, 2013 at 3:25 PM, Ista Zahn wrote: > On Mon, Mar 11, 2013 at 3:17 PM, Dan Abner wrote: >> Hi everyone, >> >> I have the following call

Re: [R] merge function while obviating duplicate columns XXXX

2013-03-11 Thread Ista Zahn
On Mon, Mar 11, 2013 at 3:17 PM, Dan Abner wrote: > Hi everyone, > > I have the following call to the merge() function. How does one > prevent duplicate columns in the resulting data frame that the 2 > parent data frames have in common but are not true key or "by" > variables? > > > data3<-merge(d

[R] merge function while obviating duplicate columns XXXX

2013-03-11 Thread Dan Abner
Hi everyone, I have the following call to the merge() function. How does one prevent duplicate columns in the resulting data frame that the 2 parent data frames have in common but are not true key or "by" variables? data3<-merge(data1,data2,by="id") data3 id total.x total.y balance 1 78 78 90