replace dictionary single quotes to double

Question

dic = [{'one':1, 'two':'t', 'three': {'three.1': 3.1, 'three.2': '3.2' }}]

Desire Output,

[{"one":1, "two":"t", "three": {"three.1": 3.1, "three.2": "3.2" }}]

Tried Code:

ast.literal_eval(json.dumps(dic[0]))

here, Json converting the quotes but also changing the type to str. So I applied ast to change type. at end getting the same output with single quotes.

Output of Json.dumps: json.dumps(dic[0])

'{"one": 1, "two": "t", "three": {"three.1": 3.1, "three.2": "3.2"}}'

Above pre and post single quotes are the issue.

Why do you need a specific type of quotes in the string representation of a `dict`? — chepner, Sep 19 '22 at 13:28
Actually I need to upload these file to PowerBI, and need explode. PowerBI gives error with single quote. — , Sep 19 '22 at 13:29
If you create JSON file, there will be no single quotes around the JSON string. So use `json.dump()` — buran, Sep 19 '22 at 13:35
Somewhat related: https://stackoverflow.com/questions/18283725/how-to-create-a-python-dictionary-with-double-quotes-as-default-quote-format — Tzane, Sep 19 '22 at 13:39

score 0 · Accepted Answer · answered Sep 19 '22 at 13:33

0

Whats wrong with json.dumps(dic)?

answered Sep 19 '22 at 13:33

bitflip

3,436
1
3
22

score 0 · Answer 2 · answered Sep 19 '22 at 13:36

0

If you want to print the dictionary to terminal with double quotes, you can

>>> print(json.dumps(dic))
[{"one": 1, "two": "t", "three": {"three.1": 3.1, "three.2": "3.2"}}]

answered Sep 19 '22 at 13:36

Tzane

2,752
1
10
21

replace dictionary single quotes to double

2 Answers2