marimo icon indicating copy to clipboard operation
marimo copied to clipboard

ui.dataframe with Ibis support

Open szst11 opened this issue 1 year ago • 1 comments

Description

The feature of exploring and transforming a pandas dataframe with ui.dataframe is really amazing. If this would be possible with an Ibis-table, Marimo would be able to explore data in a database, just in the same way.

Suggested solution

create ibis code snippets in a similar way like the pandas snippets and add an option to only display a limited number of rows in the preview.

Alternative

No response

Additional context

No response

szst11 avatar Jun 12 '24 19:06 szst11

we had a similar request for Polars (#616). I can look into extending this to support different types of dataframes

mscolnick avatar Jun 12 '24 23:06 mscolnick

It would be rad to support Ibis. That would open up marimo to a lot of different backends.

rupurt avatar Aug 31 '24 06:08 rupurt

@rupurt @szst11, I am adding support for ibis in #2188

Would it be useful for you to get the SQL/python equivalent as well (basically GUI to code)?

mscolnick avatar Aug 31 '24 19:08 mscolnick

@mscolnick amazing. Do you mean that we could use the Python/SQL Ibis API directly? That would be useful for sure.

rupurt avatar Aug 31 '24 19:08 rupurt

@rupurt - I was thinking we could show the equivalent code for Python/SQL, like we do with pandas

mscolnick avatar Aug 31 '24 21:08 mscolnick

Gotcha. Yeah that would also be super useful

rupurt avatar Aug 31 '24 22:08 rupurt