Installation

Getting Started

This package is available from the Python Package Index. If you have pip you should be able to do:

$ pip install petl

You can also download manually, extract and run python setup.py install.

To verify the installation, the test suite can be run with pytest, e.g.:

$ pip install pytest
$ pytest -v petl

petl has been tested with Python versions 2.7 and 3.6-3.13 under Linux, MacOS, and Windows operating systems.

Dependencies and extensions

This package is written in pure Python and has no installation requirements other than the Python core modules.

Some domain-specific and/or experimental extensions to petl are available from the petlx package.

Some of the functions in this package require installation of third party packages. These packages are indicated in the relevant parts of the documentation for each file format.

Also is possible to install some of dependencies when installing petl by specifying optional extra features, e.g.:

$ pip install petl['avro', 'interval', 'remote']

The available extra features are:

db

For using records from Databases with SQLAlchemy.

Note that is also required installing the package for the desired database.

interval

For using Interval transformations with intervaltree

avro

For using Avro files with fastavro

pandas

For using DataFrames with pandas

numpy

For using Arrays with numpy

xls

For using Excel/LO files with xlrd/xlwt

xlsx

For using Excel/LO files with openpyxl

xpath

For using XPath expressions with lxml

bcolz

For using Bcolz ctables with bcolz

whoosh

For using Text indexes with whoosh

hdf5

For using HDF5 files with PyTables.

Note that also are additional software to be installed.

remote

For reading and writing from Remote Sources with fsspec.

Note that fsspec also depends on other packages for providing support for each protocol as described in petl.io.remotes.RemoteSource.