在DataFrame中计算满足多个条件的值的百分比

import pandas as pd

# 创建一个示例DataFrame
data = {'A': [1, 2, 3, 4, 5],
        'B': [6, 7, 8, 9, 10],
        'C': [11, 12, 13, 14, 15]}
df = pd.DataFrame(data)

# 设置多个条件
condition1 = df['A'] > 2
condition2 = df['B'] < 9

# 根据条件筛选出满足要求的数据子集
subset = df[condition1 & condition2]

# 计算满足条件的值的数量
count = subset.shape[0]

# 计算满足条件的值的百分比
percentage = (count / df.shape[0]) * 100

print("满足条件的值的百分比：{:.2f}%".format(percentage))