How to remove rows that contain all zeros in R dataframe?
In this article, let’s discuss how to rows that contain all zeroes in R dataframe.
Approach:
- Create dataframe
- Get the sum of each row
- Simply remove those rows that have zero-sum. Based on the sum we are getting we will add it to the new dataframe. if the sum is greater than zero then we will add it otherwise not.
- Display dataframe
To calculate the sum of each row rowSums() function can be used.
Syntax:
df[rowSums(df[])>0,]
Where, df is the dataframe.
Example 1:
R
df <- data.frame (x = c (0, 1, 3, 0, 0), y = c (0, 1, 5, 0, 3)) print ( "data frame is " ) print (df) ans = df[ rowSums (df[])>0,] print ( "rows after removing rows that have all zeros" ) print (ans) |
Output:
Example 2:
R
a = rep (0,10) b = sample ( c (0,1),10,replace= TRUE ) df = data.frame (a,b) print ( "dataframe is " ) print (df) ans = df[ rowSums (df[])>0,] print ( "rows after removing rows that have all zeros" ) print (ans) |
Output: