[R] Creating Tag

2017-11-01 Thread Hemant Sain
i want to tag categories to its menuname. i have a csv containing menu item name and in other csv i have a column containing some strings, i want to pick that strings from categories and look into menu items if any menu item containing that string i want to create a new column next to menu item

Re: [R] How to define proper breaks in RFM analysis

2017-10-23 Thread Hemant Sain
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 > >&

Re: [R] How to define proper breaks in RFM analysis

2017-10-13 Thread Hemant Sain
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 > Petr > > > > -Original Message- > > From: R-help [mai

[R] How to define proper breaks in RFM analysis

2017-10-12 Thread Hemant Sain
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

Re: [R] Help RFM analysis in R (i want a code where i can define my own breaks instead of system defined breaks used in auto_RFM package)

2017-10-10 Thread Hemant Sain
hat shows what you are doing, I can't > guess what the problem is. > > Jim > > > On Mon, Oct 9, 2017 at 9:40 PM, Hemant Sain <hemantsai...@gmail.com> > wrote: > > I'm getting all the rows as NA in Cscore and almost most of the > observation > > in R and F

Re: [R] Help RFM analysis in R (i want a code where i can define my own breaks instead of system defined breaks used in auto_RFM package)

2017-10-09 Thread Hemant Sain
I'm getting all the rows as NA in Cscore and almost most of the observation in R and F and M are also NA. what can be the reason for this. also suggest me the appropriate solution. On 9 October 2017 at 15:51, Jim Lemon wrote: > Hi Hemant, > Here is an example that might

[R] Help RFM analysis in R (i want a code where i can define my own breaks instead of system defined breaks used in auto_RFM package)

2017-10-06 Thread Hemant Sain
I'm trying to perform an RFM analysis on the attached dataset, I'm able to get the results using the auto_rfm function but i want to define my own breaks for RFM. as follow r <-c(30,60,90) f <-c(2,5,8) m <-c(10,20,30) but when i tried to define my own breaks i got the identical result for RFM

[R] RFM Analysis Help

2017-10-04 Thread Hemant Sain
I'm trying to perform a RFM analysis on attached dataset, i'm able to get the results using the auto_rfm function but i want to define my own breaks for RFM, when i tried to define my own breaks i got the identical result i.e 111 for every ID. please help me with this with working R script. Thanks

[R] nested loop

2017-09-08 Thread Hemant Sain
i have a vector containing values ranging from 0 to 24 i want to create another variable which can categorize those values like this please help me with an R code Thanks *Value New_Var*10 -5 30 -5 50 -5 96-10 76-10 5

Re: [R] Dataframe Manipulation

2017-09-04 Thread Hemant Sain
lit_items(.)) > > cat_help %>% gather("Foo", "Item") %>% > filter(!is.na(Item)) %>% > left_join(data_help, by = "Item") %>% > group_by(Foo, Purchase_ID) %>% > summarise(Item = paste(Item, collapse = ", ")) %>% >

Re: [R] Dataframe Manipulation

2017-08-30 Thread Hemant Sain
by using these two tables we have to create third table in this format where categories will be on the top and transaction will be in the rows, On 30 August 2017 at 16:42, Hemant Sain <hemantsai...@gmail.com> wrote: > Hello Ulrik, > Can you please once check this code again on the fo

Re: [R] Dataframe Manipulation

2017-08-30 Thread Hemant Sain
duct) > > and you mix uppercase and lowercase letters which could be also > problematic, when matching words. > > Cheers > Petr > > > -Original Message----- > > From: R-help [mailto:r-help-boun...@r-project.org] On Behalf Of Hemant > Sain > > Sent: Wed

[R] Dataframe Manipulation

2017-08-30 Thread Hemant Sain
i want to do a market basket analysis and I’m trying to create a dataset for that i have two tables, one table contains daily transaction of products in which each row of table shows item purchased by the customer, The second table contains parent group under those products are fallen, for example