I use pandas and siuba to analyze episode popularity for the TV show the Avatar. This ended up going pretty smoothly! I went from looking at popularity over time, to different show writers, to examining whether ratings improved once the character Toph showed up.
Tools used:
siuba: http://github.com/machow/siuba
Timeline:
00:07:30 - counting number of episodes per writer.
00:08:00 - unnesting data when one episode had multiple writers.
00:14:30 - line plot: when did the show have its highest ratings?
00:20:00 - finding biggest rating difference between subsequent episodes
00:28:00 - many plots: which director had highest ratings?
00:46:30 - when does a character first show up?
01:07:55 - do ratings improve once Toph shows up?