In this video, we will learn how to handle the missing values in our dataset, handling missing values
is very important since most of the models cannot run if there is some missing value in our data said.
We saw how to find out the missing value using the descriptive statistics option, and we found out
that and housemaid's variable contains some missing values.
To look at the missing values, we will again use these filtering options if you have not applied filters
to law.
To apply filters, you have to select the top row of the table and go to data and click on this filter
option.
Now that you have these filtering options, click on the small triangle of enhancement, then scroll
down and you will find these this Blancs option, this blancs is giving us all those cells which do
not contain any value.
So first, we will undertake all of these cells back and checking the select button.
Then we will take this Blancs option.
You can see we get eight observations which do not have value for inhospitable variable.
As we have learned in antireligious, depending on the business knowledge, we can use mean median maximum
or zero as the replacement for these missing values.
For now, we are going to use the mean value of this variable to replace the missing values.
To find the main values, we will again go to these filtering options and select all the values.
Delectably, values.
Ed, we will rate average to this function will give us the average of all the values.
To select all the values and hit enter.
So this seven point eight nine nine is the average of all the values of enhanced BERRIDGE variable.
We will use this value to replace the missing values, so copy this value.
Then click this icon and select only the blank values.
And paste this value in each of these blankets, but while pasting, you have to place this as values.
So the second option in posting options is values.
Click on this to paste the value of this.
Otherwise you will paste formula here, which will give you the long value of the average to right click
on this will go to place options and to link this second image of basters values.
So now we have replaced all the blank values with the mean, if I remove the filter and select all.
Now if I go, there will be no blank value in it.
So we have handled the missing values and this and housemaid's variable.
If in your dataset there are other variables which have some missing values, you need to treat all
those variables, apply the filter and select the blanks in that column, change the values of those
blanks to mean median max, whichever is the business scenario for those missing values.