How to remove empty rows from R dataframe?

Remove First Row of DataFrame in R

Last Updated : 23 Aug, 2021

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 row

R

# create dataframe with names and id 
data=data.frame(names=c("sravan","boby","ojaswi","gnanesh", 
                        "rohith"),id=c(1,2,3,4,5)) 
  
# display 
data 
  
# remove first row 
data=data[- 1, ]   
  
print("------") 
  
# display 
data

Output:

Example 2: R program to create dataframe with 4 columns and delete the first row

R

# create dataframe with names ,id,phone and address 
data = data.frame(names=c("sravan", "boby", "ojaswi", "gnanesh", 
                          "rohith"), 
                  id=c(1, 2, 3, 4, 5), 
                  phone=c("91834567450", "2222222222", "333333333333", 
                          "5555555555555", "333333333333"), 
                  address=c("hyd", "kol", "patna", "bikat", "guntut")) 
  
# display 
data 
  
# remove first row 
data = data[- 1, ] 
  
print("------") 
  
# display 
data 

Output:

How to remove empty rows from R dataframe?

gottumukkalabobby

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 Examp

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

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 remove empty rows from R dataframe?

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 w

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. Approach Create a data frameSelect the column based on which rows are t

Extract first N rows from dataframe in R

A required number of rows can be retrieved from a dataframe for some computation that demands so. In this article, we will be discussing two different approaches for extracting the first n rows from the data frame File in Use: Method 1: Using head() function This function will help to extract the gi

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

Reshape DataFrame from Long to Wide Format in R

In this article, we will discuss how to reshape dataframe from long to wide format in R programming language. The data in the dataframe is recognized by the format in which the storage and retrieval happens. Duplicate key-value pairs exist in dataframe and can be rearranged using the following metho

How to Retrieve Row Numbers in R DataFrame?

In this article, we will discuss how to Retrieve Row Numbers in R Programming Language. The dataframe column can be referenced using the $ symbol, which finds its usage as data-frame$col-name. The which() method is then used to retrieve the row number corresponding to the true condition of the speci

Select First Row of Each Group in DataFrame in R

In this article, we will discuss how to select the first row of each group in Dataframe using R programming language. The duplicated() method is used to determine which of the elements of a dataframe are duplicates of other elements. The method returns a logical vector which tells which of the rows