petl-developers/petl

Health v2 · maintenance only

Adoption not part of the score

1318 stars · 213 forks observed · 2026-09-25

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

petl is a general-purpose Python package for extracting, transforming and loading tables of data. It provides a lightweight, pure-Python toolkit for reading, converting, and writing tabular data across formats like CSV, JSON, XML, and SQL databases.

Use cases

• convert csv files to
• clean and transform tabular data in python
• load data from csv into a sql database
• filter and sort rows in a large table
• join and merge datasets from different files
• extract transform load without pandas
• deduplicate records in a data file

When to choose

• you need lightweight pure-Python ETL without heavy dependencies
• you work with tabular data in many formats (csv, , xml, sql)
• you want lazy evaluation pipelines that handle large files
• you need simple data cleaning, sorting, joining, and conversion

When to avoid

• you need distributed or parallel processing at scale (use Spark/Dask)
• you want dataframe-style numeric analysis (use pandas)
• you need a full orchestration or scheduling ETL platform

Facets

library · maturity stable

etl csv data-science data-science files python cross-platform etl tables data-pipelines tabular-data data-engineering

Member repositories

For agents

markdown · JSON · MCP: product_card(name="petl-developers/petl")