Re: [R] bind select data frames

From: arnaud Gaboury <arnaud.gaboury_at_gmail.com>
Date: Wed, 02 Jun 2010 17:28:51 +0200

Here we go :

dd<-data.frame(do.call(rbind, mget(paste("DailyPL",sel[-1],sep=""),envir=.GlobalEnv)),row.names=NULL)

TY so much Joshua and Jorge.

> -----Original Message-----
> From: Joshua Wiley [mailto:jwiley.psych_at_gmail.com]
> Sent: Wednesday, June 02, 2010 5:11 PM
> To: arnaud Gaboury
> Cc: r-help_at_r-project.org
> Subject: Re: [R] bind select data frames
>
> On Wed, Jun 2, 2010 at 8:06 AM, arnaud Gaboury
> <arnaud.gaboury_at_gmail.com> wrote:
> > I am working with something like this :
> >
> > for (i in sel[-1]) {
> > dd<-data.frame(do.call(rbind,
> mget(paste("DailyPL",i,sep=""),envir=.GlobalEnv)),row.names=NULL)
> >
> > }
> >
> > But the result is not good. In the case where sel[-1]<-c("100420",
> "100421"), "dd" is only equal to "DailyPL100421"
>
> Yes, because it is in a loop, dd is reassigned for each value of i.
> That is why in the first loop I sent you I included the old data in
> the rbind, otherwise it is just overwritten everytime it loops.
>
> Josh
>
> >
> >
> >
> >
> >> -----Original Message-----
> >> From: Joshua Wiley [mailto:jwiley.psych_at_gmail.com]
> >> Sent: Wednesday, June 02, 2010 4:48 PM
> >> To: arnaud Gaboury
> >> Cc: r-help_at_r-project.org
> >> Subject: Re: [R] bind select data frames
> >>
> >> Hello,
> >>
> >> Does this do what you are looking for?
> >>
> >> ############
> >> output <- NULL
> >> for(i in paste("DailyPL", sel, sep="")[-1]){
> >> output <- rbind(output, get(i))
> >> }
> >> ############
> >>
> >> If you just want to rbind all the data frames, there are ways of
> doing
> >> it without a loop too, but since you specifically asked with the
> >> condition for(i in sep[-1]) I did it using a loop.
> >>
> >> Best regards,
> >>
> >> Josh
> >>
> >>
> >> On Wed, Jun 2, 2010 at 7:24 AM, arnaud Gaboury
> >> <arnaud.gaboury_at_gmail.com> wrote:
> >> > Dear group,
> >> >
> >> > Here is my environment:
> >> >
> >> >> ls()
> >> > [1] "DailyPL100419" "DailyPL100420" "DailyPL100421" "dd"
> >> "i"
> >> > "l" "PLglobal" "Pos100416" "Pos100419"
> >> "Pos100420"
> >> > "Pos100421" "position"
> >> > [13] "result" "sel" "Trad100416" "Trad100419"
> >> > "Trad100420" "Trad100421" "trade"
> >> >
> >> > With "sel" the following element :
> >> >
> >> > sel <-
> >> > c("100419", "100420", "100421")
> >> >
> >> >
> >> > "DailyPL100419" , "DailyPL100420","DailyPL100421" are all data
> frames
> >> with
> >> > same columns names. I want to rbind them with this condition :
> >> >
> >> >
> >> > for (i in sel[-1])
> >> >
> >> > I have no idea how to write it.
> >> >
> >> > TY for any help
> >> >
> >> > ______________________________________________
> >> > R-help_at_r-project.org mailing list
> >> > https://stat.ethz.ch/mailman/listinfo/r-help
> >> > PLEASE do read the posting guide http://www.R-project.org/posting-
> >> guide.html
> >> > and provide commented, minimal, self-contained, reproducible code.
> >> >
> >>
> >>
> >>
> >> --
> >> Joshua Wiley
> >> Senior in Psychology
> >> University of California, Riverside
> >> http://www.joshuawiley.com/
> >
> >
>
>
>
> --
> Joshua Wiley
> Senior in Psychology
> University of California, Riverside
> http://www.joshuawiley.com/



R-help_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. Received on Wed 02 Jun 2010 - 15:36:33 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 02 Jun 2010 - 15:40:26 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive