Skip to main content

Format agnostic tabular data library (XLS, CSV, JSON, YAML, CSV)

Project description

Tablib: format-agnostic tabular dataset library

_____         ______  ___________ ______
__  /_______ ____  /_ ___  /___(_)___  /_
_  __/_  __ `/__  __ \__  / __  / __  __ \
/ /_  / /_/ / _  /_/ /_  /  _  /  _  /_/ /
\__/  \__,_/  /_.___/ /_/   /_/   /_.___/

Tablib is a format-agnostic tabular dataset library, written in Python. It is a full python module which doubles as a CLI application for quick dataset conversions.

Formats supported:

  • JSON

  • YAML

  • Excel

  • CSV

At this time, Tablib supports the export of it’s powerful Dataset object instances into any of the above formats. Import is underway.

Please note that tablib purposefully excludes XML support. It always will.

Features

Populate fresh data files:

headers = ('first_name', 'last_name', 'gpa')

data = [
    ('John', 'Adams', 4.0),
    ('George', 'Washington', 2.6),
    ('Henry', 'Ford', 2.3)
]

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

# Establish file location and save
data.save('test.xls')

Intelligently add new rows:

data.append('Bob', 'Dylan', 3.2)

print data.headers
# >>> ('first_name', 'last_name', 'gpa')

Slice rows:

print data[0:1]
# >>> [('John', 'Adams', 4.0), ('George', 'Washington', 2.6)]

Slice columns by header:

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

Manipulate rows by index:

del data[0]
print data[0:1]
# >>> [('George', 'Washington', 2.6), ('Henry', 'Ford', 2.3)]

Roadmap

  • Import datasets from CSV, JSON, YAML

  • Auto-detect import format

  • Plugin support

History

0.6.0 (2010-09-11)

  • Public Release.

  • Export Support for XLS, JSON, YAML, and CSV.

  • DataBook Export for XLS, JSON, and YAML.

  • Python Dict Property Support.

Project details


Download files

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

Source Distribution

tablib-0.6.1.tar.gz (8.2 kB view details)

Uploaded Source

File details

Details for the file tablib-0.6.1.tar.gz.

File metadata

  • Download URL: tablib-0.6.1.tar.gz
  • Upload date:
  • Size: 8.2 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No

File hashes

Hashes for tablib-0.6.1.tar.gz
Algorithm Hash digest
SHA256 8b577bd60254d187630fbed8aacc0b75d9663a84bf89885d54642928321d341d
MD5 187c3dead5d3773eb908ff0a07faae51
BLAKE2b-256 51d24cdf3715d296b5b0231c0d94e67969f9becb989c71d456f20824d10d9aa7

See more details on using hashes here.

Provenance

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page