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 to get mean when column has any values.
This is an issue because if I just write mean and within record, I write B.F. Dolar and Husband.
So if I'm trying to find out mean of this variable and if I run it, I get any.
Because this variable contains any.
So I need to tweak this formula.
I will write you mean.
And within bracket.
I will I be of color.
Any D.F. dollar and husband does the same.
I'll give another parameter which is comma and Nadaf item is equal to.
And a dog at home is equal to two.
What this means is, while calculating the mean remove and is from it to no effect on this, I mean
value to the minus seven point eight nine for this variable.
Now we have the mean value know we need to identify the black values in 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 are the only variable, which is D.F., daughter and husband.
Head 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 run this.
This is telling me you have to phosphorylation one hour today, integration, 16th position.
All these values are having and in them.
Nonsense.
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 the dollar and hospitals.
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 in it.
And we are replacing these values with the mean.
So this gets to mean that we got locatable.
So let's run this.
This is done.
Missing values are replaced by mean.
And now if I run 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.
If I run this again, I'm getting in danger 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.