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. Poker hand range chart visualization in R
  2. ggplot wrong color assignment
  3. How to rename a single column in a data.frame?
  4. Critical t values in R
  5. What does %>% function mean in R?
  6. t-stat for feature selection
  7. Reasons for using the set.seed function
  8. R on MacOS Error: vector memory exhausted (limit reached?)
  9. Remove legend ggplot 2.2
  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. R: Using equation with natural logarithm in nls
  14. How to change legend title in ggplot
  15. Error in do_one(nmeth) : NA/NaN/Inf in foreign function call (arg 1)
  16. R on MacOS Error: vector memory exhausted (limit reached?)
  17. kmeans complains “NA/NaN/Inf in foreign function call (arg 1)”, when there are none?
  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. Having trouble setting working directory
  22. SummarySE (Rmisc package) to produce a barplot with error bars (ggplot2)
  23. R ggplot2 scale_y_continuous : Combining breaks & limits
  24. “Error: Mapping should be created with `aes()` or `aes_()`.”
  25. Error in file(file, “rt”) : invalid ‘description’ argument in complete.cases program
  26. Longer object length is not a multiple of shorter object length?
  27. rmarkdown error “attempt to use zero-length variable name”
  28. cannot coerce type ‘closure’ to vector of type ‘character’
  29. Error in lm.fit(x, y, offset = offset, singular.ok = singular.ok, …) : NA/NaN/Inf in ‘y’, tried every possible way
  30. Logistic regression – eval(family$initialize) : y values must be 0 <= y <= 1
  31. R – longer object length is not a multiple of shorter object length
  32. Opposite of %in%: exclude rows with values specified in a vector
  33. Arcsine transformation of percentage data
  34. R loop that adds following numbers to each element in list
  35. R: Using equation with natural logarithm in nls
  36. remove legend title in ggplot
  37. scale_color_manual() not working
  38. Can I calculate z-score with R?
  39. Clear R environment of all objetcs & packages
  40. Function to clear the console in R and RStudio
  41. “replace” function examples
  42. R: need finite ‘ylim’ values in function
  43. Convert a list to a data frame
  44. Manually colouring plots with `scale_fill_manual` in ggplot2 not working
  45. Why I get this error writing data to a file
  46. Correlation between multiple variables of a data frame
  47. Adding a regression line on a ggplot
  48. Remove grid, background color, and top and right borders from ggplot2
  49. R: “Unary operator error” from multiline ggplot2 command
  50. What does the double percentage sign (%%) mean?
  51. invalid type (list) for variable
  52. not a Stata version 5-12 .dta file
  53. How to subset a Data frame column wise using column names?
  54. Mean of a column in a data frame, given the column’s name
  55. No non-missing arguments warning when using min or max in reshape2
  56. How to convert a factor to integer\numeric without loss of information?
  57. Having trouble setting working directory
  58. Custom legend for multiple layer ggplot
  59. file.path function in R
  60. predict.lm() in a loop. warning: prediction from a rank-deficient fit may be misleading
  61. Convert categorical variables to numeric in R
  62. How to sum data.frame column values?
  63. Error: invalid subscript type ‘list’ in R
  64. “non-numeric argument to binary operator” error in R
  65. How to sum a variable by group
  66. readOGR() cannot open file
  67. What does “The following object is masked from ‘package:xxx'” mean?
  68. grep using a character vector with multiple patterns
  69. How to avoid “Error in stripchart.default(x1, …) : invalid plotting method” error?
  70. R error in unique.default(x) unique() applies only to vectors
  71. Unused arguments in R
  72. Combine two data frames by rows (rbind) when they have different sets of columns
  73. Boxplot dplyr: Error: non-numeric argument to binary operator
  74. How do I install an R package from source?
  75. Getting invalid model formula in ExtractVars when using rpart function in R
  76. Error: ggplot2 doesn’t know how to deal with data of class matrix?
  77. Aggregate multiple columns at once
  78. Error in match.fun(FUN)
  79. Error in file(filename, “r”, encoding = encoding) : cannot open the connection
  80. installing data.table results in “there is no package”
  81. What is integer overflow in R and how can it happen?
  82. R histogram range error: some ‘x’ not counted; maybe ‘breaks’ do not span range of ‘x
  83. Correct syntax for mutate_if
  84. Plotting data in R; error: default method not implemented for type ‘list’
  85. Error:attempt to apply non-function
  86. Error in contrib.url(repos, “source”) in R trying to use CRAN without setting a mirror Calls: install.packages -> contrib.url Execution halted
  87. Changing fonts in ggplot2
  88. Error in : target of assignment expands to non-language object
  89. How do I combine two data-frames based on two columns?
  90. How to eliminate “NA/NaN/Inf in foreign function call (arg 7)” running predict with randomForest
  91. Indicator function in R
  92. Batch convert columns to numeric type
  93. R4DS error comparison (1) is possible only for atomic and list types
  94. How can I make a list of lists in R?
  95. Error in x[[i]] : recursive indexing failed at level 2
  96. How to avoid “operations are possible only for numeric, logical or complex types” when computing top 3 elements in each group
  97. Warning: non-integer #successes in a binomial glm! (survey packages)
  98. Remove columns from dataframe where some of values are NA
  99. Difference between as.POSIXct/as.POSIXlt and strptime for converting character vectors to POSIXct/POSIXlt
  100. How to deal with “data of class uneval” error from ggplot2?

Leave a Comment

tech