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


table 1 data frame return data frame row based on value column r


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 data frame return data frame row based on value column r


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.


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.


Subscribe to the Statistics Globe Newsletter

Get regular updates on the latest tutorials, offers & news at Statistics Globe.
I hate spam & you may opt out anytime: Privacy Policy.

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.