使用
collections.defaultdict
from collections import defaultdict
main_list = [["user1@test.com", "Administration", "100"],
["user2@test.com", "Testing", "30"],
["user2@test.com", "Development", "45"],
["user2@test.com", "Development", "90"],
["user2@test.com", "Development", "35"],
["user3@test.com", "Development", "400"],
["user3@test.com", "Administration", "95"],
["user3@test.com", "Testing", "200"]]
result = defaultdict(int)
for k, v, n in main_list:
result[(k, v)] += int(n)
result = [list(k) + [v] for k, v in result.items()]
print(result)
输出:
[['user1@test.com', 'Administration', 100],
['user2@test.com', 'Testing', 30],
['user2@test.com', 'Development', 170],
['user3@test.com', 'Development', 400],
['user3@test.com', 'Administration', 95],
['user3@test.com', 'Testing', 200]]