Re: [R] merge a list of data frames

2012-09-06 Thread Sam Steingold
> * David Winsemius [2012-09-06 10:30:16 -0700]: > >> these are the results of applying a model to the test data. >> the first column is the ID > > In which case you should be using the 'by' argument to `merge` I already do! see my initial message! >> 3. sort by the sum/mean of the V3 columns an

Re: [R] merge a list of data frames

2012-09-06 Thread David Winsemius
On Sep 6, 2012, at 6:42 AM, Sam Steingold wrote: >> * David Winsemius [2012-09-05 21:02:16 -0700]: >> >> On Sep 5, 2012, at 8:51 PM, Sam Steingold wrote: >> >>> I have a list of data frames: >>> str(data) >>> List of 4 >>> $ :'data.frame':700773 obs. of 3 variables: >>> ..$ V1: chr

Re: [R] merge a list of data frames

2012-09-06 Thread PIKAL Petr
Hi > -Original Message- > From: r-help-boun...@r-project.org [mailto:r-help-bounces@r- > project.org] On Behalf Of Sam Steingold > Sent: Thursday, September 06, 2012 3:43 PM > To: David Winsemius > Cc: r-help@r-project.org > Subject: Re: [R] merge a list of data

Re: [R] merge a list of data frames

2012-09-06 Thread Jeff Newmiller
"not practical [...] to rename the column to something unique." On the contrary, since R is a scripting language it is quite practical. Depending on the format of your data, it is probably necessary as well. If all of the files have exactly the same number of rows corresponding to the same key

Re: [R] merge a list of data frames

2012-09-06 Thread Sam Steingold
> * David Winsemius [2012-09-05 21:02:16 -0700]: > > On Sep 5, 2012, at 8:51 PM, Sam Steingold wrote: > >> I have a list of data frames: >> >>> str(data) >> List of 4 >> $ :'data.frame': 700773 obs. of 3 variables: >> ..$ V1: chr [1:700773] "200130446465779" "200070050127778" >> "2000306337

Re: [R] merge a list of data frames

2012-09-05 Thread Jeff Newmiller
I don't really know what you want, but if you have many columns with the same names I am wondering why this is so. Do you really want to merge, which puts all of the non-key columns side-by-side in one data frame? If so, why don't you start by renaming the columns so they will make sense in the

Re: [R] merge a list of data frames

2012-09-05 Thread David Winsemius
On Sep 5, 2012, at 8:51 PM, Sam Steingold wrote: > I have a list of data frames: > >> str(data) > List of 4 > $ :'data.frame': 700773 obs. of 3 variables: > ..$ V1: chr [1:700773] "200130446465779" "200070050127778" "200030633708779" > "200010587002779" ... > ..$ V2: int [1:700773] 0 0