Re: [R] union of two data frames

2008-02-25 Thread Achim Zeileis
to Gabor). > you could begin by ?merge.zoo > Good Luck. > AA. > - Original Message - > From: "stephen sefick" <[EMAIL PROTECTED]> > To: "Erik Iverson" <[EMAIL PROTECTED]>; > Sent: Monday, February 25, 2008 5:37 PM > Subject: Re: [R] union

Re: [R] union of two data frames

2008-02-25 Thread AA
d begin by ?merge.zoo Good Luck. AA. - Original Message - From: "stephen sefick" <[EMAIL PROTECTED]> To: "Erik Iverson" <[EMAIL PROTECTED]>; Sent: Monday, February 25, 2008 5:37 PM Subject: Re: [R] union of two data frames > On Mon, Feb 25, 2008 at 5:35

Re: [R] union of two data frames

2008-02-25 Thread Achim Zeileis
On Mon, 25 Feb 2008, stephen sefick wrote: > DateTime var1 var2 var3 var4 var5 var6 > . .. . . . . > . . . .. . . > . .. . . . . > 1/5/06 1 2 3 4 5 6 > 1

Re: [R] union of two data frames

2008-02-25 Thread stephen sefick
On Mon, Feb 25, 2008 at 5:35 PM, stephen sefick <[EMAIL PROTECTED]> wrote: > DateTime var1 var2 var3 var4 var5 var6 > . .. . . . . > . . . .. . . > . .. . . . . > 1/5/06 1

Re: [R] union of two data frames

2008-02-25 Thread stephen sefick
DateTime var1 var2 var3 var4 var5 var6 . .. . . . . . . . .. . . . .. . . . . 1/5/06 1 2 3 4 5 6 1/6/06 1 2 3 4 5 6 1/7/06 3

Re: [R] union of two data frames

2008-02-25 Thread Erik Iverson
Perhaps this example might help you? I create 2 sample data.frames, take a look at what they contain and then what the merge function gives. Compare with all = FALSE. df1 <- data.frame(a = 1:10, b = 11:20) df2 <- data.frame(a = c(1:2,98), b = c(11:12, 99)) merge(df1, df2, all = TRUE) Erik I

Re: [R] union of two data frames

2008-02-25 Thread Wensui Liu
stephen, are you sure you want a union? in db term, union has a specific meaning. it seems to me you want a innerjoin, isn't it? sqldf package is a good one, which will also help you grasp the knowledge of SQL and complete your request as well. On Mon, Feb 25, 2008 at 4:59 PM, stephen sefick <[EMA

Re: [R] union of two data frames

2008-02-25 Thread Erik Iverson
You probably need to provide an example here, show us your data.frame column names, and what you mean by 'common subset of the same data' at least. What did you try and what did it do that you didn't expect? stephen sefick wrote: > I have a thirty thousand row data frame imported from excel and

[R] union of two data frames

2008-02-25 Thread stephen sefick
I have a thirty thousand row data frame imported from excel and a 60,000 row data frame imported from excel. they share a common subset of the same data and I would like to combine the two into one data frame merged together on the data in common. I have looked at the help file for merge and inte