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 #170: 2019 Grand Prix US - Heat 1

MatteoReddavide
8 - Asteroid

My solution

 

Spoiler
Screenshot 2023-07-11 095034.pngScreenshot 2023-07-11 095056.png
Charity_K_Wilson
10 - Fireball

The imputation was rough for me.  And I use the multi-row formula often.  I just struggled with it. 

 

The ETS part was simple enough.

NMangera
10 - Fireball

workflow.png

 

takeway

1. directly read in zip files

ed_hayter
12 - Quasar
Spoiler
I was fairly quick at this one - could have done it faster had i not tried to avoid using crosstab by using group-by in the multi-row only to realize that would not work because without the crosstab I had not generated the null entries that needed to be imputed.


Challenge 170 WF Image.png
gawa
15 - Aurora
15 - Aurora

Done

yuyadezaki
6 - Meteoroid

here is my solution.

Spoiler
Challenge_#170_done.png
mithily
8 - Asteroid
Spoiler
easy enough using tsforecast
daiphuongngo
9 - Comet
Spoiler
Screenshot 2023-10-09 170014.png

Hub119
8 - Asteroid

Solution attached.

BS_THE_ANALYST
14 - Magnetar

~ 10 minutes.

 

Spoiler:

Spoiler
Challenge170.png