How to separate json with lists as values into separate json objects with python?

Question

So, I am trying to achieve the following. I have a json with following structure:

json = {'key1':[value11,value12], 'key2':[value12, value22]}

I want to separate each value in particular key to from a separate json while retaining its key as follows:

json1 = {'key1':value11,'key2':value12}
json2 = {'key1':value12,'key2':value22}

Builtin json module does not seems to help

Do all the lists have the same length? What happens, if they don't have? — Brizar
– Brizar, Commented Nov 18, 2019 at 9:38
They always always have same length. Incase they don't, then logically the later jsons values should be None — Hamza
– Hamza, Commented Nov 18, 2019 at 9:41
Perhaps you want a list of those dict objects instead of separate variables? — Diptangsu Goswami
– Diptangsu Goswami, Commented Nov 18, 2019 at 9:45
[{key:json[key]} for key in json.keys()] shouldn't this be enough? — Abhyudai
– Abhyudai, Commented Nov 18, 2019 at 10:05

Brizar · Accepted Answer · 2019-11-18 10:27:06Z

1

Its hacky and I could not figure out to use the inline for loops, but it works for me: I first created the empty array, and due to the for loops you should be able to catch the case if sth should be none...

json = {'key1':[11, 12], 'key2':[21, 22]}
max_len = max([len(json[key]) for key in json.keys()])
data = [{}] * max_len
# data = [{} for _ in range(max_len)]
for i in range(max_len):
    for key in json.keys():
        data[i][key] = json[key][i] if json[key][i] else None
print(data)

gives:

[{'key1': 11, 'key2': 21}, {'key1': 12, 'key2': 22}]

edited Nov 18, 2019 at 10:27

answered Nov 18, 2019 at 10:07

Brizar

1411 silver badge11 bronze badges

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

Collectives™ on Stack Overflow

How to separate json with lists as values into separate json objects with python?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related