How to delete columns that contain ONLY NAs?

by

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]

More Related Contents:

  1. How do I replace NA values with zeros in an R dataframe?
  2. Replacing character values with NA in a data frame
  3. How to replace NA values in a table for selected columns
  4. Omit rows containing specific column of NA
  5. Count NAs per row in dataframe [duplicate]
  6. Subset of rows containing NA (missing) values in a chosen column of a data frame
  7. Remove columns from dataframe where some of values are NA
  8. How to subset data in R without losing NA rows?
  9. Randomly insert NAs into dataframe proportionaly
  10. Select last non-NA value in a row, by row
  11. Replace in a factor column
  12. Replace all NA with FALSE in selected columns in R
  13. Find columns with all missing values
  14. R: replacing NAs in a data.frame with values in the same position in another dataframe
  15. Move NAs to the end of each column in a data frame
  16. How to convert a list consisting of vector of different lengths to a usable data frame in R?
  17. Filtering a data frame on a vector [duplicate]
  18. Selecting multiple odd or even columns/rows for dataframe
  19. Deleting reversed duplicates with R
  20. Select every nth row from dataframe
  21. duplicates in multiple columns
  22. Extend contigency table with proportions (percentages)
  23. Check whether values in one data frame column exist in a second data frame
  24. How do you remove columns from a data.frame?
  25. Unlist a data frame by rows, not columns
  26. DT[!(x == .)] and DT[x != .] treat NA in x inconsistently
  27. Difference between `names(df[1])
  28. How to create a new variable in a data.frame based on a condition?
  29. Filtering rows in R unexpectedly removes NAs when using subset or dplyr::filter
  30. Interpolating timeseries

Leave a Comment