Pandas 1.x Cookbook Review
The Pandas 1.x Cookbook, by Matt Harrison and Theodore Petrou, is now in its 2nd edition, published this February. Previously, […]
Mid-Career Tech
Mid-Career Tech
If you’re Gen X or Gen Y in tech, it’s a rough ride. Mid-career tech professionals of the 2020s have weathered two storms: data science and generative AI. In the spirit of continuous learning, I’m sharing how I’m navigating and evolving in this increasingly challenging space. Join me!
Mid-Career Tech
Sort and rank data with pandas
Businesses like to know what their top-performing products, markets, and segments are. Therefore, you’ll need to sort and rank data
Mid-Career Tech
Combine data sets by merging or concatenating
Have you ever tied up your computer for hours with a vlookup? Or laboriously copy pasted rows of .csv data
Mid-Career Tech
Grouping and aggregating data in pandas
Most business questions involve grouping and aggregating data. For example, we might want to examine sales by product category. Or
Mid-Career Tech
Handle missing values in your DataFrame
When will you get missing values in your data? Quite often, actually! For instance, customer survey data where respondents did
Mid-Career Tech
How to filter a DataFrame: Focus on specific data
In the past few posts, we’ve discussed how to read your data into pandas, and then manipulate it via calculations.
Mid-Career Tech
Loops and list comprehension concepts
My intention is to help you understand every line of code posted. As such, I need to explain the concepts
Mid-Career Tech
Working with date and time in Pandas
When looking at business data, time is always an important factor. From the start, you will focus on pulling your
Mid-Career Tech
Write your own functions: customize your metrics
If you use Excel heavily, you will have used their functions at some point. In short, a function is a