Format agnostic tabular data library (XLS, JSON, YAML, CSV)
Tablib: format-agnostic tabular dataset library
_____ ______ ___________ ______ __ /_______ ____ /_ ___ /___(_)___ /_ _ __/_ __ `/__ __ \__ / __ / __ __ \ / /_ / /_/ / _ /_/ /_ / _ / _ /_/ / \__/ \__,_/ /_.___/ /_/ /_/ /_.___/
Tablib is a format-agnostic tabular dataset library, written in Python.
Output formats supported:
- Excel (Sets + Books)
- JSON (Sets + Books)
- YAML (Sets + Books)
- Pandas DataFrames (Sets)
- HTML (Sets)
- Jira (Sets)
- TSV (Sets)
- ODS (Sets)
- CSV (Sets)
- DBF (Sets)
Note that tablib purposefully excludes XML support. It always will. (Note: This is a joke. Pull requests are welcome.)
Tablib documentation is graciously hosted on https://tablib.readthedocs.io
It is also available in the
docs directory of the source distribution.
Make sure to check out Tablib on PyPI!
Please see the contributing guide.
- Dropped Python 3.5 support
- JSON-exported data is no longer forced to ASCII characters.
- YAML-exported data is no longer forced to ASCII characters.
- Added Python 3.9 support
- Added read_only option to xlsx file reader (#482).
- Prevented crash in rst export with only-space strings (#469).
Row.lpush/rpushlogic was reversed.
lpushwas appending while
appendwere prepending. This was fixed (reversed behavior). If you counted on the broken behavior, please update your code (#453).
- Fixed minimal openpyxl dependency version to 2.6.0 (#457).
- Dates from xls files are now read as Python datetime objects (#373).
- Allow import of "ragged" xlsx files (#465).
- When importing an xlsx file, Tablib will now read cell values instead of formulas (#462).
- Upcoming breaking change in Tablib 2.0.0: the
Row.lpush/rpushlogic is reversed.
lpushis appending while
appendare prepending. The broken behavior will remain in Tablib 1.x and will be fixed (reversed) in Tablib 2.0.0 (#453). If you count on the broken behavior, please update your code when you upgrade to Tablib 2.x.
- Tablib is now able to import CSV content where not all rows have the same length. Missing columns on any line receive the empty string (#226).
- Dropped Python 2 support
- Dependencies are now all optional. To install
tablibas before with all possible supported formats, run
pip install tablib[all]
- Formats can now be dynamically registered through the
- Tablib methods expecting data input (
Databook.load) now accepts file-like objects in addition to raw strings and bytestrings (#440).
- Fixed a crash when exporting an empty string with the ReST format (#368)
- Error cells from imported .xls files contain now the error string (#202)
- The 0.14.x series will be the last to support Python 2
- Dropped Python 3.4 support
- Added Python 3.7 and 3.8 support
- The project is now maintained by the Jazzband team, https://jazzband.co
- Improved format autodetection and added autodetection for the odf format.
- Added search to all documentation pages
- Open xlsx workbooks in read-only mode (#316)
- Unpin requirements
- Only install backports.csv on Python 2
DataBook().loadparameter ordering (first stream, then format).
- Fixed a regression for xlsx exports where non-string values were forced to strings (#314)
- Fixed xlsx format detection (which was often detected as
- Added reStructuredText output capability (#336)
- Added Jira output capability
- Stopped calling openpyxl deprecated methods (accessing cells, removing sheets) (openpyxl minimal version is now 2.4.0)
- Fixed a circular dependency issue in JSON output (#332)
- Fixed Unicode error for the CSV export on Python 2 (#215)
- Removed usage of optional
- Dropped Python 3.3 support
Dataset.<format>syntax in docs
- Make Panda dependency optional
- Add initial Panda DataFrame support
- Dropped Python 2.6 support
yaml.safe_loadfor importing yaml.
- Use built-in
jsonpackage if available
- Support Python 3.5+ in classifiers
- Fixed textual representation for Dataset with no headers
- Handle decimal types
- Release fix.
- Fix export only formats.
- Fix for xlsx output.
- Fixed packaging error on Python 3.
- Added LaTeX table export format (
- Support for dBase (DBF) files (
- New import/export interface (
- CSV custom delimiter support (
- Adding ability to remove duplicates to all rows in a dataset (
- Added a mechanism to avoid
datetime.datetimeissues when serializing data.
detect_format()function (mostly for internal use).
- Update the vendored unicodecsv to fix
- Only freeze the headers row, not the headers columns (xls).
- Fix XLSX import.
- Bugfix for
- Unicode Column Headers
- ALL the bugfixes!
- Dataset API Changes
- column operations have their own methods now (
- OpenDocument Spreadsheet support (.ods)
- Full Unicode TSV support
- Full XLSX Support!
- Pickling Bugfix
- Compat Module
- Full unicode CSV support
- Python 3.1, Python 3.2 Support (same code base!)
- Formatter callback support
- Various bug fixes
- Python 2.5 Support!
- Tox Testing for 2.5, 2.6, 2.7
- AnyJSON Integrated
- OrderedDict support
- Caved to community pressure (spaces)
- Databook duplication leak fix.
- HTML Table output.
- Added column sorting.
- Transpose method added to Datasets.
- New frozen top row in Excel output.
- Pickling support for Datasets and Rows.
- Support for row/column stacking.
- Minor reference shadowing bugfix.
- Massive documentation update!
- Row tagging and Dataset filtering!
- Column insert/delete support
- Column append API change (header required)
- Internal Changes (Row object and use thereof)
- New import system. All dependencies attempt to load from site-packages, then fallback on tenderized modules.
- Updated XLS output: Only wrap if '\n' in cell.
- Ability to append new column passing a callable as the value that will be applied to every row.
- Added alignment wrapping to written cells.
- Added separator support to XLS.
- Packaging Fix
- New format plugin system!
- Imports! ELEGANT Imports!
- Tests. Lots of tests.
- Reverting methods back to properties.
- Windows bug compensated in documentation.
- Renamed DataBook Databook for consistency.
- Export properties changed to methods (XLS filename / StringIO bug).
- Optional Dataset.xls(path='filename') support (for writing on windows).
- Added utf-8 on the worksheet level.
- Updated unicode export for XLS.
- More exhaustive unit tests.
- Added Dataset.append() support for columns.
- Fixed Dataset.append() error on empty dataset.
- Updated Dataset.headers property w/ validation.
- Added Testing Fixtures.
- Packaging hotfixes.
- Public Release.
- Export Support for XLS, JSON, YAML, and CSV.
- DataBook Export for XLS, JSON, and YAML.
- Python Dict Property Support.
Release history Release notifications | RSS feed
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
|Filename, size||File type||Python version||Upload date||Hashes|
|Filename, size tablib-3.0.0-py3-none-any.whl (47.9 kB)||File type Wheel||Python version py3||Upload date||Hashes View|
|Filename, size tablib-3.0.0.tar.gz (95.0 kB)||File type Source||Python version None||Upload date||Hashes View|