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? — taleinat
– taleinat, Commented Jan 13, 2016 at 5: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. — taleinat
– taleinat, Commented Jan 13, 2016 at 5:37

Yoav Glazner · Accepted Answer · 2016-01-13 05:37:12Z

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, 2016 at 5:37

Yoav Glazner

8,0511 gold badge22 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Tony Roczz Over a year ago

Is there a way not to replace the duplicate keys?

Yoav Glazner Over a year ago

using the reversed list will give you that - a[::-1] (its just replacing from the end to start :) )

Tony Roczz Over a year ago

how do i use the reversed list, should i use it as for small_dict in -a:

Yoav Glazner Over a year ago

@TonyRoczz - for small_dict in a[::-1]:

Community · Accepted Answer · 2017-05-23 11:44:57Z

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, 2017 at 11:44

CommunityBot

11 silver badge

answered Jan 13, 2016 at 5:47

alecxe

476k127 gold badges1.1k silver badges1.2k bronze badges

Collectives™ on Stack Overflow

How to merge multiple json in python

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related