cycquery.ops.ConditionStartsWith

class ConditionStartsWith(col, string, not_=False, binarize_col=None, **cond_kwargs)

Bases: QueryOp

Filter rows based on starting with some string.

Parameters:

• col (str) – Column name on which to condition.

• string (any) – String.

• not (bool, default=False) – Take negation of condition.

• binarize_col (str, optional) – If specified, create a Boolean column of name binarize_col instead of filtering.

• **cond_kwargs (Any) – Optional keyword arguments for processing the condition.

Examples

>>> ConditionStartsWith("col1", "a")(table)
>>> ConditionStartsWith("col1", "a", binarize_col="col1_bool")(table)

Methods

__call__(table, return_cond=False)

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