cycquery.ops.FillNull

class FillNull(cols, fill_values, new_col_names=None)

Bases: QueryOp

Fill NULL values with a given value.

Parameters:

• cols (Union[str, List[str]]) – Columns to fill.

• fill_values (Union[Any, List[Any]]) – Value(s) to fill with.

• new_col_names (Union[str, List[str], None]) – New column name(s) for the filled columns. If not provided,

Examples

>>> FillNull("col1", 0)(table)
>>> FillNull(["col1", "col2"], [0, 1])(table)
>>> FillNull(["col1", "col2"], [0, 1], ["col1_new", "col2_new"])(table)

Methods

__call__(table)

Fill NULL values with a given value.

Parameters:

table (Union[Select, Subquery, Table, DBTable]) – Table on which to perform the operation.

Returns:

Table with NULL values filled.

Return type:

Subquery