[R] Combining columns

[MacQueen, Don]

Something along the lines of

tmpfun <- function(chvec) chvec[!is.na(chvec)]

apply( mydata, 1, tmpfun)

Assuming every row has only one non-NA entry.



-- 
Don MacQueen

Lawrence Livermore National Laboratory
7000 East Ave., L-627
Livermore, CA 94550
925-423-1062





On 11/21/16, 1:26 PM, "R-help on behalf of Olu Ola via R-help"
<r-help-bounces at r-project.org on behalf of 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.