'JSON Parsing- multiple double quotes
I have a csv source with JSON strings, One such JSON string has the structure
{""x"":""y""}
while parsing this is throwing error as
parse = pd.json_normalize(data['target'].apply(json.loads).tolist()).rename(
columns=lambda x: x.replace('target.', ''))
JSONDecodeError: Expecting ':' delimiter: line 1 column 19 (char 18)
making is manually as {"x":"y"} works...
Question is how do I handle such cases when dealing with large datasets, without handling these unique cases manually.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
