coalesce: A more versatile form of the T-SQL 'coalesce()' function.

Description Usage Arguments Examples

Description

Little more than a wrapper for vectorize, allows for duplication of SQL coalesce functionality, certain types of if-else statements, and apply/Reduce combinations.

Usage

1
coalesce(..., fun = (function(x, y) if (!is.na(x)) x else y))

Arguments

...

an arbitrary number of R objects

fun

a two argument function that returns an atomic value

Examples

1
2
3
4
5
6
coalesce(c(NA,1,2))
coalesce(c(NA,1,2),c(3,4,NA))
df<-data.frame(a=c(NA,2,3),b=c(1,2,NA))
coalesce(df$a,df$b)
# Or even just:
coalesce(df)

cvarrichio/hordr documentation built on May 14, 2019, 12:53 p.m.