.com/content/posts/100913-tablib_dataset_library_v061_released!.rst

Tablib Dataset Library v0.6.1 Released!
########################################

:date: 2010-09-13 01:22
:category: code, python
:featured: True


I'm pleased to announce a new Python module:
`Tablib <http://github.com/kennethreitz/tablib>`_. Tablib is a
simple module for working with tabular datasets. It allows you
create tables of data using standard Python datatypes, manipulate
them, and easily export to Excel, JSON, YAML, and CSV. \*\*Basic
Usage\*\*: import tablib

::

    headers = ('first_name', 'last_name', 'gpa')
    data = [('John', 'Adams', 90), ('George', 'Washington', 67)]

    data = tablib.Dataset(*data, headers=headers)

You can maniuplate your data like a standard Python list: >>>
data.append(('Henry', 'Ford', 83))

::

    >>> print data['first_name']
    ['John', 'George', 'Henry']

    >>> del data[1]

You can easily export your data to JSON, YAML, XLS, and CSV. >>>
print data.json [{"first\_name": "John", "last\_name": "Adams",
"gpa": 90}, {"first\_name": "Henry", "last\_name": "Ford", "gpa":
83}]

::

    >>> print data.yaml
    - {age: 90, first_name: John, last_name: Adams}
    - {age: 83, first_name: Henry, last_name: Ford}

    >>> print data.csv
    first_name,last_name,age
    John,Adams,90
    Henry,Ford,83

    >>> open('people.xls', 'w').write(data.xls)

Excel files with multiple sheets are also supported (via the
\`DataBook\` object).
[`Source on GitHub <http://github.com/kennethreitz/tablib>`_]
[`PyPi Listing <http://pypi.python.org/pypi/tablib>`_]