From the course: Data Cleaning and Manipulating with Python in Excel

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Solution: Data manipulation

Solution: Data manipulation

From the course: Data Cleaning and Manipulating with Python in Excel

Start my 1-month free trial Buy for my team

Solution: Data manipulation

“

(upbeat music) - So what did you think about the Chapter 3 challenge? I'll be alongside you as we go through each step to ensure all of our work is accurate and correct. You just finished working in the challenge tab, now let's open the solution tab in the Chapter 3 exercise file. Okay, so the first thing we had to do here is we had to find the numeric values within the Customer ID column. If we look at that, everything that fell in the middle here was numeric values. So in this situation, we're going to use the mid function to get this information out. So going up to Insert Python, into H6, we will type in, middle is equal to our data frame and within our brackets we want to look at the Customer ID columns, so Customer_ID. Close up our brackets there. And the biggest thing now is we have to determine what is the range we're looking for? It's going to be starting at the third character all the way down to eight. Close it up and let's go take a look and see what we get. Okay, let's…

Contents