In this blog post, I’ll show you how to use the Pandas melt method. I explain what melt does, how the syntax works, and I’ll show you a simple example. If you need something specific, you can click on any of the following links: Table of Contents: Introduction Syntax Examples Frequently Asked Questions Having said … Read more
Readers at the Sharp Sight blog will know that I put a lot of emphasis on data manipulation. You’ve heard me repeat the stat many times: 80% of your work as a data scientist will be data manipulation. Although there is a little nuance to that statement, roughly speaking, it’s true. A lot of your … Read more
A few days ago, I was writing some code for a new machine learning course that I’m building, and I had a somewhat tricky problem to solve. As I’ve said in the past, Pandas code (and data manipulation more generally) is very important for machine learning. Not just for wrangling your data into the proper … Read more
Jesus. I just spent about an hour playing with GPT, asking it to write some Pandas code for me, and I want to set my computer on fire. Do you know the frustration and mild contempt you feel when something will make your life harder, but also offend your aesthetic sensibilities? Like going to a … Read more
This tutorial will show you how to recode a categorical variable in a Python dataframe. Specifically, it will show how to recode a column a Pandas Dataframe. You can click on any of the following links to jump to a specific spot in the tutorial. Table of Contents: Syntax Explanation Examples Frequently Asked Questions Having … Read more
This tutorial will explain how to use the Pandas map method to replace values in a Pandas Series. The tutorial will explain what the method does, how the syntax works, and will show you a few step-by-step examples of how to use it. If you need something specific, just click on one of the following … Read more
In this blog post, I’ll explain how to use the Pandas isna technique. I’ll describe what the technique does, explain the syntax, and I’ll show you clear examples of how to use it. If you need to learn something specific, just click on one of these links: Table of Contents: Introduction Syntax Examples Frequently Asked … Read more
In this tutorial, I’ll show you how to use the Pandas get dummies function to create dummy variables in Python. I’ll explain what the function does, explain the syntax of pd.get_dummies, and show you step-by-step examples. If you need something specific, just click on any of the following links. Table of Contents: Introduction Syntax Examples … Read more
In this tutorial, I’ll explain how to use the Pandas astype function to modify the datatype of Pandas dataframe columns and Pandas objects. I’ll explain what the technique does, explain the syntax, and show you step-by-step examples. If you need something specific, you can click on any of the following links. Table of Contents: Introduction … Read more
In this tutorial, I’ll explain how to drop rows and columns from a dataframe using the Pandas drop method. I’ll explain what the drop method does, explain the syntax, and show you clear examples. If you need something specific, you can click on any of the following links. Table of Contents: Introduction Syntax Examples Frequently … Read more