How to merge multiple json in python

Question

I have a list which holds multiple json strings like this

a = [{"name": "Alex"},{"Age": 25},{"Address": "16, Mount View"}]

I would like to merge these into a single array like this

a = [{"name": "Alex","Age": 25,"Address": "16, Mount View"}]

I have tried using jsonmerge but no luck its working fine when using head' andbase` values.

Can some one give me a hand in this.

I have also gone through a similar question in stack but it shows merge for separate json but not json in a list How to merge two json

Possible duplicate of [How do I merge a list of dicts into a single dict?](http://stackoverflow.com/questions/3494906/how-do-i-merge-a-list-of-dicts-into-a-single-dict) — taleinat, Jan 13 '16 at 05:35
This has nothing to to with JSON, since at this point you simply have a list of Python dictionary objects. There are already many answers on how to merge a list of dicts together, e.g. [the answers to this SO question](http://stackoverflow.com/questions/3494906/how-do-i-merge-a-list-of-dicts-into-a-single-dict). — taleinat, Jan 13 '16 at 05:37

score 3 · Answer 1 · answered Jan 13 '16 at 05:37

3

First, these are python dicts

[{"name": "Alex"},{"Age": 25},{"Address": "16, Mount View"}]

you may call json.dumps on them and turn them into "json strings".

2nd, you can use the dict update method

a =  [{"name": "Alex"},{"Age": 25},{"Address": "16, Mount View"}]
d = {}
for small_dict in a:
    d.update(small_dict)
print(d) # Yay!
a = [d]

Be warned! , if you have duplicate keys they will override each other

Also take a look on "ChainMap"

https://docs.python.org/3/library/collections.html#collections.ChainMap

answered Jan 13 '16 at 05:37

Yoav Glazner

7,936
1
19
36

Is there a way not to replace the duplicate keys? – Tony Roczz Jan 13 '16 at 05:55
using the reversed list will give you that - a[::-1] (its just replacing from the end to start :) ) – Yoav Glazner Jan 13 '16 at 05:59
how do i use the reversed list, should i use it as `for small_dict in -a:` – Tony Roczz Jan 13 '16 at 06:15
@TonyRoczz - for small_dict in a[::-1]: – Yoav Glazner Jan 13 '16 at 07:36

score 2 · Answer 2 · edited May 23 '17 at 11:44

2

To add to the @yoav glazner's answer and if you are on Python 3.3+, you can use ChainMap:

>>> from collections import ChainMap
>>> a = [{"name": "Alex"},{"Age": 25},{"Address": "16, Mount View"}]
>>> dict(ChainMap(*a))
{'name': 'Alex', 'Age': 25, 'Address': '16, Mount View'}

See more about the ChainMap use cases here:

What is the purpose of collections.ChainMap?

edited May 23 '17 at 11:44

Community

1
1

answered Jan 13 '16 at 05:47

alecxe

462,703
120
1,088
1,195

How to merge multiple json in python

2 Answers2