split a string into a json object [closed]

Question

Closed. This question needs debugging details. It is not currently accepting answers.

Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem. This will help others answer the question.

Closed 3 years ago.

The community reviewed whether to reopen this question 3 years ago and left it closed:

Original close reason(s) were not resolved

Improve this question

When I extract some data from a data-source the data is getting extracted as a string object and the json is being exported as a string.

I have tried

json.loads() -> link1 Convert string to JSON in Python? and this convert a json string to python object from other answers.

However, the expectation is

"details": 
"{
'col1': 'col1_details',
'col2': 'col2_details',
'col3': 'col3_details'
}"

the expected outcome is

details":
{
'col1': 'col1_details',
'col3': 'col2_details',
'col3': 'col3_details'
}

as you see the extra quotes are causing the json to be read as a string and json.loads() and json.dumps() are not working.

I am open to any suggestions without using regex to create a json object directly/easily?

edit:

modified the string object - and the whole point as you see is that the data extraction process is creating a string instead of creating a json object bypassing an extra "" that makes it an invalid json object where I cannot use json.loads and json.dunps and hence the question.

Does this answer your question? Convert string to JSON in Python? — Maxwell D. Dorliea
– Maxwell D. Dorliea, Commented Jul 13, 2022 at 17:59
That isn't valid JSON. Make a minimal reproducible example. What is the exact content of the data object? — Mark Tolonen
– Mark Tolonen, Commented Jul 13, 2022 at 18:00
Invalid JSON. Please first verify JSON with a validator. Also, this question just presents some output, without giving the input. Not really that handy... You also seem to have two different expectations. — trincot
– trincot, Commented Jul 13, 2022 at 18:04

OneCricketeer · Accepted Answer · 2022-07-13 18:30:27Z

1

Assuming you meant

"details": {
  'col1': 'col1_details',
  'col3': 'col2_details',
  'col3': 'col3_details'
}

Then re-loads the data

data["details"] = json.loads(data["details"])

But, this assumes whatever response you've gotten actually returns valid JSON, which single-quotes are not (there might be a good reason it is returned as a string instead)

Therefore, the most reasonable solution would be to modify the code that returned that response, not try to fix it via parsing it at a later point.

edited Jul 13, 2022 at 18:30

answered Jul 13, 2022 at 18:13

OneCricketeer

193k20 gold badges146 silver badges276 bronze badges

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

4 Comments

juanpa.arrivillaga Over a year ago

that's probably not going to work because data["details"] seems to be a Python repr not a JSON

juanpa.arrivillaga Over a year ago

well, it isn't the only solution, you can eval the string back to a Python object, since it seems simple enough

OneCricketeer Over a year ago

Or ast.literal_eval?

juanpa.arrivillaga Over a year ago

sure, either one would work (assuming the OP's example data is representative of the actual data)

Collectives™ on Stack Overflow

split a string into a json object [closed]

1 Answer 1

4 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Linked

Related