filters: Filters for pd_rows() and pd_aggregate()

filtersR Documentation

Filters for pd_rows() and pd_aggregate()

Description

Each helper builds one condition in the query API's 'operator.value' form. A plain value passed to [pd_rows()] must match exactly, a vector of several values matches any of them, and 'NA' matches a blank or suppressed cell.

Usage

pd_eq(value)

pd_neq(value)

pd_gt(value)

pd_gte(value)

pd_lt(value)

pd_lte(value)

pd_like(pattern)

pd_ilike(pattern)

pd_in(...)

pd_is_null()

pd_not(filter)

Arguments

value

A value to compare with. Numbers and dates compare as numbers and dates, text as text.

pattern

A pattern in which '*' stands for any run of characters.

...

Values, any of which may match. None may contain a comma.

filter

A filter to negate.

Value

A 'pd_filter' object.

See Also

Other query: pd_aggregate(), pd_connect(), pd_rows(), pd_tbl()

Examples

pd_gte(2020)
pd_in("QLD", "NSW")
pd_not(pd_is_null())

publicdataau documentation built on Oct. 14, 2026, 5:07 p.m.