在Python中使用pandas基于条件进行计数

import pandas as pd

data = {'Name': ['Alice', 'Bob', 'Charlie', 'David', 'Alice'],
        'Age': [25, 28, 22, 32, 25]}
df = pd.DataFrame(data)

filtered_data = df[df['Age'] > 25]  # 筛选出年龄大于25的数据

count = filtered_data['Name'].value_counts()

print(count)

import pandas as pd

data = {'Name': ['Alice', 'Bob', 'Charlie', 'David', 'Alice'],
        'Age': [25, 28, 22, 32, 25]}
df = pd.DataFrame(data)

filtered_data = df[df['Age'] > 25]
count = filtered_data['Name'].value_counts()

print(count)

Alice    1
David    1
Name: Name, dtype: int64