Skip to main content
Version: Python

SelectableDataSet

A SelectableDataSet provides a view of a selectable subset of a table. For example, in some selectable data sets, a GUI click can be used to select a portion of a table.

SelectableDataSet objects are useful for creating plots and figures with Deephaven methods that dynamically update when filters are applied. Dynamic plots can be created with either the one_click or one_click_partitioned_table methods.

one_click

In this example, we create a new table with read_csv, and then convert that table into a SelectableDataSet with one_click.

from deephaven import read_csv
from deephaven.plot.selectable_dataset import one_click
from deephaven.plot import Figure

source = read_csv(
"https://media.githubusercontent.com/media/deephaven/examples/main/CryptoCurrencyHistory/CSV/CryptoTrades_20210922.csv"
)
result = one_click(t=source, by=["Instrument"], require_all_filters=True)
f = Figure()
plot = f.plot_xy(series_name="Plot", t=result, x="Timestamp", y="Price").show()

img

one_click_partitioned_table

In this example, we take the table from the previous example, partition it with partition_by, and then convert it to a SelectableDataSet using one_click_partitioned_table.

from deephaven import read_csv
from deephaven.plot.selectable_dataset import one_click_partitioned_table
from deephaven.plot import Figure

source = read_csv(
"https://media.githubusercontent.com/media/deephaven/examples/main/CryptoCurrencyHistory/CSV/CryptoTrades_20210922.csv"
)
partitioned_source = source.partition_by("Exchange")

result = one_click_partitioned_table(pt=partitioned_source, require_all_filters=True)
f = Figure()
plot = f.plot_xy(series_name="Plot", t=result, x="Timestamp", y="Price").show()

img

Methods that use SelectableDataSet

The following methods take a SelectableDataSet as an input: