'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