[FEATURE]: Group by with custom aggregations

[Kogl1n]

I suggest a 'group-by' feature that builds groups of table rows based on common values of the selected column. It would be really nice if you could make use of the "Expandable Rows" feature to take a look at the groups' members. A unique feature among competitors would be a displayed summary/aggregation (like a range of values, a list or set of the occuring values, mean values and so on) of the single groups displayed next to the grouped column forming its own table row.

Example

Data:

{id: 1, name: 'apple', productType: fruit, cost: 1} {id: 2, name: 'banana', productType: fruit, cost: 1/2} {id: 3, name: 'small car', productType: car, cost: 1000}

groupby('productType').agg(name: list, cost: range):

{groupCount: 2, group: fruit, name: [apple, banana,] cost: from 1/2 to 1} {groupCount: 1, group: car, name: [car], cost: 1000}

Thank you!

Feature Check list

• [x] Agree to the Code of Conduct
• [x] Read the README to ensure the feature is not already present
• [x] You read Creating Issues, Features and Pull Requests
• [ ] Considered the value versus complexity for all users of the library as well as library maintenance
• [ ] Considered if this can be a storybook or documentation example