小于数值列特定值的Groupby计数

import pandas as pd
import numpy as np

grouped = df.groupby('列A')

group_sizes = grouped.size()

specific_value = 10
count = np.where(df['数值列'] < specific_value, 1, 0)

count_by_group = grouped['数值列'].sum()

import pandas as pd
import numpy as np

# 加载数据集
df = pd.read_csv('data.csv')

# 按列A进行分组
grouped = df.groupby('列A')

# 获取每个分组的大小
group_sizes = grouped.size()

# 设置特定值
specific_value = 10

# 计算小于特定值的元素数量
count = np.where(df['数值列'] < specific_value, 1, 0)

# 按分组求和
count_by_group = grouped['数值列'].sum()