Splitting up an ibis table.

[stb-ssk]

Hello,
I wanted to ask a question on splitting up a table into multiple tables. Suppose each row has a column with a non unique ID, so I want to group all the rows with the same ID and create new tables out of them. So a new table, for every unique ID.

Is there a way I can split up the table without using filter(), since that can take a time, if there are many IDs to go through.

[cpcloud]

Hi @stb-ssk, thanks for opening a discussion about this.

I don't see an obvious way to do this without filter.

Can you clarify why filter is undesirable?

How many rows do you have and what is the cardinality as a percentage of unique values in the id column?

What backend are you using?