5 Pandas Tricks That Quietly Save You Hours

Once you know these five, you'll wonder how you worked without them. None of them are fancy, they just quietly remove friction.

1. Filter cleanly with .query()

Instead of df[df['age'] > 30], write df.query('age > 30'). It reads like a sentence and your future self will thank you.

2. Add columns without breaking the chain

.assign() lets you create a new column inside a pipeline instead of stopping to write a separate line.

3. Instant percentages

value_counts(normalize=True) gives you proportions instead of raw counts, perfect for a quick distribution check.

4. Send a DataFrame straight to Excel

.to_clipboard() copies your table to the clipboard so you can paste it into Excel or an email. Underrated.

5. Keep transformations readable with .pipe()

Chaining your own functions with .pipe() keeps code flat instead of nesting functions inside functions.

Want guided practice on real datasets? That's exactly what the assessment and learner hub are built for.