Re: [R] Adding columns to dataframe

From: Bert Jacobs <b.jacobs_at_pandora.be>
Date: Thu, 15 May 2008 23:43:16 +0200


Jim,

I think I'm almost there. When I use your formula it works and I can get the job done, but I encounter the following problem

uniq <- setdiff(names(y), names(x)) OK

x[uniq] <- 0                                          OK

x                                                          NOT OK: Error in
1:ncol(mat) : NA/NaN argument
fix(x)                                                    This works, but I
can't use it in a function  

Any idea what could cause this issue?


From: jim holtman [mailto:jholtman_at_gmail.com] 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 <b.jacobs_at_pandora.be> 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:b.jacobs_at_pandora.be] 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:jholtman_at_gmail.com] 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 <b.jacobs_at_pandora.be> 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_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.
-- 
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_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 Fri 16 May 2008 - 11:33:03 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 Fri 16 May 2008 - 12:30:37 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