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 #316: Blowing in the Wind - Part 1

AYXAcademy
Alteryx
Alteryx

A solution to last week’s challenge can be found here.image316.png

 

This week is part 1 of the challenge “Blowing in the wind”. 

 

On December 30, 2021, a windstorm moved through some of the Front Range counties of Colorado. One Alteryx associate found herself driving back home in the storm and being “blown in the wind”. And she got the idea for a two parts challenge.

 

The dataset comes from the US National Weather Service, and it recorded the maximum wind speeds at several locations.

 

Use the dataset to:
- Find the county, location with the maximum highest wind speed at a given time
- Rank the counties by average highest wind speed
- Determine if the average highest wind speeds were before Noon or after Noon

 

First, prepare and the parse the provided input string into separate columns.

 

Note: you only need to parse up to the time.

Luke_C
17 - Castor
Spoiler
Luke_C_0-1650896585176.png

 

AkimasaKajitani
16 - Nebula
16 - Nebula

My solution.

 

Spoiler
AkimasaKajitani_1-1650898173326.png

 


 

balajilolla1
8 - Asteroid
Spoiler
Solution Attached

balajilolla1_0-1650898940007.png

 

Blake
12 - Quasar

I went outside to see this crazy wind storm everyone was talking about...

 

Spoiler
I was blown away!
Spoiler
316WC.png

 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
316.png
binuacs
17 - Castor
Spoiler
binuacs_0-1650902176086.png

 

TonyAndriani
8 - Asteroid

Here's my solution

Spoiler
TonyAndriani_0-1650905340760.png

 

 

TurboToad
8 - Asteroid

Fun data parse challenge!

Spoiler
TurboToad_0-1650909266939.png

 


 

Hsolmaz
7 - Meteor

Fun one. Thank you.