Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Fill In the Missing Values | Preprocessing Data
Advanced Techniques in pandas

Fill In the Missing ValuesFill In the Missing Values

Deleting missing values is not the only way to get rid of them. You can also replace all NaNs with a defined value, for instance, with the mean value of the column or with zeros. It can be useful in a lot of cases. You will learn this in the course Learning Statistics with Python.

Look at the example of filling missing values in the column 'Age' with the median value of this column:

Explanation:

  • value = data['Age'].median() - using the argument value, we tell the .fillna() function what to do with the NaN values. In this case, we applied the .fillna() function to the column 'Age' and replaced all missing values with the median of the column;
  • inplace=True - the argument we can use for saving changes.

Завдання

One of the most common ways of filling missing values is replacing them with the mean value of the column. So, your task here is to replace the NaN values in the column 'Age' with the mean value of the column (using the inplace = True argument). Then output the sum of the missing value in the column 'Age'.

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

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

Зміст курсу

Advanced Techniques in pandas

1. Get Familiar With Indexing and Selecting Data

Output Columns by TitleOutput Rows by IndexSelect Specific Rows and ColumnsLearn More About IndexationGet Familiar With lambda FunctionsExpand Functionality of the .iloc[] Function

2. Dealing With Conditions

Set ConditionSelect Data Based on ConditionDealing With Several ConditionsMake Your Code BeautifulConditions Quiz

3. Extract Data

Is Data in ...?Combine Your KnowledgeBetween FunctionExtract Specific DataFind the Smallest Values of a ColumnFind the Largest Values of a ColumnFind the Correlation

4. Aggregating Data

Get Familiar With the .groupby() MethodGroup by Several ColumnsComplicated GroupingGroupDealing With Pivot TablesCreate a Pivot Table

5. Preprocessing Data

Check for Missing ValuesCalculate the Number of Missing ValuesWhat Will We Do With the NaN Values?How to Delete Only NaN Values?Fill In the Missing ValuesManage Categorical VariablesCheck the Column TypeManage an Incorrect ColumnRename the Column

Advanced Techniques in pandas

Fill In the Missing ValuesFill In the Missing Values

Deleting missing values is not the only way to get rid of them. You can also replace all NaNs with a defined value, for instance, with the mean value of the column or with zeros. It can be useful in a lot of cases. You will learn this in the course Learning Statistics with Python.

Look at the example of filling missing values in the column 'Age' with the median value of this column:

Explanation:

  • value = data['Age'].median() - using the argument value, we tell the .fillna() function what to do with the NaN values. In this case, we applied the .fillna() function to the column 'Age' and replaced all missing values with the median of the column;
  • inplace=True - the argument we can use for saving changes.

Завдання

One of the most common ways of filling missing values is replacing them with the mean value of the column. So, your task here is to replace the NaN values in the column 'Age' with the mean value of the column (using the inplace = True argument). Then output the sum of the missing value in the column 'Age'.

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

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