r - R使用最小值和最大值表分配一个段

Question

我根据客户访问的次数创建了细分。这看起来像这样：

我想使用此表为每个客户分配一个组。

有任何想法吗？

structure(list(frequency_score = c(1L, 4L, 5L), number_of_orders = c(4263L, 
1307L, 1333L), min = c(1, 2, 4), max = c(1, 3, 146), frequency_band = c("1 - 1", 
"2 - 3", "4 - 146")), row.names = c(NA, -3L), .Names = c("frequency_score", 
"number_of_orders", "min", "max", "frequency_band"), class = c("tbl_df", 
"tbl", "data.frame"))

标签： rmergemaxmin

Answer 1

我已经这样做了，尽管它比 R 更 sql ......

sqldf("select a.*
            , c.frequency_score as frequency_score1
            from df a 
            left join counts_frequency c
            on a.visits between c.min and c.max
            ")