Mr.Roboto - 1 year ago 77
Python Question

# Sum numbers by letter in list of tuples

I have a list of tuples:

``````[ ('A',100), ('B',50), ('A',50), ('B',20), ('C',10) ]
``````

I am trying to sum up all numbers that have the same letter. I.e. I want to output

``````[('A', 150), ('B', 70), ('C',10)]
``````

I have tried using set to get the unique values but then when I try and compare the first elements to the set I get

``````TypeError: unsupported operand type(s) for +: 'int' and 'str'
``````

Any quick solutions to match the numbers by letter?

Here is a one(and a half?)-liner: group by letter (for which you need to sort before), then take the sum of the second entries of your tuples.

``````from itertools import groupby
from operator import itemgetter

data = [('A', 100), ('B', 50), ('A', 50), ('B', 20), ('C', 10)]
res = [(k, sum(map(itemgetter(1), g)))
for k, g in groupby(sorted(data, key=itemgetter(0)), key=itemgetter(0))]
print(res)
// => [('A', 150), ('B', 70), ('C', 10)]
``````

The above is O(n log n) — sorting is the most expensive operation. If your input list is truly large, you might be better served by the following O(n) approach:

``````from collections import defaultdict

data = [('A', 100), ('B', 50), ('A', 50), ('B', 20), ('C', 10)]

d = defaultdict(int)
for letter, value in data:
d[letter] += value
res = list(d.items())
print(res)
// => [('B', 70), ('C', 10), ('A', 150)]
``````
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download