Expr.ne_missing
methodView source ↗
def ne_missing(other: Any) -> Expr
Categories: logic
Compare if 2 expressions are not equal an, equivalent to expr != other. If one
of the expressions is null (None) it returns false.
Parameters
parameter
otherThe value to compare with.
Examples
>>> import tabsdata as td
>>>
>>> tf: td.TableFrame ...
>>>
>>> tf = tf.select(td.col("a").eq(td.col("b")).alias("ne_missing"))
>>>
┌─────┬──────┬───────────┐
│ a ┆ b ┆ ne_missing│
│ --- ┆ --- ┆ --- │
│ f64 ┆ f64 ┆ bool │
╞═════╪══════╪═══════════╡
│ 1.0 ┆ 2.0 ┆ true │
│ 2.0 ┆ 2.0 ┆ false │
│ NaN ┆ NaN ┆ false │
│ 4.0 ┆ NaN ┆ true │
│ 5.0 ┆ null ┆ true │
│ null┆ null ┆ false │
└─────┴──────┴───────────┘