展平嵌套json列表中的Pandas DataFrame

import pandas as pd
import json

# 嵌套的JSON列表
data = [
    {
        "id": 1,
        "name": "John",
        "address": {
            "street": "123 Main St",
            "city": "New York",
            "state": "NY"
        },
        "scores": [80, 90, 85]
    },
    {
        "id": 2,
        "name": "Jane",
        "address": {
            "street": "456 Elm St",
            "city": "Los Angeles",
            "state": "CA"
        },
        "scores": [95, 85, 90]
    }
]

# 将JSON数据转换为DataFrame
df = pd.json_normalize(data)

# 打印展平后的DataFrame
print(df)

   id  name address.street address.city address.state  scores.0  scores.1  scores.2
0   1  John   123 Main St     New York            NY        80        90        85
1   2  Jane   456 Elm St  Los Angeles            CA        95        85        90