cycquery.ops.ConditionRegexMatch¶

class ConditionRegexMatch(col, regex, not_=False, binarize_col=None)[source]¶

Filter rows based on matching a regular expression.

Parameters:

col (str) – Column name on which to condition.
regex (str) – Regular expression to match.
not – Take negation of condition.
binarize_col (Optional[str]) – If specified, create a Boolean column of name binarize_col instead of filtering.

Examples

>>> ConditionRegexMatch("col1", ".*")(table)
>>> ConditionRegexMatch("col1", ".*", binarize_col="col1_bool")(table)

Methods

__call__(table, return_cond=False)[source]¶

Process the table.

Parameters:

table (Union[Select, Subquery, Table, DBTable]) – Table on which to perform the operation.
return_cond (bool) – Return the condition instead of filtering.

Returns:

Processed table.

Return type:

sqlalchemy.sql.selectable.Subquery