parsing issues in corrupted json using python

Question

I have a corrupted json, like following:

{'a': 'b', 'c': "abcd'efgh ijklm"}

Before using python json.loads, i need to do 2 things:

replace single quote inside double quote with \'
replace all other single quote, except \' with double quote

I am not sure how to do both steps. Please help.

Why do you need to replace ' by \' in double-quoted strings? — melpomene
– melpomene, Commented Jun 18, 2016 at 8:06
@melpomene I am not sure... if that is not required, please tell what is best way to convert this string, so that it can be loaded in json.loads — Shweta
– Shweta, Commented Jun 18, 2016 at 8:09
The other part you have to be careful about is double quotes in single-quoted strings: '"' needs to become "\"", not """. — melpomene
– melpomene, Commented Jun 18, 2016 at 8:19
How about reading each line and use ast.literal_eval to convert the string to dict? — Sede
– Sede, Commented Jun 18, 2016 at 8:34

Sede · Accepted Answer · 2016-06-18 09:14:04Z

2

Actually you can't use the json.loads function to deserialize your string because the string doesn't contain a valid JSON document. Instead, you should consider to use the ast.literal_eval function.

Demo:

In [25]: import ast

In [26]: with open('inputfile') as f:
   ....:     for d in map(ast.literal_eval, f):
   ....:         print(d)
   ....:         
{'c': "abcd'efgh ijklm", 'a': 'b'}
{'c': "abcdgfgfgg", 'a': 'b'}

answered Jun 18, 2016 at 9:14

Sede

61.5k20 gold badges159 silver badges162 bronze badges

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

Collectives™ on Stack Overflow

parsing issues in corrupted json using 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