Challenge #316: Blowing in the Wind - Part 1
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
A solution to last week’s challenge can be found here.
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.
- Labels:
- Advanced
- Basic
- Data Preparation
- Parse
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Fun data parse challenge!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator