String to Json Python

Question

Print(Json_text)
'{\n                    \n                        acorn: "",\n                        acorn_type: "",\n                        area_name: "Glasgow",\n                        beds_max: 2,\n                        beds_min: 2,\n }

I tried to solve it doing:

json_text = re.sub(r'\n', '',json_text)
json_text = re.sub(r' ', '',json_text)

then the results:

print(json_text)
'{acorn:"",acorn_type:"",area_name:"Glasgow",beds_max:2,beds_min:2,branch_id:"32896"}

then I tried to convert to Json Format:

json_text= json.dumps(json_text)
json_text = json.loads(json_text)

But the final value is an string.

json_text['area_name']
TypeError: string indices must be integers

i think is because the Key values don't have quotations ("")

It's not valid JSON, the string keys are unquoted by your approach — roganjosh
– roganjosh, Commented Jul 27, 2019 at 13:56
how did you get Json_text ? It is not correct JSON. If you generate this JSON then change method - use module json for this. — furas
– furas, Commented Jul 27, 2019 at 13:57
you can try module dirtyjson - it can handle some problems in wrong JSON. — furas
– furas, Commented Jul 27, 2019 at 13:59

heemayl · Accepted Answer · 2019-07-27 14:04:39Z

You need to do replacements to make it json parse-able:

In [120]: text = '{\n                    \n                        acorn: "",\n                        acorn_type: "",\n                        area_name: "Glasgow",\n                        beds_max: 2,\
     ...: n                        beds_min: 2,\n }'                                                                                                                                                        

In [121]: json.loads(re.sub(r'\b([^:",]+)(?=:)', r'"\1"', re.sub(r'\s*|,\s*(?=\}$)', '', text)))                                                                                                            
Out[121]: 
{'acorn': '',
 'acorn_type': '',
 'area_name': 'Glasgow',
 'beds_max': 2,
 'beds_min': 2}

At first, we need to drop all whitespaces and the trailing ,:

In [122]: re.sub(r'\s*|,\s*(?=\}$)', '', text)                                                                                                                                                              
Out[122]: '{acorn:"",acorn_type:"",area_name:"Glasgow",beds_max:2,beds_min:2}'

Now, on the returned string, we need to add double quotes to the keys:

In [123]: re.sub(r'\b([^:",]+)(?=:)', r'"\1"', re.sub(r'\s*|,\s*(?=\}$)', '', text))                                                                                                                        
Out[123]: '{"acorn":"","acorn_type":"","area_name":"Glasgow","beds_max":2,"beds_min":2}'

Now, json.loads would do:

In [124]: json.loads(re.sub(r'\b([^:",]+)(?=:)', r'"\1"', re.sub(r'\s*|,\s*(?=\}$)', '', text)))                                                                                                            
Out[124]: 
{'acorn': '',
 'acorn_type': '',
 'area_name': 'Glasgow',
 'beds_max': 2,
 'beds_min': 2}

Using names:

In [125]: text                                                                                                                                                                                              
Out[125]: '{\n                    \n                        acorn: "",\n                        acorn_type: "",\n                        area_name: "Glasgow",\n                        beds_max: 2,\n                        beds_min: 2,\n }'

In [126]: text_wo_whitespaces = re.sub(r'\s*|,\s*(?=\}$)', '', text)                                                                                                                                        

In [127]: text_quoted = re.sub(r'\b([^:",]+)(?=:)', r'"\1"', text_wo_whitespaces)                                                                                                                           

In [128]: json.loads(text_quoted)                                                                                                                                                                           
Out[128]: 
{'acorn': '',
 'acorn_type': '',
 'area_name': 'Glasgow',
 'beds_max': 2,
 'beds_min': 2}

Collectives™ on Stack Overflow

String to Json Python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related