aggrid cannot set group header

[CrystalWindSnake]

aggrid in nicegui allows grouped table headers, but not in the bi module in ex4nicegui.

grid = ui.aggrid(
    {
        "defaultColDef": {"flex": 1},
        "columnDefs": [
            {
                "headerName": "xxxx",
                "children": [
                    {
                        "field": "name",
                    },
                    {
                        "field": "age",
                    },
                ],
            },
            {
                "field": "parent",
            },
        ],
        "rowData": [
            {"name": "Alice", "age": 18, "parent": "David"},
            {"name": "Bob", "age": 21, "parent": "Eve"},
            {"name": "Carol", "age": 42, "parent": "Frank"},
        ],
        "rowSelection": "multiple",
    }
).classes("max-h-40")


ds = bi.data_source(
    pd.DataFrame(
        {"name": "Alice", "age": 18, "parent": "David"},
        {"name": "Bob", "age": 21, "parent": "Eve"},
        {"name": "Carol", "age": 42, "parent": "Frank"},
    )
)

ds.ui_aggrid(
    options={
        "columnDefs": [
            {
                "headerName": "xxxx",
                "children": [
                    {
                        "field": "name",
                    },
                    {
                        "field": "age",
                    },
                ],
            },
            {
                "field": "parent",
            },
        ],
    }
)

[CrystalWindSnake]

Currently options can be modified by accessing the native element

ds = bi.data_source(
    pd.DataFrame(
        {"name": "Alice", "age": 18, "parent": "David"},
        {"name": "Bob", "age": 21, "parent": "Eve"},
        {"name": "Carol", "age": 42, "parent": "Frank"},
    )
)

table = ds.ui_aggrid()


col_defs: List[Dict] = table.element.options["columnDefs"]

#  Remove the configuration of name and age.
col_defs.pop(0)
col_defs.pop(0)

# Insert a grouping of name and age
col_defs.insert(
    0,
    {
        "headerName": "xxxx",
        "children": [
            {
                "field": "name",
            },
            {
                "field": "age",
            },
        ],
    },
)

[CrystalWindSnake]

Perhaps a way to tweak the configuration could be provided

ds.ui_aggrid().adjust_column_defs(
    {
        #  0 means put in the first column
        0: {
            "headerName": "xxxx",
            "children": [
                {
                    "field": "name",
                },
                {
                    "field": "age",
                },
            ],
        },
    },
    # Remove some columns
    remove=["name", "age"],
)