collect dictionairy values in python list

Question

I have a list which has dict values in it. I want to group by ts and collect other values. Please note that ts is common and will be there in all dictionaries in the list. But the other values like HP, BP can change in each dictionary. Please suggest.

input

[
{'ts': '2016-11-29 19:01', u'HP': 1}, 
{'ts': '2016-11-29 19:01', u'BP': 1}, 
{'ts': '2016-11-29 19:01', u'AP': 1}, 
{'ts': '2016-11-29 19:02', u'HP': 1},
{'ts': '2016-11-29 19:02', u'AP': 1}
]

output

[
{'ts': '2016-11-29 19:01', u'HP': 1, u'BP': 1,u'AP': 1  }, 
{'ts': '2016-11-29 19:02', u'HP': 1, u'AP': 1} 
]

What if there are more than one `HP` corresponding to a `ts`? — thefourtheye, Nov 30 '16 at 08:01
Is the condition "collate dictionary if it contains `ts` as a key"? — Ébe Isaac, Nov 30 '16 at 08:02
I dont want to give -1 but as @KlausD. said what did you tried? — obayhan, Nov 30 '16 at 08:05

Ahsanul Haque · Accepted Answer · 2016-12-01T04:19:33.310

0

You can use itertools.groupby()

from itertools import groupby

result = []
for _, v in groupby(a,lambda x:x['ts']):
    temp_dict = {}
    for dic in v:
        temp_dict.update(dic)
    result.append(temp_dict)

print result

Output:

[
 {u'AP': 1, u'HP': 1, u'BP': 1, 'ts': '2016-11-29 19:01'}, 
 {u'AP': 1, u'HP': 1, 'ts': '2016-11-29 19:02'}
]

edited Dec 01 '16 at 04:19

answered Nov 30 '16 at 08:22

Ahsanul Haque

9,145
2
27
48

Kool, thanks Ahsanul, Works fine – Venkat Venkat Nov 30 '16 at 20:53

collect dictionairy values in python list

1 Answers1