[Talk] Translating SQL to pandas. And back.


Want to work together? My team at Sprout Social is looking for a Senior Data Scientist.


A few weeks ago, I gave a pandas tutorial at PyData NYC titled "Translating SQL to pandas. And back." I don't remember why I put the "And back" in there - if you can translate things one way, you can translate them the other way, too.

Anyway, here's the abstract:

SQL is still the bread-and-butter of the data world, and data analysts/scientists/engineers need to have some familiarity with it as the world runs on relational databases.

When first learning pandas (and coming from a database background), I found myself wanting to be able to compare equivalent pandas and SQL statements side-by-side, knowing that it would allow me to pick up the library quickly, but most importantly, apply it to my workflow.

This tutorial will provide an introduction to both syntaxes, allowing those inexperienced with either SQL or pandas to learn a bit of both, while also bridging the gap between the two, so that practitioners of one can learn the other from their perspective. Additionally, I'll discuss the tradeoffs between each and why one might be better suited for some tasks than the other.

Having never been to a technical conference, much less given a talk at one, it was quite a new experience for me - and something I'd like to do again.

I highly recommend giving a talk at an event like PyData if you ever have the opportunity. And if you think you don't have anything interesting to say, or aren't experienced enough to give a tutorial, or are just plain nervous ... don't worry, I felt all those things too. You should do it anyway.

Below is the video of my talk. You can find the accompanying materials here.