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 #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
10 - Fireball

Challenge 329

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

 

MilindG
12 - Quasar
Spoiler
MilindG_0-1658757728360.png

 

Luke_C
17 - Castor
Spoiler
Luke_C_0-1658757834060.png

 

Kenda
16 - Nebula
16 - Nebula
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
13 - Pulsar
13 - Pulsar
Spoiler
329.png