Challenge #392: Calculate Climate Extremes

[AYXAcademy]

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

As a part of our Weekly Challenge User Group October Takeover event, we selected an exciting challenge we received from @myastarling, a member of the Milwaukee User Group. Thanks, Mya, for this fantastic contribution!

You have been tasked with creating a table of average temperatures by region and determining the locations of the warmest and coldest monthly and annual temperatures in the US. Luckily, you remember that the National Oceanic and Atmospheric Administration (NOAA) tracks climactic data through weather observing stations in the 50 US states and US territories, and the National Centers for Environmental Information provides access to the data.

In addition to a variety of other climate measurements, NOAA tracks average temperature. You get the OK to report temperatures by weather station. Using a dataset that contains the normal mean daily temperatures between 1981 and 2010, your challenge is to provide the following:

1. The station with the warmest average annual temperature
2. The station with the warmest average monthly temperature, and the month it occurs
3. The station with the coldest average annual temperature
4. The station with the coldest average monthly temperature, and the month it occurs
5. A table of all stations and their average temperature by month

Source: https://www.ncei.noaa.gov/pub/data/ccd-data/nrmavg.txt

[Flo_P]

My solution for the weather challenge!

Spoiler

[benjimoser]

My Solution:

Spoiler

 

[ed_hayter]

Nice Challenge

Spoiler

[mmontgomery]

C392

Spoiler

Workflow has output table in it, screenshot missed it

[AkimasaKajitani]

My solution!

Spoiler

 

 

[ahsanaali]

Solution attached

Spoiler

Spoiler

Solution using Control Container. Average temperature by States.

[PhilipMannering]

Solution attached..

Spoiler

[binuacs]

Spoiler

[RolandSchubert]

Spoiler