How to merge/append two json array list in python in a specific way

Question

I have two list of Json array output,

x =

[
    {
        "id": "5019",
        "tiClass": "Device",
        "tiSubclass": "Virtual Machine",
        "cmbStatus": "Planned",
        "cmbUPosition": "",
        "Subnet Mask": null
    },
    {
        "id": "5020",
        "tiClass": "Device",
        "tiSubclass": "Virtual Machine",
        "cmbStatus": "Planned",
        "cmbUPosition": "",
        "cmbType": "Virtual LoadBalancer",
        "Subnet Mask": null
    }
]

y =

[
    {
        "dataports": [
            {
                "itemId": 5019,
                "portId": 12614,
                "used": false,
                "reserved": false,
                "type": "Virtual"
            },
            {
                "itemId": 5019,
                "portId": 12615,
                "used": false,
                "reserved": false,
                "type": "Virtual"
            }            
            
        ]
    },
    {
        "dataports": [
            {
                "itemId": 5020,
                "portId": 12615,
                "used": false,
                "reserved": false,
                "type": "Virtual"
            }
        ]
    }
]

the way i want the result is:

result =

[
    {
        "id": "5019",
        "tiClass": "Device",
        "tiSubclass": "Virtual Machine",
        "cmbStatus": "Planned",
        "cmbUPosition": "",
        "Subnet Mask": null,
        "dataports": [
            {
                "itemId": 5019,
                "portId": 12614,
                "used": false,
                "reserved": false,
                "type": "Virtual"
            },
            {
                "itemId": 5019,
                "portId": 12615,
                "used": false,
                "reserved": false,
                "type": "Virtual"
            }            
            
        ]
    },
    {
        "id": "5020",
        "tiClass": "Device",
        "tiSubclass": "Virtual Machine",
        "cmbStatus": "Planned",
        "cmbUPosition": "",
        "cmbType": "Virtual LoadBalancer",
        "Subnet Mask": null,
        "dataports": [
            {
                "itemId": 5020,
                "portId": 12615,
                "used": false,
                "reserved": false,
                "type": "Virtual"
            }
        ]
    }
]

i have tried result = x+y but the result output is not what i am looking for. i have searched SO for any references/examples that will suit to my use case but couldn't find. Can anyone suggest the right way to get above result output (list Y should be appended/added to list x )

dawg · Accepted Answer · 2022-03-15 18:52:34Z

1

With your examples, you need to merge each sub dict in the list like so:

x=json.load(open("/tmp/x"))
y=json.load(open("/tmp/y"))
your_result=json.load(open("/tmp/your_result"))

n=[{**x_, **y_} for x_,y_ in zip(x,y)]

>>> n==your_result
True

answered Mar 15, 2022 at 18:52

dawg

105k24 gold badges142 silver badges217 bronze badges

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

2 Comments

netv Over a year ago

thank you . i got the desired output. But i would like to know the logic behind {**x_, **y_} , ```**`` . Can you please explain. Thanks a ton.

dawg Over a year ago

It is the older (but more obscure) way to merge dictionaries. In Python 3.9 you have d | other but versions of Python 3.5+ support {**d, **other} to merge those two dicts into a new dict. Covered in PEP 584 and PEP 448

Collectives™ on Stack Overflow

How to merge/append two json array list in python in a specific way

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related