`bokeh.models.widgets.tables`¶

Boolean (check mark) cell formatter.

icon¶

property type: icon:Enum(‘check’, ‘check-circle’, ‘check-circle-o’, ‘check-square’, ‘check-square-o’)

The icon visualizing the check mark.

{
  "icon": "check",
  "id": "559fbb45-d875-4d5e-9009-09c8cfb60594",
  "name": null,
  "tags": []
}

class CellEditor(**kwargs)¶

Bases: bokeh.model.Model

Abstract base class for data table’s cell editors.

{
  "id": "ac3ee4ac-6995-4838-86df-103c5ed01f35",
  "name": null,
  "tags": []
}

class CellFormatter(**kwargs)¶

Bases: bokeh.model.Model

Abstract base class for data table’s cell formatters.

{
  "id": "978ade53-01be-4bd6-a825-adaacabf35e7",
  "name": null,
  "tags": []
}

class CheckboxEditor(**kwargs)¶

Boolean value cell editor.

{
  "id": "8da71a2c-56b3-42be-9267-07f5da29b3e1",
  "name": null,
  "tags": []
}

class DataTable(**kwargs)¶

Bases: bokeh.models.widgets.tables.TableWidget

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

columns¶

property type: columns:List(Instance(TableColumn))

The list of child column widgets.

editable¶

property type: editable: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: fit_columns: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.

height¶

property type: height:Either(Int, Auto)

Height in pixels of the table widget. Use Auto to make the widget adjust its height automatically. Note that Auto is inefficient for large amounts of data, so should be used with care.

row_headers¶

property type: row_headers:Bool

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

scroll_to_selection¶

property type: scroll_to_selection: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: selectable:Either(Bool, Enum(‘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: sortable: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.

width¶

property type: width:Int

Optional width in pixels of the table widget. By default, uses all horizontal space available.

{
  "columns": [],
  "disabled": false,
  "editable": false,
  "fit_columns": true,
  "height": 400,
  "id": "4487c8e5-ae54-40c3-939b-eaab40f6a222",
  "name": null,
  "row_headers": true,
  "scroll_to_selection": true,
  "selectable": true,
  "sortable": true,
  "source": null,
  "tags": [],
  "width": null
}

class DateEditor(**kwargs)¶

Calendar-based date cell editor.

{
  "id": "0b164101-b144-4e40-be2b-d9a8b00d0695",
  "name": null,
  "tags": []
}

class DateFormatter(**kwargs)¶

Date cell formatter.

format¶

property type: format:Either(Enum(‘ATOM’, ‘W3C’, ‘RFC-3339’, ‘ISO-8601’, ‘COOKIE’, ‘RFC-822’, ‘RFC-850’, ‘RFC-1036’, ‘RFC-1123’, ‘RFC-2822’, ‘RSS’, ‘TICKS’, ‘TIMESTAMP’), 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

{
  "format": "yy M d",
  "id": "87d9efe4-0731-4d9a-82d8-3c51842354b9",
  "name": null,
  "tags": []
}

class HTMLTemplateFormatter(**kwargs)¶

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: template:String

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

{
  "id": "8dd20444-9b4f-4e18-b337-d076e5b49905",
  "name": null,
  "tags": [],
  "template": "<%= value %>"
}

class IntEditor(**kwargs)¶

Spinner-based integer cell editor.

step¶

property type: step:Int

The major step value.

{
  "id": "c564eca3-23e5-4965-9b19-b76f4ebd0e01",
  "name": null,
  "step": 1,
  "tags": []
}

class NumberEditor(**kwargs)¶

Spinner-based number cell editor.

step¶

property type: step:Float

The major step value.

{
  "id": "5b118445-58c2-41c0-8c0e-3e85b3ded6b8",
  "name": null,
  "step": 0.01,
  "tags": []
}

class NumberFormatter(**kwargs)¶

Bases: bokeh.models.widgets.tables.StringFormatter

Number cell formatter.

format¶

property type: format: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

language¶

property type: language:Enum(‘be-nl’, ‘chs’, ‘cs’, ‘da-dk’, ‘de-ch’, ‘de’, ‘en’, ‘en-gb’, ‘es-ES’, ‘es’, ‘et’, ‘fi’, ‘fr-CA’, ‘fr-ch’, ‘fr’, ‘hu’, ‘it’, ‘ja’, ‘nl-nl’, ‘pl’, ‘pt-br’, ‘pt-pt’, ‘ru’, ‘ru-UA’, ‘sk’, ‘th’, ‘tr’, ‘uk-UA’)

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

rounding¶

property type: rounding:Enum(‘round’, ‘nearest’, ‘floor’, ‘rounddown’, ‘ceil’, ‘roundup’)

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

{
  "font_style": "normal",
  "format": "0,0",
  "id": "ff18645f-79a0-458e-bc5a-1bef26d4229b",
  "language": "en",
  "name": null,
  "rounding": "round",
  "tags": [],
  "text_align": "left",
  "text_color": null
}

class PercentEditor(**kwargs)¶

IntEditor optimized for editing percentages.

{
  "id": "155339d9-b2a2-45aa-a514-ff0bd805a793",
  "name": null,
  "tags": []
}

class SelectEditor(**kwargs)¶

Select cell editor.

options¶

property type: options:List(String)

The list of options to select from.

{
  "id": "e2ce1179-7eba-464b-b23b-4b2b5b7a02cb",
  "name": null,
  "options": [],
  "tags": []
}

class StringEditor(**kwargs)¶

Basic string cell editor with auto-completion.

completions¶

property type: completions:List(String)

An optional list of completion strings.

{
  "completions": [],
  "id": "497ba546-37e4-44bd-b28e-e5bfea50aaf2",
  "name": null,
  "tags": []
}

class StringFormatter(**kwargs)¶

Basic string cell formatter.

font_style¶

property type: font_style:Enum(‘normal’, ‘italic’, ‘bold’)

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

text_align¶

property type: text_align:Enum(‘left’, ‘right’, ‘center’)

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

text_color¶

property type: text_color:Color

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

{
  "font_style": "normal",
  "id": "ee8e0397-9db2-481d-83f9-251b98ccc4d7",
  "name": null,
  "tags": [],
  "text_align": "left",
  "text_color": null
}

class TableColumn(**kwargs)¶

Bases: bokeh.model.Model

Table column widget.

default_sort¶

property type: default_sort:Enum(‘ascending’, ‘descending’)

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

editor¶

property type: editor:Instance(CellEditor)

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

field¶

property type: field:String

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

formatter¶

property type: formatter:Instance(CellFormatter)

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

sortable¶

property type: sortable: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: title:String

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

width¶

property type: width:Int

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

{
  "default_sort": "ascending",
  "editor": {
    "id": "6aea2fcc-2dee-4bb5-bbce-81a55e31dc07",
    "type": "StringEditor"
  },
  "field": null,
  "formatter": {
    "id": "a2cc88d5-22ce-45dd-8d1a-f293d4e08e47",
    "type": "StringFormatter"
  },
  "id": "6ea5ba15-df2a-4eba-abcb-106d0f303719",
  "name": null,
  "sortable": true,
  "tags": [],
  "title": null,
  "width": 300
}

class TableWidget(**kwargs)¶

Bases: bokeh.models.widgets.widget.Widget

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

source¶

property type: source:Instance(DataSource)

The source of data for the widget.

{
  "disabled": false,
  "id": "33a9496c-1808-4759-9560-4bb3f0dc6cac",
  "name": null,
  "source": null,
  "tags": []
}

class TextEditor(**kwargs)¶

Multi-line string cell editor.

{
  "id": "21a76156-cae3-48bf-af92-b8c985c91a4f",
  "name": null,
  "tags": []
}

class TimeEditor(**kwargs)¶

Spinner-based time cell editor.