我正在使用Azure机器学习工作室,以及在我的数据集上添加运行总数。这包括一个日期列,我想对行日期当天或之前的所有行(对于组)求和。在
在SQL Server中,我将使用:SELECT [t1].*,
SUM([t1].[Amount (Settlement CCY))
OVER (
PARTITION BY [t1].[Contract Ref], [t1].[LOBCode], [t1].[Superline], [t1].[Occupation], [t1].[TransType], [t1].[SettCCY]
ORDER BY [t1].[Transaction Date] ASC
ROWS BETWEEN UNBOUNDED PRECEDING
AND CURRENT ROW
)
FROM [t1]
GROUP BY [t1].[contract ref], [t1].[Transaction date], [t1].[LOBCode], [t1].[Superline], [t1].[Occupation], [t1].[TransType], [t1].[SettCCY]
但是Azure机器学习使用SQLite,其中没有实现Over/Partition子句。在
我在python/pandas中尝试了另一种方法:
^{pr2}$
但这总结了团队的一切,而不仅仅是当前一行的约会。因此,我认为它不包括:ROWS BETWEEN UNBOUNDED PRECEDING
AND CURRENT ROW
我要怎么做?在