按日分组和条件盘点出库

SELECT
    DATE(outbound_date) AS outbound_date,
    product_id,
    SUM(quantity) AS total_quantity
FROM
    outbound_records
GROUP BY
    outbound_date, product_id
HAVING
    SUM(quantity) > 100;

import pandas as pd

# 假你有一个包含出库记录的DataFrame
data = {
    'outbound_date': ['2021-01-01', '2021-01-01', '2021-01-02', '2021-01-02'],
    'product_id': [1, 2, 1, 2],
    'quantity': [150, 200, 100, 150]
}

df = pd.DataFrame(data)

# 将出库日期转换为日期类型
df['outbound_date'] = pd.to_datetime(df['outbound_date'])

# 按日分组并汇总出库数量
grouped = df.groupby(['outbound_date', 'product_id']).sum()

# 筛选出出库数量大于100的记录
filtered = grouped[grouped['quantity'] > 100]

print(filtered)