将json列表分组到日期，并进一步分组到特定字段

import json
from datetime import datetime

# 假设json_list是包含JSON数据的列表
json_list = [
    {"date": "2022-01-01", "category": "A", "value": 10},
    {"date": "2022-01-01", "category": "B", "value": 20},
    {"date": "2022-01-02", "category": "A", "value": 15},
    {"date": "2022-01-02", "category": "B", "value": 25},
    {"date": "2022-01-02", "category": "C", "value": 30}
]

# 创建一个字典用于存储分组后的数据
grouped_data = {}

# 遍历json_list，将数据分组到日期和特定字段
for item in json_list:
    date = datetime.strptime(item["date"], "%Y-%m-%d").date()
    category = item["category"]
    value = item["value"]
    
    if date not in grouped_data:
        grouped_data[date] = {}
    
    if category not in grouped_data[date]:
        grouped_data[date][category] = []
    
    grouped_data[date][category].append(value)

# 打印分组后的数据
for date, categories in grouped_data.items():
    print(f"Date: {date}")
    for category, values in categories.items():
        print(f"Category: {category}, Values: {values}")