Remove columns from dataframe where ALL values are NA

by

Try this:

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

More Related Contents:

  1. R Apply() function on specific dataframe columns
  2. apply a function over groups of columns
  3. rbind data frames based on a common pattern in data frame name
  4. Dataframe create new column based on other columns
  5. Calculate row-wise proportions
  6. Last Observation Carried Forward In a data frame? [duplicate]
  7. use multiple columns as variables with sapply
  8. how to apply a function on a data set?
  9. Replace values in a dataframe based on lookup table
  10. Sample random rows in dataframe
  11. Subset / filter rows in a data frame based on a condition in a column
  12. Replacing character values with NA in a data frame
  13. Coerce multiple columns to factors at once
  14. How to add a row to a data frame in R?
  15. Replace all particular values in a data frame
  16. Subtract a column in a dataframe from many columns in R
  17. Converting a data frame to xts
  18. Creating a summary statistical table from a data frame
  19. Interpolate NA values in a data frame with na.approx
  20. Merge rows in a dataframe where the rows are disjoint and contain NAs
  21. Randomly insert NAs into dataframe proportionaly
  22. How to delete rows where all the columns are zero
  23. Convert a dataframe to a vector (by rows)
  24. Transposing a dataframe maintaining the first column as heading
  25. Filter data frame rows based on values in vector
  26. Replace empty values with value from other column in a dataframe
  27. Replace values in data frame based on other data frame in R
  28. Add an image to a table-like output in R
  29. Divide each value by the sum of values by group
  30. Convert all data frame character columns to factors

Leave a Comment