import pandas as pd
# 创建 DataFrame
data = {
"序号": list(range(1, 22)),
"团队": ["A团队"] * 10 + ["B团队"] * 13, # 假设数据
"衣服码": ["XXL", "XL", "XL", "XL", "M", "XXL", "XXXL", "L", "L", "L", "XL", "L", "XXL", "XXL", "XL", "XXXL", "M", "XXL", "XXL", "XL", "XXXL"],
"鞋码": [40, 37, 39, 40, 40, 41, 41, 36, 38, 39, 39, 37, 42, 40, 41, 40, 36, 38, 39, 40, 41]
}
df = pd.DataFrame(data)
# 统计鞋码在36到42之间的人数,分团队统计
shoes_count = df[df['鞋码'].between(36, 42)].groupby('团队')['鞋码'].count()
# 统计衣服码的数量,分团队统计
clothes_count = df.groupby('团队')['衣服码'].value_counts()
# 输出结果
print("鞋码统计(36-42):")
print(shoes_count)
print("\n衣服码统计:")
print(clothes_count)