Challenge #33: Reshaping Nielsen Data

[dpencheva]

Here is my solution. The task was very interesting like a puzzle!

[PeterH23]

My solution

Spoiler

What a crazy data format.

[joshuaburkhow]

A good reminder to study the data first. Like others, spent time going down a rabbit to realize there is an easy way

[steven4320555]

Overwhelmed by the messy data. It helped to go through some solutions, and as well as export the data into an excel. Got a solution at the end.

Spoiler

I cheated/copied the well-structured part from the browse tool.

Exported the input data into excel, and observed the structure of the data, and figured out the logic of using Regex match ^\(\d\/\d\d\/\d\d\)   to get the date, and the line above with data. Actually  ^\(.*\) was able to do the job. 

Familiarity with the structure of data will definitely help with such a problem.

[AMansour]

Hi,

Here's my solution 

Spoiler

Cheers

Amr

[terry10]

Messy input data. It took me awhile to wrap my head around the task. 

Spoiler

[Sylvana]

My solution.

[deepaprash]

Solved. Took more time to understand the layout of the raw data.

[cc000072]

Here is my solution

Spoiler

[Normster]

My solution was a little longer because I dynamically updated header names.  I see that a few others took the same approach.

Normster