Skip Navigation

Scout Archives

Home Projects Publications Archives About Sign Up or Log In

Browse Resources

Data warehousing

Resources

Petl

Petl is a Python library and companion command-line tool to support Extract, Transform, and Load (ETL) workflows on tabular data. Petl can read and write several dozen formats including Excel, XML, JSON, Delimited text, HTML, and many others. Numerous transformations are supported, including transformations of individual values, splitting compound values from one cell into multiple cells, SQL-like...

https://petl.readthedocs.io/en/stable/