remove a row from a dataframe in r

To remove a row from a dataframe in R, you can use the subset() function to create a new dataframe that excludes the row you want to remove. Another way is to use the indexing operator [ ] to remove the row in-place.

Here's an example using the mtcars dataset in R:


main.r
# Load mtcars dataset
data(mtcars)

# Method 1: Using subset() function
mtcars_sub <- subset(mtcars, !(row.names(mtcars) %in% c("Mazda RX4")))
# This creates a new dataframe called mtcars_sub where the row with name "Mazda RX4" is excluded

# Method 2: Using indexing operator [ ]
mtcars_new <- mtcars[-1, ]
# This creates a new dataframe called mtcars_new that excludes the first row in mtcars
395 chars
11 lines

In Method 2, we specified -1 to remove the row with index 1. Similarly, you can specify any row index that you want to remove.

similar r code snippets

set the first row as headers in r

filter nycflights13 by month of july in r

read all files in a directory into a data frame, with a column recording filename in r

check if column values have 90 percent overlap in vlaues in r

mutate a column via its name in r

tidyverse overlap 90 percent column values in r

in a dataframe where the concentration column goes 10, 5, 2, 1 repeatedly, reverse the order of the concentration column in r

read all files in a directory into a data frame, with a column recording filename using tidyverse in r

how to create a dataframe in r

recode some rows of dataframe in r

related categories