Python Archives - A Long Random Walk

Pandas for Productivity Vlog Ep 5: Moving averages in Pandas

November 16, 2020

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

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,

September 28, 2020

Businesses like to know what their top-performing products, markets, and segments are. Therefore, you’ll need to sort and rank data

September 27, 2020

Have you ever tied up your computer for hours with a vlookup? Or laboriously copy pasted rows of .csv data

September 26, 2020

Most business questions involve grouping and aggregating data. For example, we might want to examine sales by product category. Or

September 25, 2020

When will you get missing values in your data? Quite often, actually! For instance, customer survey data where respondents did