Skip to main content
Version: Python

isNull

isNull returns a boolean value indicating whether or not the specified value is null.

Syntax

isNull(value)

Parameters

ParameterTypeDescription
valuebyte

The value to check.

valuecharacter

The value to check.

valueBoolean

The value to check.

valuedate-time

The value to check.

valuedouble

The value to check.

valuefloat

The value to check.

valueint

The value to check.

valuelong

The value to check.

valueshort

The value to check.

valueString

The value to check.

isNull can take almost any generic object as its argument.

Returns

true if the value parameter is null; false otherwise.

Examples

The following example shows how isNull interacts with various objects within a table.

from deephaven import new_table
from deephaven.column import string_col, datetime_col
from deephaven.time import to_datetime

source = new_table([
string_col("Strings", ["", "A", None]),
datetime_col("DateTime", [to_datetime("2020-01-01T00:00:00 NY"), to_datetime("2021-01-01T00:00:00 NY"), None])
])

result = source.update(formulas=["StringIsNull = isNull(Strings)", "DateTimeIsNull = isNull(DateTime)"])