Challenge #33: Reshaping Nielsen Data

[gawa]

Upload solution file

[SJKIM]

Completed.^^

[MitchellBliesner]

This took a lot longer then I wanted it to. I need to practice more data prep. I also need to practice Regex.

[caltang]

Done!

Spoiler

[Tgigs]

My solution attached.

Had to peek at the solution to figure out what to do.

Added some commentary around the regex expressions to explain what it is doing and added a couple of extra steps to convert some data types at the end (specifically date and numeric types) so that the dataset is primed for analysis.

[Tofel]

Spoiler

[danielhoge]

Spoiler

[afnfyz]

I couldn't figure out the pattern of the numerical values here, had too take a peek at a solution to find the pattern.
Once I knew which rows contained the data it all made sense.

Spoiler

[DanielG]

This was an anxiety-inducing dataset.  What I built solves the problem, but would not be the best solution for a dynamic situation where report structure might look different in a given timeframe.

Glad to wash my hands on this and mark it:

Solved.  😊

[Carolyn]

Solved! I had to peek at the solution to find where the data was since I was lost

Spoiler