NewYour coding agent can read the release notes before it upgrades.Set up the MCP server →
PyPI
PyPI, #4249 most downloaded on PyPI
A Python package for extracting, transforming and loading tables of data.
Latest stable
1.7.32
Last release 12 days ago
10 Nov 2026
Ships unpredictably
gaps range from 8 days to 13 months
Most releases are documented
notes for 49 of the last 60 stable releases
Nothing withdrawn
no release was ever pulled
15 years old
107 releases · first in 2011
Drag across the ruler to compare, or tap a release to open it.
docs: restore nine related-work links by @ub3dqy in https://github.com/petl-developers/petl/pull/776
Full Changelog: https://github.com/petl-developers/petl/compare/v1.7.31...v1.7.32
Your coding agent can read these notes before it upgrades. Set up the MCP server →
Clear existing merged cells when replacing a named sheet with toxlsx() so the saved workbook retains every value in the replacement table. By IlyaKhalafi, 815.
Use PETL's mixed-type ordering for pivot categories, including missing values, instead of raising when category types cannot be directly compared. Collect all values for each category before aggregation, even when distinct categories compare as ordering ties. By anishpentyala, 811.
Preserve explicit iterator headers across repeated passes in fromtext(). By IlyaKhalafi.
Use PETL's mixed-type ordering for variable names discovered by recast(), allowing tables with mixed-type headers to be melted and recast without a comparison error. By wynneyin.
Compare custom missing values by equality in coalesce() so equal but distinct values fall back to the next field or the configured default. Preserve identity-based markers and array-valued cells whose comparisons have no scalar truth value. By wynneyin.
Fill every column by position when filldown() has no explicit field selectors, including columns with integer or mixed-type headers. By wynneyin.
Close remote gzip and bz2 responses after reading or an error. By IlyaKhalafi, 803.
Give each randomtable() iterator an independent random generator so interleaved iterations and unrelated random calls preserve seeded output without changing Python's global random state. By akashmalbari, 799.
Keep headers aligned with row values when unpack() selects a duplicate field name by index. By HocVoNgThai, 793.
Preserve explicit iterator headers across rows and repeated passes in fromdicts() and fromjson() without consuming headers until the first iteration. By IlyaKhalafi, 794.
Preserve existing data when appending to a preloaded MemorySource, even after a partial read.
Exclude negatively selected fields from the inferred keys or variables in melt(). By IlyaKhalafi, 786.
Avoid repeating right-hand key columns when join keys use negative indexes. By IlyaKhalafi, 790.
Keep the header and data aligned when unpack() selects a field by a negative index. By IlyaKhalafi, 781.
Preserve header alignment when split() selects a duplicate field by index. By IlyaKhalafi, 779.
Normalize negative field indexes in split() and splitdown() so output rows replace or remove the selected cell correctly. By IlyaKhalafi, 777.
Accept field indexes and single-field lists as the key in mergeduplicates() and merge(). An integer key raised TypeError, a one-item list split each key value into characters, and a list of indexes repeated the key columns. Negative indexes count from the end of the header, and in merge() indexes refer to the combined header. By LuisFigueroaG, 774.
Fix toarray() on tables without data rows by @LuisFigueroaG in https://github.com/petl-developers/petl/pull/746
Full Changelog: https://github.com/petl-developers/petl/compare/v1.7.30...v1.7.31
Refresh nine related-work links using project sites, source repositories, author pages, and clearly labelled research/book references. By ub3dqy, 616.
Close the table with a bottom border when look() uses the default grid style on a table without data rows, as the simple style already does, so the output is a valid reStructuredText grid table. By LuisFigueroaG, 761.
Accept a field index in capture(), as in split(), instead of raising ValueError while building the header when the original field is not kept. Negative indexes count from the end of the header. By LuisFigueroaG, 763.
Pass whole rows to simple aggregation functions when both key and value are None, instead of raising FieldSelectionError. By umtong, 770.
Close ZIP member streams before their archives in ZipSource, allowing exports such as tocsv() to finish and releasing retained reader handles after normal or interrupted context exits. By chivector, 773.
Ignore values beyond the header in columns() and facetcolumns() even when missing matches a field name or is unhashable. This avoids appending extra values to a column or raising TypeError on long rows. By akashmalbari, 771.
Allow importing petl when a standard stream's binary buffer has been detached, which raises ValueError on Python 3.15.1. Continue trying the existing fallbacks for both standard input and standard output. By KennyMcSimpson, 768.
Close XLSX workbooks when iteration ends early or raises an exception. By nawaaaaaAaar, 766.
Refresh OpenRefine's name and links in related work. By tongwentao, 764.
CI: Fix failing tests on Ubuntu 26.04. By tongwentao, 764.
Add opt-in escape=True to toxml() for literal XML values and header text. By IlyaKhalafi, 755.
Honor reverse=True in sortheader(), which was ignored, so the columns are ordered with the header sorted in descending order. By LuisFigueroaG, 762.
Return an empty list from intervaljoinvalues() with lkey and rkey for left rows whose key is not in the right table, as for rows with no overlapping intervals, instead of raising KeyError. By LuisFigueroaG, 760.
Convert HTML header values to text before truncation in tohtml() and teehtml(), avoiding errors for non-string headers. By IlyaKhalafi, 756.
Add distinctvalues() to collect unique field values in their original table order, including compound field selections. By IlyaKhalafi, 147.
Keep the header when toavro() writes a table without data rows and no schema is given. Every field is written as a nullable string, instead of an Avro file with no fields that reads back with an empty header. By LuisFigueroaG, 754.
Close database load cursors created by petl when truncation, insertion or input iteration fails. By IlyaKhalafi, 753.
Return zero count and frequency from valuecount() on a table without data rows, instead of raising ZeroDivisionError. By IlyaKhalafi, 752.
Return tuple rows from Whoosh indexes with zero or one stored field, including document number and search score columns. By IlyaKhalafi, 751.
Return an empty array from toarray() and torecarray() on a table without data rows when no dtype is given, instead of raising IndexError. The fields keep the table header and use the object type, as there are no values to infer a type from. By LuisFigueroaG, 746.
Propagate process-control exceptions such as KeyboardInterrupt and SystemExit from parsers used by parsecounter() and parsecounts(), instead of treating them as ordinary data parsing failures. By jadenfix, 747.
Respect explicit empty headers for dictionary generators by @xiehuanyi in https://github.com/petl-developers/petl/pull/742
Full Changelog: https://github.com/petl-developers/petl/compare/v1.7.29...v1.7.30
Return the original value from boolparser(strict=False) when it can't be parsed, as documented, instead of a stripped and lowercased copy. By LuisFigueroaG, 745.
Accept a single list or tuple of fields in cutout(), as in cut(). By akashmalbari, 744.
Return True from issorted() on a table without data rows, instead of raising StopIteration. By LuisFigueroaG, 743.
Honor decoder options when reading JSON Lines by @sunlishuo25 in https://github.com/petl-developers/petl/pull/729
Full Changelog: https://github.com/petl-developers/petl/compare/v1.7.28...v1.7.29
Reuse the sorted rows and discovered fields when a recast() view is read again. Copy row fields before sorting to keep the cache stable when source rows are edited in place. See 369.
Write the demo file in the fromcsv() docstring with newline='', so the example round-trips on Windows instead of inserting an empty row after every record. By lizerui1608-dev, 734.
Allow importing petl on Python builds without the bz2 module. Reading or writing .bz2 files then raises an ImportError explaining that bz2 is not available. By LuisFigueroaG, 415.
Apply JSON decoder options in fromjson(..., lines=True) during header discovery and row parsing, including custom decoders and numeric parsers. Reuse the first decoded record for header discovery and row output so stateful decoder callbacks do not process it twice within one iteration. By sunlishuo25.
Add skiplast() to remove trailing rows, such as file footers, in one pass with bounded buffering. By natesute, closes 216.
Update the contributor guide to use pytest and the configured Tox test, doctest and documentation environments. By ryanduguid, 737.
Fix selectusingcontext() raising RuntimeError on a table that has a header but no data rows. The header is now returned unchanged. By raashish1601.
Add tomarkdown() to write a table as a Markdown pipe table. By LuisFigueroaG, 418.
Fix progress() and log_progress() raising UnboundLocalError when the table yields no rows at all, e.g. when reading an empty CSV file. By raashish1601.
Document how to sort by several fields in different directions with sort(), by chaining stable sorts starting with the last field. By LuisFigueroaG, 375.
Return the header with the count field from distinct(..., count=...) on a table without data rows, instead of raising a TypeError. By NotAFlightRisk.
Add substring convenience functions by @akashmalbari in https://github.com/petl-developers/petl/pull/722
Full Changelog: https://github.com/petl-developers/petl/compare/v1.7.27...v1.7.28
Preserve group keys in multiple aggregations when the key selector is a one-item list or tuple, matching simple aggregation. This avoids splitting iterable key values into extra columns or raising errors for scalar values.
Preserve missing-cell positions when displaying short rows with see(), including duplicate and numeric-looking field names. By rastagan-git, 726.
Expand the configuration reference with inspection, sorting and error handling defaults, argument precedence and executable examples. By rastagan-git, 725, closes 390.
Return row-oriented data from fromxlsx() for single-cell, whole-row and whole-column ranges, in both normal and read-only mode. Reject ranges containing row zero rather than treating zero as an unspecified bound. By rastagan-git, 724.
Add standardize() to scale numeric fields to a mean of 0 and a standard deviation of 1. Based on the contribution by CharveeSaraiya in 690. By akashmalbari, 730.
Add callable support to setheader by @akashmalbari in https://github.com/petl-developers/petl/pull/721
Full Changelog: https://github.com/petl-developers/petl/compare/v1.7.26...v1.7.27
Preserve integer values in fromdataframe() when pandas tables contain both integer and floating-point columns, avoiding precision loss for large integers. Index inclusion and empty-table behavior are unchanged. By rastagan-git, 720.
Add callable support to setheader By akashmalbari, 721.
docs: clarify valuecounter field arguments by @codeofwxz in https://github.com/petl-developers/petl/pull/714
Full Changelog: https://github.com/petl-developers/petl/compare/v1.7.25...v1.7.26
Support SQLAlchemy 2 database operations By umd0730, 719.
Preserve tuple values when formatting DuplicateKeyError and FieldSelectionError messages, including compound duplicate keys and invalid tuple field selectors. See 641. By umd0730, 718.
Preserve discovered columns and values with sample=1 in fromdicts() and JSON array input. Empty samples no longer raise RuntimeError. By umd0730, 717.
Read empty JSON lines files as empty tables instead of raising RuntimeError when discovering the header. By umd0730, 716.
Correct csvkit's PyPI link in related work By codeofwxz, 715.
Clarify that valuecounter() accepts multiple fields as positional arguments, with examples of mixed names/indexes and tuple unpacking. See 641. By be-student, 714.
Raise ArgumentError for invalid recast() fields, including under Python optimization, instead of relying on assertions. See 297. By umd0730, 712.
docs: demonstrate row field-name and index access in convert. By be-student, 711.
feat: add truncate argument to todb function by @ChrisJr404 in https://github.com/petl-developers/petl/pull/707
Full Changelog: https://github.com/petl-developers/petl/compare/v1.7.24...v1.7.25
docs: demonstrate field-name and index access in row-aware conversions, including column names containing spaces. By be-student, 671.
chore: improve CI/CD workflows, update documentation By juarezr, 709.
feat: add truncate argument to todb function By ChrisJr404, 669.
Fix avro decimal precision and scale inferred from Decimal values by @gaoflow in https://github.com/petl-developers/petl/pull/706
Full Changelog: https://github.com/petl-developers/petl/compare/v1.7.23...v1.7.24
fix: Fix avro decimal precision and scale inferred from Decimal values By gaoflow, 706.
Fix cache/complement/index/skip attributes shadowing Table methods by @gaoflow in https://github.com/petl-developers/petl/pull/705
Full Changelog: https://github.com/petl-developers/petl/compare/v1.7.22...v1.7.23
fix: Fix cache/complement/index/skip attributes shadowing Table methods By gaoflow, 705.
Fix header instance attribute shadowing Table.header() across views by @gaoflow in https://github.com/petl-developers/petl/pull/704
Full Changelog: https://github.com/petl-developers/petl/compare/v1.7.21...v1.7.22
fix: Fix header instance attribute shadowing Table.header across views By gaoflow, 704.
Fix filldown RuntimeError on header-only tables by @sarathfrancis90 in https://github.com/petl-developers/petl/pull/698
Full Changelog: https://github.com/petl-developers/petl/compare/v1.7.20...v1.7.21
fix: Fix filldown RuntimeError on header-only tables By sarathfrancis90, 698.
fix: Fix DictsView.dicts instance attr shadowing Table.dicts method By gaoflow, 697.
fix: treat None cells as non-matching in capture by @santhreal in https://github.com/petl-developers/petl/pull/701
Full Changelog: https://github.com/petl-developers/petl/compare/v1.7.19...v1.7.20
Fix filldown RuntimeError on header-only tables By sarathfrancis90, 698.
feat: modernize python dependencies in CI By juarezr, 702.
## Whats Changed
Fix filldown RuntimeError on header-only tables By sarathfrancis90, 698.
feat: modernize python dependencies in CI By juarezr, 702.
Add drop="if_exists" support to todb() by @akashmalbari in https://github.com/petl-developers/petl/pull/695
Full Changelog: https://github.com/petl-developers/petl/compare/v1.7.18...v1.7.19
## Whats Changed
Add drop=if_exists support to todb By akashmalbari, 695.
Fix tojson() output for stdin-backed CSV input by @akashmalbari in https://github.com/petl-developers/petl/pull/693
ownsb to fromdb function by @juarezr in https://github.com/petl-developers/petl/pull/694Full Changelog: https://github.com/petl-developers/petl/compare/v1.7.17...v1.7.18
Fix tojson() output for stdin-backed CSV input By akashmalbari, 693.
feat: add argument ownsb to fromdb function By juarezr, 694.
ci: added readthedocs settings file by @juarezr in https://github.com/petl-developers/petl/pull/677
Full Changelog: https://github.com/petl-developers/petl/compare/v1.7.16...v1.7.17
ci: added readthedocs settings file By juarezr, 677.
build and publish a wheel By dimbleby, 679.
Added ability to infer JSON column type into db_create.py By muhammadbadar1998, 682.
fix: mitigate code injection related in #672 By juarezr, 681.
Add drop='if_exists' support to petl.io.db.todb. 666.
feat(CI): add python 3.13 to CI testing on github actions by @juarezr in https://github.com/petl-developers/petl/pull/675
Full Changelog: https://github.com/petl-developers/petl/compare/v1.7.15...v1.7.16
CI: added jobs for testing petl with python 3.13 and macos-13 on Intel platform By juarezr, 675.
CI: workaround for actions/setup-python as Github removed support for python 3.7 By juarezr, 675.
Fix: Joining tables with uneven rows gives wrong result. By MichalKarol.
Resolve DeprecationWarning: Seeding based on hashing by @bmos in https://github.com/petl-developers/petl/pull/656
Full Changelog: https://github.com/petl-developers/petl/compare/v1.7.14...v1.7.15
Add unit tests for randomtable, dummytable, and their supporting functions and classes. By bmos, 657.
Fix: DeprecationWarning: Seeding based on hashing is deprecated since Python 3.9 and will be removed in a subsequent version. By bmos, 657.
Enhancement; Fix functions to conform with PEP 479 by @augustomen in https://github.com/petl-developers/petl/pull/653
Full Changelog: https://github.com/petl-developers/petl/compare/v1.7.13...v1.7.14
Enhancement: Fix other functions to conform with PEP 479 By augustomen, 645.
CI: fix build as SQLAlchemy 2 is not supported yet By juarezr, 635.
CI: workaround for actions/setup-python#672 as Github removed python 2.7 and 3.6 By juarezr, 649.
CI: Gh actions upgrade By juarezr, 639.
Fix in case a custom protocol was registered in fsspec by @timheb in https://github.com/petl-developers/petl/pull/647
Full Changelog: https://github.com/petl-developers/petl/compare/v1.7.12...v1.7.13
Fix in case a custom protocol was registered in fsspec By timheb, 647.
Add reference to Tablib by @harkabeeparolus in https://github.com/petl-developers/petl/pull/629
Full Changelog: https://github.com/petl-developers/petl/compare/v1.7.11...v1.7.12
Fix: calling functions to*() should output by default to stdout By juarezr, 632.
Add python3.11 for the build and testing By juarezr, 635.
Add support for writing to JSONL files By mzaeemz, 524.
### Fixes - #618 - Fix fromdicts() generator support to use lazy file cache instead of itertools.tee to reduce memory consumption
Fix generator support in fromdicts to use file cache By arturponinski, 625.
Fix fromtsv() to pass on header argument by @jfitzell in https://github.com/petl-developers/petl/pull/622
Full Changelog: https://github.com/petl-developers/petl/compare/v1.7.9...v1.7.10
Fix fromtsv() to pass on header argument By jfitzell, 622.
### Features - #615 - Add improved support for working with Google Sheets (#404 and #405) ### Maintainability - #614 - Improve test helpers testing
Feature: Add improved support for working with Google Sheets By juarezr, 615.
Maintanance: Improve test helpers testing By juarezr, 614.
### Fixes - #575 - Fix iterrowslice() to conform with PEP 479 - #392 - Fix sortheader() to not overwrite data for duplicate column names - #385 - Fix
__iter__Fix iterrowslice() to conform with PEP 479 By arturponinski, 575.
Cleanup and unclutter old and unused files in repository By juarezr, 606.
Add tohtml with css styles test case By juarezr, 609.
Fix sortheader() to not overwrite data for duplicate column names By arturponinski, 392.
Add NotImplementedError to IterContainer's __iter__ By arturponinski, 483.
Add casting of headers to strings in toxlsx and appendxlsx By arturponinski, 530.
Fix sorting of rows with different length By arturponinski, 385.
Creating this release to sync package repositories PyPI and Conda-Forge
New pull request template. No python changes. By juarezr, 594.
### Fixes - #579 - convertall does not work when table header has non-string elements - #578 - petl todataframe() multiply run lambda function in addf
Fix convertall does not work when table header has non-string elements By dnicolodi, 579.
Fix todataframe() to do not iterate the table multiple times By dnicolodi, 578.
Fix broken aggregate when supplying single key By MalayGoel, 552.
Migrated to pytest By arturponinski, 584.
Testing python 3.10 on Github Actions. No python changes. By juarezr, 591.
codacity: upgrade to latest/main github action version. No python changes. By juarezr, 585.
Publish releases to PyPI with Github Actions. No python changes. By juarezr, 593.
Added Decimal to numeric types #573
fromdicts header does not raise #555Added Decimal to numeric types By blas, 573.
Add support for ignore_workbook_corruption parameter in xls By arturponinski, 572.
Add support for generators in the petl.fromdicts By arturponinski, 570.
Add function to support fromdb, todb, appenddb via clickhouse_driver By superjcd, 566.
Fix fromdicts(...).header() raising TypeError By romainernandez, 555.
Use python 3.6 instead of 2.7 for deploy on travis-ci. No python changes.
Use python 3.6 instead of 2.7 for deploy on travis-ci. No python changes. By juarezr, 550.
### Changes #545 Fixed SQLAlchemy 1.4 removed the Engine.contextual_connect method #542 document how to use convert with custom function and reference
#545 Fixed SQLAlchemy 1.4 removed the Engine.contextual_connect method #542 document how to use convert with custom function and reference row
Fixed SQLAlchemy 1.4 removed the Engine.contextual_connect method By juarezr, 545.
How to use convert with custom function and reference row By javidy, 542.
## Enhancements - #541: Allow aggregation over the entire table (without a key). - #370: Allow specifying output field name for simple aggregation. ##
lxml from 4.4.0 to 4.6.2, due to security issues.Allow aggregation over the entire table (without a key) By bmaggard, 541.
Allow specifying output field name for simple aggregation By bmaggard, 370.
Bumped version of package dependency on lxml from 4.4.0 to 4.6.2 By juarezr, 536.
Fixing conda packaging failures. #534
Added toxml() as convenience wrapper over totext() on #529.
toxml() as convenience wrapper over totext() on #529.remote I/O. on #533.Added toxml() as convenience wrapper over totext(). By juarezr, 529.
Document behavior of multi-field convert-with-row. By chrullrich, 532.
Allow user defined sources from fsspec for remote I/O. By juarezr, 533.
Allow using a custom/restricted xml parser in fromxml() on #527.
Allow using a custom/restricted xml parser in fromxml(). By juarezr, 527.
Reduced memory footprint for JSONL files, huge improvement on #523.
Reduced memory footprint for JSONL files, huge improvement. By fahadsiddiqui, 522.
Fixed #487: compatibility with python3.8 in petl.timings.clock().
petl.timings.clock().petl with python3.8 in CI. #517 also prepares for testing with python3.9.Added python version 3.8 and 3.9 to tox.ini for using in newer distros. By juarezr, 517.
Fixed compatibility with python3.8 in petl.timings.clock(). By juarezr, 484.
Added json lines support in fromjson(). By fahadsiddiqui, 521.
Fixed #514: fromxlsx() with read_only=True crashes.
fromxlsx() with read_only=True crashes.Fixed fromxlsx() with read_only crashes. By juarezr, 514.
Fixed exception when writing to S3 with fsspec auto_mkdir=True on #512.
fsspec auto_mkdir=True on #512.Fixed exception when writing to S3 with fsspec auto_mkdir=True. By juarezr, 512.
Allowed reading and writing Excel files in remote sources. On #506.
toxlsx() to add or replace a worksheet. On #502.Allowed reading and writing Excel files in remote sources. By juarezr, 506.
Allow toxlsx() to add or replace a worksheet. By churlrich, 502.
Improved avro: improve message on schema or data mismatch. By juarezr, 507.
Fixed build for failed test case. By juarezr, 508.
Fixed boolean type detection in toavro(). (504).
toavro(). (:issue:504).503).Fixed boolean type detection in toavro(). By juarezr, 504.
Fix unavoidable warning if fsspec is installed but some optional package is not installed. By juarezr, 503.
Fixed: unavoidable warning downgraded to debug.
warning downgraded to debug. (#500)extra_requires and documentation on Installation dependencies. (#501)Added extras_require for the petl pip package. By juarezr, 501.
Fix unavoidable warning if fsspec is not installed. By juarezr, 500.
Feature: read and write from files in remote servers/clouds using fsspec package.
fsspec.Added class petl.io.remotes.RemoteSource using package fsspec for reading and writing files in remote servers by using the protocol in the url for selecting the implementation. By juarezr, 494.
Removed classes petl.io.source.s3.S3Source as it's handled by fsspec By juarezr, 494.
Removed classes petl.io.codec.xz.XZCodec, petl.io.codec.xz.LZ4Codec and petl.io.codec.zstd.ZstandardCodec as it's handled by fsspec. By juarezr, 494.
Fix bug in connection to a JDBC database using jaydebeapi. By miguelosana, 497.
Added functions petl.io.sources.register_reader and petl.io.sources.register_writer for registering custom source helpers for hanlding I/O from remote
Added functions petl.io.sources.register_reader and petl.io.sources.register_writer for registering custom source helpers for hanlding I/O from remote protocols. By juarezr, 491.
Added function petl.io.sources.register_codec for registering custom helpers for compressing and decompressing files with other algorithms. By juarezr, 491.
Added classes petl.io.codec.xz.XZCodec, petl.io.codec.xz.LZ4Codec and petl.io.codec.zstd.ZstandardCodec for compressing files with XZ and the "state of art" LZ4 and Zstandard algorithms. By juarezr, 491.
Added classes petl.io.source.s3.S3Source and petl.io.source.smb.SMBSource reading and writing files to remote servers using int url the protocols s3:// and smb://. By juarezr, 491.
Added functions petl.io.avro.fromavro, petl.io.avro.toavro, and petl.io.avro.appendavro for reading and writing to Apache Avro files. Avro generally i
Added functions petl.io.avro.fromavro, petl.io.avro.toavro, and petl.io.avro.appendavro for reading and writing to Apache Avro <https://avro.apache.org/docs/current/spec.html> files. Avro generally is faster and safer than text formats like Json, XML or CSV. By juarezr, 490.
See release notes.
See release notes.
Note
The parameters to the petl.io.xlsx.fromxlsx function have changed in this release. The parameters row_offset and col_offset are no longer supported. Please use min_row, min_col, max_row and max_col instead.
A new configuration option failonerror has been added to the petl.config module. This option affects various transformation functions including petl.transform.conversions.convert, petl.transform.maps.fieldmap, petl.transform.maps.rowmap and petl.transform.maps.rowmapmany. The option can have values True (raise any exceptions encountered during conversion), False (silently use a given errorvalue if any exceptions arise during conversion) or "inline" (use any exceptions as the output value). The default value is False which maintains compatibility with previous releases. By bmaggard, 460, 406, 365.
A new function petl.util.timing.log_progress has been added, which behaves in a similar way to petl.util.timing.progress but writes to a Python logger. By dusktreader, 408, 407.
Added new function petl.transform.regex.splitdown for splitting a value into multiple rows. By John-Dennert, 430, 386.
Added new function petl.transform.basics.addfields to add multiple new fields at a time. By mjumbewu, 417.
Pass through keyword arguments to xlrd.open_workbook. By gjunqueira, 470, 473.
Added new function petl.io.xlsx.appendxlsx. By victormpa and alimanfoo, 424, 475.
Fixes for upstream API changes in openpyxl and intervaltree modules. N.B., the arguments to petl.io.xlsx.fromxlsx have changed for specifying row and column offsets to match openpyxl. (472 - alimanfoo).
Exposed read_only argument in petl.io.xlsx.fromxlsx and set default to False to prevent truncation of files created by LibreOffice. By mbelmadani, 457.
Added support for reading from remote sources with gzip or bz2 compression (463 - H-Max).
The function petl.transform.dedup.distinct has been fixed for the case where None values appear in the table. By bmaggard, 414, 412.
Changed keyed sorts so that comparisons are only by keys. By DiegoEPaez, 466.
Documentation improvements by gamesbook (458).
Nothing published for this version
See release notes.
See release notes.
Please note that this version drops support for Python 2.6 (443, 444 - hugovk).
Function petl.transform.basics.addrownumbers now supports a "field" argument to allow specifying the name of the new field to be added (366, 367 - thatneat).
Fix to petl.io.xlsx.fromxslx to ensure that the underlying workbook is closed after iteration is complete (387 - mattkatz).
Resolve compatibility issues with newer versions of openpyxl (393, 394 - henryrizzi).
Fix deprecation warnings from openpyxl (447, 445 - scardine; 449 - alimanfoo).
Changed exceptions to use standard exception classes instead of ArgumentError (396 - bmaggard).
Add support for non-numeric quoting in CSV files (377, 378 - vilos).
Fix bug in handling of mode in MemorySource (403 - bmaggard).
Added a get() method to the Record class (401, 402 - dusktreader).
Added ability to make constraints optional, i.e., support validation on optional fields (399, 400 - dusktreader).
Added support for CSV files without a header row (421 - LupusUmbrae).
Documentation fixes (379 - DeanWay; 381 - PabloCastellano).
Nothing published for this version
See release notes.
See release notes.
Fixed petl.transform.reshape.melt to work with non-string key argument (#209).
Added example to docstring of petl.transform.dedup.conflicts to illustrate how to analyse the source of conflicts when rows are merged from multiple tables (#256).
Added functions for working with bcolz ctables, see petl.io.bcolz (#310).
Added petl.io.base.fromcolumns (#316).
Added petl.transform.reductions.groupselectlast. (#319).
Added example in docstring for petl.io.sources.MemorySource (#323).
Added function petl.transform.basics.stack as a simpler alternative to petl.transform.basics.cat. Also behaviour of petl.transform.basics.cat has changed for tables where the header row contains duplicate fields. This was part of addressing a bug in petl.transform.basics.addfield for tables where the header contains duplicate fields (#327).
Change in behaviour of petl.io.json.fromdicts to preserve ordering of keys if ordered dicts are used. Also added petl.transform.headers.sortheader to deal with unordered cases (#332).
Added keyword strict to functions in the petl.transform.setops module to enable users to enforce strict set-like behaviour if desired (#333).
Added epilogue argument to petl.util.vis.display to enable further customisation of content of table display in Jupyter notebooks (#337).
Added petl.transform.selects.biselect as a convenience for obtaining two tables, one with rows matching a condition, the other with rows not matching the condition (#339).
Changed petl.io.json.fromdicts to avoid making two passes through the data (#341).
Changed petl.transform.basics.addfieldusingcontext to enable running calculations (#343).
Fix behaviour of join functions when tables have no non-key fields (#345).
Fix incorrect default value for 'errors' argument when using codec module (#347).
Added some documentation on how to write extension classes, see intro (#349).
Fix issue with unicode field names (#350).
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Support for XPath via lxml if installed (#320). Fix for BZ2 under PY26 (#315).
Support for XPath via lxml if installed (#320). Fix for BZ2 under PY26 (#315).
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
One column per quarter.