Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #33: Reshaping Nielsen Data

Towers
11 - Bolide

tried a bit too hard to get the column names on this one 😅

Spoiler
challenge 33.png

BS_THE_ANALYST
14 - Magnetar
14 - Magnetar

Interesting ..

All the best,
BS

LinkedIN

Bulien
tristank
11 - Bolide

If someone gave me data like this we are throwing hands 😤

 

33.png

 

rachel_lynch
Alteryx
Alteryx
Spoiler
Reshaping Nielsen Data.png

Rachel Lynch
MatteoReddavide
8 - Asteroid

My solution

 

Spoiler
Screenshot 2023-07-24 164219.png
lwolfie
11 - Bolide

Struggled with seeing how the data was coming in more than how to separate it.

H_a_n_g_C_h_e_n__x3
8 - Asteroid

Brute forced my way through this data. It's quite the manual solve rather than making it dynamic. Will revisit this one day to see if I can make it more efficient.

GabrielaTudor
8 - Asteroid
Spoiler
Challenge 33.jpg
jon_amanrich
8 - Asteroid

Challenge 33 solution below!

gawa
16 - Nebula
16 - Nebula

Done

Spoiler
image.png