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

Зміст курсу

Preprocessing Data

Preprocessing Data

1. Data Exploration
Data ExtractingExplore the DatasetData Types
2. Data Cleaning
Missing and Wrong DataWork with NaNsReplace Numerical Missing Data with ValuesDealing with Missing AgesReplace Categorical Missing Data with ValuesReplace Missing Values with InterpolationRemoving DuplicatesRemoving OutliersVisualizing Outliers
3. Data Validation
Types ConversionData Binning
4. Normalization & Standardization
Data NormalizationData Standardization
5. Data Encoding
Label EncodingOne Hot Encoding

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.

Завдання

  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.

Завдання

  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.

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів

Все було зрозуміло?

Секція 2. Розділ 5
toggle bottom row

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.

Завдання

  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.

Завдання

  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.

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів

Все було зрозуміло?

Секція 2. Розділ 5
toggle bottom row

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.

Завдання

  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.

Завдання

  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.

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів

Все було зрозуміло?

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.

Завдання

  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.

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів
Секція 2. Розділ 5
Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів
We're sorry to hear that something went wrong. What happened?
some-alt