Removing empty rows of a data file in R

by

I assume you want to remove rows that are all NAs. Then, you can do the following :

data <- rbind(c(1,2,3), c(1, NA, 4), c(4,6,7), c(NA, NA, NA), c(4, 8, NA)) # sample data
data
     [,1] [,2] [,3]
[1,]    1    2    3
[2,]    1   NA    4
[3,]    4    6    7
[4,]   NA   NA   NA
[5,]    4    8   NA

data[rowSums(is.na(data)) != ncol(data),]
     [,1] [,2] [,3]
[1,]    1    2    3
[2,]    1   NA    4
[3,]    4    6    7
[4,]    4    8   NA

If you want to remove rows that have at least one NA, just change the condition :

data[rowSums(is.na(data)) == 0,]
     [,1] [,2] [,3]
[1,]    1    2    3
[2,]    4    6    7

More Related Contents:

  1. Convert an upper to lower triangle matrix in r [duplicate]
  2. Deleting specific rows with a pattern[start and end indicators] from a dataframe [closed]
  3. Create a sequential number (counter) for rows within each group of a dataframe [duplicate]
  4. Extracting specific columns from a data frame
  5. Can dplyr package be used for conditional mutating?
  6. ggplot2 keep unused levels barplot
  7. Faster version of combn
  8. Subset a dataframe between 2 dates
  9. as.Date with dates in format m/d/y in R
  10. How to move cells with a value row-wise to the left in a dataframe [duplicate]
  11. rep() with each equals a vector
  12. Convert column classes in data.table
  13. Perform a semi-join with data.table
  14. Remove all of x axis labels in ggplot [duplicate]
  15. Handling java.lang.OutOfMemoryError when writing to Excel from R
  16. What’s the use of which?
  17. Replace logical values (TRUE / FALSE) with numeric (1 / 0)
  18. Cluster one-dimensional data optimally? [closed]
  19. Replace duplicated elements with NA, instead of removing them
  20. RMarkdown: How to end tabbed content
  21. reading global variables using foreach in R
  22. In R, how do I add a max by group? [duplicate]
  23. Group by using base R
  24. Saving grid.arrange() plot to file
  25. How to plot a Stacked and grouped bar chart in ggplot?
  26. Efficiently merging two data frames on a non-trivial criteria
  27. Any way to force fread() of data.table not to stop on empty lines?
  28. Process substitution
  29. adding x and y axis labels in ggplot2
  30. how to create md5 hash of a column in R?

Leave a Comment