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.


Please accept YouTube cookies to play this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.

YouTube Content Consent Button Thumbnail

YouTube privacy policy

If you accept this notice, your choice will be saved and the page will refresh.


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.