Skip to content
Prev 165646 / 398503 Next

Merge or combine data frames with missing columns

Mark,

I think ?rbind should work for you.

Regards,
Brian

-----Original Message-----
From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org] On Behalf Of Mark Heckmann
Sent: Monday, December 29, 2008 9:18 AM
To: r-help at r-project.org
Subject: [R] Merge or combine data frames with missing columns



Hi R-experts,

suppose I have a list with containing data frame elements:

[[1]]
(Intercept)          y1          y2          y3          y4 
 -6.64              0.761      0.383      0.775      0.163
 
[[2]]
(Intercept)          y2          y3          
-3.858             0.854      0.834     

Now I want to put them into ONE dataframe like this:
               (Intercept)           y1          y2         y3           y4 
   1           -6.64              0.761      0.383      0.775      0.163
   2         -3.858                  NA       0.854      0.834        NA

The problem I encounter is that not always all possible columns (Intercept,  y1,  y2, y3,  y4) exist or at least have NA entries .

I cannot figure out how (e.g. with merge)...

TIA, Mark