CODEWITHSUNDEEP
pythonjson
venkat
venkat

Reputation: 1263

Combine json based on Key value using python

I have two JSON strings as sample: 

json_1 = [
    {
        "breadth": 48.04,
        "vessel_id": 1, 
        "vessel_name": "SHIP-01", 
        "vessel_type": "Crude Oil Tanker", 
        "year_built": 2012
     },
     {
        "breadth": 42,
        "vessel_id": 2,
        "vessel_name": "SHIP-02",
        "vessel_type": "Crude Oil Tanker",
        "year_built": 2016
     }
]

json_2 = [
    {
        "Ballast_miles": 43575.8,
        "Ballast_miles_pct": 36.1,
        "org_id": 1,
        "port_days": 383.5,
        "sea_days": 414.9,
        "total_days": 798.4,
        "vessel_id": 1
    },
    {
        "Ballast_miles": 21642.7,
        "Ballast_miles_pct": 29.8,
        "org_id": 1, 
        "port_days": 325.7,
        "sea_days": 259.8,
        "total_days": 585.5,
        "vessel_id": 2
    }
]

I want to combine these two JSON based on vessel_id.

My output format should look like:

[{ vesselId: 1,
 json1:{},
 json2:{}
},
{ vesselId: 2,
 json1:{},
 json2:{}
}]

What I've tried so far is:

data = {'First_Json': json_1, 'Second_Json': json_2}
json.dumps(data)

But this combines entirely without checking based on vessel_id.

Upvotes: 0

Views: 62

Answers (1)

ExplodingGayFish
ExplodingGayFish

Reputation: 2897

Something like this?

json_1 = [{ "breadth": 48.04, "vessel_id": 1, "vessel_name": "SHIP-01", "vessel_type": "Crude Oil Tanker", "year_built": 2012 }, { "breadth": 42,  "vessel_id": 2, "vessel_name": "SHIP-02", "vessel_type": "Crude Oil Tanker", "year_built": 2016 }]
json_2 = [{ "Ballast_miles": 43575.8, "Ballast_miles_pct": 36.1, "org_id": 1, "port_days": 383.5, "sea_days": 414.9, "total_days": 798.4, "vessel_id": 1 }, { "Ballast_miles": 21642.7, "Ballast_miles_pct": 29.8,  "org_id": 1, "port_days": 325.7, "sea_days": 259.8, "total_days": 585.5, "vessel_id": 2 }] 

from collections import defaultdict
result = defaultdict(dict)
for item in json_1:
    result[item['vessel_id']]['json_1'] = item
for item in json_2:
    result[item['vessel_id']]['json_2'] = item

[{"vessel_id" : k,
  "json1" : v['json_1'],
  "json2" : v['json_2']}
    for k,v in result.items()]

Output:

[{'json1': {'breadth': 48.04,
   'vessel_id': 1,
   'vessel_name': 'SHIP-01',
   'vessel_type': 'Crude Oil Tanker',
   'year_built': 2012},
  'json2': {'Ballast_miles': 43575.8,
   'Ballast_miles_pct': 36.1,
   'org_id': 1,
   'port_days': 383.5,
   'sea_days': 414.9,
   'total_days': 798.4,
   'vessel_id': 1},
  'vessel_id': 1},
 {'json1': {'breadth': 42,
   'vessel_id': 2,
   'vessel_name': 'SHIP-02',
   'vessel_type': 'Crude Oil Tanker',
   'year_built': 2016},
  'json2': {'Ballast_miles': 21642.7,
   'Ballast_miles_pct': 29.8,
   'org_id': 1,
   'port_days': 325.7,
   'sea_days': 259.8,
   'total_days': 585.5,
   'vessel_id': 2},
  'vessel_id': 2}]

If you want to remove the redundant vessel_id, try using for loop with a del command on each dict

Upvotes: 2

Related Questions