Challenge #491: Behind the Blockbusters

[apmessner]

Here's my solution...My solution matched for parts 1 and 2, but I used the spoken_languages field for part 3 and ended up getting many more languages than were in the solution.

[Kenda]

Spoiler

[AlteryxUser1]

Spoiler

I looked at step 3 using Alteryx and then separately in Python and I would say the amount of languages should be 86. I was able to map out a lot of the 2 letter abbreviations from the iso_639_1 a list from this website: ISO 639-2 Language Code List - Codes for the representation of names of languages (Library of Congre...

[Qiu]

@olga_strubbe 
Thank you for agreeing with me. 😂
You mentioned that you get 80 only and I was wondering why.

Spoiler

After looking at your flow, I found that the difference was caused by enabling AMP engine in your flow, then resulted not all records in "tmdb_5000_movies" were pulled in.

After disabling AMP engine, we have the same results of 87.

[NatSnook]

Thank goodness I was not alone in struggling with task 3 

Spoiler

[EKasminsky]

I got 86 for question 3. I gotta work on my regex skills!

[SteveY02]

Task 1: The  reference didn't consider the situation where total budgt are the same, however, the are more than one movie with the same budgt.

Task 2: Same as reference answer.

Task 3: Different from reference answer. 

[AkimasaKajitani]

My solution!

The output for Task 3 differs from the given answer.

Spoiler

[Bobbyt23]

Not sure about the last question.

Spoiler

[Flo_P]

I count 86 iso language codes, not sure how you get to 27.

Spoiler