https://community.splunk.com/t5/Splunk-Search/How-to-create-a-market-basket-analysis/m-p/146256#M185206 <P>HI guys,</P> <P>Been trying to create a market basket analysis using splunk. Simply, I would like to build a pivot that would show me what other items were bought when Product A was purchased.</P> <P>I have a CSV with two columns, Transaction IDs and Products names. If a transaction had more than 1 item purchased the id will be listed with as many unique items as possible.</P> <P>Example </P> <P>ID-32 Product A<BR /> ID 32 Product B<BR /> ID 33 Product G<BR /> ID 33 Product B<BR /> ID 34 Product A<BR /> ID 34 Product J</P> <P>etc.</P> <P>I am sure Splunk can do it. I just can't wrap my brain around it right now.</P> <P>Thank you.</P> Sat, 06 Dec 2014 00:29:25 GMT tylampella 2014-12-06T00:29:25Z https://community.splunk.com/t5/Splunk-Search/How-to-create-a-market-basket-analysis/m-p/146256#M185206 <P>HI guys,</P> <P>Been trying to create a market basket analysis using splunk. Simply, I would like to build a pivot that would show me what other items were bought when Product A was purchased.</P> <P>I have a CSV with two columns, Transaction IDs and Products names. If a transaction had more than 1 item purchased the id will be listed with as many unique items as possible.</P> <P>Example </P> <P>ID-32 Product A<BR /> ID 32 Product B<BR /> ID 33 Product G<BR /> ID 33 Product B<BR /> ID 34 Product A<BR /> ID 34 Product J</P> <P>etc.</P> <P>I am sure Splunk can do it. I just can't wrap my brain around it right now.</P> <P>Thank you.</P> Sat, 06 Dec 2014 00:29:25 GMT https://community.splunk.com/t5/Splunk-Search/How-to-create-a-market-basket-analysis/m-p/146256#M185206 tylampella 2014-12-06T00:29:25Z https://community.splunk.com/t5/Splunk-Search/How-to-create-a-market-basket-analysis/m-p/146257#M185207 <P>You could do something like this</P> <PRE><CODE>| search_or_inputlookup_to_get_csv | stats values(Products) as ProductList by TransactionID | where isnotnull(mvfind(ProductList,"Product A")) </CODE></PRE> Sat, 06 Dec 2014 00:54:58 GMT https://community.splunk.com/t5/Splunk-Search/How-to-create-a-market-basket-analysis/m-p/146257#M185207 lguinn2 2014-12-06T00:54:58Z https://community.splunk.com/t5/Splunk-Search/How-to-create-a-market-basket-analysis/m-p/146258#M185208 <P>this search string doing the work for the following data<BR /> sample data:<BR /> partner cost<BR /> World T Plus 19000<BR /> Prix Mono 47500<BR /> Prix Mono 19000<BR /> Prix Mono 19000<BR /> World T Plus 19000<BR /> Prix Mono 19000<BR /> Prix Mono 38000<BR /> Prix Mono 19000</P> <P>search string:<BR /> source="C:\tachiFlashDisc\test_firstAnswers.csv" |sort partner|table partner cost | dedup cost<BR /> result:<BR /> partner cost<BR /> Africa Telecom 9500<BR /> Africa Telecom 19000<BR /> Africa Telecom 47500<BR /> Africa Telecom 28500<BR /> B and C 0<BR /> B and C 4750<BR /> B and C 33250<BR /> B and C 14250</P> Fri, 12 Dec 2014 12:10:21 GMT https://community.splunk.com/t5/Splunk-Search/How-to-create-a-market-basket-analysis/m-p/146258#M185208 tachifelix 2014-12-12T12:10:21Z