search for: subtotal_amount

...31 2 7.99 291719 21.26 8/25/2017 6 2 15.67 291787 46.1 8/31/2017 0 2 32.57 292630 24.34 7/31/2017 31 1 24.34 295204 21.86 7/18/2017 44 1 21.86 295989 8.98 8/20/2017 11 2 14.095 298883 14.38 8/24/2017 7 2 11.185 308824 10.77 7/31/2017 31 1 10.77") names(dat) <- c("user_id", "subtotal_amount", "created_at", "Recency", "Frequency", "Monetary") dat <- data.frame(dat,stringsAsFactors=FALSE) I suspect read.table would also have worked for me, but I was expecting difficulties based on Petr's posting. #And ended up with this result (on t...

Hi Hemant, As I suspected, the code broke when I got to the line: result <- rfm_auto(df, id="user_id", payment ="subtotal_amount", date="created_at") Error in rfm_auto(df, id = "user_id", payment = "subtotal_amount", date = "cr eated_at") : could not find function "rfm_auto" It looks like you are using the hoxo-m/easyRFM function hosted on GitHub. I may get a chance t...

...5.67 > 291787 46.1 8/31/2017 0 2 32.57 > 292630 24.34 7/31/2017 31 1 24.34 > 295204 21.86 7/18/2017 44 1 21.86 > 295989 8.98 8/20/2017 11 2 14.095 > 298883 14.38 8/24/2017 7 2 11.185 > 308824 10.77 7/31/2017 31 1 10.77") > > names(dat) <- c("user_id", "subtotal_amount", "created_at", "Recency", "Frequency", "Monetary") > dat <- data.frame(dat,stringsAsFactors=FALSE) > > I suspect read.table would also have worked for me, but I was expecting difficulties based on Petr's posting. > > > #And ende...

...32.57 > > 292630 24.34 7/31/2017 31 1 24.34 > > 295204 21.86 7/18/2017 44 1 21.86 > > 295989 8.98 8/20/2017 11 2 14.095 > > 298883 14.38 8/24/2017 7 2 11.185 > > 308824 10.77 7/31/2017 31 1 10.77") > > > > names(dat) <- c("user_id", "subtotal_amount", "created_at", "Recency", > "Frequency", "Monetary") > > dat <- data.frame(dat,stringsAsFactors=FALSE) > > > > I suspect read.table would also have worked for me, but I was expecting > difficulties based on Petr's posting....

...,8) m <-c(10,20,30) but when i tried to define my own breaks i got the identical result for RFM i.e 111 for every ID. please help me with this with working R script so that i can get output according to my own defined values of RFM instead of system defined breaks. Thanks *Dataset:* *user_id subtotal_amount created_at* *3451945 19.32 6/11/2017 17:40* *5404261 20 6/16/2017 22:45* *3572177 9.78 7/6/2017 0:41* *1197515 11.97 5/20/2017 17:48* *7288355 14.76 6/5/2017 17:48* *3071276 7.99 6/11/2017 0:13* *8568400 15.98 6/22/2017 0:59* *429475 7.99 6/8/2017 18:14* *6805938 13.97 7/1/2017 23:30* *561442 11....

...bution is non normal. so i want you to suggest another method so that i can define 3 breaks with the ideal interval for Recency, frequency and monetary to calculate RFM score. i'm again attaching you some of the data set. please look into it and help me with the R code. Thanks Data user_id subtotal_amount created_at Recency Frequency Monetary 194849 6.99 8/22/2017 9 5 9.996 194978 14.78 8/28/2017 3 15 16.308 198614 18.44 7/31/2017 31 1 18.44 234569 34.99 8/20/2017 11 8 13.5075 252686 7.99 7/31/2017 31 2 7.99 291719 21.26 8/25/2017 6 2 15.67 291787 46.1 8/31...

...ution is non normal. so i want you to suggest another method so that i can define 3 breaks with the ideal interval for Recency, frequency and monetary to calculate RFM score. i'm again attaching you some of the data set. please look into it and help me with the R code. Thanks *Data* user_id subtotal_amount created_at Recency Frequency Monetary 194849 6.99 8/22/2017 9 5 9.996 194978 14.78 8/28/2017 3 15 16.308 198614 18.44 7/31/2017 31 1 18.44 234569 34.99 8/20/2017 11 8 13.5075 252686 7.99 7/31/2017 31 2 7.99 291719 21.26 8/25/2017 6 2 15.67 291787 46.1 8/31/2017 0 2 32.57 292630 24.34 7/31/2017 31 1...

Hi Your statement about attaching data is problematic. We cannot do much with it. Instead use output from dput(yourdata) to show us what exactly your data look like. We also do not know how do you want to split your data. It would be nice if you can show also what should be the bins with respective data. Unless you provide this information you probably would not get any sensible answer. Cheers

Hello, I'm working on RFM analysis and i wanted to define my own breaks but my frequency distribution is not normally distributed so when I'm using quartile its not giving the optimal results. so I'm looking for a better approach where i can define breaks dynamically because after visualization i can do it easily but i want to apply this model so that it can automatically define the