Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEADone
My solution
This was a great challenge - and I now have a few new movie's to add to my list that I'd never heard of. Interesting how as time goes on, the ratings decline but the revenue goes up :(
I noticed that both my solution and the given solution exclude a rating datapoint for the sole film in the 1940's (The Wolf Man), since it has a null value for revenue. Is there a way to configure the Join tool as a FULL OUTER JOIN?
I also chose to express the decades as an ordinal counting up from 1AD, where 1-9 AD are Decade 1, 10-19 are Decade 2, ... 2020-2029 are decade 203. This has an advantage of being more numerical than "2020s", but has two disadvantages. First, it is liable to be misinterpreted, and second, there is a potential data skew. Since, under this system, the first decade (1AD-9AD) has only 9 years, but every subsequent decade has 10 years of data, the potential exists for the first decade to have lower gross revenue. Happily, however, IMDB does not record any motion picture revenues from the first decade AD!