Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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
20 - Arcturus
20 - Arcturus

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

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
10 - Fireball

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
10 - Fireball
Spoiler
braveraj_0-1669048377180.png

 

TurboToad
9 - Comet

My solution

 

Spoiler
TurboToad_0-1669052128412.pngTurboToad_1-1669052154643.png

 

OllieClarke
15 - Aurora
15 - Aurora

Here's my solution:

Spoiler
OllieClarke_0-1669052552445.png