get same value for keys into another dictionary from List of Dictionary

Question

Here is my list of dictionary.

d = [{'count': '100', 'zone': 'PIMPRI', 'cycle': '15'},
     {'count': '50', 'zone': 'PIMPRI', 'cycle': '15'},
     {'count': '150', 'zone': 'PIMPRI', 'cycle': '30'}]

How can I get output like below:

d_one = [{'count': '100', 'zone': 'PIMPRI', 'cycle': '15'},
         {'count': '50', 'zone': 'PIMPRI', 'cycle': '15'}]

d_two = [{'count': '150', 'zone': 'PIMPRI', 'cycle': '30'}]

Getting distinct data from list of dictionary from two keys zone and cycle. For same zone and cycle pair create one list of dictionary and it goes till end.

What have you tried, and what exactly is the problem with it? — jonrsharpe, May 28 '18 at 09:43
I am using django framework. So by using its ORM it gives me list of dictionary which I have given in d variable. So I will get variable data and list items too. Sometimes I may have 1 item in it or 50 too. So I want create new dictionary of same values of zone and cycle key. If total pair is 3 or 5 then dictionary should get created respectiely — Luffy, May 28 '18 at 09:53
That doesn't answer my question at all: where's your attempt to implement this functionality? SO isn't a code-writing service. — jonrsharpe, May 28 '18 at 09:54
My dear friend, of course I tried something which was not working. I tried something as doing looping and then comparing but the problem was that I was not on the right way as I had no clue what to do with this. That's why I called for help. Hope you understand. Thanks — Luffy, Aug 14 '18 at 13:56

score 1 · Accepted Answer · answered May 28 '18 at 09:50

1

Make a dict using pairs (dct['zone'], dct['cycle']) as keys:

>>> result = {}
>>> 
>>> for dct in d:
...     result.setdefault((dct['zone'], dct['cycle']), []).append(dct)
... 
>>> result
{('PIMPRI', '15'): [{'count': '100', 'zone': 'PIMPRI', 'cycle': '15'}, {'count': '50', 'zone': 'PIMPRI', 'cycle': '15'}], ('PIMPRI', '30'): [{'count': '150', 'zone': 'PIMPRI', 'cycle': '30'}]}

answered May 28 '18 at 09:50

Paul Panzer

51,835
3
54
99

I modified code a bit and done with this approach. Thanks all and sorry for late comment. – Luffy Aug 14 '18 at 13:53

score 0 · Answer 2 · answered May 28 '18 at 09:41

You want to filter your data :

d_one = filter(lambda d:d['cycle']=='15',d)
> [{'count': '100', 'zone': 'PIMPRI', 'cycle': '15'}, 
>  {'count': '50', 'zone': 'PIMPRI', 'cycle': '15'}]

and

d_two = filter(lambda d:d['cycle']=='30',d)
> [{'count': '150', 'zone': 'PIMPRI', 'cycle': '30'}]

score 0 · Answer 3 · answered May 28 '18 at 09:42

One approach is to use collections. And have your variable('cycle') as key in a dict.

Ex:

import collections 
res = collections.defaultdict(list)
d = [{'count': '100', 'zone': 'PIMPRI', 'cycle': '15'},
     {'count': '50', 'zone': 'PIMPRI', 'cycle': '15'},
     {'count': '150', 'zone': 'PIMPRI', 'cycle': '30'}]

for i in d:
    res[i["cycle"]].append(i)
print(res['15'])
print("-----")
print(res['30'])

Output:

[{'count': '100', 'zone': 'PIMPRI', 'cycle': '15'}, {'count': '50', 'zone': 'PIMPRI', 'cycle': '15'}]
-----
[{'count': '150', 'zone': 'PIMPRI', 'cycle': '30'}]

Rahul K P · Answer 4 · 2018-05-28T10:27:13.753

0

Try with groupby,

from itertools import groupby 
from operator import itemgetter
grouper = itemgetter("cycle", "zone")
dict_one,dict_two = (list(g) for _,g in groupby(d,key=grouper))

The code will return a tuple now we have only 2 elements. So the value assignment will work here. If you have more values you can assign these values to a dict or store as iterable.

Output

In [9]: dict_one
Out[9]: 
[{'count': '100', 'cycle': '15', 'zone': 'PIMPRI'},
 {'count': '50', 'cycle': '15', 'zone': 'PIMPRI'}]

In [10]: dict_two
Out[10]: [{'count': '150', 'cycle': '30', 'zone': 'PIMPRI'}]

edited May 28 '18 at 10:27

answered May 28 '18 at 09:47

Rahul K P

15,740
4
35
52

what if more values ? and not only cycle, zone also he specified. – Vikas Periyadath May 28 '18 at 09:47
@VikasDamodar OP described two values, So a specific solution written here. Anyway if you have more values. We can get as iterable. – Rahul K P May 28 '18 at 09:49
what about zone ? – Vikas Periyadath May 28 '18 at 09:54
see OP's comment he may have more values . – Vikas Periyadath May 28 '18 at 09:55
Updated the answer. And he can add more values in `grouper`. – Rahul K P May 28 '18 at 09:55
here you have only dict_one and dict_two, what if he has more than two group of data ? – Vikas Periyadath May 28 '18 at 09:58
Please read OP's comment in question, he is said he may have more values. – Vikas Periyadath May 28 '18 at 10:01
that doesn't answer the question – Vikas Periyadath May 28 '18 at 10:02

score 0 · Answer 5 · answered May 28 '18 at 09:48

Why to use separate dictionaries for all those values. Couldn't you make it to a single dictionary. For your example,

d = [{'count': '100', 'zone': 'PIMPRI', 'cycle': '15'},
     {'count': '50', 'zone': 'PIMPRI', 'cycle': '15'},
     {'count': '150', 'zone': 'PIMPRI', 'cycle': '30'}]

this is what we could get,

res = {}
for ele in d:
    res.setdefault((ele['cycle'],ele['zone']), [])
    res[(ele['cycle'], ele['zone'])].append(ele['count'])

get same value for keys into another dictionary from List of Dictionary

5 Answers5