Merging a list of dictionaries to json

Question

I am trying to merge a list of dictionaries into a single json object to be consumed by another json parser.

Here is my list which I fetched from a requests.get:

list = [{"name":"New York USA"}, {"id":446}]

Desired Output:

{
  "org": {
    "name": "New York USA",
    "id": 446
  }
}

@jizhihaoSAMA please use normal quotes, when you edit his post. Original Post has normal Quotes — demonking, Jun 22 '20 at 11:21
Does this answer your question? [Python: converting a list of dictionaries to json](https://stackoverflow.com/questions/21525328/python-converting-a-list-of-dictionaries-to-json) — Itamar Mushkin, Jun 22 '20 at 11:28
Hi, and welcome to Stack Overflow. In the future, please search Stack Overflow for similar questions. — Itamar Mushkin, Jun 22 '20 at 11:29
The title "Converting a list of dictionaries to json" doesn't currently describe the specifics described in the body, which is more of a problem of building a single object from a list of dictionaries and then converting that to JSON. — Paul, Jun 22 '20 at 11:29
@Paul oh, can you edit / suggest an edit to the title then? And maybe find another dupe... — Itamar Mushkin, Jun 22 '20 at 12:05
@demonking If you see the timeline of the post,you will find he didn't use the normal quote,I just added some backquotes. — jizhihaoSAMA, Jun 22 '20 at 12:18

score 1 · Answer 1 · answered Jun 22 '20 at 11:54

1

Another solution would be Using dictionary comprehension (Note: This solution will work even if dict has multiple keys and values)

list = [{"name":"New York USA"}, {"id":446}]
data = {}
data['org'] = {key:value for item in list for key, value in item.items()}
print(data)

output: {'org': {'name': 'New York USA', 'id': 446}}

answered Jun 22 '20 at 11:54

Shivam Seth

677
1
8
21

@user3558255, If this solution really solved your problem, Please accept this answer – Shivam Seth Jul 22 '20 at 20:02

score 0 · Answer 2 · answered Jun 22 '20 at 11:20

0

You can use the builtin json library

import json

list_of_dicts = [{},{}]

json_rep = json.dumps(list_of_dicts)

answered Jun 22 '20 at 11:20

James Burgess

487
1
4
12

Does this code producing desired output? I tried this code, It is producing output same as input – Shivam Seth Jun 22 '20 at 11:55

score 0 · Answer 3 · answered Jun 22 '20 at 11:50

First merge your all dictionaries in list then, make a new dictionary thn dumps it with json.please try this below

import json
list = [{"name":"New York USA"}, {"id":446}]
def Merge(dict1, dict2): 
   res = {**dict1, **dict2} 
   return res 
dic=Merge(list[0],list[1])
print(dic)
new_json={'org':dic}
json_rep = json.dumps(new_json)
print(json_rep)

output

'{"org": {"name": "New York USA", "id": 446}}'

Merging a list of dictionaries to json

3 Answers3