嵌套和转义JSON有效负载到扁平化字典- python

{
  "name": "John",
  "age": 30,
  "address": {
    "street": "123 Main St",
    "city": "New York",
    "state": "NY"
  },
  "hobbies": ["reading", "music", "sports"]
}

{
  "name": "John",
  "age": 30,
  "address.street": "123 Main St",
  "address.city": "New York",
  "address.state": "NY",
  "hobbies.0": "reading",
  "hobbies.1": "music",
  "hobbies.2": "sports"
}

import json

def flatten_json(json_data, parent_key='', sep='.'):
    flattened_dict = {}
    for key, value in json_data.items():
        new_key = parent_key + sep + key if parent_key else key
        if isinstance(value, dict):
            flattened_dict.update(flatten_json(value, new_key, sep))
        elif isinstance(value, list):
            for i, item in enumerate(value):
                new_key_with_index = new_key + sep + str(i)
                flattened_dict.update(flatten_json(item, new_key_with_index, sep))
        else:
            flattened_dict[new_key] = value
    return flattened_dict

# 假设json_payload是嵌套的JSON有效负载
json_payload = '''
{
  "name": "John",
  "age": 30,
  "address": {
    "street": "123 Main St",
    "city": "New York",
    "state": "NY"
  },
  "hobbies": ["reading", "music", "sports"]
}
'''

# 解析JSON数据
data = json.loads(json_payload)

# 转换为扁平化字典
flattened_data = flatten_json(data)

# 打印结果
for key, value in flattened_data.items():
    print(key, ":", value)

name : John
age : 30
address.street : 123 Main St
address.city : New York
address.state : NY
hobbies.0 : reading
hobbies.1 : music
hobbies.2 : sports