Translating SQL to Python's pandas

You can find the rest of the materials here: https://github.com/gjreda/pydata2014nyc