Python中多条件下多列的Groupby sum和count

import pandas as pd

# 创建一个示例数据集
data = {'Category': ['A', 'B', 'A', 'B', 'A', 'B'],
        'Group': ['X', 'X', 'Y', 'Y', 'X', 'Y'],
        'Value1': [1, 2, 3, 4, 5, 6],
        'Value2': [7, 8, 9, 10, 11, 12]}
df = pd.DataFrame(data)

# 根据Category和Group进行分组，并计算Value1和Value2的和
sum_result = df.groupby(['Category', 'Group']).sum()
print("Groupby Sum Result:")
print(sum_result)

# 根据Category和Group进行分组，并计算Value1和Value2的计数
count_result = df.groupby(['Category', 'Group']).count()
print("Groupby Count Result:")
print(count_result)

Groupby Sum Result:
               Value1  Value2
Category Group                
A        X          6      18
         Y          3       9
B        X          2       8
         Y          4      22
Groupby Count Result:
               Value1  Value2
Category Group                
A        X          2       2
         Y          1       1
B        X          1       1
         Y          2       2