[R] coalesce columns within a data frame

Ivan Alves papucho at mac.com
Wed Oct 22 17:21:21 CEST 2008


Dear all,

I searched the mail archives and the R site and found no guidance  
(tried "merge", "cbind" and terms like "coalesce" with no success).   
There surely is a way to coalesce (like in SQL) columns in a  
dataframe, right?  For example, I would like to go from a dataframe  
with two columns to one with only one as follows:

From

Name.x Name.y
nx1 ny1
nx2 NA
NA ny3
NA NA
...

To

Name
nx1
nx2
ny3
NA
...

where column Name.x is taken if there is a value, and if not then  
column Name.y

Any help would be appreciated

Kind regards,
Ivan



More information about the R-help mailing list