Combine multiple columns without considering NA's

Question

Below is the dataframe

I want to create 6th column where all the values of the 5 columns are combined. If a column has NA or 0, it shouldn't be considered.

There should be a space between each variable combined.

akrun · Accepted Answer · 2017-01-12T10:39:38.843

0

We can use

 df1$X6 <- apply(df1, 1, FUN=function(x) paste(x[!is.na(x)], collapse=" "))

edited Jan 12 '17 at 10:39

answered Jan 12 '17 at 10:31

akrun

Thanks...but the output is like this "bike_335, ball_514, coal_70". I want like this "bike_335 ball_514 coal_70" with no commas. – Mohan Chakradhar Vedurupaka Jan 12 '17 at 10:36
@MohanChakradharVedurupaka I changed the code – akrun Jan 12 '17 at 10:40

1 Answers1