ibis
ibis copied to clipboard
ibis-project
the portable Python dataframe library
### What happened? When executing the following function chain (pseudocode): ``` base_aggrs = [ ibis.Table(py_table).group_by().aggregate() for py_table in (py_table0, ..., py_table3) ] query = base_aggrs[0].outer_join(base_aggrs[1], ...).select(...) .outer_join(base_aggrs[2], ...).select(...) ``` The...
### What happened? Discovered in https://github.com/NickCrews/mismo/issues/64. CC @jstammers. Here is a more minimal reproducer. Run with `uv run script.py` to get uv to install the deps automatically, or install them...
### Please describe the issue The [operation support matrix](https://ibis-project.org/backends/support/matrix) has links to each operation, but they don’t work. Currently they go to something of the form `https://ibis-project.org/backends/support/operations.html#ibis.expr.operations.analytic.Analytic` but it appears...
### What happened? ```python import ibis ibis.memtable({"x": [1.2, 3.4]}).x.round().cast(int).cast(str).execute().to_list() # gives # ['1.0', '3.0'] # I expect # ['1', '3'] # not a problem with literals? ibis.literal(1.2).round().cast(int).cast(str).execute() # '1' ```...
### What happened? for BigQuery, if we use a Recursive CTE statement something like this: ``` WITH RECURSIVE CTE_1 AS ( (SELECT 1 AS iteration UNION ALL SELECT 1 AS...
### Please describe the issue Current docs online about tables, schemas and data types do not mention that schema types may include an "!" prefix, e.g. a schema might look...
xref: https://ibis-project.zulipchat.com/#narrow/stream/405330-duckdb/topic/spatial.20filtering.20joins/near/472566239 cc: @cboettig (data from "https://data.source.coop/cboettig/ca30x30/ca_areas.parquet") ```python In [1]: import ibis In [2]: import ibis ...: from ibis import _ ...: con = ibis.duckdb.connect() In [3]: t = (con...
### Is your feature request related to a problem? Ibis treats columns named "a" and "A" differently, and you can have both in a relation. I think this makes, some...
TBD
### Is your feature request related to a problem? From my research and going through the documentation, if I want to bring my ibis expr into memory, I need to...
