python jupyter中的SUMIFS

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

import pandas as pd

# 创建示例数据集
data = {'Product': ['A', 'B', 'A', 'B', 'A', 'B'],
        'Sales': [100, 200, 150, 300, 120, 250],
        'Date': ['2022-01-01', '2022-01-02', '2022-01-03', '2022-01-04', '2022-01-05', '2022-01-06']}
df = pd.DataFrame(data)

# 指定条件范围和条件值
criteria_range1 = df['Product']
criteria1 = 'A'
criteria_range2 = pd.to_datetime(df['Date'])
criteria2_start = pd.to_datetime('2022-01-02')
criteria2_end = pd.to_datetime('2022-01-05')

# 使用SUMIFS函数计算销售总额
total_sales = df.loc[(criteria_range1 == criteria1) & (criteria_range2 >= criteria2_start) & (criteria_range2 <= criteria2_end), 'Sales'].sum()

print('销售总额:', total_sales)