Python list json conversion to list

Question

I have a list in the below format.

['111: {"id":"de80ca97","data":"test"}', '222: {"id":"8916a167","data":"touch"}', '333: {"id":"12966e98","data":"tap"}']

I need to remove the data column from above list / json and replace it with key value of the list.

I need to transform it to the below structure. Desired output:

[
    {
     "score":111,
     "id":"de80ca97"
    },
    {
     "score":222,
     "id":"8916a167"
    },
    {
     "score":333,
     "id":"12966e98"
    }
]

Any suggestions or ideas most welcome.

What have you tried, and where are you stuck?

monkut
– monkut

2020-06-22 05:26:34 +00:00
Commented Jun 22, 2020 at 5:26 — monkut
– monkut, Commented Jun 22, 2020 at 5:26
Few ideas: for-loop, str.split, json.loads.

bereal
– bereal

2020-06-22 05:37:10 +00:00
Commented Jun 22, 2020 at 5:37 — bereal
– bereal, Commented Jun 22, 2020 at 5:37

lmiguelvargasf · Accepted Answer · 2020-06-22 12:30:50Z

2

You can use a for loop or you can also use a list comprehension as follows:

>>> import json
>>> l = ['111: {"id":"de80ca97","data":"test"}', '222: {"id":"8916a167","data":"touch"}', '333: {"id":"12966e98","data":"tap"}']
>>> [{'score': int(e.split()[0][:-1]), 'id': json.loads(e.split()[1])['id']} for e in l]

If you prefer to use a for loop:

new_l = []
for e in l:
    key, json_str = e.split()
    new_l.append({'score': int(key[:-1]), 'id': json.loads(json_str)['id']})

edited Jun 22, 2020 at 12:30

answered Jun 22, 2020 at 5:42

lmiguelvargasf

71.2k55 gold badges231 silver badges239 bronze badges

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

1 Comment

bereal Over a year ago

You can do that with a single split: key, json_str = e.split(':', 1). In one-liner that may require the walrus operator.

Collectives™ on Stack Overflow

Python list json conversion to list

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related