基于多准则pandas在数据帧中生成计数列

import pandas as pd

# 创建一个示例数据帧
data = {'Name': ['Alice', 'Bob', 'Charlie', 'David', 'Eve'],
        'Age': [25, 30, 35, 40, 45],
        'Gender': ['Female', 'Male', 'Male', 'Male', 'Female']}
df = pd.DataFrame(data)

# 使用多准则筛选数据，并生成计数列
df['Count'] = ((df['Age'] > 30) & (df['Gender'] == 'Male')).sum()

print(df)

      Name  Age  Gender  Count
0    Alice   25  Female      1
1      Bob   30    Male      1
2  Charlie   35    Male      1
3    David   40    Male      1
4      Eve   45  Female      1