在python pandas中打开json l后，如何跨字段进行聚合？

[
    {"name": "Alice", "age": 30, "score": 85},
    {"name": "Bob", "age": 25, "score": 90},
    {"name": "Charlie", "age": 35, "score": 80}
]

import pandas as pd

# 加载JSON文件
df = pd.read_json('data.json')
print(df)

# 按年龄段分组并计算平均分数
grouped = df.groupby(pd.cut(df['age'], bins=[20, 30, 40]))['score'].mean()
print(grouped)

# 假设JSON数据包含嵌套结构
nested_json = [
    {"name": "Alice", "details": {"age": 30, "score": 85}},
    {"name": "Bob", "details": {"age": 25, "score": 90}},
    {"name": "Charlie", "details": {"age": 35, "score": 80}}
]

# 使用json_normalize处理嵌套结构
df_nested = pd.json_normalize(nested_json, sep='_')
print(df_nested)

# 现在可以进行正常的聚合操作
grouped_nested = df_nested.groupby(pd.cut(df_nested['details_age'], bins=[20, 30, 40]))['details_score'].mean()
print(grouped_nested)