Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Learn Replace Categorical Missing Data with Values | Data Cleaning
Preprocessing Data

bookReplace Categorical Missing Data with Values

To deal with categorical data:

  • replace with some constant or the most popular value
  • create a new category for these values. -process the data after converting it to the numerical. We'll use this approach later.

Let's explore for each column Cabin and Embarked(these columns contain NaNs) and figure out how to proceed with the NaNs.

Task

Swipe to start coding

  1. Explore the share of NaNs for each of the given columns. Print these values.
  2. For Embarked column, simply drop the missing values, since there are only 2 rows containing it.
  3. For the Cabin, about 77% of data is missing (if everything is done correct). That's why we'll replace NaNs with some new value. To do that:
  • print all the unique values for the Cabin column.
  • choose any other vlaue except already presented in the Cabin column and replace all NaNs with it. (For example, it can be 'Z' or 'X').

Check some data samples to see the modified dataframe.

Solution

Everything was clear?

How can we improve it?

Thanks for your feedback!

Sectionย 2. Chapterย 5
single

single

Ask AI

expand

Ask AI

ChatGPT

Ask anything or try one of the suggested questions to begin our chat

Suggested prompts:

Summarize this chapter

Explain the code in file

Explain why file doesn't solve the task

close

Awesome!

Completion rate improved to 5.56

bookReplace Categorical Missing Data with Values

Swipe to show menu

To deal with categorical data:

  • replace with some constant or the most popular value
  • create a new category for these values. -process the data after converting it to the numerical. We'll use this approach later.

Let's explore for each column Cabin and Embarked(these columns contain NaNs) and figure out how to proceed with the NaNs.

Task

Swipe to start coding

  1. Explore the share of NaNs for each of the given columns. Print these values.
  2. For Embarked column, simply drop the missing values, since there are only 2 rows containing it.
  3. For the Cabin, about 77% of data is missing (if everything is done correct). That's why we'll replace NaNs with some new value. To do that:
  • print all the unique values for the Cabin column.
  • choose any other vlaue except already presented in the Cabin column and replace all NaNs with it. (For example, it can be 'Z' or 'X').

Check some data samples to see the modified dataframe.

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

close

Awesome!

Completion rate improved to 5.56
Sectionย 2. Chapterย 5
single

single

some-alt