atoti.Measure.isnull()#
- Measure.isnull()#
Return a condition evaluating to
True
if the measure evalutes toNone
andFalse
otherwise.Use
~measure.isnull()
for the opposite behavior.Example
>>> df = pd.DataFrame( ... columns=["Country", "City", "Price"], ... data=[ ... ("France", "Paris", 200.0), ... ("Germany", "Berlin", None), ... ], ... ) >>> table = session.read_pandas(df, table_name="isnull example") >>> cube = session.create_cube(table) >>> l, m = cube.levels, cube.measures >>> m["Price.isnull"] = m["Price.SUM"].isnull() >>> m["Price.notnull"] = ~m["Price.SUM"].isnull() >>> cube.query( ... m["Price.isnull"], ... m["Price.notnull"], ... levels=[l["Country"]], ... ) Price.isnull Price.notnull Country France False True Germany True False
- Return type:
Condition[MeasureIdentifier, Literal[‘eq’], None, None]