Challenge #289: Prep a Shoe List

A solution to last week’s challenge can be found here."Women Shoe Store" by MyStockPhotos is marked with CC0 1.0

For this week's challenge, let’s do a bit of data preparation using shoe inventory data!

The following dataset contains a list of shoes with an ID, colors, and sizes available.

For this challenge, you want to clean the inventory data and reorganize the list to have:
- A new ID number
- The size
- A comment stating how many colors are available, and
- Three columns for color

Keep in mind that the names of the colors are separated by the sign /.

challenge_289_start_file.yxzp

challenge_289_solution.yxzp

Parse

Advanced

Data Preparation

Accepted answers

All comments

BMorgan1390

So many colors to choose from!

challenge_289_BM_Complete.yxzp

Miles_Waller

Not too difficult, but a good challenge nonetheless

Spoiler

challenge_289_MW.yxzp

TonyAdam

Why does New ID 192 not have a size in the solution?

Spoiler

challenge_289_Tony.yxmd

Jasmine

Spoiler

Used 'Tile Tool' to make sure the IDs were unique instead of the commonly used 'Record ID' tool.

challenge_289_Solution_JS.yxzp

bfitz-gerald

Spoiler

Found this one relatively straightforward. Was stuck initially on whether to draw out repeated IDs, but given output didn't seem to do that.

Challenge 289 - Data Parsing.yxmd

allwynthomas24

Spoiler

challenge_289_solution_AllwynThomas.yxmd

chuckleswk

Spoiler

challenge_289_start_file.yxmd

tammybrown_tds

I agree with others' comments on ID 1533. I think the intent was to have the last color be White/Light Grey as the 3rd color, but then colors 1 and 2 are both light grey. Regardless, it works.

Spoiler

challenge_289_tbrown.yxmd

ahmedirfanp

My Solution for this weeks challenge. there were two unique IDs I came across and I have addressed them in my solution. Please let me know if it is incorrect.

challenge_289_solution_aip.yxmd

galmahalal

Hi, here is my solution.

Best

challenge_256_GalMahalal_Solution.yxmd

RogerJackls

challenge_289_start_file_Solutions.yxmd

ddiesel

My 2 solutions:

Spoiler

challenge_289_end_file_ddiesel.yxmd

MichaelPilotFreight

Check out my solution!

Michael_DiGiacomo_Challenge_288.yxmd

KPinto

Spoiler

challenge_289_soln_file_KP.yxzp

hayleematecko

Not too shabby!

challenge_289_hayleematecko.yxzp

Reesetrain2

All,

Spoiler

That w as a fun, yet quick challenge.
-I used Text-to-column, Data Cleaning, Record ID, Formula (I started with the comment field defaulted to one color, then changed it conditionally to either 2 or 3 colors based on the emptiness of the Color 2 or Color 3 fields.)
-Cheers!

Matt

Challenge_289_Reesetrain2_file.yxmd

tammybrown_tds

@ahmedirfanp, I see the duplicates that you identified, but then on the next join, you put them right back in again. So I'm not sure that your unique steps were actually deduping anything.