Return Data Frame Row Based On Value in Column in R (Example)
This article explains how to select particular rows conditionally in R.
Table of contents:
It’s time to dive into the example!
Creating Example Data
The following data will be used as basement for this R programming tutorial:
data <- data.frame(x1 = c(1, 4, 3, 1, 7), # Create example data x2 = letters[1:5], x3 = 9:5) data # Print example data
As you can see based on Table 1, our exemplifying data is a data frame consisting of five rows and three columns.
Example: Select Data Frame Rows According to Variable
The following R code illustrates how to create a subset of our data frame based on a specific data frame column.
In this example, we’ll select only rows where the variable x1 is equal to 1:
data_new <- data[data$x1 == 1, ] # Extract certain rows data_new # Print updated data
Table 2 shows the output of the previous R programming code: A data frame subset where x1 is equal to 1.
Video & Further Resources
Do you need more info on the contents of this article? Then I recommend having a look at the following video of my YouTube channel. In the video, I show the R programming syntax of this article.
In addition, you may read the related tutorials of this website.
- Split Data Frame in R
- Randomly Reorder Data Frame by Row and Column
- Append to Data Frame in Loop
- Convert Row Names into Column of Data Frame
- Return Column Name of Largest Value for Each Row
- R Programming Examples
Summary: You have learned in this post how to extract specific rows based on a variable of a data frame in the R programming language. In case you have further questions, please tell me about it in the comments.