Syed's Blog

8 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.

Pandas Tricks That Make You Look Like a Wizard

· data-science

Method chaining, query, assign, groupby with named aggregations and other small habits that turn messy notebooks into readable analysis.

Terminal-Based Data Science Workflow

· data-science

Build an efficient data science workflow entirely from the terminal using modern CLI tools and Python.

Recursion, or Mirrors Inside Mirrors

· coding

A function that calls itself sounds like a paradox. It's actually just a careful way of saying "do the same thing on a smaller problem, and know when to stop."

Writing Tests Is Cheaper Than Therapy

· coding

Unit tests, regression tests and the quiet confidence of a green checkmark, with examples you can paste into pytest today.

Stop Writing Clever Code

· coding

The one-liner that impressed you on Friday is the riddle that ruins someone's Monday. A gentle case for boring, readable code.

Python Type Hints: Lying to Your Future Self, But Politely

· coding

Type hints don't do anything at runtime. That's exactly why they're so useful, and why they can also be beautiful little lies.

Your Code Isn't Slow, Your Regex Is Having an Existential Crisis

· coding

Catastrophic backtracking explained with one innocent-looking pattern, a frozen server and a lot of regret.