Feature request: filter tables by value in column about marimo HOT 4 OPEN

After I thought about this overnight, it occurred to me that there might be a workaround. I'll see if it works later today; it might be possible to make this simply a recipe in the documentation.

from marimo.

I was able to hack this together by using a text field in another cell to get input to a filtering operation to preprocess the table, and then put them in a vstack. I'll try to get it looking better and do a writeup over the weekend.

from marimo.

Here's what I've got so far:

@app.cell
def __(mo):
    filter_text = mo.ui.text()
    return filter_text,


@app.cell
def __():
    table_entries = []  # Edit this to have something actually interesting in there.
    return table_entries,


@app.cell
def __(filter_text, table_entries, mo):
    def _filter_on_column(column, text, dicts):
        return [dct for dct in dicts if text in dct[column]]


    _stack = mo.vstack(
        (
            mo.hstack(("Filter by:", filter_text), justify="end"),
            mo.ui.table(
                _filter_on_column("Column Name", filter_text.value, table_entries)
            ),
        )
    )

    DOCUMENTATION_SECTION = f"{_stack}"
    return DOCUMENTATION_SECTION,

I'm going to say that this will hold me for now, but there are a few possible areas of improvement, some of which may interfere with each other:

• I haven't tried to get it working with any input type besides "list of dicts"
• It would be nice to have regex or fuzzy search
• It would be nice if the matches were bolded or otherwise highlighted

from marimo.

... Of course, it also works to skip making the hstack and just use the label argument to text().

from marimo.