petl - Extract, Transform and Load (Tables of Data)¶
petl
is a general purpose Python package for extracting, transforming
and loading tables of data.
- Documentation: http://petl.readthedocs.org/
- Source Code: https://github.com/petl-developers/petl
- Download: http://pypi.python.org/pypi/petl
- Mailing List: http://groups.google.com/group/python-etl
Please feel free to ask questions via the mailing list (python-etl@googlegroups.com).
To report installation problems, bugs or any other issues please email python-etl@googlegroups.com or raise an issue on GitHub.
For an example of petl
in use, see the case study on comparing tables.
For an alphabetic list of all functions in the package, see the Index.
Note
Version 1.0 is a new major release of petl
. See the Changes
section for more information about what has changed in version 1.0.
- Introduction
- Extract/Load - reading/writing tables from files, databases and other sources
- Extract (read)
- Load (write)
- Python objects
- Delimited files
- Pickle files
- Text files
- XML files
- HTML files
- JSON files
- Databases
- Excel .xls files (xlrd/xlwt)
- Excel .xlsx files (openpyxl)
- Arrays (NumPy)
- DataFrames (pandas)
- HDF5 files (PyTables)
- Bcolz ctables
- Text indexes (Whoosh)
- Avro files (fastavro)
- I/O helper classes
- Remote I/O helper classes
- Deprecated I/O helper classes
- Custom I/O helper classes
- Transform - transforming tables
- Utility functions
- Configuration
- Changes
- Contributing
- Acknowledgments
- Related Work