Remove columns from dataframe where some of values are NA

The data:

Itun <- data.frame(v1 = c(1,1,2,1,2,1), v2 = c(NA, 1, 2, 1, 2, NA))

This will remove all columns containing at least one NA:

Itun[ , colSums(is.na(Itun)) == 0]

An alternative way is to use apply:

Itun[ , apply(Itun, 2, function(x) !any(is.na(x)))]

Related Posts:

  1. Emulate ggplot2 default color palette
  2. ggplot wrong color assignment
  3. How to rename a single column in a data.frame?
  4. Critical t values in R
  5. t-stat for feature selection
  6. Reasons for using the set.seed function
  7. What does na.rm=TRUE actually means?
  8. Error in if/while (condition) {: missing Value where TRUE/FALSE needed
  9. How do I replace NA values with zeros in an R dataframe?
  10. How to change legend title in ggplot
  11. Changing column names of a data frame
  12. Error in do_one(nmeth) : NA/NaN/Inf in foreign function call (arg 1)
  13. R on MacOS Error: vector memory exhausted (limit reached?)
  14. Counting the number of elements with the values of x in a vector
  15. Non-numeric Argument to Binary Operator Error in R
  16. Non-numeric Argument to Binary Operator Error in R
  17. R issue “object not found”
  18. Error in Confusion Matrix : the data and reference factors must have the same number of levels
  19. Why do I get “number of items to replace is not a multiple of replacement length”
  20. Error in file(file, “rt”) : invalid ‘description’ argument in complete.cases program
  21. Extracting value specific rows in R
  22. “Error: Mapping should be created with `aes()` or `aes_()`.”
  23. Error in file(file, “rt”) : invalid ‘description’ argument in complete.cases program
  24. Longer object length is not a multiple of shorter object length?
  25. plot.new has not been called yet
  26. Error in lm.fit(x,y,offset = offset, singular.ok,…) 0 non-NA cases with boxcox formula
  27. Error in lm.fit(x, y, offset = offset, singular.ok = singular.ok, …) : NA/NaN/Inf in ‘y’, tried every possible way
  28. Logistic regression – eval(family$initialize) : y values must be 0 <= y <= 1
  29. Opposite of %in%: exclude rows with values specified in a vector
  30. Add text to ggplot
  31. Rotating and spacing axis labels in ggplot2
  32. Arcsine transformation of percentage data
  33. R loop that adds following numbers to each element in list
  34. Can I calculate z-score with R?
  35. Reading PSV (pipe-separated) file or string
  36. Function to clear the console in R and RStudio
  37. plot.new has not been called yet
  38. “replace” function examples
  39. Why I get this error writing data to a file
  40. Remove NA values from a vector
  41. Correlation between multiple variables of a data frame
  42. character string is not in a standard unambiguous format
  43. Remove rows with all or some NAs (missing values) in data.frame
  44. duplicate ‘row.names’ are not allowed error
  45. Function to clear the console in R and RStudio
  46. Adding a regression line on a ggplot
  47. Invalid factor level, NA generated warning
  48. R: “Unary operator error” from multiline ggplot2 command
  49. invalid type (list) for variable
  50. not a Stata version 5-12 .dta file
  51. Error: unexpected ‘}’ in “}” in R [duplicate]
  52. No non-missing arguments warning when using min or max in reshape2
  53. How to convert a factor to integer\numeric without loss of information?
  54. Having trouble setting working directory
  55. Understanding `scale` in R
  56. Add empty columns to a dataframe with specified names from a vector
  57. `fread` with headers with special characters (latin1) and unusual nested quotes
  58. Generate a set of random unique integers from an interval
  59. How to move or position a legend in ggplot2
  60. Rotating and spacing axis labels in ggplot2
  61. “installation of package ‘FILE_PATH’ had non-zero exit status” in R
  62. Plot multiple lines (data series) each with unique color in R
  63. Replace all particular values in a data frame
  64. Plot a legend outside of the plotting area in base graphics?
  65. Still getting error in dev.off() : cannot shut down device 1 (the null device)
  66. How to sum a variable by group
  67. lme4 error: boundary (singular) fit: see ?isSingular
  68. How to get summary statistics by group
  69. Non-conformable arrays error in code
  70. object of type ‘builtin’ is not subsettable
  71. What causes an R script to get Killed?
  72. Combine two data frames by rows (rbind) when they have different sets of columns
  73. Function to calculate R2 (R-squared) in R
  74. dplyr mutate with conditional values
  75. `Error in file(con, “r”) : cannot open the connection` from running BRugsFit()
  76. Getting invalid model formula in ExtractVars when using rpart function in R
  77. Too few periods for decompose()
  78. How to solve prcomp.default(): cannot rescale a constant/zero column to unit variance
  79. incorrect number of subscripts on matrix in R
  80. How Do You Compare Two Strings in R?
  81. changing title in multiplot ggplot2 using grid.arrange
  82. How to split data into training/testing sets using sample function
  83. Correct syntax for mutate_if
  84. Creating a Plot Window of a Particular Size
  85. Error:attempt to apply non-function
  86. Error in xj[i] : invalid subscript type ‘list’
  87. How do you specifically order ggplot2 x axis instead of alphabetical order?
  88. Sample random rows in dataframe
  89. Error in eval(predvars, data, env) : object ‘Rm’ not found
  90. How to initialize a vector with fixed length in R
  91. Efficiently sum across multiple columns in R
  92. How do I clean up R memory without restarting my PC?
  93. Side-by-side plots with ggplot2
  94. lib unspecified & Error in loadNamespace
  95. How to convert data.frame column from Factor to numeric [duplicate]
  96. Merge data frames based on rownames in R
  97. What do these R glm error messages mean: “Error: no valid set of coefficients has been found: please supply starting values”
  98. What is the meaning of the dollar sign “$” in R function()?
  99. How can I change the name of a data frame
  100. How to calculate combination and permutation in R?

Leave a Comment

tech