Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #33: Reshaping Nielsen Data

Asteroid
Spoiler
Chantelbbr_0-1580266014616.png
Highlighted
Fireball

#33

Spoiler
33.PNG
Highlighted
Alteryx Partner

Very tricky. That data format was horrible!

Highlighted
Asteroid

I used a long time on determine the header name...

 

Highlighted
Asteroid
 
Highlighted

Not the best solution, and they'd better never change the number of header or footer rows. I could have done better with filtering out data rather than sampling, but the format just made me so angry i wanted to be done with it.

Spoiler
sonyakasenkramer_0-1581951792571.png

 

Highlighted
Asteroid