我正在尝试将深度嵌套的JSON转换为pandas数据帧

{
    "name": "John",
    "age": 30,
    "address": {
        "street": "123 Main St",
        "city": "Anytown",
        "zipcode": "12345"
    },
    "contacts": [
        {
            "type": "email",
            "value": "john@example.com"
        },
        {
            "type": "phone",
            "value": "555-1234"
        }
    ]
}

import pandas as pd
import json

# 示例JSON数据
data = {
    "name": "John",
    "age": 30,
    "address": {
        "street": "123 Main St",
        "city": "Anytown",
        "zipcode": "12345"
    },
    "contacts": [
        {
            "type": "email",
            "value": "john@example.com"
        },
        {
            "type": "phone",
            "value": "555-1234"
        }
    ]
}

# 将JSON数据转换为字典
data_dict = json.loads(json.dumps(data))

# 展平嵌套的字典
def flatten_json(y):
    out = {}

    def flatten(x, name=''):
        if type(x) is dict:
            for a in x:
                flatten(x[a], name + a + '.')
        elif type(x) is list:
            i = 0
            for a in x:
                flatten(a, name + str(i) + '.')
                i += 1
        else:
            out[name[:-1]] = x

    flatten(y)
    return out

flattened_data = flatten_json(data_dict)

# 转换为Pandas数据帧
df = pd.DataFrame([flattened_data])

print(df)

   name  age address.street address.city address.zipcode contacts.0.type contacts.0.value contacts.1.type contacts.1.value
0  John   30    123 Main St      Anytown         12345            email  john@example.com           phone        555-1234