Remove rows with all or some NAs (missing values) in data.frame

Also check complete.cases :

> final[complete.cases(final), ]
             gene hsap mmul mmus rnor cfam
2 ENSG00000199674    0    2    2    2    2
6 ENSG00000221312    0    1    2    3    2

na.omit is nicer for just removing all NA‘s. complete.cases allows partial selection by including only certain columns of the dataframe:

> final[complete.cases(final[ , 5:6]),]
             gene hsap mmul mmus rnor cfam
2 ENSG00000199674    0    2    2    2    2
4 ENSG00000207604    0   NA   NA    1    2
6 ENSG00000221312    0    1    2    3    2

Your solution can’t work. If you insist on using is.na, then you have to do something like:

> final[rowSums(is.na(final[ , 5:6])) == 0, ]
             gene hsap mmul mmus rnor cfam
2 ENSG00000199674    0    2    2    2    2
4 ENSG00000207604    0   NA   NA    1    2
6 ENSG00000221312    0    1    2    3    2

but using complete.cases is quite a lot more clear, and faster.

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. Remove legend ggplot 2.2
  9. Error in if/while (condition) {: missing Value where TRUE/FALSE needed
  10. How do I replace NA values with zeros in an R dataframe?
  11. How to change legend title in ggplot
  12. Changing column names of a data frame
  13. Error in do_one(nmeth) : NA/NaN/Inf in foreign function call (arg 1)
  14. R on MacOS Error: vector memory exhausted (limit reached?)
  15. Counting the number of elements with the values of x in a vector
  16. Non-numeric Argument to Binary Operator Error in R
  17. Non-numeric Argument to Binary Operator Error in R
  18. R issue “object not found”
  19. Error in Confusion Matrix : the data and reference factors must have the same number of levels
  20. Why do I get “number of items to replace is not a multiple of replacement length”
  21. Error in file(file, “rt”) : invalid ‘description’ argument in complete.cases program
  22. Extracting value specific rows in R
  23. “Error: Mapping should be created with `aes()` or `aes_()`.”
  24. Error in file(file, “rt”) : invalid ‘description’ argument in complete.cases program
  25. Longer object length is not a multiple of shorter object length?
  26. plot.new has not been called yet
  27. Error in lm.fit(x,y,offset = offset, singular.ok,…) 0 non-NA cases with boxcox formula
  28. Error in lm.fit(x, y, offset = offset, singular.ok = singular.ok, …) : NA/NaN/Inf in ‘y’, tried every possible way
  29. Logistic regression – eval(family$initialize) : y values must be 0 <= y <= 1
  30. Opposite of %in%: exclude rows with values specified in a vector
  31. Add text to ggplot
  32. Rotating and spacing axis labels in ggplot2
  33. Arcsine transformation of percentage data
  34. R loop that adds following numbers to each element in list
  35. Can I calculate z-score with R?
  36. Reading PSV (pipe-separated) file or string
  37. Function to clear the console in R and RStudio
  38. plot.new has not been called yet
  39. “replace” function examples
  40. Why I get this error writing data to a file
  41. Remove NA values from a vector
  42. Correlation between multiple variables of a data frame
  43. character string is not in a standard unambiguous format
  44. Function to clear the console in R and RStudio
  45. Adding a regression line on a ggplot
  46. Remove grid, background color, and top and right borders from ggplot2
  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. Mean of a column in a data frame, given the column’s name
  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. Custom legend for multiple layer ggplot
  56. Understanding `scale` in R
  57. Add empty columns to a dataframe with specified names from a vector
  58. file.path function in R
  59. Generate a set of random unique integers from an interval
  60. How to move or position a legend in ggplot2
  61. Rotating and spacing axis labels in ggplot2
  62. Plot multiple lines (data series) each with unique color in R
  63. Error: invalid subscript type ‘list’ in R
  64. “non-numeric argument to binary operator” error in R
  65. Replace all particular values in a data frame
  66. Still getting error in dev.off() : cannot shut down device 1 (the null device)
  67. How to sum a variable by group
  68. readOGR() cannot open file
  69. How to get summary statistics by group
  70. R error in unique.default(x) unique() applies only to vectors
  71. Combine two data frames by rows (rbind) when they have different sets of columns
  72. Boxplot dplyr: Error: non-numeric argument to binary operator
  73. Function to calculate R2 (R-squared) in R
  74. How do I install an R package from source?
  75. Getting invalid model formula in ExtractVars when using rpart function in R
  76. Too few periods for decompose()
  77. Aggregate multiple columns at once
  78. Error in match.fun(FUN)
  79. installing data.table results in “there is no package”
  80. changing title in multiplot ggplot2 using grid.arrange
  81. Correct syntax for mutate_if
  82. Plotting data in R; error: default method not implemented for type ‘list’
  83. Error:attempt to apply non-function
  84. Changing fonts in ggplot2
  85. Error in xj[i] : invalid subscript type ‘list’
  86. How do you specifically order ggplot2 x axis instead of alphabetical order?
  87. Sample random rows in dataframe
  88. Batch convert columns to numeric type
  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 can I make a list of lists in R?
  93. lib unspecified & Error in loadNamespace
  94. How to convert data.frame column from Factor to numeric [duplicate]
  95. Merge data frames based on rownames in R
  96. What do these R glm error messages mean: “Error: no valid set of coefficients has been found: please supply starting values”
  97. Remove columns from dataframe where some of values are NA
  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