Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI had already given up on trying to match the solution based on obviously incomplete requirements and built something on my own. After I finished, I looked through the solutions and found that only noon dates were used. Didn't bother fixing it. In the real world I would have gone back to the customer and asked for the rest of the requirements before spending hours trying to read their mind.
Most mismatch due to Fall period, probably because Winter date was aggregated.
Some rounding difference for Average temperature.
Here's my solution. If you're having trouble matching the output, try looking up the dates for the Fall season. My workflow may help, if you're still stuck.
The instructions regarding the seasons doesnt make sense
1. Do we only analyse the data for 3 dates - March 19th, June 20th and September 22nd? So completely exclude the other dates?
2. If we are using ranges for our seasons - where does winter fall? I am sure there is meant to be 4 seasons in a year. What do we do with dates from September 22nd and March 18th?