alekwisnia
alekwisnia

Reputation: 2354

Python compute running sum of values in one-line

I try to process such data:

some_data = [
                {'value': 2, 'date':'2016-02-06'},
                {'value': 1, 'date':'2016-02-07'},
                {'value': 5, 'date':'2016-02-08'},
                {'value': 3, 'date':'2016-02-09'},
                {'value': 1, 'date':'2016-02-10'},
            ]

So that it produces a list with values updated to be a running sum. Now I do it with a multiline loop:

def values_incremented(some_data):
    temp_sum = 0
    result = []
    for element in some_data:
        temp_sum += element['value']
        result.append({'value': temp_sum, 'date': element['date']})
    return result

How to make the loop one-liner, so that I got:

return [{'value': somehow_incremented, 'date': element['date']} for element in some_data]

Upvotes: 6

Views: 2273

Answers (3)

topkara
topkara

Reputation: 896

Here's a one liner that runs in linear time:

reduce(lambda (c,s), a: (c + [{'value':s+a['value'], 'date':a['date']}], s+a['value']), some_data,([],0))[0]

>>> [{'date': '2016-02-06', 'value': 2},
    {'date': '2016-02-07', 'value': 3},
    {'date': '2016-02-08', 'value': 8},
    {'date': '2016-02-09', 'value': 11},
    {'date': '2016-02-10', 'value': 12}]

You should look at the other running total question for a simpler version of the same problem.

Upvotes: 1

Karoly Horvath
Karoly Horvath

Reputation: 96258

I wouldn't recommend doing anything, your code is fine. Keep it readable.

That being said, here's an approach:

def values_incremented(some_data):
    return [{'value': current_sum, 'date': element['date']}
      for element, current_sum
      in zip(some_data,
           reduce(lambda x, y: [y['value']] if not x else x + [x[-1] + y['value']], some_data, []))]

Upvotes: 3

tobias_k
tobias_k

Reputation: 82889

You could write yourself an accumulating generator function. Use send to send values into the generator and get the new sum.

def accumulator(n=0):
    while True:
        n += yield n

acc = accumulator(0)
acc.send(None)

res = [{'value': acc.send(element['value']), 'date': element['date']} for element in some_data]

As a result, res is

[{'value': 2, 'date': '2016-02-06'}, 
 {'value': 3, 'date': '2016-02-07'}, 
 {'value': 8, 'date': '2016-02-08'}, 
 {'value': 11, 'date': '2016-02-09'}, 
 {'value': 12, 'date': '2016-02-10'}]

Upvotes: 6

Related Questions