在Pandas中基于多个参数计算覆盖月数

import pandas as pd

# 创建一个示例数据集
data = {
    '日期': pd.date_range(start='2022-01-01', end='2022-12-31', freq='M'),
    '参数1': [10, 20, 30, 40, 50, 60, 70, 80, 90, 100, 110, 120],
    '参数2': [5, 15, 25, 35, 45, 55, 65, 75, 85, 95, 105, 115],
    '参数3': [8, 18, 28, 38, 48, 58, 68, 78, 88, 98, 108, 118]
}

df = pd.DataFrame(data)

# 设置阈值
thresholds = {
    '参数1': 50,
    '参数2': 60,
    '参数3': 70
}

# 计算覆盖月数
coverage = {}
for param, threshold in thresholds.items():
    coverage[param] = len(df[df[param] >= threshold])

print("覆盖月数:")
for param, count in coverage.items():
    print(f"{param}: {count} 个月")