Challenge #330: Check out the weather

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

Do you check the weather before planning a trip to a foreign country?

The following dataset contains information about the temperature of various locations in Ireland. Your job is to find the following the average (rounded up), the minimum, and the maximum temperature by "Station" in the Spring, Summer, and Fall. Use only the temperature recorded at 12:00.

Note: Use the following dates to determine the seasons:
- Spring March 19
- Summer June 20
- Fall September 22

Thank you for your comments, this challenge has been updated.

challenge_330_start_file_updated.yxzp

challenge_330_solution_updated.yxzp

Parse

Join

Data Preparation

Core

Transform

Basic

Accepted answers

All comments

Luke_C

Spoiler

Getting different values, not sure how the solution is doing it. For example the min spring temp in Athenry per the solution is 7.1, but in the data there are negative temperatures, for example on 4/11 which solidly falls within the spring range.

challenge_330_start_file.yxmd

philipmannering

Also getting different values...ヽ(ಠ_ಠ)ノ

But very similar to @Luke_C .... so that'll do for me.

Spoiler

challenge_330_start_file.yxmd

balajilolla1

Spoiler

Solution Attached

challenge_330_start_file.yxmd

MilindG

Spoiler

Solution 330.yxmd

Watermark

Like the others my numbers don't match, but they match with what others are getting. So 🤔

Spoiler

challenge_330_MT_Solution.yxmd

Watermark

ps - also have to say that initially it looked like it was using "month" of march from 'year' of 2019, then discover that data is only 2012. Ok, but the way it's worded seems like it indicates use ONLY that day ie. March 19 of 2012. Yes you can 'assume' but remember data types have learned that 'assuming' things gets you in trouble and will use the instructions provided. Lastly it provides no 'end' date for the range of using fall, so you 'have' to assume an end date .... 2012-12-21? 2012-12-31? Lastly, since none of us are matching. It seems there are other built in assumptions not identified in the instructions. Is it by design to make the instructions ambiguous? Have us spend effort trying to figure out the unspoken assumptions in order to match? Since (let's be honest) you never actually get clear instructions in real life. I leave these various thoughts, but seems that instructions should be clear enough that we all land on the same number in the solution. Just my pennies.

alexnajm

Agreed with everyone, not matching the output and I double checked a few to feel comfortable with my output

Spoiler

challenge_330_start_file_Alex Abi-Najm.yxmd

AkimasaKajitani

My solution!

I also could not match the answers.

Spoiler

challenge_330_start_file_AK.yxzp

binu_acs

Spoiler

challenge_330_solution_BV.yxmd

Nadia_Bonner

Spoiler

challenge_330_start_file.yxmd

phottovy

My solution:

Spoiler

challenge_330_ph_solution.yxmd

patrick_digan

Looks like they're only using the noon measurements and removing empty readings.

Spoiler

challenge_330_start_file.yxmd

opoleleyeva

agree with others about different results

Spoiler

challenge_330_solution.yxmd

TurboToad

My take on the solution. Output does not match, but as mentioned it looks like they only used the 12:00 temps for output. Not called out in the description so little confusing.

Spoiler

TT_challenge_330_solution_file.yxzp

mmontgomery

Challenge 330:

Spoiler

c_330.yxzp

mikemotter

The output example only appears to look at the 12:00 readings.

Spoiler

Irish Weather Challenge 2.yxzp

Kenda

Spoiler

Same comments as @patrick_digan plus the average wasn't always rounded up

challenge_330_start_file.yxmd

Kenda

Great use case for the Make Columns tool, @mmontgomery! I always forget about that one, but it's definitely helpful here

ahsanaali

challenge_330_Solution_AAA.yxmd

Powerhouse_21

Two Outputs

#1: All dates and times in the dataset

#2: All dates and only at Noon (to match the start file output)

Spoiler

PH21_Challenge_330.yxmd

nkinsey

Spoiler

Couldn't get the right answer like most others on here, but got similar output to others

challenge_330_nkinsey_solution.yxmd

Kaustubh17

@AYXAcademy

Here is my solution for weekly challenge 320. The result is not matching. Waiting for the exact solution for this challenge.

Weekly Challenge 330.png

Regards,

Kaustubh

Weekly Challenge 330.yxzp

RobertZiegl

Spoiler

2022-08-02 14_13_22-Alteryx Designer x64 - challenge_330_start_file.png

Challenge how to match the output to the correct output Unclear why to filter on only a single time of the day and why "rounded up" is different...

challenge_330_start_file.yxzp

CallumWilson

Same as other, different values but i'm happy with my outcome.

challenge_330_CW.yxmd

RolandSchubert

Spoiler

Also got different results ...

challenge_330_solution_rsc.yxzp

mattnason1

My solution. Slightly different results but I'm wondering if I picked the wrong day as first of winter which of course would change spring/fall. Might be good to add first day of winter to the challenge to get results more in line.

Spoiler

challenge_330_start_file_updated.yxmd

JamesCharnley

Spoiler

I've matched output here by accident genuinely without intending to. I was kind of annoyed at the lack of an end date for seasons so I just did the two ranges we had and then 'else Fall', completely disregarding the fact a fourth season exists to see if I could work out the change later. Not sure why it would be set up that way though.

Challenge 330 Zipped.yxzp

Toons

My solution :

Spoiler

challenge_330_Solution_Toons.yxzp

DataNath

My solution to #330.

Spoiler

Challenge 330 completed.yxmd

praveen_babu

Solution as per the updated challenge

challenge_330_solution.yxmd

Brian32

Challenge Solution:

The requirement of 12:00 is missing in the workflow which causes a bit of confusion I think. Also, my numbers are slightly off, but that is because I considered Round Up to mean that even .1 would go to the next integer. Great challenge!