Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #346: Map Messi and Ronaldo's Goals (Part 1)

Qiu
21 - Polaris
21 - Polaris

A solution to last week’s challenge can be found here.

image_346.png

 

This challenge comes to us from @Qiu  who was inspired after reading the following article: https://medium.com/analytics-vidhya/using-spatial-and-activities-data-with-python-to-understand-how-.... Thank you for your contribution!

 

This week and next week, you will use datasets to analyze how Lionel Messi and Cristiano Ronaldo do their magic.

To complete Part 1 of this challenge:
- Use the Players dataset to filter information about Messi and Ronaldo. You must include the first name, last name, role name, short name, and ID (wyid or playerid).
- Use the events_Spain_Goal dataset to retrieve information for the same 2 players. You must include the eventName, matchID, playerID, position_0_x, position_0_y, subEventID, subEventName, and tags_0_id.
- Join your 2 findings in 1 dataset. It will be used in Part 2 of the challenge.

DataNath
17 - Castor
17 - Castor

My solution to #346.

 

Spoiler
DataNath_0-1669041368402.png
AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
AkimasaKajitani_0-1669041615501.png

 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
346.jpg
mmontgomery
11 - Bolide
11 - Bolide

Challenge 346

 

Spoiler
mmontgomery_1-1669044325218.png

 

sergejs_kutkovics
9 - Comet

My try!

Spoiler
sergejs_kutkovics_0-1669046128828.png

 

joelmiller66
9 - Comet

wc.jpg

Spoiler
pic 346.jpg
braveraj
11 - Bolide
Spoiler
braveraj_0-1669048377180.png

 

TurboToad
11 - Bolide

My solution

 

Spoiler
TurboToad_0-1669052128412.pngTurboToad_1-1669052154643.png

 

OllieClarke
16 - Nebula
16 - Nebula

Here's my solution:

Spoiler
OllieClarke_0-1669052552445.png