Convert Dataframe.describe output to some json

Question

I am learning Pandas + Python.

When I use var = dataFrame.describe() , I want the output to be converted to json, so that I can send it as a response via a Flask API

    order_id  quantity
count  5.000000  5.000000
mean   1.200000  1.200000
std    0.447214  0.447214
min    1.000000  1.000000
25%    1.000000  1.000000
50%    1.000000  1.000000
75%    1.000000  1.000000
max    2.000000  2.000000

`describe` returns a data frame obj, you can just use `var.to_json()` directly — rafaelc, Oct 07 '19 at 16:43

score 4 · Answer 1 · answered Oct 07 '19 at 16:44

Use DataFrame.to_json:

var.to_json()

Output:

'{"order_id":{"count":5.0,"mean":1.2,"std":0.447214,"min":1.0,"25%":1.0,"50%":1.0,"75%":1.0,"max":2.0},"quantity":{"count":5.0,"mean":1.2,"std":0.447214,"min":1.0,"25%":1.0,"50%":1.0,"75%":1.0,"max":2.0}}'

Convert Dataframe.describe output to some json

1 Answers1