So in the last video, we saw that our time taken variable have some missing value in it.
Now we need to treat this missing values.
We are going to replace this missing values with the mean value of this time taken variable as per your
business knowledge.
You can impute it using mean median mode zero or any other values as you like, but here will use the
mean value.
So let's first calculate the mean of this time.
Taken variable to calculate mean will write the F and a square record will write our variable name.
There it is, time taken to autocomplete.
You can also hit tab.
And we will use the mean method.
So we'll let Dot mean.
If we on this.
This is the mean of forward time taken variable.
That is one fifty seven point three nine.
We will use this mean value to impute our missing values.
To impute missing values, there is another method that is.
And they.
So, again, will they be if time taken?
Here we will use Phil and they mattered.
So, all right, Dort Phil and they.
We'll first look at the parameters that we need using shift beb better.
So he had our first.
I mean, that is value.
And the value we are going to assign is the mean of this variable.
So, all right.
Value equal to.
And then we will copy paste this our mean formula.
We will again look at all the parameters.
Here there is another parameter that is in place.
What this in place parameter will do is if this in place parameter is equal to falls, it is not going
to store this information and Daud be a data frame.
We can just use it to output this information, to store this information.
And Tord, be a data frame.
That is, we want to make permanent changes in door B of data frame that every blank should be replaced
with the mean.
Then we have to use the in place equally to grow.
If we don't use in place Equador.
It is not going to store.
This changes as permanent changes.
We can run this.
Now, again, we will dig the info off or be of the name.
You can see now our time taken variable.
Have five hundred and six values.
We have imputed our missing values with the mean of time taken.
Very well.