Skip to main content

Python API for Google Visualization

Project description


Gviz Data Table is a simple Python library for converting Python data types
to the Google Visualization Data Table JSON format.

The Google Visualization Library itself is a Javascript library that provides
interactive charts that work in pretty much any browser. The libraries cover
most use cases including tables as well as charts, so you can have a chart
and a table of the same data.

Gviz Data Table is designed primarily for use with data sources such as
databases. Usage is supposed to be minimal: you provide a schema, that is a
list of columns, and the rows of data. A column must have a name and Python
data type. It can also have a label which will be used for display, otherwise
the name will be used.

Each row is a sequence of cells. Although columns are explicit row names are
always the first cell in a row. Like columns, cells can also have labels.
Gviz Data Table will validate each cell to make sure that data conforms to
type specified in the schema and will map Python types to their JSON
equivalent but it does not coerce any data, i.e. if a column has type `int`
and a cell's data is a string containing numerical characters only this will
still raise an exception.

Gviz Data Table handles data conversion only. You will need to add the
necessary Javascript to an web page in order for any charts or table to be
drawn. Tables, columns and cells can all have options which are just
dictionaries. As there is no further definition of options no validation of
their items occurs. Unknown items will simply be ignored.

Gviz Data Table is composed of: one container class "Table"; two data
classes, Cell and Column and one JSON encoder. Application code should
probably only ever need to use Table and the encoder.


Tables can be initialised with a schema or these can be added imperatively.
Once one row has been added to a table no more columns can be added. Once all
the rows have been added. The table can be converted into JSON using the


Let's say we have data representing the names and salaries of people

====== ======
Name Salary
====== ======
Jim 50
Bob 80
====== ======

This could be coded in Gviz Data Table like this:

.. code-block:: python

from gviz_data_table import Table

table = Table()
table.add_column('name', str, "Name")
table.add_column(salary', int, "Salary")
table.append(["Jim", 50])
table.append(["Bob", 80])

This can be encoded into JSON using the encoder:

.. code-block:: python

from gviz_data_table import encode


It can also be directly encoded

.. code-block:: python


And also used as a static data source for asynchronous loading from Javascript

.. code-block:: python


Complete documentation including the API at

1.0.0 (2013-03-18)

- Python 3 compatibile
- Changed convenience import: `encode` replaces `encoder`
- Added convenience methods to Table to allow direct encoding as JSON and a
Google data source.

0.9.1 (2012-07-26)

- Changed signature of add_column when I found I used it wrongly myself in
the docs

0.9 (2012-07-25)

- Initial release

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for gviz_data_table, version 1.0.1
Filename, size File type Python version Upload date Hashes
Filename, size gviz_data_table-1.0.1.tar.gz (11.7 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page