bokeh.models.widgets.tables¶

Various kinds of data table (data grid) widgets.

class BooleanFormatter(**kwargs)[source]¶

Bases: bokeh.models.widgets.tables.CellFormatter

Boolean (check mark) cell formatter.

icon¶

property type: Enum ( Enumeration(check, check-circle, check-circle-o, check-square, check-square-o) )

The icon visualizing the check mark.

{
  "icon": "check",
  "id": "f3a8fcc2-44e1-4dbb-815c-3c5b2d3d91b8",
  "js_event_callbacks": {},
  "js_property_callbacks": {},
  "name": null,
  "subscribed_events": [],
  "tags": []
}

class CellEditor(**kwargs)[source]¶

Bases: bokeh.model.Model

Abstract base class for data table’s cell editors.

Note

This is an abstract base class used to help organize the hierarchy of Bokeh model types. It is not useful to instantiate on its own.

JSON Prototype

{
  "id": "95e52823-c344-49c2-8380-524ace1085aa",
  "js_event_callbacks": {},
  "js_property_callbacks": {},
  "name": null,
  "subscribed_events": [],
  "tags": []
}

class CellFormatter(**kwargs)[source]¶

Bases: bokeh.model.Model

Abstract base class for data table’s cell formatters.

Note

This is an abstract base class used to help organize the hierarchy of Bokeh model types. It is not useful to instantiate on its own.

JSON Prototype

{
  "id": "742e4efe-b50b-43e7-889f-dca3a791253a",
  "js_event_callbacks": {},
  "js_property_callbacks": {},
  "name": null,
  "subscribed_events": [],
  "tags": []
}

class CheckboxEditor(**kwargs)[source]¶

Bases: bokeh.models.widgets.tables.CellEditor

Boolean value cell editor.

JSON Prototype

{
  "id": "fa5589f6-9c30-47dc-a445-19e08e9f0b7f",
  "js_event_callbacks": {},
  "js_property_callbacks": {},
  "name": null,
  "subscribed_events": [],
  "tags": []
}

class DataTable(**kwargs)[source]¶

Bases: bokeh.models.widgets.tables.TableWidget

Two dimensional grid for visualisation and editing large amounts of data.

columns¶

property type: List ( Instance ( TableColumn ) )

The list of child column widgets.

editable¶

property type: Bool

Allows to edit table’s contents. Needs cell editors to be configured on columns that are required to be editable.

fit_columns¶

property type: Bool

Whether columns should be fit to the available width. This results in no horizontal scrollbar showing up, but data can get unreadable if there is no enough space available. If set to True, columns’ width is understood as maximum width.

reorderable¶

property type: Bool

Allows the reordering of a tables’s columns. To reorder a column, click and drag a table’s header to the desired location in the table. The columns on either side will remain in their previous order.

row_headers¶

property type: Bool

Enable or disable row headers, i.e. the index column.

scroll_to_selection¶

property type: Bool

Whenever a selection is made on the data source, scroll the selected rows into the table’s viewport if none of the selected rows are already in the viewport.

selectable¶

property type: Either ( Bool , Enum ( Enumeration(checkbox) ) )

Whether a table’s rows can be selected or not. Using checkbox is equivalent to True, but makes selection visible through a checkbox for each row, instead of highlighting rows. Multiple selection is allowed and can be achieved by either clicking multiple checkboxes (if enabled) or using Shift + click on rows.

sortable¶

property type: Bool

Allows to sort table’s contents. By default natural order is preserved. To sort a column, click on it’s header. Clicking one more time changes sort direction. Use Ctrl + click to return to natural order. Use Shift + click to sort multiple columns simultaneously.

JSON Prototype

{
  "columns": [],
  "css_classes": null,
  "disabled": false,
  "editable": false,
  "fit_columns": true,
  "height": 400,
  "id": "fb3c9986-0bfa-4584-ad11-ea73b9b6dbb9",
  "js_event_callbacks": {},
  "js_property_callbacks": {},
  "name": null,
  "reorderable": true,
  "row_headers": true,
  "scroll_to_selection": true,
  "selectable": true,
  "sizing_mode": "fixed",
  "sortable": true,
  "source": null,
  "subscribed_events": [],
  "tags": [],
  "width": null
}

class DateEditor(**kwargs)[source]¶

Bases: bokeh.models.widgets.tables.CellEditor

Calendar-based date cell editor.

JSON Prototype

{
  "id": "5d1dd97d-523d-437b-81d2-e478d7f05444",
  "js_event_callbacks": {},
  "js_property_callbacks": {},
  "name": null,
  "subscribed_events": [],
  "tags": []
}

class DateFormatter(**kwargs)[source]¶

Bases: bokeh.models.widgets.tables.CellFormatter

Date cell formatter.

format¶

property type: Either ( Enum ( DateFormat ), String )

The date format can be combinations of the following:

d: day of month (no leading zero)
dd: day of month (two digit)
o: day of year (no leading zeros)
oo: day of year (three digit)
D: day name short
DD: day name long
m: month of year (no leading zero)
mm: month of year (two digit)
M: month name short
MM: month name long
y: year (two digit)
yy: year (four digit)

@: Unix timestamp (ms since 01/01/1970)

!: Windows ticks (100ns since 01/01/0001)
”...”: literal text

‘’: single quote

JSON Prototype

{
  "format": "yy M d",
  "id": "75fb462f-a1a9-4631-8d55-c4bb2571a6bb",
  "js_event_callbacks": {},
  "js_property_callbacks": {},
  "name": null,
  "subscribed_events": [],
  "tags": []
}

class HTMLTemplateFormatter(**kwargs)[source]¶

Bases: bokeh.models.widgets.tables.CellFormatter

HTML formatter using a template. This uses Underscore’s template method and syntax. http://underscorejs.org/#template The formatter has access other items in the row via the dataContext object passed to the formatter. So, for example, if another column in the datasource was named url, the template could access it as:

<a href=”<%= url %>”><%= value %></a>

To use a different set of template delimiters, pass the appropriate values for evaluate, interpolate’, or `escape. See the Underscore template documentation for more information. http://underscorejs.org/#template

Example: Simple HTML template to format the column value as code.

HTMLTemplateFormatter(template=’<code><%= value %></code>’)

Example: Use values from other columns (manufacturer and model) to build a hyperlink.

HTMLTemplateFormatter(template=’<a href=”https:/www.google.com/search?q=<%= manufacturer %>+<%= model %>” target=”_blank”><%= value %></a>’)

template¶

property type: String

Template string to be used by Underscore’s template method.

JSON Prototype

{
  "id": "75c03002-8327-4e01-b6b7-369ea8c20155",
  "js_event_callbacks": {},
  "js_property_callbacks": {},
  "name": null,
  "subscribed_events": [],
  "tags": [],
  "template": "<%= value %>"
}

class IntEditor(**kwargs)[source]¶

Bases: bokeh.models.widgets.tables.CellEditor

Spinner-based integer cell editor.

step¶

property type: Int

The major step value.

JSON Prototype

{
  "id": "4b1ad720-e2c1-4289-907b-4b8416280510",
  "js_event_callbacks": {},
  "js_property_callbacks": {},
  "name": null,
  "step": 1,
  "subscribed_events": [],
  "tags": []
}

class NumberEditor(**kwargs)[source]¶

Bases: bokeh.models.widgets.tables.CellEditor

Spinner-based number cell editor.

step¶

property type: Float

The major step value.

JSON Prototype

{
  "id": "927df91d-6af4-4c2c-8f69-229c8b1b71ba",
  "js_event_callbacks": {},
  "js_property_callbacks": {},
  "name": null,
  "step": 0.01,
  "subscribed_events": [],
  "tags": []
}

class NumberFormatter(**kwargs)[source]¶

Bases: bokeh.models.widgets.tables.StringFormatter

Number cell formatter.

format¶

property type: String

The number format, as defined in the following tables:

NUMBERS:

Number	Format	String
10000	‘0,0.0000’	10,000.0000
10000.23	‘0,0’	10,000
10000.23	‘+0,0’	+10,000
-10000	‘0,0.0’	-10,000.0
10000.1234	‘0.000’	10000.123
10000.1234	‘0[.]00000’	10000.12340
-10000	‘(0,0.0000)’	(10,000.0000)
-0.23	‘.00’	-.23
-0.23	‘(.00)’	(.23)
0.23	‘0.00000’	0.23000
0.23	‘0.0[0000]’	0.23
1230974	‘0.0a’	1.2m
1460	‘0 a’	1 k
-104000	‘0a’	-104k
1	‘0o’	1st
52	‘0o’	52nd
23	‘0o’	23rd
100	‘0o’	100th

CURRENCY:

Number	Format	String
1000.234	‘$0,0.00’	$1,000.23
1000.2	‘0,0[.]00 $’	1,000.20 $
1001	‘$ 0,0[.]00’	$ 1,001
-1000.234	‘($0,0)’	($1,000)
-1000.234	‘$0.00’	-$1000.23
1230974	‘($ 0.00 a)’	$ 1.23 m

BYTES:

Number	Format	String
100	‘0b’	100B
2048	‘0 b’	2 KB
7884486213	‘0.0b’	7.3GB
3467479682787	‘0.000 b’	3.154 TB

PERCENTAGES:

Number	Format	String
1	‘0%’	100%
0.974878234	‘0.000%’	97.488%
-0.43	‘0 %’	-43 %
0.43	‘(0.000 %)’	43.000 %

TIME:

Number	Format	String
25	‘00:00:00’	0:00:25
238	‘00:00:00’	0:03:58
63846	‘00:00:00’	17:44:06

For the complete specification, see http://numbrojs.com/format.html

language¶

property type: Enum ( NumeralLanguage )

The language to use for formatting language-specific features (e.g. thousands separator).

rounding¶

property type: Enum ( RoundingFunction )

Rounding functions (round, floor, ceil) and their synonyms (nearest, rounddown, roundup).

JSON Prototype

{
  "font_style": "normal",
  "format": "0,0",
  "id": "84c27f24-ff83-4dc6-90b2-559ffcd67fa2",
  "js_event_callbacks": {},
  "js_property_callbacks": {},
  "language": "en",
  "name": null,
  "rounding": "round",
  "subscribed_events": [],
  "tags": [],
  "text_align": "left",
  "text_color": null
}

class PercentEditor(**kwargs)[source]¶

Bases: bokeh.models.widgets.tables.CellEditor

IntEditor optimized for editing percentages.

JSON Prototype

{
  "id": "c8c266ab-a11e-441b-98d5-ec226b853796",
  "js_event_callbacks": {},
  "js_property_callbacks": {},
  "name": null,
  "subscribed_events": [],
  "tags": []
}

class SelectEditor(**kwargs)[source]¶

Bases: bokeh.models.widgets.tables.CellEditor

Select cell editor.

options¶

property type: List ( String )

The list of options to select from.

JSON Prototype

{
  "id": "bc531326-1816-435f-b465-a4ed1a00258a",
  "js_event_callbacks": {},
  "js_property_callbacks": {},
  "name": null,
  "options": [],
  "subscribed_events": [],
  "tags": []
}

class StringEditor(**kwargs)[source]¶

Bases: bokeh.models.widgets.tables.CellEditor

Basic string cell editor with auto-completion.

completions¶

property type: List ( String )

An optional list of completion strings.

JSON Prototype

{
  "completions": [],
  "id": "545ff312-1fd2-4a67-815a-2e62d41d421a",
  "js_event_callbacks": {},
  "js_property_callbacks": {},
  "name": null,
  "subscribed_events": [],
  "tags": []
}

class StringFormatter(**kwargs)[source]¶

Bases: bokeh.models.widgets.tables.CellFormatter

Basic string cell formatter.

font_style¶

property type: Enum ( FontStyle )

An optional text font style, e.g. bold, italic.

text_align¶

property type: Enum ( TextAlign )

An optional text align, i.e. left, center or right.

text_color¶

property type: Color

An optional text color. See bokeh.core.properties.Color for details.

JSON Prototype

{
  "font_style": "normal",
  "id": "ef4e237a-42ba-4cb0-812d-93467eae91b6",
  "js_event_callbacks": {},
  "js_property_callbacks": {},
  "name": null,
  "subscribed_events": [],
  "tags": [],
  "text_align": "left",
  "text_color": null
}

class TableColumn(**kwargs)[source]¶

Bases: bokeh.model.Model

Table column widget.

default_sort¶

property type: Enum ( Enumeration(ascending, descending) )

The default sorting order. By default ascending order is used.

editor¶

property type: Instance ( CellEditor )

The cell editor for this column. By default, a simple string editor is used.

field¶

property type: String

The name of the field mapping to a column in the data source.

formatter¶

property type: Instance ( CellFormatter )

The cell formatter for this column. By default, a simple string formatter is used.

sortable¶

property type: Bool

Whether this column is sortable or not. Note that data table has to have sorting enabled to allow sorting in general.

title¶

property type: String

The title of this column. If not set, column’s data field is used instead.

width¶

property type: Int

The width or maximum width (depending on data table’s configuration) in pixels of this column.

JSON Prototype

{
  "default_sort": "ascending",
  "editor": {
    "id": "9bb9e76a-5dc0-4427-b5c3-d45536bd86d7",
    "type": "StringEditor"
  },
  "field": null,
  "formatter": {
    "id": "6e1626f4-e43d-4410-99ae-a9cda617af0a",
    "type": "StringFormatter"
  },
  "id": "6fb58cf2-cc39-4385-bffe-4cef1e8a1799",
  "js_event_callbacks": {},
  "js_property_callbacks": {},
  "name": null,
  "sortable": true,
  "subscribed_events": [],
  "tags": [],
  "title": null,
  "width": 300
}

class TableWidget(**kwargs)[source]¶

Bases: bokeh.models.widgets.widget.Widget

Abstract base class for data table (data grid) widgets.

Note

This is an abstract base class used to help organize the hierarchy of Bokeh model types. It is not useful to instantiate on its own.

source¶

property type: Instance ( DataSource )

The source of data for the widget.

JSON Prototype

{
  "css_classes": null,
  "disabled": false,
  "height": null,
  "id": "990624aa-7421-4b24-83db-9062a6672f9d",
  "js_event_callbacks": {},
  "js_property_callbacks": {},
  "name": null,
  "sizing_mode": "fixed",
  "source": null,
  "subscribed_events": [],
  "tags": [],
  "width": null
}

class TextEditor(**kwargs)[source]¶

Bases: bokeh.models.widgets.tables.CellEditor

Multi-line string cell editor.

JSON Prototype

{
  "id": "1c8f9381-5f4c-47f2-a8c7-81dabbfc470d",
  "js_event_callbacks": {},
  "js_property_callbacks": {},
  "name": null,
  "subscribed_events": [],
  "tags": []
}

class TimeEditor(**kwargs)[source]¶

Bases: bokeh.models.widgets.tables.CellEditor

Spinner-based time cell editor.

JSON Prototype

{
  "id": "89527b44-f9ec-4a52-970d-4d2c9b0bf994",
  "js_event_callbacks": {},
  "js_property_callbacks": {},
  "name": null,
  "subscribed_events": [],
  "tags": []
}