Mid-Career Tech Archives - Page 3 of 6

Pandas for Productivity Vlog Ep. 7: The necessity of making SQL queries scalable

November 30, 2020

Why this topic? Back in 2016, the size of my performance marketing portfolio tripled overnight. I was working 16-hour days […]

November 23, 2020

Why this topic? The first time I encountered Google BigQuery in 2016, I was thrown off by some of its

November 16, 2020

Why this topic? This topic doesn’t have much documentation, yet is potentially very useful. Calculating moving averages in Excel is

November 6, 2020

Why this topic? This is a lead-in to next week’s episode, where I will talk about calculating moving averages in

October 24, 2020

Why this topic? There’s a lot of documentation on using Numpy’s arange function to create ranges of numbers. However, not

October 17, 2020

Why this topic? When we join two flat files, or a flat file to a SQL query output in Python,

October 15, 2020

Welcome to the launch of the Pandas for Productivity vlog series! Here, I discuss the peskier data wrangling challenges that

October 3, 2020

We previously discussed here that plotting charts in Python is second priority for beginners. Indeed, Python’s matplotlib library is very

September 28, 2020

The Pandas 1.x Cookbook, by Matt Harrison and Theodore Petrou, is now in its 2nd edition, published this February. Previously,