Weekly exercise #7

[Carlos_A]

Hello all,

Sorry for the delay in posting this week's exercises, from now on I will, be posting these on fridays. You can also find the solution to last week's exercise here. For this week we'll be looking at formatting data to a given output:

Use Case: A credit card company’s customer Data is structured so that each row of data contains the merchants each customer has visited in a given week. The credit card company is wanting to understand 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.

Objective:  Restructure the data into rows that pair merchants together by customer.

[Carlos_A]

Hi everyone,

I have attached my solution and the one provided by Alteryx to this week's exercise.

[giuseppe]

Hi Carlos, attached my solution