Remove columns from dataframe where ALL values are NA

r apply dataframe
Gnark picture Gnark · Apr 15, 2010 · Viewed 112.4k times · Source

I'm having trouble with a data frame and couldn't really resolve that issue myself:
The dataframe has arbitrary properties as columns and each row represents one data set.

The question is:
How to get rid of columns where for ALL rows the value is NA?

Answer

teucer picture teucer · Apr 15, 2010

Try this:

df <- df[,colSums(is.na(df))<nrow(df)]

Related questions

R Apply() function on specific dataframe columns

I want to use the apply function on a dataframe, but only apply the function to the last 5 columns. B<- by(wifi,(wifi$Room),FUN=function(y){apply(y, 2, A)}) This applies A to all the columns of …

Read More
Dataframe create new column based on other columns

I have a dataframe: df <- data.frame('a'=c(1,2,3,4,5), 'b'=c(1,20,3,4,50)) df a b 1 1 1 2 2 20 3 3 3 4 4 4 5 5 50 and I want to create a new column based on existing columns. Something like this: if (df[['a']] == df[['b']]) { df[['c']] <- …

Read More
calculate row sum and product in data.frame

I would like to append a columns to my data.frame in R that contain row sums and products Consider following data frame x y z 1 2 3 2 3 4 5 1 2 I want to get the following x y z sum prod 1 2 3 6 6 2 3 4 9 24 5 1 2 8 10 I have tried …

Read More