We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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
8 - Asteroid

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