json.decoder.JSONDecodeError: Expecting property name enclosed in double quotes: line 2 column 2 (char 3)

Question

I know this Question is already answered, but I dont know where the Error is in my Case.

This is my Code:

import json

json_data = """
{
    'position1': '516, 440',
    'position2': '971, 443',
    'position3': '1186, 439',
    'position4': '1402, 441',
    'position5': '1630, 449',
    'position6': '299, 681',
    'position7': '518, 684',
    'position8': '736, 691',
    'position9': '739, 431'
}
"""
data = json.loads(json_data)
print(data)

Im not really into working with json files, so please don't blame me if it's a really dump mistake.

The error message seems pretty clear - what don’t you understand about it? — DisappointedByUnaccountableMod
– DisappointedByUnaccountableMod, Commented May 28, 2021 at 22:20
'516, 440', the problem is the comma in the middle of the numbers is being interpreted the same as the comma at the end of the key:value pair, so you need to use double quotes instead of single quotes if you want commas in your values — Jonathan Leon
– Jonathan Leon, Commented May 28, 2021 at 22:22

Paul Lemarchand · Accepted Answer · 2021-05-28 22:23:11Z

3

Don't use triple quotes """. Instead use a dictionary with json.dumps() so that commas in your values are not misinterpreted as commas between items.

import json

json_data = {
    'position1': '516, 440',
    'position2': '971, 443',
    'position3': '1186, 439',
    'position4': '1402, 441',
    'position5': '1630, 449',
    'position6': '299, 681',
    'position7': '518, 684',
    'position8': '736, 691',
    'position9': '739, 431'
}

data = json.dumps(json_data)
print(data)

answered May 28, 2021 at 22:23

Paul Lemarchand

2,1042 gold badges17 silver badges28 bronze badges

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

1 Comment

programming_for_fun Over a year ago

Worked! Thank you!

Jonathan Leon · Accepted Answer · 2021-05-28 22:26:27Z

3

If you are using triple quotes, this would work

json_data = json_data.replace("'", '"')

data = json.loads(json_data)
print(data)

answered May 28, 2021 at 22:26

Jonathan Leon

5,6862 gold badges9 silver badges16 bronze badges

1 Comment

ladrua Over a year ago

I was using this and worked fine until I had a value containing a '

Geethika Wijesuriya · Accepted Answer · 2021-05-28 22:26:55Z

0

Try this one

import json

json_data = {
    'position1': '516, 440',
    'position2': '971, 443',
    'position3': '1186, 439',
    'position4': '1402, 441',
    'position5': '1630, 449',
    'position6': '299, 681',
    'position7': '518, 684',
    'position8': '736, 691',
    'position9': '739, 431'
}

data = json.dumps(json_data)
print(data)

answered May 28, 2021 at 22:26

Geethika Wijesuriya

1143 bronze badges

1 Comment

Paul Lemarchand Over a year ago

This is the exact same code as in my answer.

Collectives™ on Stack Overflow

json.decoder.JSONDecodeError: Expecting property name enclosed in double quotes: line 2 column 2 (char 3)

3 Answers 3

1 Comment

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related