Now, to handle the second observation of our analysis that is missing values in and horse bids.
We are going to replace the missing values with the mean of the other values available with us.
So now we need to know two things to be able to do that.
One is, how do good mean when column has any values?
This is an issue because if I just write mean and within record, I write B.F. Towler and Husband.
So if I'm trying to find out mean of this variable and if I run it, I get any.
Because this very well contains any.
So I need to tweak this formula.
I will write.
You mean and within bracket.
I will be of color.
Any beef dollar and husband does the same.
I'll give another parameter which is comma and need art item is equal to blue.
In a dark autumn is equal to two.
What this means is, while calculating the mean remove and is from it.
Now if I run this, I'll get a mean value to the Menas seven point eight nine for this variable.
Now we have the mean value.
Now we need to identify the black values using this variable.
This can be done by writing, which will write which.
And within Blackard, we will write is any.
And again, within record, we're the only variable, which is D.F. Toler and husband.
Dysfunction is any will identify which all the cells are any and which will list them down as a result
for us.
So when I this.
This is telling me you have to ask permission one after the into the 16th position.
All these values are having and name them.
Oh, since we do not need to list Tony values, we just need to identify them, will not be using which
but only the last part of this.
So let's replace values.
No, by rating.
Beef, dollar and horsemeat.
And husbands and within square bracket will specify is not any.
We'll take this part.
Copy pasted here.
So this is identifying which all values are any.
And we are replacing these values with the mean.
So this gets to mean that we got locatable.
Let's run this.
This is done.
Missing values are replaced by mean and no, if I ran the somebody of this particular variable.
It is not giving me any any value.
We can also run this, which come on again, which listed on all the cells which have any value.
But on this, again, I'm getting a deja vu of zero.
That is, there is no position which has any value.
So we have successfully imputed missing values in this variable.
This is all missing.
Value imputation is done in our.