Challenge #164: Retail Therapy

[mertshepard]

Solution attached.

[bpiscoya]

Spoiler

[caltang]

Done!

Spoiler

[hharris0411]

Spoiler

[mdm]

Spoiler

Here's my solution and result:

The class name of Clothing ID1119 is "Outerwear" rather than "Jackets". 

Refer to the expected output, the class name of Clothing ID#1119 is "Jackets".

After checked with the raw data, it shows that the [positive feedback count] of clothing ID 1119 with class name "Jackets" is less than 10.

Hence, clothing ID 1119 of class name "Jacket" should be filtered out in the workflow.

Actual raw data:

[joeoswald614]

Fun challenge!

Spoiler

Tools used in order:

1. Select Tool - change Clothing ID and Positive Feedback Count to Int16. change Rating to Double
2. Filter Tool - positive Feedback Count >= 10
3. Summarize Tool - group by clothing ID. Average Rating. First Class Name. First Department Name
4. Sort Tool - Class Name Ascending. Avg_Rating Descending
5. Sample Tool - first 5 Rows. Group by Class Name
6. Select Tool - reorder to Department Name, Class Name, Clothing ID, Avg_Rating

[Srikanth_K]

My first challenge completed...

[supriyamb83]

Solution for today's Challenge

[Sebastian_Chaieb2]

I have slightly different results as I used Class assigned to ID with highest score and positive feedback. 

There is nothing in objectives what to do with not unique cat for each Cloth ID so in my opinion it is misleading.

Spoiler

[NMangera]

Spoiler

TA

-tool container to organise workflow