I need to produce an association rules work flow based on a shopping list. The dataset is CSV so I don’t seem to be able to upload it. The confusion I’m having is that all the examples and practice exercises I’ve worked with has has all the items in one cell, not split into individual cells like this. (I’ve try to upload an image). I’ve tried to work with the file as it is but so far no luck in getting anything useful (yet!). I was wondering should I merge the cells into one list? I tried column combine but rows have different items so when I combine all the columns I get a bunch of messy ? and “”. What would be the optimum approach?
Can you be a bit more specific about what the idea behind this is? What is the expected output? Can you draft an example? What have you tried so far? The more you can provide (data, screenshots, workflows, etc.), the better people will be able to help you out Are you looking for similarities between shopping lists?
If you convert the csv to an Excel sheet, you are able to upload it the forum so people can work with the same data.
It’s tricky, because it’s my assignment for Uni. Our practice data sets were structured differently to this set so the methods don’t work. I did Domain Calculator to unrestrict the limits then One to Many but it’s just created a load of duplicates. Fortunately it’s a tiny bit of the assignment so I can move onto something else that (hopefully) I can get my head around! Thank you for offering to help
groceries - groceries (1).xlsx (261.9 KB)
My assignment is all handed in and I didn’t get it to work but I would like to understand where I went wrong, this is the workflow I started following what I had been taught in class, but I would be interested to learn how others would of approached it so I know next time (and I can see this being really useful in my job!) AssoRules.knwf (1.2 MB)