Challenge #164: Retail Therapy
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
mertshepard
8 - Asteroid
03-23-2023
02:05 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
bpiscoya
7 - Meteor
03-26-2023
10:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
caltang
17 - Castor
04-02-2023
06:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hharris0411
8 - Asteroid
04-03-2023
09:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
mdm
8 - Asteroid
04-05-2023
03:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
6 - Meteoroid
04-05-2023
06:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Fun challenge!
Spoiler
Tools used in order:
- Select Tool - change Clothing ID and Positive Feedback Count to Int16. change Rating to Double
- Filter Tool - positive Feedback Count >= 10
- Summarize Tool - group by clothing ID. Average Rating. First Class Name. First Department Name
- Sort Tool - Class Name Ascending. Avg_Rating Descending
- Sample Tool - first 5 Rows. Group by Class Name
- Select Tool - reorder to Department Name, Class Name, Clothing ID, Avg_Rating
Srikanth_K
5 - Atom
04-05-2023
06:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My first challenge completed...
supriyamb83
6 - Meteoroid
04-06-2023
03:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Sebastian_Chaieb2
9 - Comet
04-07-2023
02:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
NMangera
10 - Fireball
04-07-2023
04:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator