Challenge #25: Creating Merchant Combos

[derekbelyea]

Spoiler

[Tubalady]

My solution

[sglynn14]

.

[rockyw9]

See solutions attached.

[scoles0617]

My solution:

[Jeune]

Spoiler:

I was a bit confused by this one.  The question states that you want to know "the correlation of merchants visited by customer, for example if a customer visit 7-11 what other stores do they have a high propensity to visit." So my solution looks at all combinations between stores for a customer, while at the same time removing any nulls in the 2nd merchant column which are the result of a customer only visiting one store.

 

[Robinvm]

Solved

[sreekanthac]

My solution attached!

[Alteryx_AR]

My solution

[FrederikE]

Spoiler

My way may not be dynamic, but since that wasn't asked for, I took the quick route.