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 #349: Analyze the World Cup Event

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
AkimasaKajitani_0-1670858225418.png

 

RWvanLeeuwen
11 - Bolide

quick challenge

Spoiler
i was first tempted to do some data cleaning by parsing the dates, but we don't have to care about that. Most of these challenges require a top 3 or whatever and we can get there with a sort+sampe combo but for question 2 I decided to use the good ol' multirow+filter combination as it allows us to discern tied ranks (if there are any)i was first tempted to do some data cleaning by parsing the dates, but we don't have to care about that. Most of these challenges require a top 3 or whatever and we can get there with a sort+sampe combo but for question 2 I decided to use the good ol' multirow+filter combination as it allows us to discern tied ranks (if there are any)
dougbaron
8 - Asteroid
Spoiler
dougbaron_0-1670860662945.png

 

DanFlint
8 - Asteroid

My solution:

Spoiler
DanFlint_0-1670861053187.png

 

AlexTan07
5 - Atom

Here is my solution for this challenge

Spoiler
AlexTan07_0-1670861146805.png

 

TurboToad
9 - Comet

My solution

Spoiler
TurboToad_0-1670863321462.png

 

braveraj
10 - Fireball
Spoiler
braveraj_0-1670863651096.png

 

mmontgomery
10 - Fireball

Rather straight forward. Used regex to extract out team names for P1.

 

Spoiler
mmontgomery_0-1670864546072.png

 

Watermark
12 - Quasar
12 - Quasar
Spoiler
MT_Solution_349.jpg

Allez les Blues!

FinnCharlton
13 - Pulsar
Spoiler
FinnCharlton_0-1670866816852.png