Selecting rows based on multiple conditions using OR instead of AND in R

Question

I have a large dataset that I am trying to filter based on the value of 2 separate columns. For each row I have a column showing their total count (tot) and a column showing the total times that type of sample was seen (tot.type).

I want to filter my data based on both (tot) and (tot.type) where (tot) OR (tot.type) must be greater than or equal to 2, for example.

All examples I have found for filtering based on multiple values use "AND" but nothing where you use "OR"...

Example data:
name = c("A","B","C","D","E")
rx = c(1,0,2,1,1)
ry = c(0,1,1,0,0)
rz = c(0,0,2,2,3)
type = c("p","q","r","p","r")
tot = c(1,1,5,3,4)
tot.type = c(2,1,2,2,2)
test = data.frame(name,rx,ry,rz,tot,tot.type)

In this example I would discard row B, and keep the rest.

I have filtered the data into 2 separate data sets based on just one column or the other, and then merged them but can this be done in one line that generates one data set, rather than doing two separate ones and combining them later?

BrodieG · Accepted Answer · 2015-02-05 18:37:27Z

5

subset is designed exactly for this:

subset(test, tot.type >= 2 | tot >= 2)

edited Feb 5, 2015 at 18:37

answered Feb 5, 2015 at 18:35

BrodieG

52.8k9 gold badges99 silver badges148 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ina.Quest Over a year ago

Thank you, this works perfectly. So simple yet so difficult to find the answer on my own.

Frank Over a year ago

By the way, this 'or' condition has an alternative formulation: subset(test,pmax(tot,tot.type)>=2) Generally, thinking about the math may help simplify calculations.

C_Z_ · Accepted Answer · 2015-02-05 18:25:58Z

3

Try

test[test$tot>=2 | test$tot.type>=2,]

(p.s. I think there's an error in your example, do you want

test = data.frame(name,rx,ry,rz,type,tot,tot.type)

instead of

test = data.frame(name,rx,ry,rz,tax,tot,N.tax)

?

answered Feb 5, 2015 at 18:25

C_Z_

7,8765 gold badges53 silver badges92 bronze badges

Comments

akrun · Accepted Answer · 2015-02-05 18:46:54Z

1

You could use rowSums. ("test" is based on @CactusWoman's data)

  test[!!rowSums(test[c('tot', 'tot.type')]>=2),])

Or another option

  test[unique(which(test[c("tot","tot.type")] >= 2,
                           arr.ind = TRUE)[, 1]), ]

edited Feb 5, 2015 at 18:46

answered Feb 5, 2015 at 18:28

akrun

891k38 gold badges590 silver badges700 bronze badges

1 Comment

BrodieG Over a year ago

Am I missing some inside joke here? Also, @DavidArenburg, you should get a badge for fastest edit ever. It felt like you edited that almost before I hit submit!

Collectives™ on Stack Overflow

Selecting rows based on multiple conditions using OR instead of AND in R

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related