datatable: ag grid - how to perform group by on my data table #649

sumitmehta1025 · 2024-06-09T11:30:20Z

sumitmehta1025
Jun 9, 2024

thank you first of all for put_datatable it has made loading hundreds of thousands of rows so quick :)
I am trying to use ag grid on my data and can do simple ag grid functions like pagination by passing those as a variable. However not able to perform group by fucntion. How can I do implement following (from ag grid) in my python program -

const gridOptions = {
    columnDefs: [
        // index = 1, gets grouped second
        { field: "country", hide: true, rowGroupIndex: 1 },
        // index = 0, gets grouped first
        { field: "year", hide: true, rowGroupIndex: 0 },
    ],

    // other grid options ...
}

Please help! thank you in advance!

Answered by wang0618

Jun 10, 2024

You can use column_args param in put_datatable() to provide the columnDefs to ag-grid. For your case, you can use

put_datatable(..., column_args={
    "country": { "hide": True, "rowGroupIndex": 1 },
    "year": { "hide": True, "rowGroupIndex": 0},
})

View full answer

wang0618 · 2024-06-10T05:28:45Z

wang0618
Jun 10, 2024
Maintainer

You can use column_args param in put_datatable() to provide the columnDefs to ag-grid. For your case, you can use

put_datatable(..., column_args={
    "country": { "hide": True, "rowGroupIndex": 1 },
    "year": { "hide": True, "rowGroupIndex": 0},
})

4 replies

wang0618 Jun 10, 2024
Maintainer

Here is a demo: https://s.pywebio.online/fe456baf227fb20cda1e454b4f221c03

sumitmehta1025 Jun 10, 2024
Author

Thank you so much! this is great! I got it work now along with pagination! I have one question though, would enterprise_key="test" will give me error in my application at some point. I see that group does not work without this option. Do I really need to buy ag grid enterprise version to use it?

wang0618 Jun 13, 2024
Maintainer

Group feature is a enterprise feature of ag-grid. If you don't use a valid enterprise_key (like the demo), your datatable will show a "for trial only" message at right-bottom corner.

sumitmehta1025 Jun 13, 2024
Author

Got it! thank you!

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

datatable: ag grid - how to perform group by on my data table #649

{{title}}

{{editor}}'s edit

{{editor}}'s edit

Replies: 1 comment 4 replies

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

Select a reply

datatable: ag grid - how to perform group by on my data table #649

sumitmehta1025 Jun 9, 2024

Replies: 1 comment · 4 replies

wang0618 Jun 10, 2024 Maintainer

wang0618 Jun 10, 2024 Maintainer

sumitmehta1025 Jun 10, 2024 Author

wang0618 Jun 13, 2024 Maintainer

sumitmehta1025 Jun 13, 2024 Author

sumitmehta1025
Jun 9, 2024

Replies: 1 comment 4 replies

wang0618
Jun 10, 2024
Maintainer

wang0618 Jun 10, 2024
Maintainer

sumitmehta1025 Jun 10, 2024
Author

wang0618 Jun 13, 2024
Maintainer

sumitmehta1025 Jun 13, 2024
Author