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 |
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_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 |
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: