coalesce

0th

Percentile

Find first non-missing element

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.

Usage
coalesce(x, ...)
Arguments
x, ...

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

Value

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

See Also

na_if() to replace specified values with a NA.

Aliases
  • coalesce
Examples
library(dplyr) # 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)
Documentation reproduced from package dplyr, version 0.5.0, License: MIT + file LICENSE

Community examples

Looks like there are no examples yet.