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

Scope	Windows	Mac	Action
Global	^E	⌘E	Clear all filters
	^L	⌘L	Toggle Linker tool
Console	^L	^C	Clear lines in console field
	⌃⇧D	⌃⇧D	Disconnect/close session
	^H	^H	Focus history
Command History	^C	⌘C	Copy selection
	⏎	⏎	Send selection to console
	⌥R	⌥R	Run selection in console
	⌃⏎	⌘⏎	Send selection to notebook
CSV Overlay	^V	⌘V	Paste
File List	⌃⌫	⌘⌫	Delete
	⏎	⏎	Rename
Notebook	⌃F	⌘F	Find
	^S	⌘S	Save
	⌥R	⌥R	Run notebook
	⇧⌥R	⇧⌥R	Run selected lines
PQ Editor	^S	⌘S	Save
Tables/Panels	^C	⌘C	Copy selected row(s) to clipboard
	^F	⌘F	Open the Quick Filter bar on the focused table.
	^S	⌘S	Open the Search bar on the focused table.
	⌃⇧E	⌘⇧E	Remove all filters from the focused table

Last Updated: 16 February 2021 18:07 -04:00 UTC Deephaven v.1.20200928 (See other versions)