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 #329: Near Earth Objects

AYXAcademy
Alteryx
Alteryx

Near-Earth Objects (NEO) are rocks in space that come within a certain distance of the Earth. These objects are tracked to determine if they have the potential to impact the Earth.

image329.png

 

The dataset for this challenge includes the 1000 nearest objects discovered to date. The numeric fields for distance and size are in units of km and the velocity is in units of km/s.

 

For this challenge:
- Parse out the year from the "name" field and then find out which year has the most discoveries?
- Find out in what years hazardous objects were discovered?
- Find out what year had the the highest average of "relative_ velocity" of all objects found?


Datasets
Two datasets are available for this challenge; one dataset to parse and one already parsed for our new users.
In both datasets, the "name" field represents the year the object was discovered.

mmontgomery
8 - Asteroid

Challenge 329

Spoiler
Year regex: REGEX_Replace([name], ".*(\d{4}).*","$1")
mmontgomery_0-1658757109941.png

 

MilindG
11 - Bolide
Spoiler
MilindG_0-1658757728360.png

 

Luke_C
17 - Castor
Spoiler
Luke_C_0-1658757834060.png

 

Kenda
15 - Aurora
15 - Aurora
Spoiler
Kenda_0-1658757990576.png

 

patrick_digan
17 - Castor
17 - Castor
Spoiler
patrick_digan_0-1658758514557.png

 

Amol_Telore
11 - Bolide
Spoiler
Amol_Telore_0-1658758646848.png

 

MuralidharAreti
8 - Asteroid

I took the pre-parsed route because... 

 

Spoiler
MuralidharAreti_0-1658759068458.png

 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
329.png
phottovy
12 - Quasar
Spoiler
329.png