Count number of zeros per row, and remove rows with more than n zeros

by

It’s not only possible, but very easy:

DF[rowSums(DF == 0) <= 4, ]

You could also use apply:

DF[apply(DF == 0, 1, sum) <= 4, ]

More Related Contents:

  1. How to sum a variable by group
  2. How do I make a list of data frames?
  3. Split data frame string column into multiple columns
  4. How to convert a data frame column to numeric type?
  5. Filtering a data frame by values in a column [duplicate]
  6. subtract value from previous row by group
  7. Repeat rows of a data.frame [duplicate]
  8. Expand ranges defined by “from” and “to” columns
  9. Adding a column of means by group to original data [duplicate]
  10. pair-wise duplicate removal from dataframe [duplicate]
  11. Transpose a data frame
  12. Combine two or more columns in a dataframe into a new column with a new name
  13. Error – replacement has [x] rows, data has [y]
  14. How to swap values between two columns
  15. Define and apply custom bins on a dataframe
  16. Subset of rows containing NA (missing) values in a chosen column of a data frame
  17. rbind dataframes with a different column name
  18. Find duplicated rows (based on 2 columns) in Data Frame in R
  19. Converting two columns of a data frame to a named vector
  20. Collapsing data frame by selecting one row per group
  21. Change value of variable with dplyr
  22. How to initialize empty data frame (lot of columns at the same time) in R
  23. Practical limits of R data frame
  24. R: Assign variable labels of data frame columns
  25. rbind data frames based on a common pattern in data frame name
  26. Merge or combine by rownames
  27. How to add new column to an dataframe (to the front not end)?
  28. Return pmin or pmax of data.frame with multiple columns
  29. How to divide a number of columns by one column?
  30. Split a column by group [duplicate]

Leave a Comment