Select only rows if its value in a particular column is less than the value in the other column

select r rows
Bazon picture Bazon · May 18, 2010 · Viewed 235.9k times · Source

I am using R and need to select rows with aged (age of death) less than or equal to laclen (lactation length). I am trying to create a new data frame to only include rows/ids whereby the value of column'aged' is less than its corresponding 'laclength' value.

df:
 id1   id2    laclen    aged
9830  64526    26       6 
7609  64547    28       0 
9925  64551     3       0 
9922  64551     3       5 
9916  64551     3       8 
9917  64551     3       8 
9914  64551     3       2

the new data frame should look like this:

dfnew:
id1   id2    laclen    aged
9830  64526    26       6 
7609  64547    28       0 
9925  64551     3       0 
9914  64551     3       2

Any help would be appreciated!

Bazon

Answer

wkmor1 picture wkmor1 · May 18, 2010 
df[df$aged <= df$laclen, ]

Should do the trick. The square brackets allow you to index based on a logical expression.

Related questions

Select rows of a matrix that meet a condition

In R with a matrix: one two three four [1,] 1 6 11 16 [2,] 2 7 12 17 [3,] 3 8 11 18 [4,] 4 9 11 19 [5,] 5 10 15 20 I want to extract the submatrix whose rows have column three = 11. That is: one two three four [1,] 1 6 11 16 [3,] 3 8 11 18 [4,] 4 9 11 19 I want to do this without looping. I am new to R so this …

Read More
Select unique values with 'select' function in 'dplyr' library

Is it possible to select all unique values from a column of a data.frame using select function in dplyr library? Something like "SELECT DISTINCT field1 FROM table1" in SQL notation. Thanks!

Read More
dplyr: select columns by position in NSE

I am trying to create a function that will select columns in a DF based on their position. I will always need the first column and then a subset of the DF. I have 1 object for each subset I need …

Read More