Suggestions appear as you type. Use the up and down arrows to choose one and Enter to open it.

This page's audience our own tag's counts — open to see them
–Visits
–Page views
–Clicks to vendors
–Time on page
–Reading now
Clicks to vendors, by tool
  • –
Top countries
  • –
Devices
  • –

– · visits, page views and clicks counted by our own tag, which counts more than our checked analytics; every figure rounded down · how we count

Ibis review

Free#15 of 36 in Data Transformation Tools

A code-first choice for portable Python transformations across SQL systems.

7.8/10Editor score
Visit Ibis
Ibis7.8 Visit Ibis

Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026

Ibis is an open-source Python dataframe library for transforming, analyzing, and preparing data across multiple execution backends. It is aimed at data practitioners and library developers who want a common interface for database tables, local files, and dataframe objects. Its lazy table expressions defer execution, while the dataframe-style API covers joins, aggregation, filtering, casting, and deduplication. Ibis can also convert results to pandas, PyArrow, and Python data structures.

The main fit is cross-backend transformation work. Ibis compiles expressions into backend-native SQL or dataframe operations and allows Python and SQL code to be mixed directly. That combination can help teams keep transformation logic in Python while still targeting SQL systems and other dataframe backends. File support includes CSV, TSV, JSON, Parquet, Delta Lake, and Avro, with reading and writing available for CSV, JSON, Parquet, and Delta Lake. The result is a broad interface for table operations rather than a tool centered on one file type or execution environment.

Ibis is self-hosted and code-based, so it suits teams comfortable managing their own runtime and expressing transformations programmatically. It is a practical choice when portability, deferred execution, and backend-native compilation matter more than a visual workflow. Teams looking for a hosted transformation product, a point-and-click interface, or a narrowly focused file conversion utility should choose an alternative. Ibis is most appropriate for Python-led analytics workflows that need to move transformation logic across SQL and dataframe backends while retaining access to familiar table operations.

Ibis pros and cons

  • Where it wins
    • Lazy Python expressions compile into backend-native SQL.
    • Mixes Python dataframe code with SQL in one workflow.
    • Supports SQL backends, dataframe objects, and common file formats.
  • Where it doesn't
    • Requires a code-based workflow rather than a visual interface.
    • Self-hosted deployment places environment management with the team.
    • Portability depends on the connected backend and its capabilities.

Ibis fact sheet, pricing and score →

Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.

Last updated · How we research and update