Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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

apathetichell
18 - Pollux

I'm not 100% comfortable with the answer provided - but that's what I got once I limited myself to the first 30 records. regexed out the fieldnames but they were so useless that I ended up hardcoding them anyway.

 

I remember nielsen ratings to my old college radio station... by fax. They were slightly easier to read than this.

Gopi_Krishna_Bandi
8 - Asteroid

Hi,

 

PFA my solution

Toons
12 - Quasar

My solution :

 

Spoiler
Toons_0-1617049819226.png

 

Maskell_Rascal
13 - Pulsar

Here is my solution!

 

Spoiler
Maskell_Rascal_0-1619103208718.png

 

Cheers!

Phil

meghanarang
6 - Meteoroid

Interesting challenge

Erin
9 - Comet
Spoiler
Was trying to get away from manually updating the headers in the last join, but adding the age classification to the headers stumped me. Just seemed more efficient to add manually in the join after all. 
dmceleney
7 - Meteor

completed

RashedDS
8 - Asteroid

My solution

Spoiler
RashedDS_0-1626541235468.png

 

JackBurnham
8 - Asteroid

b

Elias_Nordlinder
11 - Bolide

Here is my solution:

 

Spoiler
Elias_Nordlinder_0-1626962344224.png

 

Elias_Nordlinder_1-1626962375082.png