在pandas中“扁平化”数据帧中的JSON的最有效方法是什么？

pandas.json_normalize(data, record_path=None, meta=None, meta_prefix=None, record_prefix=None, errors='raise')

import pandas as pd
import json

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

# 将JSON数据转换为数据帧
df = pd.json_normalize(data, 'scores', ['id', 'name', ['address', 'street'], ['address', 'city'], ['address', 'state']])

print(df)

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