Hi guys! Things are starting to fall in place, thanks to you all! There is one thing I’m not able to fix in my data. I’ve got that nice list of dictionaries for my repeating panel. But I would like to pivot/flip the elements of ‘username’ in 2 different column. [{'period': 'Period 2020-08-01 to…

I guess it depends on the complexity of the data structure you might find pandas pivot useful or for your example something simpler like my_table = [{'period': 'Period 2020-08-01 to 2020-07-31', 'status': 'Open', 'username': 'Jane', 'amount': 180.32}, {'period': 'Period 2020-08-01 to…

Pivot a column in list of dictionaries

Anvil Q&A

stucork July 31, 2020, 12:14am 6

You can use

my_new_dict.update({'date': somedate, 'status':somestatus})

You may also wish to check out itertools groupby

Here are some posts with related data manipulations and have itertools solutions