I’m having a really, really empty head day and would appreciate some help. I have an array of data in the following format : [ { "name" : "Dave", "group" : "grpdata1", "type" : "typedata", "totals" : 1500 }, { next row.. } ] and it’s displayed in tabular form : Custom…

So that now looks more like: from itertools import groupby test = [ {"name": "Dave", "group": "grpdata1", "type": "typedata", "totals": 1500}, {"name": "Owen", "group": "grpdata1", "type": "typedata2", "totals": 2000}, ] def grouper(item): return (item["name"], item["group"]) resul…

Blog Tutorials Examples Features Pricing Forum Docs Start Building

Anvil Community Forum

Working out summaries

Anvil Q&A

owen.campbell April 1, 2020, 11:19am 2

I reckon you need either itertools.groupby or pandas.DataFrame.groupby

2 Likes

Pivot a column in list of dictionaries