The following is a list of lists. How do I add the sums of just "Total Black" and Total Color" into one list keeping just "Account ID" and "Account Name" the same?
[[{'Total Black': 3, 'Total Color': 2, 'Account ID': '2222', 'Account Name': 'Moe'},
{'Total Black': 5, 'Total Color': 4, 'Account ID': '3333', 'Account Name': 'Larry'},
{'Total Black': 9, 'Total Color': 6, 'Account ID': '4444', 'Account Name': 'Curly'}],
[{'Total Black': 8, 'Total Color': 4, 'Account ID': '2222', 'Account Name': 'Moe'},
{'Total Black': 2, 'Total Color': 7, 'Account ID': '3333', 'Account Name': 'Larry'},
{'Total Black': 11, 'Total Color': 9, 'Account ID': '4444', 'Account Name': 'Curly'}]]
So the result would be:
[{'Total Black': 11, 'Total Color': 6, 'Account ID': '2222', 'Account Name':
'Moe'}, {'Total Black': 7, 'Total Color': 11, 'Account ID': '3333', 'Account
Name': 'Larry'}, {'Total Black': 20, 'Total Color': 15, 'Account ID': 4444,
'Account Name': 'Curly'}]
解决方案
Let's use pandas.
#From @C14L setup:
li = [
[
{'Total Black': 3, 'Total Color': 2, 'Account ID': '2222', 'Account Name': 'Moe'},
{'Total Black': 5, 'Total Color': 4, 'Account ID': '3333', 'Account Name': 'Larry'},
{'Total Black': 9, 'Total Color': 6, 'Account ID': '4444', 'Account Name': 'Curly'}
],
[
{'Total Black': 8, 'Total Color': 4, 'Account ID': '2222', 'Account Name': 'Moe'},
{'Total Black': 2, 'Total Color': 7, 'Account ID': '3333', 'Account Name': 'Larry'},
{'Total Black': 11, 'Total Color': 9, 'Account ID': '4444', 'Account Name': 'Curly'}
]
]
pd.concat([pd.DataFrame(li[i]) for i in range(len(li))])\
.groupby(['Account ID','Account Name'])\
.sum()\
.reset_index()\
.to_dict(orient='records')
Output:
[{'Account ID': '2222',
'Account Name': 'Moe',
'Total Black': 11,
'Total Color': 6},
{'Account ID': '3333',
'Account Name': 'Larry',
'Total Black': 7,
'Total Color': 11},
{'Account ID': '4444',
'Account Name': 'Curly',
'Total Black': 20,
'Total Color': 15}]
Details:
First we use list comprehension and the pandas dataframe constructor to build dataframes for each element of your original list of list with dictionaries.
Next, use pd.concat to put these two, in this case dataframes together into one combined dataframe.
Use groupby with sum to aggregate values of Total Color and Total Black.
Lastly, reset index and to_dict to output combined dataframe as a dictionary.