Conditional Element Selection

Share:

Description

'ifelse' returns a value with the same shape as 'test' which is filled with elements selected from either 'yes' or 'no' depending on whether the element of 'test' is 'TRUE' or 'FALSE'.

Usage

1
2
## S4 method for signature 'db.obj'
ifelse(test, yes, no)

Arguments

test

A db.obj object, which has only one column. The column can be casted into boolean values.

yes

A normal value or a db.obj object. It is the returned value when test is TRUE.

no

The returned value when test is FALSE.

Value

A db.obj which has the same length in-database as test.

Author(s)

Author: Hong Ooi, Pivotal Inc.

Maintainer: Frank McQuillan, Pivotal Inc. fmcquillan@pivotal.io

See Also

db.obj

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
## Not run: 


## set up the database connection
## Assume that .port is port number and .dbname is the database name
cid <- db.connect(port = .port, dbname = .dbname, verbose = FALSE)

## create a table
x <- as.db.data.frame(abalone, conn.id = cid, verbose = FALSE)

## create a new db.obj with one-column,
## and values "small" or "big"
z <- ifelse(x$rings < 10, "small", "big")

db.disconnect(cid, verbose = FALSE)

## End(Not run)

Want to suggest features or report bugs for rdrr.io? Use the GitHub issue tracker.