- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to remove rows that contain at least one 0 in R?
To remove rows that contain at least one 0, we can use single square brackets for subsetting rows with apply that will select rows that do not contain even one zero. For example, if we have a data frame called df then we can remove rows that contain at least one 0 can be done by using the command df[apply(df,1, function(x) all(x!=0)),].
Example
Consider the below data frame −
x1<-rpois(20,1) x2<-rpois(20,5) x3<-rpois(20,5) df1<-data.frame(x1,x2,x3) df1
Output
x1 x2 x3 1 0 5 5 2 1 8 2 3 0 4 8 4 1 4 3 5 1 4 5 6 1 5 3 7 2 11 8 8 1 3 8 9 1 4 4 10 1 7 4 11 0 9 5 12 3 4 1 13 0 6 2 14 0 4 7 15 0 6 5 16 1 6 8 17 1 6 3 18 1 5 4 19 2 3 1 20 0 1 4
Removing rows of df1 that do not contain at least one 0 −
Example
df1[apply(df1,1, function(x) all(x!=0)),]
Output
x1 x2 x3 2 1 8 2 4 1 4 3 5 1 4 5 6 1 5 3 7 2 11 8 8 1 3 8 9 1 4 4 10 1 7 4 12 3 4 1 16 1 6 8 17 1 6 3 18 1 5 4 19 2 3 1
Example
y1<-sample(0:2,20,replace=TRUE) y2<-sample(1:5,20,replace=TRUE) y3<-sample(1:10,20,replace=TRUE) df2<-data.frame(y1,y2,y3) df2
Output
y1 y2 y3 1 0 2 6 2 2 3 6 3 1 5 8 4 2 3 1 5 1 5 5 6 0 2 4 7 1 2 10 8 1 5 8 9 1 5 5 10 0 2 6 11 1 4 4 12 0 2 3 13 0 1 2 14 0 3 8 15 1 4 4 16 0 4 3 17 2 5 3 18 0 3 7 19 2 4 1 20 0 3 2
Removing rows of df2 that do not contain at least one 0 −
Example
df2[apply(df2,1, function(x) all(x!=0)),]
Output
y1 y2 y3 2 2 3 6 3 1 5 8 4 2 3 1 5 1 5 5 7 1 2 10 8 1 5 8 9 1 5 5 11 1 4 4 15 1 4 4 17 2 5 3 19 2 4 1
- Related Articles
- How to remove rows from an R data frame that contains at least one NaN?
- How to remove rows that contain NAs in R matrix?
- How to subset R data frame rows if at least one or more values matches?
- How to filter rows that contain a certain string in R?
- How to extract columns having at least one non-duplicate in R?
- How to remove rows from data frame in R that contains NaN?
- How to remove rows in R matrix that contains a specific number?
- How to subset rows that do not contain NA and blank in one of the columns in an R data frame?
- Count of sub-strings that contain character X at least once in C++
- How to remove rows that contains all zeros in an R data frame?
- How to remove rows in R data frame that contains a specific number?
- How to remove rows in data.table object in R that contains a specific number?
- How to remove all rows having NA in R?
- How to remove rows that have NA in R data frames stored in a list?
- How to remove rows that contains NA values in certain columns of an R data frame?

Advertisements