Select Data Frame Rows Based On Row Names in R (Example Code)

In this R tutorial you’ll learn how to select certain observations based on row names.

Creation of Example Data

data(iris)                                            # Loading iris data
head(iris)
#   Sepal.Length Sepal.Width Petal.Length Petal.Width Species
# 1          5.1         3.5          1.4         0.2  setosa
# 2          4.9         3.0          1.4         0.2  setosa
# 3          4.7         3.2          1.3         0.2  setosa
# 4          4.6         3.1          1.5         0.2  setosa
# 5          5.0         3.6          1.4         0.2  setosa
# 6          5.4         3.9          1.7         0.4  setosa

Example: Subsetting Iris Data Frame Using Row Names

iris_keep <- c(1:3, 6, 8)                             # These rows should be retained
iris_keep                                             # Show selected row names in RStudio console
# [1] 1 2 3 6 8
iris_select <- iris[rownames(iris) %in% iris_keep, ]  # Extract particular rows from iris
iris_select                                           # Show iris data frame subset in RStudio console
#   Sepal.Length Sepal.Width Petal.Length Petal.Width Species
# 1          5.1         3.5          1.4         0.2  setosa
# 2          4.9         3.0          1.4         0.2  setosa
# 3          4.7         3.2          1.3         0.2  setosa
# 6          5.4         3.9          1.7         0.4  setosa
# 8          5.0         3.4          1.5         0.2  setosa

Further Resources

Below, you may find some further resources on topics such as groups, coding errors, merging, and extracting data:

Leave a Reply

Your email address will not be published.

Fill out this field
Fill out this field
Please enter a valid email address.
You need to agree with the terms to proceed

Menu
Top