[R] Combining columns

Jim Lemon drjimlemon at gmail.com
Mon Nov 21 22:54:36 CET 2016


Hi Olu,
If you always have only one non-NA value in the first three columns:

veg_df<-data.frame(col1=c(NA,"cassava","yam",NA,NA,NA,"maize"),
 col2=c("pumpkin",NA,NA,"cherry",NA,NA,NA),
 col3=c(NA,NA,NA,NA,"pepper","mango",NA))

veg_df$col4<-apply(as.matrix(veg_df),1,function(x) x[!is.na(x)])

Jim


On Tue, Nov 22, 2016 at 8:26 AM, Olu Ola via R-help
<r-help at r-project.org> wrote:
>  Hello,I have the following data
> | colA | colB | colC | colD |
> | NA | pumpkin | NA | Pumpkin |
> | Cassava | NA | NA | Cassava |
> | yam | NA | NA | yam |
> | NA | Cherry | NA | Cherry |
> | NA | NA | Pepper | Pepper |
> | NA | NA | Mango | Mango |
> | maize | NA | NA | maize |
>
>
> All I want to do is to combine the first three columns in order to obtain the fourth column.
> A way forward will be greatly appreciated.
>
>         [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> 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.



More information about the R-help mailing list