Related Values

Hello,
i am working on recommender and i am at the first step and doing Data preperation. This is an example how my data looks like:
I wannted to make my Algorithm understand that the names with the same 'matchid' are related together.
It's important because I want to know which Champions(Name) are related togehter and later, if I've just got one name, I want to predict the other one.
Hope someone can help me. Thnaks!
Best Answer
-
Hi,
I think Pivot is your friend
Best,
Martin
3
Answers
-
You can use the Aggregate operator to group by mattch id and aggregate counts of purchases, etc. Then run your analysis on the dataset prepared in that way.
1 -
Hi,
I think Pivot is your friend
Best,
Martin
3 -
@Telcontar120 Thanks for your help. It's not really clear for me how thise gonna be work, but i'm fine with pivot.
@mschmitz Thanks a lot
1