data

In short, beyond accounting for new releases, there must be other factors influencing Rolling Stone’s choices.

This project uses Rolling Stone album rankings – twenty years apart in time – to determine what influences “greatness”.

First, musical greatness is shaped by how we listen.

Have you ever wondered how much of your personal information is available online? Here’s your chance to find out.

I quickly learned that writing one giant query with a bunch of joins or even bunch of Python helper functions could get me stuck. My transformation functions weren’t flexible enough, or my joins were too complicated to answer the endless variety of questions thrown my way while keeping the numbers correct.

Instead, the easiest way to be fast, nimble, and answer all the unexpected questions was to prepare a giant table or dataframe and limit myself to it. As long as I understood the table’s contents, it was harder to make mistakes. I could group by and aggregate on the fly with confidence.