SaaSHub helps you find the best software and product alternatives Learn more →
Ibis Alternatives
Similar projects and alternatives to ibis
-
-
InfluxDB
InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
-
obsninja
VDO.Ninja is a powerful tool that lets you bring remote video feeds into OBS or other studio software via WebRTC.
-
-
prql
PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement
-
-
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
MindsDB
AI's query engine - Platform for building AI that can answer questions over large scale federated data. - The only MCP Server you'll ever need
-
-
gpt-neox
An implementation of model parallel autoregressive transformers on GPUs, based on the Megatron and DeepSpeed libraries
-
Redash
Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.
-
-
octosql
OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.
-
-
-
-
-
-
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
ibis discussion
ibis reviews and mentions
-
Why Pandas feels clunky when coming from R (2024)
pandas* per the style guide (nobody follows it)
also I recommend trying Ibis. created by the creator of pandas originally and solves so many of the issues
https://ibis-project.org
-
Coding as Craft: Going Back to the Old Gym
I felt the same - have to relearn/lookup everything every time I went back to a project or wanted to do some operations that are simple to describe in SQL but I couldn't wrap my mind around e.g. using multi-indexed dataframes & aggregations properly. These days, I always jump to Polars instead of Pandas - much more intuitive and consistent API. Tons of props to Pandas for all that they did (and continue to do) in the data space, but their API did not evolve very well IMO.
I've also been wanting to play with Ibis[1] recently, but Polars has been sufficient for me.
[1] https://ibis-project.org/
-
Polars Cloud: The Distributed Cloud Architecture to Run Polars Anywhere
Ibis also solves this problem by providing a portable dataframe API that works across multiple backends (DuckDB by default): https://ibis-project.org/
-
Modern Polars – A side-by-side comparison of the Polars and Pandas libraries
I just want to add an additional entry to the Other cool stuff you might like in the summary: https://ibis-project.org/
It's a portable dataframe library that defaults to a DuckDB backend, but you can also use polars and pandas (among the 20 backends that it supports).
- FireDucks: Pandas but 100x Faster
- The Polars vs. Pandas difference nobody is talking about – Labs
- DuckDB over Pandas/Polars
-
DuckDB 1.1.0 Released
There is is still much to do especially on large table formats (iceberg/delta) and memory management when running on bigger boxes on cloud. Eg the elusive "Failed to allocate ..." bug[1] is an inhibitor to the claim that big data is dead[2]. As it is, we tried and abandoned DuckDB as a cheaper replacement for some databricks batch jobs.
[0] https://github.com/ibis-project/ibis
-
Farewell Pandas, and thanks for all the fish
`_` definitely clashes with IPython and Jupyter's use of it.
However, if you import it from Ibis then it ceases to be used as "most recent result" and remains the ibis underscore object (unless of course you explicitly assign it to something else).
Regarding backend compatibility, there are definitely a few kinds of things that we don't currently abstract over. One is regular expression syntax and another is floating point math (e.g., various algebraic properties that are violated that result in slightly different outputs).
Hope you give it a go, and please report issues at https://github.com/ibis-project/ibis.
-
tea-tasting: a Python package for the statistical analysis of A/B tests
tea-tasting accepts data either as a Pandas DataFrame or an Ibis Table. Ibis is a Python package which serves as a DataFrame API to various data backends. It supports 20+ backends including BigQuery, ClickHouse, PostgreSQL/GreenPlum, Snowflake, and Spark. You can write an SQL query, wrap it as an Ibis Table, and pass it to tea-tasting.
-
A note from our sponsor - SaaSHub
www.saashub.com | 12 Jun 2025
Stats
ibis-project/ibis is an open source project licensed under Apache License 2.0 which is an OSI approved license.
The primary programming language of ibis is Python.