Challenge #392: Calculate Climate Extremes

[tammybrown_tds]

I couldn't tell how the table was supposed to be sorted, so it's not sorted the same as the answer.

Spoiler

[Ray_Pospisil]

I am skipping SQL this time. Only Alteryx and Python code. I am not saying impossible in SQL but highly impractical to use SQL for such parsing in real life.

[AlexvanOs]

Fun to play with parsing!

To make it a bit more challenging, I chose to parse the headers as well and chose to make 3 different ways to tackle tasks 1-4.

I haven't checked the solution yet, but I expect the solution will use sort & sample, then union the results.

I also added 2 other methods: one without union or joins and one with basic summarize functions that does use joins and unions. 

Spoiler

[LHolmes]

Loved this challenge!

Spoiler

Solution
Q1-4
Q5

[bgreedy]

Spoiler

[ARussell34]

It's fascinating there could be such extremes for states and territories a part of the same country.

[agulati]

Solution attached. A combination of:

1. Download tool

2. text to column parsing (multiple)

3. Cleaning

4, Reporting tool

5. Basic aggregations

[Medha31]

PFA my solution

[gazpool]

solution

[estherb47]

My solution attached