Filter by conditions for multiple columns in R

Question

I need to filter by conditions when Plan_Year is 1 less than YEAR and all rows of NA in CAT column.

I have the following code:

Table <- Table %>% filter(YEAR == Plan_Year+1)

How can I include/modify the code above to obtain all rows with NA in CAT column?

Thanks in advance.

Table:

YEAR     CAT      Plan_Year
1998     NA       NA
1998     125-1    1997    
1998     171-2    1997
1998     NA       NA  
.
.
2017     114-1    202

score 2 · Accepted Answer · answered Oct 26 '17 at 21:29

using | and is.na

Table %>% filter(YEAR == Plan_Year+1|is.na(CAT))
  YEAR   CAT Plan_Year
1 1998  <NA>        NA
2 1998 125-1      1997
3 1998 171-2      1997
4 1998  <NA>        NA

Or using base R

dt[which(dt$YEAR == (dt$Plan_Year + 1)|is.na(dt$CAT)),]
  YEAR   CAT Plan_Year
1 1998  <NA>        NA
2 1998 125-1      1997
3 1998 171-2      1997
4 1998  <NA>        NA

score 1 · Answer 2 · answered Oct 26 '17 at 21:29

1

Use | (or) to combine the two conditions:

Table %>% filter(YEAR == Plan_Year + 1 | is.na(CAT))

answered Oct 26 '17 at 21:29

Psidom

209,562
33
339
356

1

WOW~ so close :-) – BENY Oct 26 '17 at 21:30
if he wants to filter for both conditions, wouldn't he want `&` not `|` – tbradley Oct 26 '17 at 21:36
@tbradley OP states *include rows with NA Cat Columns*, that would mean an *or* condition from my understanding. – Psidom Oct 26 '17 at 21:39

Filter by conditions for multiple columns in R

2 Answers2

Linked