☰Read-only archive⌕
Looking for help with Bokeh?

This is a read-only archive. Ask questions and join the conversation on GitHub.

Visit Community Support on GitHub →
Archived discussions · Captured October 28, 2026

Dates in DataTable in bokeh

Community Support
Tom
TomDec 17, 2014   #1

I just started playing with the DataTable in bokeh. Very cool!

One thing I found that didn’t work or I didn’t know how to do was trying to display dates. A simple example is below. I looked for a DateFormatter but didn’t see one in widgets although I saw various other Date related classes.

from bokeh import plotting

from bokeh import models

from bokeh.models import widgets

import pandas, datetime

plotting.output_notebook()

df = pandas.DataFrame(dict(Date = [datetime.date(2014, 1,1), datetime.date(2014, 1,2), datetime.date(2014, 1,3)], Value = [1,2,3]))

source = models.ColumnDataSource(df)

columns = [

widgets.TableColumn(field=c, title=c) for c in df.columns

]

data_table = widgets.DataTable(source=source, columns=columns, editable=True, width = 500)

plotting.show(data_table)

If anyone knows how to do this please let me know. If the functionality doesn’t exist and it requires python work and someone can point me to where to get started i’d be happy to give it a try. I’m pretty weak on javascript so if that’s needed I might bow out.

–Tom

⌁   Link to post
Mateusz_Paprocki
Mateusz_PaprockiDec 18, 2014   #2

Hi,

···

On Wed, Dec 17, 2014 at 2:00 AM, Tom tom.denniston@gmail.com wrote:

I just started playing with the DataTable in bokeh. Very cool!

One thing I found that didn’t work or I didn’t know how to do was trying to display dates. A simple example is below. I looked for a DateFormatter but didn’t see one in widgets although I saw various other Date related classes.

from bokeh import plotting

from bokeh import models

from bokeh.models import widgets

import pandas, datetime

plotting.output_notebook()

df = pandas.DataFrame(dict(Date = [datetime.date(2014, 1,1), datetime.date(2014, 1,2), datetime.date(2014, 1,3)], Value = [1,2,3]))

source = models.ColumnDataSource(df)

columns = [

widgets.TableColumn(field=c, title=c) for c in df.columns

]

data_table = widgets.DataTable(source=source, columns=columns, editable=True, width = 500)

plotting.show(data_table)

If anyone knows how to do this please let me know. If the functionality doesn’t exist and it requires python work and someone can point me to where to get started i’d be happy to give it a try. I’m pretty weak on javascript so if that’s needed I might bow out.

This is an unfortunate omission, but there is current no support for dates/times/datetimes in DataTable. This will be implemented in bokeh 0.7.1.

Mateusz

–Tom

–

You received this message because you are subscribed to the Google Groups “Bokeh Discussion - Public” group.

To unsubscribe from this group and stop receiving emails from it, send an email to bokeh+unsubscribe@continuum.io.

To post to this group, send email to bokeh@continuum.io.

To view this discussion on the web visit https://groups.google.com/a/continuum.io/d/msgid/bokeh/527723c8-f59a-4a10-a891-440db7f24e75%40continuum.io.

For more options, visit https://groups.google.com/a/continuum.io/d/optout.

⌁   Link to post
Tom_Denniston
Tom_DennistonDec 22, 2014   #3

Thanks Mateusz!

···

On Thu, Dec 18, 2014 at 10:35 AM, Mateusz Paprocki mateusz.paprocki@continuum.io wrote:

Hi,

–

You received this message because you are subscribed to the Google Groups “Bokeh Discussion - Public” group.

To unsubscribe from this group and stop receiving emails from it, send an email to bokeh+unsubscribe@continuum.io.

To post to this group, send email to bokeh@continuum.io.

To view this discussion on the web visit https://groups.google.com/a/continuum.io/d/msgid/bokeh/CANFzp8go5EHwfKYjUi5QHSTCh3eQAOiEfigDrQ43GwLr%2BATY1Q%40mail.gmail.com.

For more options, visit https://groups.google.com/a/continuum.io/d/optout.

On Wed, Dec 17, 2014 at 2:00 AM, Tom tom.denniston@gmail.com wrote:

I just started playing with the DataTable in bokeh. Very cool!

One thing I found that didn’t work or I didn’t know how to do was trying to display dates. A simple example is below. I looked for a DateFormatter but didn’t see one in widgets although I saw various other Date related classes.

from bokeh import plotting

from bokeh import models

from bokeh.models import widgets

import pandas, datetime

plotting.output_notebook()

df = pandas.DataFrame(dict(Date = [datetime.date(2014, 1,1), datetime.date(2014, 1,2), datetime.date(2014, 1,3)], Value = [1,2,3]))

source = models.ColumnDataSource(df)

columns = [

widgets.TableColumn(field=c, title=c) for c in df.columns

]

data_table = widgets.DataTable(source=source, columns=columns, editable=True, width = 500)

plotting.show(data_table)

If anyone knows how to do this please let me know. If the functionality doesn’t exist and it requires python work and someone can point me to where to get started i’d be happy to give it a try. I’m pretty weak on javascript so if that’s needed I might bow out.

This is an unfortunate omission, but there is current no support for dates/times/datetimes in DataTable. This will be implemented in bokeh 0.7.1.

Mateusz

–Tom

–

You received this message because you are subscribed to the Google Groups “Bokeh Discussion - Public” group.

To unsubscribe from this group and stop receiving emails from it, send an email to bokeh+unsubscribe@continuum.io.

To post to this group, send email to bokeh@continuum.io.

To view this discussion on the web visit https://groups.google.com/a/continuum.io/d/msgid/bokeh/527723c8-f59a-4a10-a891-440db7f24e75%40continuum.io.

For more options, visit https://groups.google.com/a/continuum.io/d/optout.

⌁   Link to post
Tom
TomJan 12, 2015   #4

Hello all,

Just wanted to say that I updated to the latest dev build (from Jan 9) and noticed that model.DateFormatter now exists and works quite nicely. It takes a string of the form “m/d/yy” for instance which is quite easy to use. If you added it Mateusz, thank you! Or thank you to whomever did.

I’m re-posting the working example with the DateFormatter so anyone who finds this on Google will have the answer easily available.

from bokeh import plotting
from bokeh import models
from bokeh.models import widgets
import pandas, datetime, numpy
import bokeh
print(bokeh.version)

plotting.output_notebook()
df = pandas.DataFrame(dict(Date = [datetime.date(2014, 1,1), datetime.date(2014, 1,2), datetime.date(2014, 1,3)], Value = [1,2,3]))
df[‘Date’] = pandas.to_datetime(df[‘Date’]) # annoyingly the way I built the data frame, pandas makes the “Date” column an object

source = models.ColumnDataSource(df)

columns = [
widgets.TableColumn(field=c, title=c, formatter=models.DateFormatter(format=‘m/d/yy’) if numpy.issubdtype(df[c].dtype, numpy.datetime64) else None) for c in df.columns
]
data_table = widgets.DataTable(source=source, columns=columns, editable=True, width = 500)
plotting.show(data_table)

``

–Tom

···

On Sunday, December 21, 2014 at 9:48:18 PM UTC-5, Tom Denniston wrote:

Thanks Mateusz!

On Thu, Dec 18, 2014 at 10:35 AM, Mateusz Paprocki mateusz....@continuum.io wrote:

Hi,

On Wed, Dec 17, 2014 at 2:00 AM, Tom tom.de...@gmail.com wrote:

I just started playing with the DataTable in bokeh. Very cool!

One thing I found that didn’t work or I didn’t know how to do was trying to display dates. A simple example is below. I looked for a DateFormatter but didn’t see one in widgets although I saw various other Date related classes.

from bokeh import plotting

from bokeh import models

from bokeh.models import widgets

import pandas, datetime

plotting.output_notebook()

df = pandas.DataFrame(dict(Date = [datetime.date(2014, 1,1), datetime.date(2014, 1,2), datetime.date(2014, 1,3)], Value = [1,2,3]))

source = models.ColumnDataSource(df)

columns = [

widgets.TableColumn(field=c, title=c) for c in df.columns

]

data_table = widgets.DataTable(source=source, columns=columns, editable=True, width = 500)

plotting.show(data_table)

If anyone knows how to do this please let me know. If the functionality doesn’t exist and it requires python work and someone can point me to where to get started i’d be happy to give it a try. I’m pretty weak on javascript so if that’s needed I might bow out.

This is an unfortunate omission, but there is current no support for dates/times/datetimes in DataTable. This will be implemented in bokeh 0.7.1.

Mateusz

–Tom

–

You received this message because you are subscribed to the Google Groups “Bokeh Discussion - Public” group.

To unsubscribe from this group and stop receiving emails from it, send an email to bokeh+un...@continuum.io.

To post to this group, send email to bo...@continuum.io.

To view this discussion on the web visit https://groups.google.com/a/continuum.io/d/msgid/bokeh/527723c8-f59a-4a10-a891-440db7f24e75%40continuum.io.

For more options, visit https://groups.google.com/a/continuum.io/d/optout.

–

You received this message because you are subscribed to the Google Groups “Bokeh Discussion - Public” group.

To unsubscribe from this group and stop receiving emails from it, send an email to bokeh+un...@continuum.io.

To post to this group, send email to bo...@continuum.io.

To view this discussion on the web visit https://groups.google.com/a/continuum.io/d/msgid/bokeh/CANFzp8go5EHwfKYjUi5QHSTCh3eQAOiEfigDrQ43GwLr%2BATY1Q%40mail.gmail.com.

For more options, visit https://groups.google.com/a/continuum.io/d/optout.

⌁   Link to post

End of archived discussion · Replies are disabled