【代码报错】row子句问题
由luvymhq创建,最终由small_q 被浏览 13 用户
row子句结果有问题
import dai
dai.query(""" select instrument,date,daily_return,close,
cumsum(close) over(partition by instrument order by date rows between 10 preceding and current row) as nn
,cumsum(close) over(partition by instrument order by date rows between 10 preceding and 5 preceding) as mmm
from cn_stock_prefactors
where date between '2024-01-01' and '2024-09-10'
and instrument='000002.SZ'""").df()
nn 和mm 的结果完全一样。但我求和的函数不一样。哪里出了问题?