Challenge #3: Running Averages

We hope you enjoyed last week's challenge. For the third challenge, let’s look at creating 3 and 6 month running averages.

The goal is to create 3 and 6 month running averages for the values contained in columns: c.LK98, p.LK98, c.1K, p.1K, c.NLP3, and p.NLP3. Create the averages by RM Category.

Update: As of 9/20/19, the start and solution files were updated. Your solutions may not look like those posted by Community members prior to this date.

challenge_3_solution.yxmd

challenge_3_start_file.yxmd

Parse

Join

Preparation

Advanced

Intermediate

Data Preparation

Transform

Accepted answers

All comments

gawa

Though not exactly same to solution, but this is my answer.

Spoiler

gawa

As cannot edit last post, upload solution as a new post

challenge_3_start_file.yxmd

AImbody

This was good for some tools I wasn't familiar with.

challenge_3_start_file AI.yxmd

perin

Output in solution seems different. Although, it was a fun one.

challenge_3_perin.yxmd

SJKIM

Always CROSS / TRANSPOSE is not easy.

challenge_3_start_file_Solved.yxmd

InchulKo

Here is my solution.

challenge_3_Solved.yxmd

caltang

Done, but not sure lol.

Spoiler

challenge_3_start_file_ct.yxmd

orangebomber

Spoiler

challenge_3_solution_file-jh.yxmd

Spoiler

Spoiler

Here is my solution.

Hi, here is my solution, but the output doesn't make sense to me to be honest...😕

challenge_3_SOLUTION.yxzp

AthollJ

Solution attached

challenge_3_start_file.yxmd

MDestra

Challenge #3:

challenge_3_start_file-MD.yxmd

Carolyn

Completed! My format is a bit different than the solution but being that this challenge is almost 7 years old, I'm saying it's good enough

Spoiler

challenge_3_start_file.yxmd

iamBenSmith

This one was a bit confusing when looking at the provided output file, but this solution makes the most sense of the data provided

Spoiler

3.yxmd

RasmusFormo

My solution

challenge_3_solution.yxmd

Myles_Stevenson

Spoiler

Here is my solution

Challenge 3.yxmd

CoG

This was tough, and I needed a little help, since I didn't understand the necessary tools well enough.

Spoiler

challenge_3_Solution.yxmd

danielprince

A bit confusing but it made more sense after understanding the output

challenge_3_start_file.yxmd

ToniZheng

I think there's something wrong with the solution. The 6-month running average isn't by RM Category. But well, good practice.

challenge_3_start_file.yxmd

StevenP

My Solution:

Spoiler

As others have already mentioned the solution's 6 Month average is not grouped by RM Category hence my output not matching 100%

challenge_3_SP.yxzp

unknown

The naming structure on the output was a bit challenging to understand, but alas, success!

Screenshot 2023-11-29 114010.png

BrianJohnson

I am submitting a different output presentation. To me, the goal was to present a 3 and 6 month average by those named columns and RM category. When I look at the provided solution output, I didn't see that as the result and the RM category was mixed in with the various type of values.

I'm presenting two displays in which I'd rather see the data. Sorry....

challenge_3_My_Solution.yxmd

Rob-Silk

Challenging target output to interpret and similar to some others I have chosen to display the output differently as I feel it is easier to understand.

My solution:

Spoiler

challenge_3_solution_RS.yxmd

B_SarkadiNagy

Spoiler

challenge_3_SNIB.yxmd

Shoujain

Here is the solution

challenge_3_Solution_Shoujain.yxmd

Aratryn

The provided solution doesn't seem to match the brief as the 6m average isn't grouped by RM Category (though the 3m average is).

challenge_3_solution.yxzp

nSpire

Spoiler

challenge_3_nSpire.yxzp

albracht7

Solution

challenge_3_start_file.yxmd