How to remove a subset from a DataFrame in R ?

How to remove empty rows from R dataframe?

Last Updated : 26 Mar, 2021

A dataframe can contain empty rows and here with empty rows we don't mean NA, NaN or 0, it literally means empty with absolutely no data. Such rows are obviously wasting space and making data frame unnecessarily large. This article will discuss how can this be done.

To remove rows with empty cells we have a syntax in the R language, which makes it easier for the user to remove as many numbers of empty rows in the data frame automatically.

Syntax:

data <- data[!apply(data == "", 1, all),]

Approach

Create dataframe
Select empty rows
Remove those rows
Copy the resultant dataframe
Display dataframe

Example 1:

R

gfg <- data.frame(a=c('i','','iii','iv','','vi','','viii','','x'),
                  b=c('I','','III','IV','','VI','','VIII','','X'), 
                  c=c('1','','3','4','','6','','8','','10'), 
                  d=c('a','','c','d','','f','','h','','j'))

print('Original dataframe:-')
gfg

gfg <- gfg[!apply(gfg == "", 1, all),]
print('Modified dataframe:-')
gfg

Output:

Example 2:

R

gfg <- data.frame( A=c('a','','c','','e'),
                   B=c('5','','5','','5'),
                   C=c('1','','1','','1'),
                   D=c('3','','3','','3'),
                   E=c('#','','#','','#'),
                   F=c('@','','@','','@'),
                   H=c('8','','8','','8'))
                   
print('Original dataframe:-')
gfg

gfg <- gfg[!apply(gfg == "", 1, all),]
print('Modified dataframe:-')
gfg

Output:

How to remove a subset from a DataFrame in R ?

geetansh044

Improve

Article Tags :

Similar Reads

How to Remove Rows in R DataFrame?

In this article, we will discuss how to remove rows from dataframe in the R programming language. Method 1: Remove Rows by Number By using a particular row index number we can remove the rows. Syntax: data[-c(row_number), ] where.Â data is the input dataframerow_number is the row index position Exam

How to Remove Duplicate Rows in R DataFrame?

In this article, we will discuss how to remove duplicate rows in dataframe in R programming language. Dataset in use:Method 1: Using distinct() This method is available in dplyr package which is used to get the unique rows from the dataframe. We can remove rows from the entire which are duplicates a

How to remove a subset from a DataFrame in R ?

A subset is a combination of cells that form a smaller data frame formed out from the original data frame. A set of rows and columns can be removed from the original data frame to reduce a part of the data frame. The subset removal can be based on constraints to which rows and columns are subjected

Remove First Row of DataFrame in R

In this article, we are going to see how to remove the first row from the dataframe. We can remove first row by indexing the dataframe.Â Syntax: data[-1,] where -1 is used to remove the first row which is in row position Example 1: R program to create a dataframe with 2 columns and delete the first

How to Delete Row(s) in R DataFrame ?

In this article, we will see how row(s) can be deleted from a Dataframe in R Programming Language. Deleting a single row For this, the index of the row to be deleted is passed with a minus sign. Syntax: df[-(index), ] Example 1 :Â R # creating a data frame with # some data . df=data.frame(id=c(1,2,3

Removing display of row names from dataframe in R

The dataframe rows and columns are referenced using unique row and column names for the elements. The dataframe method has an attribute row.names that don't make any modification to the existing structure of the dataframe, it just ignores the names assigned to rows. As a result, the first column con

How to Conditionally Remove Rows in R DataFrame?

In this article, we will discuss how to conditionally remove rows from a dataframe in the R Programming Language. We need to remove some rows of data from the dataframe conditionally to prepare the data. For that, we use logical conditions on the basis of which data that doesn't follow the condition

Remove rows with NA in one column of R DataFrame

Columns of DataFrame in R Programming Language can have empty values represented by NA. In this article, we are going to see how to remove rows with NA in one column. We will see various approaches to remove rows with NA values.ApproachCreate a data frameSelect the column based on which rows are to

Extract vector from dataframe in R

In this article, we will see how to extract vectors from DataFrame in R Programming Language. The approach is simple, by using $ operator, we can convert dataframe column to a vector. Syntax: dataframe_name$columnname Given below are various examples to implement the same Example 1: R # create vecto

How to add dataframe to dataframe in R ?

In this article, we will see how to add dataframe at the end of another dataframe in R Programming Language. Method 1: Using rbind() method The rbind() method in R works only if both the input dataframe contains the same columns with similar lengths and names. The dataframes may have a different num