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: Advanced data cleaning

Solution: Advanced data cleaning

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

Start my 1-month free trial Buy for my team

Solution: Advanced data cleaning

“

(upbeat music) - [Narrator] Hey there. How did the chapter two challenge go? Did you learn anything new? Let's get right into the solution. I'll be alongside you as 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 to solution tab in the chapter two exercise file. Okay, so the first thing we want to do is we want to give each of the conditions in here a proper title. So let's go into I5, go to insert Python, and let's do title is equal to where I reference our original data frame. So dF. Then our brackets, we want to look at the conditions column. So we'll type in conditions, close up our brackets, and we're going to be using the title function for this to make sure each of the cells has a proper title. Now let's commit our code and take a look. Okay now so take a look at it, and perfect. As in, each of the cells in here, I have now the proper title, which is much easier to use for our analysis. Next…

Contents