We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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 #332: The more ice cream, the better!

tammybrown_tds
8 - Asteroid

I need some ice cream now.

 

Spoiler
tammybrown_tds_0-1660858594309.png

 

janwisniewski
Alteryx
Alteryx

My first weekly challenge, I really enjoyed solving it! 

 

Spoiler
janwisniewski_0-1660897907801.png

 

Cheers,

Jan

PhilipMannering
16 - Nebula
16 - Nebula

Solution attached,

 

Spoiler
PhilipMannering_0-1660909963745.png

 

rachel_lynch
Alteryx
Alteryx
Spoiler
rachel_lynch_0-1660914887852.png

 

Rachel Lynch
mg46
8 - Asteroid

I saw that too, Dave!  I have to correct those spelling errors, haha.

mg46
8 - Asteroid
Spoiler
mguarniere_0-1660915390519.png

 

ggruccio
ACE Emeritus
ACE Emeritus

Fairly simple prep and blend.

 

Spoiler
Didn't need to re-sort data for third portion because Sample Tool has an option for last. 
 ggruccio_0-1660921713741.png

 

ScottSum
5 - Atom

How do you suggest we address the partially missing/corrupt data? For example the input dataset is missing values for what I am inferring to be 9_bj. In its place we get a row of nulls, but mixed in with the nulls we appear to get a rating, rating_count and ingredients. I recommend we go back to the original dataset to address import errors for 9_bj, 5_hd, 10_hd, 49_hd, 50_hd, 51_hd, 60_hd, 68_hd,  and all the _breyers data.

Thoughts?

karlhansen
9 - Comet

I viewed it as data we should ignore, based on the target output files -- a test of your data cleaning skills.

karlhansen
9 - Comet

I also saw two coconut cream non-allergen ice creams that were not in the target output.