Appendices

Generated Stats by Column Data Type

Data Type: Number

Count (number of non-null rows)
Sum
Avg
Min
Max
Sum(Abs)
Avg(Abs)
Min(Abs)
Max(Abs)

Data Type: Boolean

Count (number of non-null rows)
True (number of true values)
False (number of false values)
Null (number of null values if != 0)

Data Type: String

Count
Unique Values (number of distinct values)

Data Type: Date/Timestamps

Count
Unique Values (number of distinct values)

Quick Filter Statement Options

Number Data Types

Symbol	Meaning	Example(s)
= (or nothing)	Equal to	=50 50
!=	Not equal to	!=50 !50
>	Greater than	>50
>=	Greater than or equal to	>=50
<	Less than	<50
<=	Less than or equal to	<=50
&&	Greater than X and less than Y	>10 && <50
II	Or	NYSE II Nasdaq
null	No value	null
Note: Filtering statements can also be combined.

String Data Types

Filter statements for string data types are case-insensitive, and can use comparisons, simple wildcard rules, or regex.

Symbol	Meaning	Example(s)
= (or empty)	Text equals	=spy AAPL
!=	Text does not equal	!=spy !=MSFT
*	Wildcard. Follows "*." java regex; zero or more letters.	A* ( matches A or AMD or AAPL) *Z (matches XYZ)
~	Text contains	~sp
!~	Text does not contain	!~sp
null	Text field is empty (no value)	null =null
!null	Text field is not empty	!null !=null
Notes: Filtering statements can also be combined. For example, "!=A*" is the equivalent to "Text does not equal any value that starts with A". \null can be escaped to match "null" as a string vs value If the value starts and ends with a regex-like string, pass it through: "/regex/i". Any reserved character here can be used if it is escaped first with an escape character "\".

Date/Time Data Types

Date/Time filter statements are similar to filter statements for numeric data types. Date values that can be used in the filter statement include the year, month, and day. Time values can also be used in conjunction with date values, including hour and minute, and optionally seconds and nanoseconds (e.g., 2018-01-25 09:25).

Magic words such as now, today, yesterday can also be used. Note: when now is used, the values include the timestamp down to the millisecond using the appropriate time zone.

Symbol	Meaning	Example
>	Greater than (after)	>2018-01-25 >yesterday
>=	Greater than or equal to	>=2018 >=today
<	Less than (before)	<2018-01-25 <tomorrow
<=	Less than or equal to	<=2018 <=tomorrow
= (or empty)	Equal to	=2018-01-25 2018-01 =yesterday today
!=	Not equal to	!=2018-01-25 !today
null	No value	null
!null	Not null (has a value)	!null

Boolean Data Types

Boolean filtering statements work on columns displayed as "true" or "false". To filter boolean columns, you can use any derivation of the words true or false, and in any letter case. For example, the "true" value could be filtered using true, T, True, t, tru, tRUe, TRUE, etc. Moreover, the binary 0 or 1 could also be used to filter for true or false respectively. "Null" (also case insensitive) can also be used to filter for empty values in columns containing boolean values.

Keyboard Shortcuts

Ctrl+C/Cmd-C	Copies selected row(s) to clipboard of the focused table.
Ctrl-F/Cmd-F	Opens Quick Filter bar on the focused table.
Option+R	Runs an entire notebook or selected lines.

Last Updated: 25 February 2020 08:26 -05:00 UTC Deephaven v.1.20200121 (See other versions)