从JSON中找出MongoDB格式的平均值

import json
from bson import Decimal128

def find_average(json_data):
    data = json.loads(json_data)
    total = 0
    count = 0

    def traverse(obj):
        nonlocal total, count
        if isinstance(obj, dict):
            for key, value in obj.items():
                if isinstance(value, (int, float)):
                    total += value
                    count += 1
                elif isinstance(value, (dict, list)):
                    traverse(value)
        elif isinstance(obj, list):
            for item in obj:
                traverse(item)

    traverse(data)

    if count > 0:
        average = total / count
        average_bson = Decimal128(str(average))
        return average_bson
    else:
        return None

# 示例JSON数据
json_data = '''
{
  "students": [
    {
      "name": "Alice",
      "score": 80
    },
    {
      "name": "Bob",
      "score": 90
    },
    {
      "name": "Charlie",
      "score": 75
    }
  ]
}
'''

average_value = find_average(json_data)
print("平均值（MongoDB格式）：", average_value)