icase in
The icase in
match filter returns rows that contain a match of one or more specified values, regardless of the capitalization of the values.
Syntax
columnName icase in valueList
columnName
- the column the filter will search for matching values.valueList
- the set of values to match on. This supports:- a comma-separated list of variables:
A icase in X, Y, Z
. The filter will returntrue
for all rows where the value in columnA
is equal toX
,Y
, orZ
. - a java array:
A icase in X
. The filter will returntrue
for all rows whereA
is equal to at least one element of the java arrayX
. - a
java.util.Collection
:A icase in X
. The filter will returntrue
for all rows whereA
is equal to at least one element of the collectionX
. - all other types:
A icase in X
. The filter will returntrue
for all rows whereA
is equal toX
.
- a comma-separated list of variables:
Examples
The following example returns rows where Color
is in the comma-separated list of values. Capitalization is ignored.
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 icase in `Blue`, `Orange`"])
The following example returns rows where Color
is blue
or Letter
is a
. Capitalization is ignored.
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_one_of(filters=["Color icase in `Blue`", "Letter icase in `a`"])
The following example returns rows where Color
is 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 icase in my_list"])