平面化JSON重复列Pandas

{
    "id": 1,
    "name": "Alice",
    "details": {
        "age": 30,
        "address": {
            "city": "New York",
            "zipcode": "10001"
        }
    }
}

import pandas as pd

# 嵌套的JSON数据
data = {
    "id": 1,
    "name": "Alice",
    "details": {
        "age": 30,
        "address": {
            "city": "New York",
            "zipcode": "10001"
        }
    }
}

# 扁平化JSON数据
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

flat_data = [flatten_json(data)]

# 转换为Pandas DataFrame
df = pd.DataFrame(flat_data)
print(df)

   id    name  details_age address_city address_zipcode
0   1  Alice          30     New York           10001