Displaying Rows conditional on values of two columns - R

Question

treat	education	black	hispanic	re74
1:	23	10	1	1
2:	26	12	0	0
3:	22	9	1	1
4:	18	9	1	1

I'm trying to only display data where either re74==0 or re75==0 or both are equal to zero, which implies that I'm disregarding the rows where both are equal to one.

What have you tried so far that didn't work? There are many questions on SO already about subsetting data—which ones haven't worked already? — camille, Feb 09 '21 at 00:57

score 1 · Answer 1 · answered Feb 06 '21 at 23:16

1

You can use filter from dplyr

library(dplyr)
df %>% filter(re74 == 0 | re75 == 0)

answered Feb 06 '21 at 23:16

Jon S

165
6

score 1 · Accepted Answer · answered Feb 06 '21 at 23:17

(¬_¬)df <- data.frame(
...   stringsAsFactors = FALSE,
...              treat = c("1:", "2:", "3:", "4:"),
...                age = c(0L, 0L, 0L, 0L),
...          education = c(23L, 26L, 22L, 18L),
...              black = c(10L, 12L, 9L, 9L),
...           hispanic = c(1L, 0L, 1L, 1L),
...            married = c(0L, 0L, 0L, 0L),
...           nodegree = c(0L, 0L, 0L, 0L),
...               re74 = c(1L, 0L, 1L, 1L),
...               re75 = c(1L, 0L, 0L, 0L)
... )
(¬_¬)df[df$re74==0 |df$re75==0, ]
  treat age education black hispanic married nodegree re74 re75
2    2:   0        26    12        0       0        0    0    0
3    3:   0        22     9        1       0        0    1    0
4    4:   0        18     9        1       0        0    1    0

You can also use subset to select rows where both re74 and re75 are both equal to 1: ```df2 <- df[!(df$re74 == 1 & df$re75 == 1 ), ]``` — Russ Thomas, Feb 07 '21 at 01:31

score 1 · Answer 3 · answered Feb 07 '21 at 18:20

1

We can use subset

 subset(df, re74 == 0 | re75 == 0)

answered Feb 07 '21 at 18:20

akrun

874,273
37
540
662

Displaying Rows conditional on values of two columns - R

3 Answers3