python - 纯Python中dict的求和和计数列表

Question

关闭。这个问题需要多问 focused 。目前不接受答案。

---

想要改进此问题吗？更新问题，使其仅关注一个问题 editing this post .

已关闭 5 年前。

Improve this question

我需要帮助。

我有一个字典列表:

[{"title": "Report 1", "value": 1000, "commission": 2000, "user": "user_1"},

{"title": "Report 2", "value": 500, "commission": 300, "user": "user_1"},

{"title": "Report 3", "value": 1500, "commission": 300, "user": "user_2"}]

我需要对数值、按用户分组以及每个用户的总报告进行求和

[{"value": 1500, "commission": 2300, "user": "user_1", "total": 2},

{"value": 1500, "commission": 300, "user": "user_2", "total": 1}]

OBS:纯Python

Answer 1

使用非常简单的迭代方法。

演示:

data = [{"title": "Report 1", "value": 1000, "commission": 2000, "user": "user_1"},
{"title": "Report 2", "value": 500, "commission": 300, "user": "user_1"},
{"title": "Report 3", "value": 1500, "commission": 300, "user": "user_2"}]

d = {}
for i in data:
    if i['user'] not in d:
        d[i["user"]] = {"value": i["value"], "commission": i["commission"], "user": i['user'], "total": 1}
    else:
        d[i["user"]]["value"] += i["value"]
        d[i["user"]]["commission"] += i["commission"]
        d[i["user"]]["total"] += 1
print(d.values())

输出:

[{'commission': 300, 'total': 1, 'user': 'user_2', 'value': 1500}, {'commission': 2300, 'total': 2, 'user': 'user_1', 'value': 1500}]