From the course: Learning Data Analytics Part 2: Extending and Applying Core Knowledge

Unlock this course with a free trial

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

Solution: Custom sort by education

Solution: Custom sort by education

From the course: Learning Data Analytics Part 2: Extending and Applying Core Knowledge

Start my 1-month free trial Buy for my team

Solution: Custom sort by education

“

(soft music) - [Instructor] Let me show you how I would attack this challenge. Again, I want to be able to see the order of attainment for the education. And I also want to address these blanks. The very first thing I'm going to do is go to my transformed data. Okay, and I'll give myself some screen space. Okay, so anywhere there is a current age or level of education that has not been completed, I'm going to actually go replace those values to be no answer provided. I've used my Control key to select those. I'll choose my replace values. Everywhere there is a null. I'll do no answer provided. And I'll go ahead and click okay. Okay, I'll go ahead and do close and apply. And I'll definitely see those blanks. Perfect. No answer provided, no answer provided. Again, it's sorted here in age from the number all the way up to the age 65. So this sort is fine. It's the bachelor degree, master degree, some college. We really want it to be in order. So, I'm going to actually go grab some more��

Contents