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 #337: Create a New List from an Existing List

AYXAcademy
Alteryx
Alteryx

A solution to last week’s challenge can be found here.

 

How often do you have to create a new list based on another one?

This is what we are doing in this challenge.image337.PNG

 

The following dataset contains information about shows on Netflix. Use the dataset to create a new list with the following information:

 

- Categories (Action and Adventure, Documentaries, etc.)
- Type
- Title
- Release Year
- Rating
- Duration

 

This list should only contain international movies arranged in order by the year of release and duration.

Luke_C
17 - Castor
Spoiler
Luke_C_0-1663596718257.png

 

Kenda
16 - Nebula
16 - Nebula
Spoiler
If you sort by actual minutes of each movie, you get a slightly different sort order than answer given:
Kenda_0-1663596596374.png

 

But if you sort by the original duration field and don't use dictionary order, order matches output:Kenda_1-1663596776058.png

 

ahsanaali
11 - Bolide
Spoiler
Spoiler
ahsanaali_1-1663597133536.png

 

patrick_digan
17 - Castor
17 - Castor
Spoiler
patrick_digan_0-1663597404445.png

 

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
The order of output is little strange. About duration, it is sorted as string. 
AkimasaKajitani_0-1663597924422.png

 

AProblemSolver
5 - Atom

AProblemSolver_0-1663598070672.png

 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
327.png
ggruccio
ACE Emeritus
ACE Emeritus

Many ways to do this one.

Spoiler
I chose to Parse and find International Movies / Tokenize.  I also split out the numeric component of the duration and sorted on that.  The answer key is sorting the duration on alphabetical order which is why I get an error on 'Expect Equal'
ggruccio_0-1663599257426.png

 

MilindG
12 - Quasar
Spoiler
MilindG_0-1663600045892.png