Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #289: Prep a Shoe List

justindavis
10 - Fireball
Spoiler
Look at row 1533 
Lite Grey / Lite Grey / White / Lite Grey

Solution has this as "3 colors" but personally I believe it should be cleaned up to be only 2 distinct colors. Thus the longer workflow to filter out duplicates...

challenge_289_solution_jdavis.PNG
Jbone
8 - Asteroid

 

 

Spoiler
Capture.PNG

AlexvanOs
8 - Asteroid

Fun little challenge!

 

Spoiler
The remove 'Size' if the size starts with 'Size' part of this one was a nice addition. 

challenge_289_Solution AlexvanOs.png

 

mmotte628
8 - Asteroid

Nice challenge. I may use this in my upcoming company training. 

Spoiler
Shoes Challenge.PNG

 

alexnajm
16 - Nebula
16 - Nebula

I need some new shoes...

Spoiler
challenge_289_start_file_Alex Abi-Najm.PNG
BHowland
6 - Meteoroid
Spoiler
 

Solution.png

Toons
12 - Quasar

My solution :

 

Spoiler
Toons_0-1634050285664.png

 

PhilipMannering
16 - Nebula
16 - Nebula

My solution in the Python Tool,

Spoiler
PhilipMannering_0-1634050899150.png

 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
289.jpg

My result is a bit different, found a few duplicate records (5) in the inventory data and for some items duplicate colors.

dYoast
11 - Bolide

I tried to use RegExMatch, but got bad results.

Spoiler
Item 192 in the answer does not have a size.  I left mine.
dYoast_0-1634052876661.png