JSON GroupBy 2属性- Python

import pandas as pd
import json

# 示例 JSON 数据
data = '''
[
    {"name": "Alice", "age": 25, "city": "New York"},
    {"name": "Bob", "age": 30, "city": "New York"},
    {"name": "Charlie", "age": 25, "city": "Los Angeles"},
    {"name": "David", "age": 30, "city": "Los Angeles"}
]
'''

# 将 JSON 数据转换为 DataFrame
df = pd.read_json(data)

# 按 age 和 city 属性进行分组，并计算每组的数量
grouped = df.groupby(['age', 'city']).size().reset_index(name='count')

print(grouped)

   age         city  count
0   25     New York      1
1   25  Los Angeles      1
2   30     New York      1
3   30  Los Angeles      1

# 处理空值示例
df = df.dropna(subset=['age', 'city'])

# 优化分组键示例
grouped = df.groupby(['age', 'city']).agg({'name': 'count'}).reset_index(name='count')