Replace 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.
Taak
Swipe to start coding
- Explore the share of NaNs for each of the given columns. Print these values.
- For
Embarkedcolumn, simply drop the missing values, since there are only 2 rows containing it. - 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
Cabincolumn. - choose any other vlaue except already presented in the
Cabincolumn and replace all NaNs with it. (For example, it can be 'Z' or 'X').
Check some data samples to see the modified dataframe.
Oplossing
Was alles duidelijk?
Bedankt voor je feedback!
Sectie 2. Hoofdstuk 5
single
Vraag AI
Vraag AI
Vraag wat u wilt of probeer een van de voorgestelde vragen om onze chat te starten.
Suggested prompts:
Vat dit hoofdstuk samen
Explain code
Explain why doesn't solve task
Awesome!
Completion rate improved to 5.56Replace Categorical Missing Data with Values
Veeg om het menu te tonen
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.
Taak
Swipe to start coding
- Explore the share of NaNs for each of the given columns. Print these values.
- For
Embarkedcolumn, simply drop the missing values, since there are only 2 rows containing it. - 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
Cabincolumn. - choose any other vlaue except already presented in the
Cabincolumn and replace all NaNs with it. (For example, it can be 'Z' or 'X').
Check some data samples to see the modified dataframe.
Oplossing
Schakel over naar desktop voor praktijkervaringGa verder vanaf waar je bent met een van de onderstaande optiesWas alles duidelijk?
Bedankt voor je feedback!
Awesome!
Completion rate improved to 5.56Sectie 2. Hoofdstuk 5
single
