如何在pandas中使用条件执行多个groupby和转换计数

import pandas as pd

data = {'group1': ['A', 'A', 'B', 'B', 'B'],
        'group2': ['X', 'Y', 'X', 'Y', 'Z'],
        'value': [1, 2, 3, 4, 5]}
df = pd.DataFrame(data)

result = df.groupby(['group1', 'group2']).count()

filtered_data = df[df['value'] > 2]
filtered_result = filtered_data.groupby(['group1', 'group2']).count()

import pandas as pd

data = {'group1': ['A', 'A', 'B', 'B', 'B'],
        'group2': ['X', 'Y', 'X', 'Y', 'Z'],
        'value': [1, 2, 3, 4, 5]}
df = pd.DataFrame(data)

result = df.groupby(['group1', 'group2']).count()
print("原始数据分组计数：")
print(result)

filtered_data = df[df['value'] > 2]
filtered_result = filtered_data.groupby(['group1', 'group2']).count()
print("过滤后的数据分组计数：")
print(filtered_result)

原始数据分组计数：
               value
group1 group2       
A      X           1
       Y           1
B      X           1
       Y           1
       Z           1
过滤后的数据分组计数：
               value
group1 group2       
B      X           1
       Y           1
       Z           1