We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

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

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

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

Qiu
19 - Altair
19 - Altair

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
16 - Nebula

My solution to #346.

 

Spoiler
DataNath_0-1669041368402.png
AkimasaKajitani
16 - Nebula
16 - Nebula

My solution.

 

Spoiler
AkimasaKajitani_0-1669041615501.png

 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
346.jpg
mmontgomery
8 - Asteroid

Challenge 346

 

Spoiler
mmontgomery_1-1669044325218.png

 

sergejs_kutkovics
7 - Meteor

My try!

Spoiler
sergejs_kutkovics_0-1669046128828.png

 

joelmiller66
9 - Comet

wc.jpg

Spoiler
pic 346.jpg
braveraj
8 - Asteroid
Spoiler
braveraj_0-1669048377180.png

 

TurboToad
8 - Asteroid

My solution

 

Spoiler
TurboToad_0-1669052128412.pngTurboToad_1-1669052154643.png

 

OllieClarke
14 - Magnetar
14 - Magnetar

Here's my solution:

Spoiler
OllieClarke_0-1669052552445.png