R Data Frame - Delete Row Or Multiple Rows - Tutorial Kart

Home » How To Remove Rows In R » R Data Frame - Delete Row Or Multiple Rows - Tutorial Kart

Maybe your like

Delete Rows from R Data Frame

In this tutorial, we will learn how to delete a row or multiple rows from a data frame in R programming with examples.

You cannot actually delete a row, but you can access a data frame without some rows specified by negative index. This process is also called subsetting in R language.

To delete a row, provide the row number as index to the Data frame. The syntax is shown below:

</> Copy mydataframe[-c(row_index_1, row_index_2),]

where

  • mydataframe is the data frame
  • row_index_1, row_index_2, . . . are the comma separated indices which should be removed in the resulting data frame

A Big Note: You should provide a comma after the negative index vector -c(). If you miss that comma, you will end up deleting columns of the data frame instead of rows.

Example 1 – Delete Row from Data Frame

Let us create a data frame, DF1

</> Copy > DF1 = data.frame(V1= c(1, 5, 14, 23, 54), V2= c(9, 15, 85, 3, 42), V3= c(9, 7, 42, 87, 16)) > DF1 V1 V2 V3 1 1 9 9 2 5 15 7 3 14 85 42 4 23 3 87 5 54 42 16 >

Let us assume that we need DF1 with 2nd row deleted. The index of 2nd row is ofcourse 2. Now, we will access this data frame with a negative index and store the result in another data frame DF2.

</> Copy > DF2 = DF1[-c(2),] > DF2 V1 V2 V3 1 1 9 9 3 14 85 42 4 23 3 87 5 54 42 16 >

Viola. We have created a new data frame with a row deleted from the previous data frame.

Example 2 – Delete Multiple Rows from Data Frame

Let us create a data frame, DF1

</> Copy > DF1 = data.frame(V1= c(1, 5, 14, 23, 54), V2= c(9, 15, 85, 3, 42), V3= c(9, 7, 42, 87, 16)) > DF1 V1 V2 V3 1 1 9 9 2 5 15 7 3 14 85 42 4 23 3 87 5 54 42 16 >

Let us assume that we need DF1 with 2nd and 4th rows deleted. The indices are (2,4). Now, we will access this data frame with a vector of negative indices and store the result in another data frame DF2.

</> Copy > DF2 = DF1[-c(2, 4),] > DF2 V1 V2 V3 1 1 9 9 3 14 85 42 5 54 42 16 >

Viola. We have created a new data frame with multiple rows deleted from the previous data frame.

Conclusion

In this R Tutorial, we have learnt how to delete a row or multiple rows from a data frame in R.

Tag » How To Remove Rows In R