First time posting..
I have a large data set with three columns: Date purchased, Item, and Transaction id.
The transaction id can have multiple items for the same transaction id.
I want to search how many times different item combinations repeat for each transaction id.
I.e. I want to count how many times someone would order Chicken and Grain bowl together based on different transaction ids
<tbody>
</tbody>
Hope that explanation made sense.
I have a large data set with three columns: Date purchased, Item, and Transaction id.
The transaction id can have multiple items for the same transaction id.
I want to search how many times different item combinations repeat for each transaction id.
I.e. I want to count how many times someone would order Chicken and Grain bowl together based on different transaction ids
item | transactionid | ||
Salad | 7cb3b0b6-ed6d-4d13-bff4-de990c0f2bc2 | ||
lamb_sliders | 7cb3b0b6-ed6d-4d13-bff4-de990c0f2bc2 | ||
chips | 7cb3b0b6-ed6d-4d13-bff4-de990c0f2bc2 | ||
Greens&Grains | 7aef0a2c-9fde-477d-9992-ab78387dba92 | ||
Chicken | 7aef0a2c-9fde-477d-9992-ab78387dba92 | ||
Salad | e2c99877-4c19-427f-a8e5-d81d000a05d2 | ||
braised_lamb | e2c99877-4c19-427f-a8e5-d81d000a05d2 | ||
cookie | e2c99877-4c19-427f-a8e5-d81d000a05d2 |
<tbody>
</tbody>
Hope that explanation made sense.