'Pandas to JSON not respecting DataFrame format

I have a Pandas DataFrame which I need to transform into a JSON object. I thought by grouping it, I would achieve this but this does not seem to yield the correct results. Further, I wouldnt know how to name the sub group.

My data frame as follows:

parent	name	age
nick	stef	10
nick	rob	12

And I do a groupby as I would like all children together under one parent in json:

df = df.groupby(['parent', 'name'])['age'].min()

And I would like it to yield the following:

   {
      "parent": "Nick",
      "children": [
        {
          "name": "Rob",
          "age": 10,
        },
        {
          "name": "Stef",
          "age": 15,
        },,..  ]
    }

When I do .to_json() it seems to regroup everything on age etc.

Solution 1:^[1]

df.groupby(['parent'])[['name', 'age']].apply(list).to_json()

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	politinsa

'Pandas to JSON not respecting DataFrame format

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]