petl - Extract, Transform and Load (Tables of Data)

petl is a Python package for extracting, transforming and loading tables of data.

• Documentation: http://petl.readthedocs.org/
• Source Code: https://github.com/alimanfoo/petl
• Download: http://pypi.python.org/pypi/petl
• Mailing List: http://groups.google.com/group/python-etl

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.

• Introduction
  • Installation
  • Dependencies and extensions
  • Conventions - row containers and row iterators
  • Transformation pipelines
  • Caching
• Extract - reading tables from files, databases and other sources
  • Delimited files
  • Pickle files
  • Text files
  • XML files
  • JSON files
  • Databases
• Transform - transforming tables
  • Basic transformations
  • Header manipulations
  • Converting values
  • Selecting rows
  • Regular expressions
  • Deduplicating rows
  • Unpacking compound values
  • Transforming rows
  • Sorting
  • Joins
  • Set operations
  • Reducing rows
  • Reshaping tables
  • Filling missing values
• Load - writing tables to files and databases
  • Delimited files
  • Pickle files
  • Text files
  • JSON files
  • HTML files
  • Databases
• Utility functions
• I/O helper classes
• petl.fluent - Alternative notation for combining transformations
  • petl executable
• petl.interactive - Optimisations for Use in Interactive Mode
• petl.push - Branching Pipelines
  • Introduction
  • Push Functions
• Case Study 1 - Comparing Tables
  • Introduction
  • Preparing the data
  • Looking for missing or unexpected rows
  • Finding conflicts
• Related Work

Indices and tables

• Index
• Module Index
• Search Page