Challenge #33: Reshaping Nielsen Data

[DavidLane]

Similar to other methods but with a couple of developer tools thrown in there,

Spoiler

[jarrod]

looks like there was a typo in the output data in the start file (name of programs and 25-34 instead of 25-54)

Spoiler

[Lucatelli]

Please find attached my proposed response.

[maazinh]

Ended up being much simpler than I thought it'd be

[avinashsunchu]

Spoiler

 

[AngelosPachis]

Challenge #33 solved

[jacob_kahn]

Great challenge!

[seinchyiwoo]

As soon as I figured out which part of the raw data is data row(which I have to scroll all the way down), it becomes pretty straightforward....

Spoiler

[Blake]

I wouldn't say this was my favorite challenge...

Spoiler

[Ben_Jeffreys]

My submission