deephaven.table<a class="headerlink" href="#module-deephaven.table" title="Permalink to this heading">#

Returns:

a PartitionedTable

Raises:

classmethod from_partitioned_table(table, key_cols=None, unique_keys=None, constituent_column=None, constituent_table_columns=None, constituent_changes_permitted=None)[source]#

Creates a PartitionedTable from the provided underlying partitioned Table.

Note: key_cols, unique_keys, constituent_column, constituent_table_columns, constituent_changes_permitted must either be all None or all have values. When they are None, their values will be inferred as follows:

key_cols: the names of all columns with a non-Table data type unique_keys: False constituent_column: the name of the first column with a Table data type constituent_table_columns: the column definitions of the first cell (constituent table) in the constituent

column. Consequently the constituent column can’t be empty

constituent_changes_permitted: the value of table.is_refreshing

Parameters:

table (Table) – the underlying partitioned table
key_cols (Union[str, List[str]]) – the key column name(s) of ‘table’
unique_keys (bool) – whether the keys in ‘table’ are guaranteed to be unique
constituent_column (str) – the constituent column name in ‘table’
constituent_table_columns (list[Column]) – the column definitions of the constituent table
constituent_changes_permitted (bool) – whether the values of the constituent column can change

Return type:

Returns:

a PartitionedTable

Raises:

get_constituent(key_values)[source]#

Gets a single constituent table by its corresponding key column value(s). If there are no matching rows, the result is None. If there are multiple matching rows, a DHError is thrown.

Parameters:: key_values (Union[Any, Sequence[Any]]) – the value(s) of the key column(s)
Return type:: Optional[Table]
Returns:: a Table or None
Raises:: DHError –

property is_refreshing#: Whether the underlying partitioned table is refreshing.

j_object_type#: alias of PartitionedTable

property key_columns#: The partition key column names.

keys()[source]#

Returns a Table containing all the keys of the underlying partitioned table.

Return type:: Table

merge()[source]#

Makes a new Table that contains all the rows from all the constituent tables. In the merged result, data from a constituent table is contiguous, and data from constituent tables appears in the same order the constituent table appears in the PartitionedTable. Basically, merge stacks constituent tables on top of each other in the same relative order as the partitioned table.

Return type:: Table
Returns:: a Table
Raises:: DHError –

partitioned_transform(other, func)[source]#

Join the underlying partitioned Tables from this PartitionedTable and other on the key columns, then apply the provided function to all pairs of constituent Tables with the same keys in order to produce a new PartitionedTable with the results as its constituents, with the same data for all other columns in the underlying partitioned Table from this.

Note that if the Tables underlying this PartitionedTable or other change, a corresponding change will propagate to the result.

Parameters:

other (PartitionedTable) – the other Partitioned table whose constituent tables will be passed in as the 2nd argument to the provided function
(Callable[[Table (func) – a function which takes two Tables as input and returns a new Table
Table] – a function which takes two Tables as input and returns a new Table
Table] – a function which takes two Tables as input and returns a new Table

Return type:

Returns:

a PartitionedTable

Raises:

proxy(require_matching_keys=True, sanity_check_joins=True)[source]#

Makes a proxy that allows table operations to be applied to the constituent tables of this PartitionedTable.

Parameters:

require_matching_keys (bool) – whether to ensure that both partitioned tables have all the same keys present when an operation uses this PartitionedTable and another PartitionedTable as inputs for a partitioned_transform(), default is True
sanity_check_joins (bool) – whether to check that for proxied join operations, a given join key only occurs
a (in exactly one constituent table of the underlying partitioned table. If the other table argument is also) –
PartitionedTableProxy –
constraint. (its constituents will also be subjected to this) –

Return type:

sort(order_by, order=None)[source]#

The sort method creates a new partitioned table where the rows are ordered based on values in a specified set of columns. Sort can not use the constituent column. :rtype: PartitionedTable

Args:
order_by (Union[str, Sequence[str]]): the column(s) to be sorted on. Can’t include the constituent column. order (Union[SortDirection, Sequence[SortDirection], optional): the corresponding sort directions for

each sort column, default is None, meaning ascending order for all the sort columns.

Returns:
a new PartitionedTable

Raises:
DHError

property table#: The underlying partitioned table.

transform(func)[source]#

Apply the provided function to all constituent Tables and produce a new PartitionedTable with the results as its constituents, with the same data for all other columns in the underlying partitioned Table. Note that if the Table underlying this PartitionedTable changes, a corresponding change will propagate to the result.

Parameters:

(Callable[[Table] (func) – a function which takes a Table as input and returns a new Table
Table] – a function which takes a Table as input and returns a new Table

Return type:

Returns:

a PartitionedTable

Raises:

property unique_keys#: Whether the keys in the underlying table must always be unique. If keys must be unique, one can expect that self.table.select_distinct(self.key_columns) and self.table.view(self.key_columns) operations always produce equivalent tables.

class PartitionedTableProxy(j_pt_proxy)[source]#

Bases: JObjectWrapper

A PartitionedTableProxy is a table operation proxy for the underlying partitioned table. It provides methods that apply table operations to the constituent tables of the underlying partitioned table, produce a new partitioned table from the resulting constituent tables, and return a proxy of it.

target#

the underlying partitioned table of the proxy

Type:: PartitionedTable

require_matching_keys#

whether to ensure that both partitioned tables have all the same keys present when an operation uses this PartitionedTable and another PartitionedTable as inputs for a partitioned_transform(), default is True

Type:: bool

sanity_check_joins#

whether to check that for proxied join operations, a given join key only occurs in exactly one constituent table of the underlying partitioned table. If the other table argument is also a PartitionedTableProxy, its constituents will also be subjected to this constraint.

Type:: bool

abs_sum_by(by=None)[source]#

Applies the abs_sum_by() table operation to all constituent tables of the underlying partitioned table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Parameters:: by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None
Return type:: PartitionedTableProxy
Returns:: a new PartitionedTableProxy
Raises:: DHError –

agg_all_by(agg, by=None)[source]#

Applies the agg_all_by() table operation to all constituent tables of the underlying partitioned table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Note, because agg_all_by applies the aggregation to all the columns of the table, it will ignore any column names specified for the aggregation.

Parameters:

agg (Aggregation) – the aggregation
by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None

Return type:

Returns:

a new PartitionedTableProxy

Raises:

agg_by(aggs, by=None)[source]#

Applies the agg_by() table operation to all constituent tables of the underlying partitioned table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Parameters:

aggs (Union[Aggregation, Sequence[Aggregation]]) – the aggregation(s)
by (Union[str, Sequence[str]]) – the group-by column name(s), default is None

Return type:

Returns:

a new PartitionedTableProxy

Raises:

aj(table, on, joins=None, match_rule=AsOfMatchRule.LESS_THAN_EQUAL)[source]#

Applies the aj() table operation to all constituent tables of the underlying partitioned table with the provided right table or PartitionedTableProxy, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

In the case of the right table being another PartitionedTableProxy, the aj() table operation is applied to the matching pairs of the constituent tables from both underlying partitioned tables.

Parameters:

table (Union[Table, PartitionedTableProxy]) – the right table or PartitionedTableProxy of the join
on (Union[str, Sequence[str]]) – the column(s) to match, can be a common name or an equal expression, i.e. “col_a = col_b” for different column names
joins (Union[str, Sequence[str]], optional) – the column(s) to be added from the right table to the result table, can be renaming expressions, i.e. “new_col = col”; default is None
match_rule (AsOfMatchRule) – the inexact matching rule on the last column to match specified in ‘on’, default is AsOfMatchRule.LESS_THAN_EQUAL. The other valid value is AsOfMatchRule.LESS_THAN.

Return type:

Returns:

a new PartitionedTableProxy

Raises:

avg_by(by=None)[source]#

Applies the avg_by() table operation to all constituent tables of the underlying partitioned table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Parameters:: by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None
Return type:: PartitionedTableProxy
Returns:: a new PartitionedTableProxy
Raises:: DHError –

count_by(col, by=None)[source]#

Applies the count_by() table operation to all constituent tables of the underlying partitioned table with the provided source table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Parameters:

col (str) – the name of the column to store the counts
by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None

Return type:

Returns:

a new PartitionedTableProxy

Raises:

exact_join(table, on, joins=None)[source]#

Applies the exact_join() table operation to all constituent tables of the underlying partitioned table with the provided right table or PartitionedTableProxy,and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

In the case of the right table being another PartitionedTableProxy, the exact_join() table operation is applied to the matching pairs of the constituent tables from both underlying partitioned tables.

Parameters:

table (Union[Table, PartitionedTableProxy]) – the right table or PartitionedTableProxy of the join
on (Union[str, Sequence[str]]) – the column(s) to match, can be a common name or an equal expression, i.e. “col_a = col_b” for different column names
joins (Union[str, Sequence[str]], optional) – the column(s) to be added from the right table to the result table, can be renaming expressions, i.e. “new_col = col”; default is None

Return type:

Returns:

a new PartitionedTableProxy

Raises:

first_by(by=None)[source]#

Applies the first_by() table operation to all constituent tables of the underlying partitioned table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Parameters:: by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None
Return type:: PartitionedTableProxy
Returns:: a new PartitionedTableProxy
Raises:: DHError –

group_by(by=None)[source]#

Applies the group_by() table operation to all constituent tables of the underlying partitioned table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Parameters:: by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None
Return type:: PartitionedTableProxy
Returns:: a new PartitionedTableProxy
Raises:: DHError –

head(num_rows)[source]#

Applies the head() table operation to all constituent tables of the underlying partitioned table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Parameters:: num_rows (int) – the number of rows at the head of the constituent tables
Return type:: PartitionedTableProxy
Returns:: a new PartitionedTableProxy
Raises:: DHError –

property is_refreshing#: Whether this proxy represents a refreshing partitioned table.

j_object_type#: alias of PartitionedTable$Proxy

join(table, on=None, joins=None)[source]#

Applies the join() table operation to all constituent tables of the underlying partitioned table with the provided right table or PartitionedTableProxy, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

In the case of the right table being another PartitionedTableProxy, the join() table operation is applied to the matching pairs of the constituent tables from both underlying partitioned tables.

Parameters:

table (Union[Table, PartitionedTableProxy]) – the right table or PartitionedTableProxy of the join
on (Union[str, Sequence[str]]) – the column(s) to match, can be a common name or an equal expression, i.e. “col_a = col_b” for different column names; default is None
joins (Union[str, Sequence[str]], optional) – the column(s) to be added from the right table to the result table, can be renaming expressions, i.e. “new_col = col”; default is None

Return type:

Returns:

a new PartitionedTableProxy

Raises:

last_by(by=None)[source]#

Applies the last_by() table operation to all constituent tables of the underlying partitioned table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Parameters:: by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None
Return type:: PartitionedTableProxy
Returns:: a new PartitionedTableProxy
Raises:: DHError –

max_by(by=None)[source]#

Applies the max_by() table operation to all constituent tables of the underlying partitioned table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Parameters:: by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None
Return type:: PartitionedTableProxy
Returns:: a new PartitionedTableProxy
Raises:: DHError –

median_by(by=None)[source]#

Applies the median_by() table operation to all constituent tables of the underlying partitioned table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Parameters:: by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None
Return type:: PartitionedTableProxy
Returns:: a new PartitionedTableProxy
Raises:: DHError –

min_by(by=None)[source]#

Applies the min_by() table operation to all constituent tables of the underlying partitioned table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Parameters:: by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None
Return type:: PartitionedTableProxy
Returns:: a new PartitionedTableProxy
Raises:: DHError –

natural_join(table, on, joins=None)[source]#

Applies the natural_join() table operation to all constituent tables of the underlying partitioned table with the provided right table or PartitionedTableProxy, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

In the case of the right table being another PartitionedTableProxy, the natural_join() table operation is applied to the matching pairs of the constituent tables from both underlying partitioned tables.

Parameters:

table (Union[Table, PartitionedTableProxy]) – the right table or PartitionedTableProxy of the join
on (Union[str, Sequence[str]]) – the column(s) to match, can be a common name or an equal expression, i.e. “col_a = col_b” for different column names
joins (Union[str, Sequence[str]], optional) – the column(s) to be added from the right table to the result table, can be renaming expressions, i.e. “new_col = col”; default is None

Return type:

Returns:

a new PartitionedTableProxy

Raises:

raj(table, on, joins=None, match_rule=AsOfMatchRule.GREATER_THAN_EQUAL)[source]#

Applies the raj() table operation to all constituent tables of the underlying partitioned table with the provided right table or PartitionedTableProxy, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

In the case of the right table being another PartitionedTableProxy, the raj() table operation is applied to the matching pairs of the constituent tables from both underlying partitioned tables.

Parameters:

table (Union[Table, PartitionedTableProxy]) – the right table or PartitionedTableProxy of the join
on (Union[str, Sequence[str]]) – the column(s) to match, can be a common name or an equal expression, i.e. “col_a = col_b” for different column names
joins (Union[str, Sequence[str]], optional) – the column(s) to be added from the right table to the result table, can be renaming expressions, i.e. “new_col = col”; default is None
match_rule (AsOfMatchRule) – the inexact matching rule on the last column to match specified in ‘on’, default is AsOfMatchRule.GREATER_THAN_EQUAL. The other valid value is AsOfMatchRule.GREATER_THAN.

Return type:

Returns:

a new PartitionedTableProxy

Raises:

reverse()[source]#

Applies the reverse() table operation to all constituent tables of the underlying partitioned table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Return type:: PartitionedTableProxy
Returns:: a new PartitionedTableProxy
Raises:: DHError –

select(formulas=None)[source]#

Applies the select() table operation to all constituent tables of the underlying partitioned table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Parameters:: formulas (Union[str, Sequence[str]], optional) – the column formula(s), default is None
Return type:: PartitionedTableProxy
Returns:: A new PartitionedTableProxy
Raises:: DHError –

select_distinct(formulas=None)[source]#

Applies the select_distinct() table operation to all constituent tables of the underlying partitioned table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Parameters:: formulas (Union[str, Sequence[str]], optional) – the column formula(s), default is None
Return type:: PartitionedTableProxy
Returns:: A new PartitionedTableProxy
Raises:: DHError –

snapshot()[source]#

Applies the snapshot() table operation to all constituent tables of the underlying partitioned table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Return type:: PartitionedTableProxy
Returns:: a new PartitionedTableProxy
Raises:: DHError –

snapshot_when(trigger_table, stamp_cols=None, initial=False, incremental=False, history=False)[source]#

Applies the snapshot_when() table operation to all constituent tables of the underlying partitioned table with the provided trigger table or PartitionedTableProxy, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

In the case of the trigger table being another PartitionedTableProxy, the snapshot_when() table operation is applied to the matching pairs of the constituent tables from both underlying partitioned tables.

Parameters:

trigger_table (Union[Table, PartitionedTableProxy]) – the trigger Table or PartitionedTableProxy
stamp_cols (Union[str, Sequence[str]) – The columns from trigger_table that form the “stamp key”, may be renames. None, or empty, means that all columns from trigger_table form the “stamp key”.
initial (bool) – Whether to take an initial snapshot upon construction, default is False. When False, the resulting table will remain empty until trigger_table first updates.
incremental (bool) – Whether the resulting table should be incremental, default is False. When False, all rows of this table will have the latest “stamp key”. When True, only the rows of this table that have been added or updated will have the latest “stamp key”.
history (bool) – Whether the resulting table should keep history, default is False. A history table appends a full snapshot of this table and the “stamp key” as opposed to updating existing rows. The history flag is currently incompatible with initial and incremental: when history is True, incremental and initial must be False.

Return type:

Returns:

a new PartitionedTableProxy

Raises:

sort(order_by, order=None)[source]#

Applies the sort() table operation to all constituent tables of the underlying partitioned table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Parameters:

order_by (Union[str, Sequence[str]]) – the column(s) to be sorted on
order (Union[SortDirection, Sequence[SortDirection], optional) – the corresponding sort directions for each sort column, default is None, meaning ascending order for all the sort columns.

Return type:

Returns:

a new PartitionedTableProxy

Raises:

sort_descending(order_by)[source]#

Applies the sort_descending() table operation to all constituent tables of the underlying partitioned table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Parameters:: order_by (Union[str, Sequence[str]]) – the column(s) to be sorted on
Return type:: PartitionedTableProxy
Returns:: a new PartitionedTableProxy
Raises:: DHError –

std_by(by=None)[source]#

Applies the std_by() table operation to all constituent tables of the underlying partitioned table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Parameters:: by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None
Return type:: PartitionedTableProxy
Returns:: a new PartitionedTableProxy
Raises:: DHError –

sum_by(by=None)[source]#

Applies the sum_by() table operation to all constituent tables of the underlying partitioned table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Parameters:: by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None
Return type:: PartitionedTableProxy
Returns:: a new PartitionedTableProxy
Raises:: DHError –

tail(num_rows)[source]#

Applies the tail() table operation to all constituent tables of the underlying partitioned table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Parameters:: num_rows (int) – the number of rows at the end of the constituent tables
Return type:: PartitionedTableProxy
Returns:: a new PartitionedTableProxy
Raises:: DHError –

update(formulas)[source]#

Applies the update() table operation to all constituent tables of the underlying partitioned table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Parameters:: formulas (Union[str, Sequence[str]]) – the column formula(s)
Return type:: PartitionedTableProxy
Returns:: A new PartitionedTableProxy
Raises:: DHError –

update_by(ops, by=None)[source]#

Applies the update_by() table operation to all constituent tables of the underlying partitioned table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Parameters:

ops (Union[UpdateByOperation, List[UpdateByOperation]]) – the update-by operation definition(s)
by (Union[str, List[str]]) – the key column name(s) to group the rows of the table

Return type:

Returns:

a new PartitionedTableProxy

Raises:

update_view(formulas)[source]#

Applies the update_view() table operation to all constituent tables of the underlying partitioned table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Parameters:: formulas (Union[str, Sequence[str]]) – the column formula(s)
Return type:: PartitionedTableProxy
Returns:: A new PartitionedTableProxy
Raises:: DHError –

var_by(by=None)[source]#

Applies the var_by() table operation to all constituent tables of the underlying partitioned table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Parameters:: by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None
Return type:: PartitionedTableProxy
Returns:: a new PartitionedTableProxy
Raises:: DHError –

view(formulas)[source]#

Applies the view() table operation to all constituent tables of the underlying partitioned table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Parameters:: formulas (Union[str, Sequence[str]]) – the column formula(s)
Return type:: PartitionedTableProxy
Returns:: A new PartitionedTableProxy
Raises:: DHError –

weighted_avg_by(wcol, by=None)[source]#

Applies the weighted_avg_by() table operation to all constituent tables of the underlying partitioned table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Parameters:

wcol (str) – the name of the weight column
by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None

Return type:

Returns:

a new PartitionedTableProxy

Raises:

weighted_sum_by(wcol, by=None)[source]#

Applies the weighted_sum_by() table operation to all constituent tables of the underlying partitioned table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Parameters:

wcol (str) – the name of the weight column
by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None

Return type:

Returns:

a new PartitionedTableProxy

Raises:

where(filters=None)[source]#

Applies the where() table operation to all constituent tables of the underlying partitioned table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Parameters:: filters (Union[str, Filter, Sequence[str], Sequence[Filter]], optional) – the filter condition expression(s) or Filter object(s), default is None
Return type:: PartitionedTableProxy
Returns:: a new PartitionedTableProxy
Raises:: DHError –

where_in(filter_table, cols)[source]#

Applies the where_in() table operation to all constituent tables of the underlying partitioned table with the provided filter table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Parameters:

filter_table (Table) – the table containing the set of values to filter on
cols (Union[str, Sequence[str]]) – the column name(s)

Return type:

Returns:

a new PartitionedTableProxy

Raises:

where_not_in(filter_table, cols)[source]#

Applies the where_not_in() table operation to all constituent tables of the underlying partitioned table with the provided filter table, and produces a new PartitionedTableProxy with the result tables as the constituents of its underlying partitioned table.

Parameters:

filter_table (Table) – the table containing the set of values to filter on
cols (Union[str, Sequence[str]]) – the column name(s)

Return type:

Returns:

a new PartitionedTableProxy

Raises:

class RollupNodeOperationsRecorder(j_node_ops_recorder)[source]#

Bases: JObjectWrapper, _FormatOperationsRecorder, _SortOperationsRecorder

Recorder for node-level operations to be applied when gathering snapshots of RollupTable. Supported operations include column formatting and sorting.

Note: It should not be instantiated directly. User code must call node_operation_recorder() to create an instance of the recorder.

format_column(formulas)#: Returns a new recorder with the format_columns() operation applied to nodes.

format_column_where(col, cond, formula)#: Returns a new recorder with the format_column_where() operation applied to nodes.

format_row_where(cond, formula)#: Returns a new recorder with the format_row_where() operation applied to nodes.

j_object_type#: alias of RollupTable$NodeOperationsRecorder

sort(order_by)#: Returns a new recorder with the sort() operation applied to nodes.

sort_descending(order_by)#: Returns a new recorder with the sort_descending() applied to nodes.

class RollupTable(j_rollup_table, aggs, include_constituents, by)[source]#

Bases: JObjectWrapper

A RollupTable is generated as a result of applying the rollup() operation on a Table.

A RollupTable aggregates by the grouping columns, and then creates a hierarchical table which re-aggregates using one less grouping column on each level.

Note: RollupTable should not be instantiated directly by user code.

j_object_type#: alias of RollupTable

node_operation_recorder(node_type)[source]#

Creates a RollupNodeOperationsRecorder for per-node operations to apply during Deephaven UI driven snapshotting of this RollupTable. The recorded node operations will be applied only to the node of the provided NodeType. See NodeType for details.

Parameters:: node_type (NodeType) – the type of node tables that the recorded operations will be applied to; if it is NodeType.CONSTITUENT, the RollupTable must be created with include_constituents=True.
Return type:: RollupNodeOperationsRecorder
Returns:: a RollupNodeOperationsRecorder
Raises:: DHError –

with_filters(filters)[source]#

Returns a new RollupTable by applying the given set of filters to the group-by columns of this RollupTable.

Parameters:: filters (Union[str, Filter, Sequence[str], Sequence[Filter]], optional) – the filter condition expression(s) or Filter object(s)
Return type:: RollupTable
Returns:: a new RollupTable
Raises:: DHError –

with_node_operations(recorders)[source]#

Returns a new RollupTable that will apply the recorded node operations to nodes when gathering snapshots requested by the Deephaven UI.

Parameters:: recorders (List[RollupNodeOperationsRecorder]) – a list of RollupNodeOperationsRecorder containing the node operations to be applied, they must be ones created by calling the ‘node_operation_recorder’ method on the same table.
Return type:: RollupTable
Returns:: a new RollupTable
Raises:: DHError –

class SortDirection(value)[source]#

Bases: Enum

An enum defining the sorting orders.

ASCENDING = 2#

DESCENDING = 1#

class Table(j_table)[source]#

Bases: JObjectWrapper

A Table represents a Deephaven table. It allows applications to perform powerful Deephaven table operations.

Note: It should not be instantiated directly by user code. Tables are mostly created by factory methods, data ingestion operations, queries, aggregations, joins, etc.

abs_sum_by(by=None)[source]#

The abs_sum_by method creates a new table containing the absolute sum for each group.

Parameters:: by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None
Return type:: Table
Returns:: a new table
Raises:: DHError –

agg_all_by(agg, by=None)[source]#

The agg_all_by method creates a new table containing grouping columns and grouped data. The resulting grouped data is defined by the aggregation specified.

Note, because agg_all_by applies the aggregation to all the columns of the table, it will ignore any column names specified for the aggregation.

Parameters:

agg (Aggregation) – the aggregation
by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None

Return type:

Returns:

a new table

Raises:

agg_by(aggs, by=None, preserve_empty=False, initial_groups=None)[source]#

The agg_by method creates a new table containing grouping columns and grouped data. The resulting grouped data is defined by the aggregations specified.

Parameters:

aggs (Union[Aggregation, Sequence[Aggregation]]) – the aggregation(s)
by (Union[str, Sequence[str]]) – the group-by column name(s), if not provided, all rows from this table are grouped into a single group of rows before the aggregations are applied to the result, default is None.
preserve_empty (bool) – whether to keep result rows for groups that are initially empty or become empty as a result of updates. Each aggregation operator defines its own value for empty groups. Default is False.
initial_groups (Table) – a table whose distinct combinations of values for the group-by column(s) should be used to create an initial set of aggregation groups. All other columns are ignored. This is useful in combination with preserve_empty=True to ensure that particular groups appear in the result table, or with preserve_empty=False to control the encounter order for a collection of groups and thus their relative order in the result. Changes to this table are not expected or handled; if this table is a refreshing table, only its contents at instantiation time will be used. Default is None, the result will be the same as if a table is provided but no rows were supplied. When it is provided, the ‘by’ argument must be provided to explicitly specify the grouping columns.

Return type:

Returns:

a new table

Raises:

aj(table, on, joins=None, match_rule=AsOfMatchRule.LESS_THAN_EQUAL)[source]#

The aj (as-of join) method creates a new table containing all the rows and columns of the left table, plus additional columns containing data from the right table. For columns appended to the left table (joins), row values equal the row values from the right table where the keys from the left table most closely match the keys from the right table without going over. If there is no matching key in the right table, appended row values are NULL.

Parameters:

table (Table) – the right-table of the join
on (Union[str, Sequence[str]]) – the column(s) to match, can be a common name or an equal expression, i.e. “col_a = col_b” for different column names
joins (Union[str, Sequence[str]], optional) – the column(s) to be added from the right table to the result table, can be renaming expressions, i.e. “new_col = col”; default is None
match_rule (AsOfMatchRule) – the inexact matching rule on the last column to match specified in ‘on’, default is AsOfMatchRule.LESS_THAN_EQUAL. The other valid value is AsOfMatchRule.LESS_THAN.

Return type:

Returns:

a new table

Raises:

attributes()[source]#

Returns all the attributes defined on the table.

Return type:: Dict[str, Any]

avg_by(by=None)[source]#

The avg_by method creates a new table containing the average for each group.

Parameters:: by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None
Return type:: Table
Returns:: a new table
Raises:: DHError –

coalesce()[source]#

Returns a coalesced child table.

Return type:: Table

property columns#: The column definitions of the table.

count_by(col, by=None)[source]#

The count_by method creates a new table containing the number of rows for each group.

Parameters:

col (str) – the name of the column to store the counts
by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None

Return type:

Returns:

a new table

Raises:

drop_columns(cols)[source]#

The drop_columns method creates a new table with the same size as this table but omits any of specified columns.

Parameters:: cols (Union[str, Sequence[str]) – the column name(s)
Return type:: Table
Returns:: a new table
Raises:: DHError –

exact_join(table, on, joins=None)[source]#

The exact_join method creates a new table containing all the rows and columns of this table plus additional columns containing data from the right table. For columns appended to the left table (joins), row values equal the row values from the right table where the key values in the left and right tables are equal.

Parameters:

table (Table) – the right-table of the join
on (Union[str, Sequence[str]]) – the column(s) to match, can be a common name or an equal expression, i.e. “col_a = col_b” for different column names
joins (Union[str, Sequence[str]], optional) – the column(s) to be added from the right table to the result table, can be renaming expressions, i.e. “new_col = col”; default is None

Return type:

Returns:

a new table

Raises:

first_by(by=None)[source]#

The first_by method creates a new table containing the first row for each group.

Parameters:: by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None
Return type:: Table
Returns:: a new table
Raises:: DHError –

format_column_where(col, cond, formula)[source]#

Applies color formatting to a column of the table conditionally.

Parameters:

col (str) – the column name
cond (str) – the condition expression
formula (str) – the formatting string in the form of assignment expression “column=color expression” where color_expression can be a color name or a Java ternary expression that results in a color.

Return type:

Returns:

a new table

Raises:

format_columns(formulas)[source]#

Applies color formatting to the columns of the table.

Parameters:: formulas (Union[str, List[str]]) – formatting string(s) in the form of “column=color_expression” where color_expression can be a color name or a Java ternary expression that results in a color.
Return type:: Table
Returns:: a new table
Raises:: DHError –

format_row_where(cond, formula)[source]#

Applies color formatting to rows of the table conditionally.

Parameters:

cond (str) – the condition expression
formula (str) – the formatting string in the form of assignment expression “column=color expression” where color_expression can be a color name or a Java ternary expression that results in a color.

Return type:

Returns:

a new table

Raises:

group_by(by=None)[source]#

The group_by method creates a new table containing grouping columns and grouped data, column content is grouped into arrays.

Parameters:: by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None
Return type:: Table
Returns:: a new table
Raises:: DHError –

head(num_rows)[source]#

The head method creates a new table with a specific number of rows from the beginning of the table.

Parameters:: num_rows (int) – the number of rows at the head of table
Return type:: Table
Returns:: a new table
Raises:: DHError –

head_by(num_rows, by=None)[source]#

The head_by method creates a new table containing the first number of rows for each group.

Parameters:

num_rows (int) – the number of rows at the beginning of each group
by (Union[str, Sequence[str]]) – the group-by column name(s), default is None

Return type:

Returns:

a new table

Raises:

head_pct(pct)[source]#

The head_pct method creates a new table with a specific percentage of rows from the beginning of the table.

Parameters:: pct (float) – the percentage of rows to return as a value from 0 (0%) to 1 (100%).
Return type:: Table
Returns:: a new table
Raises:: DHError –

property is_refreshing#: Whether this table is refreshing.

j_object_type#: alias of Table

join(table, on=None, joins=None)[source]#

The join method creates a new table containing rows that have matching values in both tables. Rows that do not have matching criteria will not be included in the result. If there are multiple matches between a row from the left table and rows from the right table, all matching combinations will be included. If no columns to match (on) are specified, every combination of left and right table rows is included.

Parameters:

table (Table) – the right-table of the join
on (Union[str, Sequence[str]]) – the column(s) to match, can be a common name or an equal expression, i.e. “col_a = col_b” for different column names; default is None
joins (Union[str, Sequence[str]], optional) – the column(s) to be added from the right table to the result table, can be renaming expressions, i.e. “new_col = col”; default is None

Return type:

Returns:

a new table

Raises:

last_by(by=None)[source]#

The last_by method creates a new table containing the last row for each group.

Parameters:: by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None
Return type:: Table
Returns:: a new table
Raises:: DHError –

layout_hints(front=None, back=None, freeze=None, hide=None, column_groups=None)[source]#

Sets layout hints on the Table

Parameters:

front (Union[str, List[str]]) – the columns to show at the front.
back (Union[str, List[str]]) – the columns to show at the back.
freeze (Union[str, List[str]]) – the columns to freeze to the front. These will not be affected by horizontal scrolling.
hide (Union[str, List[str]]) – the columns to hide.
column_groups (List[Dict]) –
A list of dicts specifying which columns should be grouped in the UI The dicts can specify the following:

name (str): The group name children (List[str]): The color (Optional[str]): The hex color string or Deephaven color name

Return type:

Returns:

a new table with the layout hints set

Raises:

lazy_update(formulas)[source]#

The lazy_update method creates a new table containing a new, cached, formula column for each formula.

Parameters:: formulas (Union[str, Sequence[str]]) – the column formula(s)
Return type:: Table
Returns:: a new table
Raises:: DHError –

max_by(by=None)[source]#

The max_by method creates a new table containing the maximum value for each group.

Parameters:: by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None
Return type:: Table
Returns:: a new table
Raises:: DHError –

median_by(by=None)[source]#

The median_by method creates a new table containing the median for each group.

Parameters:: by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None
Return type:: Table
Returns:: a new table
Raises:: DHError –

property meta_table#: The column definitions of the table in a Table form.

min_by(by=None)[source]#

The min_by method creates a new table containing the minimum value for each group.

Parameters:: by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None
Return type:: Table
Returns:: a new table
Raises:: DHError –

move_columns(idx, cols)[source]#

The move_columns method creates a new table with specified columns moved to a specific column index value.

Parameters:

idx (int) – the column index where the specified columns will be moved in the new table.
cols (Union[str, Sequence[str]]) – the column name(s)

Return type:

Returns:

a new table

Raises:

move_columns_down(cols)[source]#

The move_columns_down method creates a new table with specified columns appearing last in order, to the far right.

Parameters:: cols (Union[str, Sequence[str]]) – the column name(s)
Return type:: Table
Returns:: a new table
Raises:: DHError –

move_columns_up(cols)[source]#

The move_columns_up method creates a new table with specified columns appearing first in order, to the far left.

Parameters:: cols (Union[str, Sequence[str]]) – the column name(s)
Return type:: Table
Returns:: a new table
Raises:: DHError –

natural_join(table, on, joins=None)[source]#

The natural_join method creates a new table containing all the rows and columns of this table, plus additional columns containing data from the right table. For columns appended to the left table (joins), row values equal the row values from the right table where the key values in the left and right tables are equal. If there is no matching key in the right table, appended row values are NULL.

Parameters:

table (Table) – the right-table of the join
on (Union[str, Sequence[str]]) – the column(s) to match, can be a common name or an equal expression, i.e. “col_a = col_b” for different column names
joins (Union[str, Sequence[str]], optional) – the column(s) to be added from the right table to the result table, can be renaming expressions, i.e. “new_col = col”; default is None

Return type:

Returns:

a new table

Raises:

partition_by(by, drop_keys=False)[source]#

Creates a PartitionedTable from this table, partitioned according to the specified key columns.

Parameters:

by (Union[str, Sequence[str]]) – the column(s) by which to group data
drop_keys (bool) – whether to drop key columns in the constituent tables, default is False

Return type:

Returns:

A PartitionedTable containing a sub-table for each group

Raises:

partitioned_agg_by(aggs, by=None, preserve_empty=False, initial_groups=None)[source]#

The partitioned_agg_by method is a convenience method that performs an agg_by operation on this table and wraps the result in a PartitionedTable. If the argument ‘aggs’ does not include a partition aggregation created by calling agg.partition(), one will be added automatically with the default constituent column name __CONSTITUENT__.

Parameters:

aggs (Union[Aggregation, Sequence[Aggregation]]) – the aggregation(s)
by (Union[str, Sequence[str]]) – the group-by column name(s), default is None
preserve_empty (bool) – whether to keep result rows for groups that are initially empty or become empty as a result of updates. Each aggregation operator defines its own value for empty groups. Default is False.
initial_groups (Table) – a table whose distinct combinations of values for the group-by column(s) should be used to create an initial set of aggregation groups. All other columns are ignored. This is useful in combination with preserve_empty=True to ensure that particular groups appear in the result table, or with preserve_empty=False to control the encounter order for a collection of groups and thus their relative order in the result. Changes to this table are not expected or handled; if this table is a refreshing table, only its contents at instantiation time will be used. Default is None, the result will be the same as if a table is provided but no rows were supplied. When it is provided, the ‘by’ argument must be provided to explicitly specify the grouping columns.

Return type:

Returns:

a PartitionedTable

Raises:

raj(table, on, joins=None, match_rule=AsOfMatchRule.GREATER_THAN_EQUAL)[source]#

The reverse-as-of join method creates a new table containing all of the rows and columns of the left table, plus additional columns containing data from the right table. For columns appended to the left table (joins), row values equal the row values from the right table where the keys from the left table most closely match the keys from the right table without going under. If there is no matching key in the right table, appended row values are NULL.

Parameters:

table (Table) – the right-table of the join
on (Union[str, Sequence[str]]) – the column(s) to match, can be a common name or an equal expression, i.e. “col_a = col_b” for different column names
joins (Union[str, Sequence[str]], optional) – the column(s) to be added from the right table to the result table, can be renaming expressions, i.e. “new_col = col”; default is None
match_rule (AsOfMatchRule) – the inexact matching rule on the last column to match specified in ‘on’, default is AsOfMatchRule.GREATER_THAN_EQUAL. The other valid value is AsOfMatchRule.GREATER_THAN.

Return type:

Returns:

a new table

Raises:

rename_columns(cols)[source]#

The rename_columns method creates a new table with the specified columns renamed.

Parameters:: cols (Union[str, Sequence[str]]) – the column rename expr(s) as “X = Y”
Return type:: Table
Returns:: a new table
Raises:: DHError –

restrict_sort_to(cols)[source]#

The restrict_sort_to method adjusts the input table to produce an output table that only allows sorting on specified table columns. This can be useful to prevent users from accidentally performing expensive sort operations as they interact with tables in the UI.

Parameters:: cols (Union[str, Sequence[str]]) – the column name(s)
Returns:: a new table
Raises:: DHError –

reverse()[source]#

The reverse method creates a new table with all of the rows from this table in reverse order.

Return type:: Table
Returns:: a new table
Raises:: DHError –

rollup(aggs, by=None, include_constituents=False)[source]#

Creates a rollup table.

A rollup table aggregates by the specified columns, and then creates a hierarchical table which re-aggregates using one less by column on each level. The column that is no longer part of the aggregation key is replaced with null on each level.

Note some aggregations can not be used in creating a rollup tables, these include: group, partition, median, pct, weighted_avg

Parameters:

aggs (Union[Aggregation, Sequence[Aggregation]]) – the aggregation(s)
by (Union[str, Sequence[str]]) – the group-by column name(s), default is None
include_constituents (bool) – whether to include the constituent rows at the leaf level, default is False

Return type:

RollupTable

Returns:

a new RollupTable

Raises:

select(formulas=None)[source]#

The select method creates a new in-memory table that includes one column for each formula. If no formula is specified, all columns will be included.

Parameters:: formulas (Union[str, Sequence[str]], optional) – the column formula(s), default is None
Return type:: Table
Returns:: a new table
Raises:: DHError –

select_distinct(formulas=None)[source]#

The select_distinct method creates a new table containing all of the unique values for a set of key columns. When the selectDistinct method is used on multiple columns, it looks for distinct sets of values in the selected columns.

Parameters:: formulas (Union[str, Sequence[str]], optional) – the column name(s), default is None
Return type:: Table
Returns:: a new table
Raises:: DHError –

property size#: The current number of rows in the table.

slice(start, stop)[source]#

Extracts a subset of a table by row positions into a new Table.

If both the start and the stop are positive, then both are counted from the beginning of the table. The start is inclusive, and the stop is exclusive. slice(0, N) is equivalent to head() (N) The start must be less than or equal to the stop.

If the start is positive and the stop is negative, then the start is counted from the beginning of the table, inclusively. The stop is counted from the end of the table. For example, slice(1, -1) includes all rows but the first and last. If the stop is before the start, the result is an empty table.

If the start is negative, and the stop is zero, then the start is counted from the end of the table, and the end of the slice is the size of the table. slice(-N, 0) is equivalent to tail() (N).

If the start is negative and the stop is negative, they are both counted from the end of the table. For example, slice(-2, -1) returns the second to last row of the table.

Parameters:

start (int) – the first row position to include in the result
stop (int) – the last row position to include in the result

Return type:

Returns:

a new Table

Raises:

snapshot()[source]#

Returns a static snapshot table.

Return type:: Table
Returns:: a new table
Raises:: DHError –

snapshot_when(trigger_table, stamp_cols=None, initial=False, incremental=False, history=False)[source]#

Returns a table that captures a snapshot of this table whenever trigger_table updates.

When trigger_table updates, a snapshot of this table and the “stamp key” from trigger_table form the resulting table. The “stamp key” is the last row of the trigger_table, limited by the stamp_cols. If trigger_table is empty, the “stamp key” will be represented by NULL values.

Parameters:

trigger_table (Table) – the trigger table
stamp_cols (Union[str, Sequence[str]) – The columns from trigger_table that form the “stamp key”, may be renames. None, or empty, means that all columns from trigger_table form the “stamp key”.
initial (bool) – Whether to take an initial snapshot upon construction, default is False. When False, the resulting table will remain empty until trigger_table first updates.
incremental (bool) – Whether the resulting table should be incremental, default is False. When False, all rows of this table will have the latest “stamp key”. When True, only the rows of this table that have been added or updated will have the latest “stamp key”.
history (bool) – Whether the resulting table should keep history, default is False. A history table appends a full snapshot of this table and the “stamp key” as opposed to updating existing rows. The history flag is currently incompatible with initial and incremental: when history is True, incremental and initial must be False.

Return type:

Returns:

a new table

Raises:

sort(order_by, order=None)[source]#

The sort method creates a new table where the rows are ordered based on values in a specified set of columns.

Parameters:

order_by (Union[str, Sequence[str]]) – the column(s) to be sorted on
order (Union[SortDirection, Sequence[SortDirection], optional) – the corresponding sort directions for each sort column, default is None, meaning ascending order for all the sort columns.

Return type:

Returns:

a new table

Raises:

sort_descending(order_by)[source]#

The sort_descending method creates a new table where rows in a table are sorted in a largest to smallest order based on the order_by column(s).

Parameters:: order_by (Union[str, Sequence[str]], optional) – the column name(s)
Return type:: Table
Returns:: a new table
Raises:: DHError –

std_by(by=None)[source]#

The std_by method creates a new table containing the standard deviation for each group.

Parameters:: by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None
Return type:: Table
Returns:: a new table
Raises:: DHError –

sum_by(by=None)[source]#

The sum_by method creates a new table containing the sum for each group.

Parameters:: by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None
Return type:: Table
Returns:: a new table
Raises:: DHError –

tail(num_rows)[source]#

The tail method creates a new table with a specific number of rows from the end of the table.

Parameters:: num_rows (int) – the number of rows at the end of table
Return type:: Table
Returns:: a new table
Raises:: DHError –

tail_by(num_rows, by=None)[source]#

The tail_by method creates a new table containing the last number of rows for each group.

Parameters:

num_rows (int) – the number of rows at the end of each group
by (Union[str, Sequence[str]]) – the group-by column name(s), default is None

Return type:

Returns:

a new table

Raises:

tail_pct(pct)[source]#

The tail_pct method creates a new table with a specific percentage of rows from the end of the table.

Parameters:: pct (float) – the percentage of rows to return as a value from 0 (0%) to 1 (100%).
Return type:: Table
Returns:: a new table
Raises:: DHError –

to_string(num_rows=10, cols=None)[source]#

Returns the first few rows of a table as a pipe-delimited string.

Parameters:

num_rows (int) – the number of rows at the beginning of the table
cols (Union[str, Sequence[str]]) – the column name(s), default is None

Return type:

str

Returns:

string

Raises:

tree(id_col, parent_col, promote_orphans=False)[source]#

Creates a hierarchical tree table.

The structure of the table is encoded by an “id” and a “parent” column. The id column should represent a unique identifier for a given row, and the parent column indicates which row is the parent for a given row. Rows that have a None parent are part of the “root” table.

It is possible for rows to be “orphaned” if their parent is non-None and does not exist in the table. These rows will not be present in the resulting tree. If this is not desirable, they could be promoted to become children of the root table by setting ‘promote_orphans’ argument to True.

Parameters:

id_col (str) – the name of a column containing a unique identifier for a particular row in the table
parent_col (str) – the name of a column containing the parent’s identifier, {@code null} for rows that are part of the root table
promote_orphans (bool) – whether to promote node tables whose parents don’t exist to be children of the root node, default is False

Return type:

TreeTable

Returns:

a new TreeTable organized according to the parent-child relationships expressed by id_col and parent_col

Raises:

ungroup(cols=None)[source]#

The ungroup method creates a new table in which array columns from the source table are unwrapped into separate rows.

Parameters:: cols (Union[str, Sequence[str]], optional) – the name(s) of the array column(s), if None, all array columns will be ungrouped, default is None
Return type:: Table
Returns:: a new table
Raises:: DHError –

update(formulas)[source]#

The update method creates a new table containing a new, in-memory column for each formula.

Parameters:: formulas (Union[str, Sequence[str]]) – the column formula(s)
Return type:: Table
Returns:: A new table
Raises:: DHError –

update_by(ops, by=None)[source]#

Creates a table with additional columns calculated from window-based aggregations of columns in this table. The aggregations are defined by the provided operations, which support incremental aggregations over the corresponding rows in the this table. The aggregations will apply position or time-based windowing and compute the results over the entire table or each row group as identified by the provided key columns.

Parameters:

ops (Union[UpdateByOperation, List[UpdateByOperation]]) – the update-by operation definition(s)
by (Union[str, List[str]]) – the key column name(s) to group the rows of the table

Return type:

Returns:

a new Table

Raises:

update_view(formulas)[source]#

The update_view method creates a new table containing a new, formula column for each formula.

Parameters:: formulas (Union[str, Sequence[str]]) – the column formula(s)
Return type:: Table
Returns:: a new table
Raises:: DHError –

var_by(by=None)[source]#

The var_by method creates a new table containing the variance for each group.

Parameters:: by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None
Return type:: Table
Returns:: a new table
Raises:: DHError –

view(formulas)[source]#

The view method creates a new formula table that includes one column for each formula.

Parameters:: formulas (Union[str, Sequence[str]]) – the column formula(s)
Return type:: Table
Returns:: a new table
Raises:: DHError –

weighted_avg_by(wcol, by=None)[source]#

The weighted_avg_by method creates a new table containing the weighted average for each group.

Parameters:

wcol (str) – the name of the weight column
by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None

Return type:

Returns:

a new table

Raises:

weighted_sum_by(wcol, by=None)[source]#

The weighted_sum_by method creates a new table containing the weighted sum for each group.

Parameters:

wcol (str) – the name of the weight column
by (Union[str, Sequence[str]], optional) – the group-by column name(s), default is None

Return type:

Returns:

a new table

Raises:

where(filters=None)[source]#

The where method creates a new table with only the rows meeting the filter criteria in the column(s) of the table.

Parameters:: filters (Union[str, Filter, Sequence[str], Sequence[Filter]], optional) – the filter condition expression(s) or Filter object(s), default is None
Return type:: Table
Returns:: a new table
Raises:: DHError –

where_in(filter_table, cols)[source]#

The where_in method creates a new table containing rows from the source table, where the rows match values in the filter table. The filter is updated whenever either table changes.

Parameters:

filter_table (Table) – the table containing the set of values to filter on
cols (Union[str, Sequence[str]]) – the column name(s)

Return type:

Returns:

a new table

Raises:

where_not_in(filter_table, cols)[source]#

The where_not_in method creates a new table containing rows from the source table, where the rows do not match values in the filter table.

Parameters:

filter_table (Table) – the table containing the set of values to filter on
cols (Union[str, Sequence[str]]) – the column name(s)

Return type:

Returns:

a new table

Raises: