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 #36: Data Cleansing Extract Authors

Alekh
9 - Comet

My solution36.png

 

AJauniskis
8 - Asteroid

My solution:

 

Spoiler
workflow.JPG
Sajeel_Kershi
8 - Asteroid

used text to columns to split on "-", filtered out for "PMID" and "FAU". Copied PMID down for each group and then applied crosstab to get result

rfergus
8 - Asteroid
Spoiler
image.png
FeedMeData
8 - Asteroid

Here's my solution

gurth
7 - Meteor

A little kludgey, but seems to work...

Anastasiia
8 - Asteroid

Here is my solution

JonathanAllenby
8 - Asteroid

Here's my solution to challenge 36!

Jonathan-Sherman
15 - Aurora
15 - Aurora

Number 36 is done!

Spoiler
challenge 36 JMS solution.PNG
Thableaus
17 - Castor
17 - Castor

Challenge #36, done.

 

Good practice to clean data. 

 

Spoiler
Challenge_36.PNG

 

Cheers,