Pandas: Do work quickly. And learn programming!
I love pandas! This kind, of course… … but also the Python Data Analysis Library, an open-source software library. Even […]
Mid-Career Tech
Mid-Career Tech
Think Stats runner problem (Chap 3): My solution
Lately, I’ve been working through Think Stats by Professor Allen Downey. This book provides a novel way to learn statistics.
Mid-Career Tech
Take ownership of your data: The end-goal
We’ve come to the end of the Survival SQL series. Hopefully, you think the posts are relevant and easy to
Mid-Career Tech
Subqueries and CTEs: Multi-step problems
As you progress, you’ll find situations where you need to combine more than one data pull to answer your question.
Mid-Career Tech
Window functions : Automate lengthy Excel tasks
“Find our 5 best-selling products by country.””What was the 7-day moving average revenue for every day last month?” Chances are,
Mid-Career Tech
Sort your data with “ORDER BY”
Most of you will use Excel to manipulate and plot the data you pull with SQL. Eventually, you’re likely to
Mid-Career Tech
When to use more complex joins
As you pull your data more often, you may encounter situations where you need more complex joins than what we’ve
Mid-Career Tech
Define your own metrics: Operators & conditionals
As you become confident with pulling data, you’ll start wanting more control over the metrics you report on. Hence, you’ll
Mid-Career Tech
Aggregating metrics: Using “GROUP BY”
Earlier, we’ve discussed that your database stores data at its most granular level. This means that every order creates one