Thank you Jim and Don.
On Monday, November 21, 2016 4:54 PM, Jim Lemon <drjimle...@gmail.com>
wrote:
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@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@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.
[[alternative HTML version deleted]]
______________________________________________
R-help@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.
