coalesce: Find first non-missing element
In sctyner/dplyr050: A Grammar of Data Manipulation

Description Usage Arguments Value See Also Examples

Given a set of vectors, coelesce finds the first non-missing value at each position. This is inspired by the SQL COALESCE function which does the same thing for NULLs.

1	coalesce(x, ...)

x, ...

Vectors. All inputs should either be length 1, or the same length as x

A vector the same length as x with missing values replaced by the first non-missing value.

na_if() to replace specified values with a NA.

# Use a single value to replace all missing values
x <- sample(c(1:5, NA, NA, NA))
coalesce(x, 0L)

# Or match together a complete vector from missing pieces
y <- c(1, 2, NA, NA, 5)
z <- c(NA, NA, 3, 4, 5)
coalesce(y, z)