Merge two json file using Python

Question

I'm new to python. Can anyone help in solving this problem? I have this problem to merge json a and json b using unique id

a = [{'id': 1, 'name': 'a', 'e_data': {'reading':'', 'writing':''}},
    {'id': 2, 'name': 'b', 'e_data': {'reading':'', 'writing':''}}]

b = [{'id':1,'reading':'2','writing':'3'}, 
    {'id':2,'reading':'3','writing':'3'}]

Output

[{'id': 1,'name': 'a','e_data':{'reading':'2','writing':'3'}},{'id': 2,'name': 'b','e_data':{'reading':'3','writing':'3'}}]

Underoos · Accepted Answer · 2019-12-26 04:36:49Z

1

Try this.

a = [{'id': 1, 'name': 'a', 'e_data': {'reading':'', 'writing':''}},
    {'id': 2, 'name': 'b', 'e_data': {'reading':'', 'writing':''}}]

b = [{'id':1,'reading':'2','writing':'3'},
    {'id':2,'reading':'3','writing':'3'}]

for i in a:
    for j in b:
        if j['id'] == i['id']:
            i['e_data'].update(j)
            i['e_data'].pop('id')

print(a)

Output:

[{'id': 1, 'name': 'a', 'e_data': {'reading': '2', 'writing': '3'}}, {'id': 2, 'name': 'b', 'e_data': {'reading': '3', 'writing': '3'}}]

answered Dec 26, 2019 at 4:36

Underoos

5,2769 gold badges55 silver badges106 bronze badges

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

Comments

ExplodingGayFish · Accepted Answer · 2019-12-26 04:08:18Z

0

Here is one simple way:

a = [{'id': 1, 'name': 'a', 'e_data': {'reading':'', 'writing':''}},
    {'id': 2, 'name': 'b', 'e_data': {'reading':'', 'writing':''}}]

b = [{'id':1,'reading':'2','writing':'3'}, 
    {'id':2,'reading':'3','writing':'3'}]

for dest in a:
    for source in b:
        if source['id'] == dest['id']:
            dest['e_data'].update(source)
a  

#[{'e_data': {'id': 1, 'reading': '2', 'writing': '3'}, 'id': 1, 'name': 'a'},
#{'e_data': {'id': 2, 'reading': '3', 'writing': '3'}, 'id': 2, 'name': 'b'}]

answered Dec 26, 2019 at 4:08

ExplodingGayFish

2,9071 gold badge8 silver badges14 bronze badges

Collectives™ on Stack Overflow

Merge two json file using Python

Output

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Output

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related