Skip to main content
Version: Python

not in

The not in match filter returns rows that do not contain a match of one or more specified values.

Syntax

columnName not in valueList
  • columnName - the column the filter will search for non-matching values.
  • valueList - the set of values to remove. This supports:
    • a comma-separated list of values: A not in X, Y, Z. The filter will return true for all rows where the value in column A is not equal to X, Y, and Z.
    • a java array: A not in X. The filter will return true for all rows where A is not equal to every element of the java array X.
    • a java.util.Collection: A not in X. The filter will return true for all rows where A is not equal to every element of the collection X.
    • all other types: A not in X. The filter will return true for all rows where A is not equal to X.

Examples

The following example returns rows where Color is not in the comma-separated list of values.

from deephaven import new_table
from deephaven.column import string_col, int_col
from deephaven.constants import NULL_INT

source = new_table([
string_col("Letter", ["A", "C", "F", "B", "E", "D", "A"]),
int_col("Number", [NULL_INT, 2, 1, NULL_INT, 4, 5, 3]),
string_col("Color", ["red", "blue", "orange", "purple", "yellow", "pink", "blue"]),
int_col("Code", [12, 14, 11, NULL_INT, 16, 14, NULL_INT]),
])


result = source.where(filters=["Color not in `blue`, `orange`"])

The following example returns rows where Number is not in an array of values.

from deephaven import new_table
from deephaven.column import string_col, int_col
from deephaven.constants import NULL_INT
array = [2, 4, 6]
source = new_table([
string_col("Letter", ["A", "C", "F", "B", "E", "D", "A"]),
int_col("Number", [NULL_INT, 2, 1, NULL_INT, 4, 5, 3]),
string_col("Color", ["red", "blue", "orange", "purple", "yellow", "pink", "blue"]),
int_col("Code", [12, 14, 11, NULL_INT, 16, 14, NULL_INT]),

])

result = source.where(filters=["Number not in array"])

The following example returns rows where Number is not in an array of values or Code is in an array of values.

from deephaven import new_table
from deephaven.column import string_col, int_col
from deephaven.constants import NULL_INT

number_array = [2, 4, 6]
code_array = [10, 12, 14]
source = new_table([
string_col("Letter", ["A", "C", "F", "B", "E", "D", "A"]),
int_col("Number", [NULL_INT, 2, 1, NULL_INT, 4, 5, 3]),
string_col("Color", ["red", "blue", "orange", "purple", "yellow", "pink", "blue"]),
int_col("Code", [12, 14, 11, NULL_INT, 16, 14, NULL_INT]),
])
result = source.where_one_of(filters=["Number not in number_array", "Code in code_array"])

The following example returns rows where Color is not in a collection of values.

from deephaven import new_table
from deephaven.column import string_col, int_col
from deephaven.constants import NULL_INT

my_list = ["pink", "purple", "blue"]

source = new_table([
string_col("Letter", ["A", "C", "F", "B", "E", "D", "A"]),
int_col("Number", [NULL_INT, 2, 1, NULL_INT, 4, 5, 3]),
string_col("Color", ["red", "blue", "orange", "purple", "yellow", "pink", "blue"]),
int_col("Code", [12, 14, 11, NULL_INT, 16, 14, NULL_INT]),
])

result = source.where(filters=["Color not in my_list"])