使用Python在数组内嵌套平面json

import json

def flatten_json(nested_json, parent_key='', sep='_'):
    """
    将嵌套的JSON展开为平面JSON
    """
    flattened_json = {}
    for key, value in nested_json.items():
        new_key = parent_key + sep + key if parent_key else key
        if isinstance(value, dict):
            flattened_json.update(flatten_json(value, new_key, sep=sep))
        else:
            flattened_json[new_key] = value
    return flattened_json

# 嵌套的JSON数组
nested_json = {
    "array": [
        {
            "name": "John",
            "age": 30,
            "city": "New York"
        },
        {
            "name": "Alice",
            "age": 25,
            "city": "San Francisco"
        }
    ]
}

# 将嵌套的JSON展开为平面JSON
flattened_json = flatten_json(nested_json)

# 将平面JSON转换为字符串
json_str = json.dumps(flattened_json)

print(json_str)

{
    "array_0_name": "John",
    "array_0_age": 30,
    "array_0_city": "New York",
    "array_1_name": "Alice",
    "array_1_age": 25,
    "array_1_city": "San Francisco"
}