首页 > 解决方案 > JuliaDB 一次将多列分组

问题描述

我正在尝试使用 JuliaDB 进行分组,一切正常,除非我想应用一次需要两列的函数。

 JuliaDB.groupby(
    (
        TOTAL_PAID = :PRICE => sum, 
        FREQUENCY_IN_DAYS = :ORDER_DATE => handle_dates,
        RECENCY_IN_DAYS = :ORDER_DATE => (x -> Dates.value(Date(now()) - maximum(x))),
        COUNT_ORDERS_LAST_MONTH = :ORDER_DATE => countOnlyLastMonth,
        TOTAL_PAID_LAST_MONTH = [:ORDER_DATE, :PRICE]  => countOnlyLastMonth,
        COUNT_ORDERS = length
    ),
    t, :USER_KEY)

是这条线不起作用

TOTAL_PAID_LAST_MONTH = [:ORDER_DATE, :PRICE] => countOnlyLastMonth,

使用 DataFrames.groupby 你可以这样做:

[:ORDER_DATE, :PRICE] => countOnlyLastMonth => :TOTAL_PAID_LAST_MONTH,

我怎么能用 juliaDB 做到这一点?谢谢

标签: group-byjuliajuliadb

解决方案


推荐阅读