将dataframe转换为嵌套json格式

import pandas as pd
import json

df = pd.DataFrame({
    'name': ['Alice', 'Bob', 'Charlie'],
    'age': [25, 30, 35],
    'city': ['New York', 'London', 'Paris']
})

json_data = df.to_json(orient='records')
nested_json = json.loads(json_data)

print(json.dumps(nested_json, indent=4))

[
    {
        "name": "Alice",
        "age": 25,
        "city": "New York"
    },
    {
        "name": "Bob",
        "age": 30,
        "city": "London"
    },
    {
        "name": "Charlie",
        "age": 35,
        "city": "Paris"
    }
]