merging dictionary based on their similar specific values

Question

I am trying to merge dictionary based on their similar specific values. Currently i have this dictionary:

    [{'max_score': '110', 'total_mark': '75', 'id': 1},
     {'max_score': '110', 'total_mark': '75', 'id': 2},
     {'max_score': '131', 'total_mark': '99', 'id': 1}, 
     {'max_score': '131', 'total_mark': '64', 'id': 2}]

and i am trying to merge them like:

    ['id': '1',
     'rec':[
             {'max_score': '110', 'total_mark': '75'},
             {'max_score': '131', 'total_mark': '99'}
           ],

     'id': '2',
     'rec':[
            {'max_score': '110', 'total_mark': '75'}, 
            {'max_score': '131', 'total_mark': '64'}
           ]
    ]

any help please. Thanks in advance.

Possible duplicate of [How to merge multiple dicts with same key?](https://stackoverflow.com/questions/5946236/how-to-merge-multiple-dicts-with-same-key) — Sociopath, Feb 12 '18 at 07:29
@javed your expected o/p is wrong, Because list cannot have `id:1` like values.Also if you make it `dict` the problem is `id` and `rec` are duplicate keys. — Vikas Periyadath, Feb 12 '18 at 07:30
i have updated my o/p sorry for the incorrect one. and "similar" mean here i want to merge the dict based on similar "id" so thats what similar defines here. — Javed, Feb 12 '18 at 07:34
@javed still your desired o/p is wrong one . May be you can try the format of o/p that in those two answers given below. — Vikas Periyadath, Feb 12 '18 at 07:35
Do you mean "identical", perhaps? "Similar" is not the same as "identical." — DYZ, Feb 12 '18 at 07:39
Why did you not refine your "ON HOLD" question https://stackoverflow.com/questions/48719814/merging-repeated-items-in-list-of-dictionary-in-python - instead you are asking something almost similar again? - just wondering b/c you accepet my answer on that one. I find (ab)using SO as iterative "CodeRefiner" distasteful. — Patrick Artner, Feb 12 '18 at 07:41
@DYZ In his expected o/p he group the dicts having the same id,. — Vikas Periyadath, Feb 12 '18 at 07:45
@VikasDamodar We should not be _guessing_ what the OP means. — DYZ, Feb 12 '18 at 07:46
@DYZ I'am not guessing , OP clearly said in his comment `similar id`, just see 4th comment. — Vikas Periyadath, Feb 12 '18 at 07:56
@VikasDamodar "Similar" means "resembling without being identical," not "same." That's exactly the problem. — DYZ, Feb 12 '18 at 07:57
i apologies for my English and this messy output all i wanted to merge the records based no their ids. — Javed, Feb 12 '18 at 08:05

Rakesh · Accepted Answer · 2018-02-12T07:51:20.563

1

You can do it using a simple forloop

x = [{'max_score': '110', 'total_mark': '75', 'id': 1},
     {'max_score': '110', 'total_mark': '75', 'id': 2},
     {'max_score': '131', 'total_mark': '99', 'id': 1}, 
     {'max_score': '131', 'total_mark': '64', 'id': 2}]

d = {}
for i in x:
    if i["id"] not in d:
        d[i["id"]] = {'rec': [{'max_score': i['max_score'], 'total_mark': i['total_mark']}]}
    else:
        d[i["id"]]['rec'].append({'max_score': i['max_score'], 'total_mark': i['total_mark']})

print d

Output:

{1: {'rec': [{'total_mark': '75', 'max_score': '110'}, {'total_mark': '99', 'max_score': '131'}]}, 2: {'rec': [{'total_mark': '75', 'max_score': '110'}, {'total_mark': '64', 'max_score': '131'}]}}

edited Feb 12 '18 at 07:51

answered Feb 12 '18 at 07:32

Rakesh

81,458
17
76
113

`for i in x: d.setdefault(i["id"],[]).append({'max_score': i['max_score'], 'total_mark': i['total_mark']})` to get rid of `if: ... else: ...` – Patrick Artner Feb 12 '18 at 07:40
can you please help me to iterate this record? the output is what i am expecting but i am not getting any way to retrieve the data. Help me to get the 'rec' of keys – Javed Feb 12 '18 at 08:02
@javed; again you can use a loop to get the "rec" list. example for i in d: print d[i]["rec"] – Rakesh Feb 12 '18 at 08:04
Thanks for the help. I am very new to python. I truly appreciate your help. – Javed Feb 12 '18 at 08:09

score 1 · Answer 2 · answered Feb 12 '18 at 07:46

    dict_data = {}
    for  val in data:
        score, mark, id_ = val
        if val[id_] in dict_data:
            dict_data[val[id_]]['rec'].append({"max_score":val[score],"total_mark":val[mark]})
        else:
            dict_data.setdefault(val[id_],{'rec':[{"max_score":val[score],"total_mark":val[mark]}]})
>>>{1: {'rec': [{'max_score': '75', 'total_mark': '110'},
                {'max_score': '99', 'total_mark': '131'}]},
   2: {'rec': [{'max_score': '75', 'total_mark': '110'},
               {'max_score': '64', 'total_mark': '131'}]}}

merging dictionary based on their similar specific values

2 Answers2