dataFrame.column.compare — notIn()

Description

The notIn() method of the compare object returns a boolean mask indicating which values don't match one of the specified values.

Signature

dataFrame.column(columnName).compare.notIn(values)
Scope
column
Family
compare
Returns
mask

Arguments

columnName (string)
The name of the column to compare values from.
values (array)
The list of values to compare against.

Returns

mask ( boolean[] )
A boolean mask indicating the rows whose values don't match one of the specified values.
  • Unmatching value: 1
  • Otherwise: 0

Example

// higlight rows where the column 'name' does not contain 'john' or 'Jane'
var mask = df.column('name').compare.notIn(['john', 'Jane']);

// set mask to dataFrame
df.column('not_in').set(mask)