How would I remove all NA from a table and create a smaller condensed table?

Asked Sep 09 '21 at 18:45

Active Sep 09 '21 at 18:45

Viewed 22 times

I have this table

NA  JAKUB.VRANA NA  NICKLAS.BACKSTROM   TOM.WILSON  NA  NA
NA  NA  LARS.ELLER  RICHARD.PANIK   T.J..OSHIE  NA  NA
NA  BRIAN.PINHO CONOR.SHEARY    DANIEL.SPRONG   NA  NA  NA

And I am looking to remove all NAs and create a table with just three columns with the names

asked Sep 09 '21 at 18:45

sfiaglja

1

Based on your input, how _exactly_ should your output look like? – Martin Gal Sep 09 '21 at 18:48
it should just remove the NAs and condense each row to three columns – sfiaglja Sep 09 '21 at 18:50
Should the first row look like "JAKUB.VRANA", "NICKLAS.BACKSTROM", "TOM.WILSON"? – Martin Gal Sep 09 '21 at 18:51
yes, that is correct – sfiaglja Sep 09 '21 at 18:52
Something like this: If your data.frame is named `df`, does `as.data.frame(t(apply(df, 1, function(x) x[!is.na(x)])))` return your expected output? https://stackoverflow.com/questions/26651606/how-to-move-cells-with-a-value-row-wise-to-the-left-in-a-dataframe – Martin Gal Sep 09 '21 at 19:02
yes, that worked for me. Thank you! – sfiaglja Sep 09 '21 at 19:11

How would I remove all NA from a table and create a smaller condensed table?

0 Answers0