Syed's Blog

2 posts · terminal version · RSS · all tags

SQL vs Pandas: The Friendly Rivalry

· data-science

Same questions, two languages. When to let the database do the work, when to pull data into Python, and how to stop downloading 40 million rows to compute one average.

SQL Joins Explained Through Office Lunch Politics

· coding

INNER, LEFT, RIGHT and FULL joins, explained by who gets lunch when the team orders food and who gets left staring at a sad desk salad.