After constructing the new dataframe, you can always reorder the columns in any order that you want by creating a character vector of the order that you want and then using it as:
mydf[my.ordered.names] You may have to give a better example of what the input and output would look like. On Thu, May 15, 2008 at 3:04 PM, Bert Jacobs <[EMAIL PROTECTED]> wrote: > Jim, > > The problem with your solution is that the columnames are not in the same > order as in the dataframe SDF2 > > The "dummy columns" are just put at the end of the dataframe SDF1. I keep > looking for a better solutions. Thx for the effort. > > > > Bert > > > ------------------------------ > > *From:* jim holtman [mailto:[EMAIL PROTECTED] > *Sent:* 15 May 2008 18:12 > > *To:* Bert Jacobs > *Subject:* Re: [R] Adding columns to dataframe > > > > Will somethink like this work to just add dummy columns: > > > > > x <- data.frame(a=1:10, b=1:10) > > y <- data.frame(a=1, c=1, d=1, e=1, f=1) > > # get unique names in y > > uniq <- setdiff(names(y), names(x)) > > # add dummy columns to x > > x[uniq] <- 0 > > x > a b c d e f > 1 1 1 0 0 0 0 > 2 2 2 0 0 0 0 > 3 3 3 0 0 0 0 > 4 4 4 0 0 0 0 > 5 5 5 0 0 0 0 > 6 6 6 0 0 0 0 > 7 7 7 0 0 0 0 > 8 8 8 0 0 0 0 > 9 9 9 0 0 0 0 > 10 10 10 0 0 0 0 > > > > On Thu, May 15, 2008 at 12:07 PM, Bert Jacobs <[EMAIL PROTECTED]> > wrote: > > Apparently the formula I use at the moment didn't pass through. As you see > I use some kind of merge function. > > DFNEW <- merge(SDF2[,4:163],SDF1[,4:ncol(SDF1)], all.y = TRUE,all.x = > FALSE)[names(SDF2[,4:163])] > > Bert > > > ------------------------------ > > *From:* Bert Jacobs [mailto:[EMAIL PROTECTED] > *Sent:* 15 May 2008 18:02 > *To:* 'jim holtman' > *Subject:* RE: [R] Adding columns to dataframe > > > > Hi Jim, > > > > The data in the new created dataframe looks OK to me, it's only a the row > position that has been changed, as if the merge evolve in some kind of > sorting system. > > The idea is simply to add empty dummy columns, but the order of the column > names should be the same as in the dataframe SDF2 > > > > Bert > ------------------------------ > > *From:* jim holtman [mailto:[EMAIL PROTECTED] > *Sent:* 15 May 2008 17:41 > *To:* Bert Jacobs > *Subject:* Re: [R] Adding columns to dataframe > > > > Does the data in the two dataframes match so that as the new columns are > added the data is correct? Or do you just want dummy (empty) columns > added? Can you use 'merge'? > > On Thu, May 15, 2008 at 11:34 AM, Bert Jacobs <[EMAIL PROTECTED]> wrote: > > > > Hi, > > > > I have a dataframe SDF1 that looks like this: > > > > Char1 Char2 Char 3 W.2007.02 W.2007.09 W.2007.16 W.2008.13 > > A C1 F1 F2 F3 > > A C2 > F4 > > B C3 F5 > F6 > > > > I have another dataframe SDF2 with 163 cols that has the following column > names > > Char1 Char2 Char 3 W.2007.02 W.2007.03 W.2007.04 W.2007.05 W.2007.06 > .W.2007.52 W.2008.01 . W.2008.13 > > > > Now I would like to add the missing period names to SDF1 as new columns and > in the same order as in SDF2. > > Therefore I use the following formula: > > > > > > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@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<http://www.r-project.org/posting-guide.html> > and provide commented, minimal, self-contained, reproducible code. > > > > > -- > Jim Holtman > Cincinnati, OH > +1 513 646 9390 > > What is the problem you are trying to solve? > > > > > -- > Jim Holtman > Cincinnati, OH > +1 513 646 9390 > > What is the problem you are trying to solve? > -- Jim Holtman Cincinnati, OH +1 513 646 9390 What is the problem you are trying to solve? [[alternative HTML version deleted]] ______________________________________________ R-help@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.
