Challenge #164: Retail Therapy

[longyanChen]

hi

[pavan20085]

Hi - Solved the challenge. My second one.

1. Select Tool to change data types of Feedback Count and Rating to Numerical

2. Filter Tool to filter out more than 10 - Positive Feedback Count

3. Summarize Tool - Grouping by Clothing ID, Group By Department Name

4. Group BY Class Name, Average of the Rating

5. Sort Tool - Class Name _ Ascending, Avg Rating - Descending

6. Sample tool - Group By Class Name and sample First 5 rows

Great Feeling!!! On a roll!! Achievement!!

Thank You.

[EamonnW]

Spoiler

[alt_marsan]

Very, very easy challenge! Confidence builder for beginners!  :)

[alt_marsan]

Another easy solution. It's exciting to see the same solution by more experienced users. It tells me I am on the right track! Cheers!

[KimishaP]

great challenge

[jamesbarker]

Will I ever get used to the ascending/descending 😄

[JoshuaB]

Updating from old profile

[poushali96]

Attaching the solution for challenge 164.

[fengliplatform]

#164