Python parsing json from string

Question

I need to parse json from a partial string I get back from a web service. I have the following snippet of code which is working fine but is extremely ugly. Is there a better or cleaner way to do this?

x = '"1":{"name":"item one","code":"1"},"2":{"name":"item two","code":"2"},"3":{"name":"item three","code":"3"}'
split = x.split('},')
index = 0
for s in split:
    split[index] = '{' + s + '}}'
    index += 1
joined = ','.join(split)
joined = '[' + joined[:-1] + ']'
j = json.loads(joined)
print(j)

Here is the result:

[{'1': {'name': 'item one', 'code': '1'}},
 {'2': {'name': 'item two', 'code': '2'}},
 {'3': {'name': 'item three', 'code': '3'}}]

Can't you just do x = json.loads("{" + x + "}") then do whatever you like with it as a dict? — JonSG
– JonSG, Commented Aug 31, 2021 at 0:24
The first thing I would do is find out if the web service can be changed to return real JSON. — wim
– wim, Commented Aug 31, 2021 at 1:02
@Selcuk Yes, that is not a complete solution, but I see you were able to use it as the core of your solution which was my intention. — JonSG
– JonSG, Commented Aug 31, 2021 at 13:37

Selcuk · Accepted Answer · 2021-08-31 00:50:15Z

3

You can use the following snippet:

>>> [dict([t]) for t in json.loads(f"{{{x}}}").items()]
[{'1': {'name': 'item one', 'code': '1'}},
 {'2': {'name': 'item two', 'code': '2'}},
 {'3': {'name': 'item three', 'code': '3'}}]

answered Aug 31, 2021 at 0:50

Selcuk

60.1k12 gold badges114 silver badges119 bronze badges

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

Comments

DYZ · Accepted Answer · 2021-08-31 01:24:28Z

2

You can fix the inconsistency by hand (add the missing braces) and use json module to parse:

data = json.loads('{' + x + '}')

Then you can convert the parsed data to the desired representation:

[{item[0]: item[1]} for item in data.items()]

#[{'1': {'name': 'item one', 'code': '1'}}, 
# {'2': {'name': 'item two', 'code': '2'}}, 
# {'3': {'name': 'item three', 'code': '3'}}]

Otherwise, you will end up implementing your own JSON parser, which is not trivial.

edited Aug 31, 2021 at 1:24

answered Aug 31, 2021 at 0:24

DYZ

57.3k10 gold badges73 silver badges101 bronze badges

Collectives™ on Stack Overflow

Python parsing json from string

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related