How to include Dataframe's name on to_json (Pandas)

Question

Using the dataset of this question (Pandas dataframe to json without index), how can I add the name of the dataframe?

to_json() is returning me this:

[
 {"id":0,"location":"[50, 50]"},
 {"id":1,"location":"[60, 60]"},
 {"id":2,"location":"[70, 70]"},
 {"id":3,"location":"[80, 80]"}
]

but I want JSON like this:

{
"stops":
[
 {"id":0,"location":"[50, 50]"},
 {"id":1,"location":"[60, 60]"},
 {"id":2,"location":"[70, 70]"},
 {"id":3,"location":"[80, 80]"}
]
}

MaxU - stand with Ukraine · Accepted Answer · 2017-10-07 17:01:33Z

3

IIUC:

In [77]: d = {'stops':df.reset_index().to_dict(orient='records')}

In [78]: js = json.dumps(d, indent=2)

In [79]: print(js)
{
  "stops": [
    {
      "id": 0,
      "location": "[50, 50]"
    },
    {
      "id": 1,
      "location": "[60, 60]"
    },
    {
      "id": 2,
      "location": "[70, 70]"
    },
    {
      "id": 3,
      "location": "[80, 80]"
    }
  ]
}

answered Oct 7, 2017 at 17:01

MaxU - stand with Ukraine

212k37 gold badges402 silver badges437 bronze badges

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

Collectives™ on Stack Overflow

How to include Dataframe's name on to_json (Pandas)

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related