Split array in json into mutiple objects in Python

Question

I have a JSON object which contains array fields. Now I want o extract the array and split it into multiple objects.

JSON object:-

{'catalog_num': 5,
    'data_array': ['16.1', 
                   '76.1', 
                   '14.1', 
                   '14.1'
                  ]
}

Now I want the split this json array into multiple objects

   {'catalog_num': 5,
    'data_id': '16.1'},

 {'catalog_num': 5,
    'data_id': '76.1'},

   {'catalog_num': 5,
    'data_id': '14.1'},

   {'catalog_num': 5,
    'data_id': '14.1'},

you mean different dict variables according to elements in data_id? — Neeraj
– Neeraj, Commented Apr 12, 2021 at 4:45
Consider the answers if they solve your problem and upvote them — Msv
– Msv, Commented Apr 12, 2021 at 5:14

exilour · Accepted Answer · 2021-04-12 04:59:17Z

2

In addition to @Sridhar's answer, you can do this with list comprehension with less code like this

data = {'catalog_num': 5,
        'data_array': ['16.1',
                       '76.1',
                       '14.1',
                       '14.1'
                       ]
        }


result = [{
    'catalog_num': data['catalog_num'],
    'data_id': data_id,
} for data_id in data['data_array']]

answered Apr 12, 2021 at 4:59

exilour

5565 silver badges13 bronze badges

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

3 Comments

Msv Over a year ago

maybe it's too advanced to talk about list comprehensions for newbies. Just an opinion :)

exilour Over a year ago

That is why I added it as an addition to your answer, your's is descriptive. He should know what options exist, I think.

Msv Over a year ago

Yeah nice job. see ya

Msv · Accepted Answer · 2021-04-12 05:13:15Z

0

please let me know if you have any other requirements

data = {'catalog_num': 5,
    'data_array': ['16.1', 
                   '76.1', 
                   '14.1', 
                   '14.1'
                  ]
}

objects_list = []

for data in data["data_array"]:
    object = {
       'catalog_num': data['catalog_num'],
       'data_id': data
    }
    objects_list.append(object)

print(objects_list)

edited Apr 12, 2021 at 5:13

answered Apr 12, 2021 at 4:51

Msv

1,41110 silver badges25 bronze badges

Collectives™ on Stack Overflow

Split array in json into mutiple objects in Python

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related