Challenge #332: The more ice cream, the better!

[tammybrown_tds]

I need some ice cream now.

Spoiler

[janwisniewski]

My first weekly challenge, I really enjoyed solving it! 

Spoiler

Cheers,

Jan

[PhilipMannering]

Solution attached,

Spoiler

[rachel_lynch]

Spoiler

[mg46]

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

[mg46]

Spoiler

[ggruccio]

Fairly simple prep and blend.

Spoiler

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

[ScottSum]

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]

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

[karlhansen]

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