How to delete columns that contain ONLY NAs?

r dataframe na
Lorenzo Rigamonti picture Lorenzo Rigamonti · Apr 12, 2013 · Viewed 107.4k times · Source

I have a data.frame containing some columns with all NA values, how can I delete them from the data.frame.

Can I use the function 

na.omit(...)

specifying some additional arguments?

Answer

Ciarán Tobin picture Ciarán Tobin · Apr 12, 2013

One way of doing it:

df[, colSums(is.na(df)) != nrow(df)]

If the count of NAs in a column is equal to the number of rows, it must be entirely NA.

Or similarly

df[colSums(!is.na(df)) > 0]

Related questions

How do I replace NA values with zeros in an R dataframe?

I have a data frame and some columns have NA values. How do I replace these NA values with zeroes?

Read More
Subset of rows containing NA (missing) values in a chosen column of a data frame

We have a data frame from a CSV file. The data frame DF has columns that contain observed values and a column (VaR2) that contains the date at which a measurement has been taken. If the date was not recorded, …

Read More
Omit rows containing specific column of NA

I want to know how to omit NA values in a data frame, but only in some columns I am interested in. For example, DF <- data.frame(x = c(1, 2, 3), y = c(0, 10, NA), z=c(NA, 33, 22)) but I only …

Read More