pandas to_json returns a string not a json object

Question

I am using the following python code to return a json object:

df_as_json = df.to_json(orient='split')
return jsonify({'status': 'ok', 'json_data': df_as_json})

When I read the object back in javascript:

// response is xhr respose from server
const mydata = response.data
console.log(mydata.constructor.name)
// >Obj
const dfdata = mydata.json_data
console.log(dfdata.constructor.name)
// >String

Is there a way to send the df_as_json as a json object inside the parent response.data json object?

Taku · Accepted Answer · 2017-04-25 15:06:43Z

34

There's no such thing as a "json object" in python that's why.to_json returns a string representation of the json object, json in python is essentially the same as a dict, you can use the to_dict method instead.

df_as_json = df.to_dict(orient='split')
return jsonify({'status': 'ok', 'json_data': df_as_json})

answered Apr 25, 2017 at 15:06

Taku

34.1k12 gold badges79 silver badges88 bronze badges

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

1 Comment

reergymerej Over a year ago

JSON is a string! It's used to represent objects. You may even say it's an Object Notation, inspired by JavaScript.

Tupis · Accepted Answer · 2017-04-25 15:06:40Z

1

Just return dict and let jsonify convert dict to string.

df_as_json = df.to_dict()
return jsonify({'status': 'ok', 'json_data': df_as_json})

answered Apr 25, 2017 at 15:06

Tupis

292 bronze badges

Comments

Max · Accepted Answer · 2021-01-25 07:47:22Z

0

You can use json in python directly.

# some JSON:
x =  '{ "name":"John", "age":30, "city":"New York"}'

# parse x:
y = json.loads(x)
return y

# the result is a Python dictionary:
print(y["age"])

answered Jan 25, 2021 at 7:47

Max

591 silver badge8 bronze badges

Collectives™ on Stack Overflow

pandas to_json returns a string not a json object

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related