This is a translation of the SQL command NULL_IF. It is useful if you want to convert an annoying value to NA.

na_if(x, y)

Arguments

x Vector to modify Value to replace with NA

Value

A modified version of x that replaces any values that are equal to y with NA.

coalesce() to replace missing values with a specified value.
na_if(1:5, 5:1)#> [1]  1  2 NA  4  5
na_if(y, "")#> [1] "abc" "def" NA    "ghi"