I need to create the below matrix where i can see the flow of customers from one drink to another over Month. Eg. 2 customers drinking coffee in Jan prefer Tea in Feb.
The actual problem will need to accommodate comparison of different months and items( like drinks here).
3 years of data. But from analysis perspective change in 1 month, 3 month, 6 month and 1 year is desirable. and volume wise > monthly snapshot is ~ 1000000 rows.
Hi Kush, Like mentioned in the reply change in 1 month, 3 month, 6 month and 1 year is desirable if not fully dynamic. Like curr. month vs last month or curr. month vs 3 months ago. etc. The main script cannot be changed as its a 100+ column data and the requested problem is one of many use cases.
