1
00:00:00,600 --> 00:00:06,470
So in the last video, we saw that our time taken variable have some missing value in it.

2
00:00:07,290 --> 00:00:09,840
Now we need to treat this missing values.

3
00:00:11,250 --> 00:00:18,850
We are going to replace this missing values with the mean value of this time taken variable as per your

4
00:00:18,850 --> 00:00:19,810
business knowledge.

5
00:00:20,080 --> 00:00:29,520
You can impute it using mean median mode zero or any other values as you like, but here will use the

6
00:00:29,520 --> 00:00:30,160
mean value.

7
00:00:31,450 --> 00:00:34,900
So let's first calculate the mean of this time.

8
00:00:34,900 --> 00:00:44,890
Taken variable to calculate mean will write the F and a square record will write our variable name.

9
00:00:44,920 --> 00:00:48,370
There it is, time taken to autocomplete.

10
00:00:48,400 --> 00:00:50,200
You can also hit tab.

11
00:00:53,690 --> 00:00:56,770
And we will use the mean method.

12
00:00:56,810 --> 00:00:58,490
So we'll let Dot mean.

13
00:01:03,960 --> 00:01:04,830
If we on this.

14
00:01:08,230 --> 00:01:10,990
This is the mean of forward time taken variable.

15
00:01:12,320 --> 00:01:15,310
That is one fifty seven point three nine.

16
00:01:16,420 --> 00:01:21,520
We will use this mean value to impute our missing values.

17
00:01:22,980 --> 00:01:26,610
To impute missing values, there is another method that is.

18
00:01:27,240 --> 00:01:27,630
And they.

19
00:01:28,880 --> 00:01:32,510
So, again, will they be if time taken?

20
00:01:40,720 --> 00:01:42,720
Here we will use Phil and they mattered.

21
00:01:42,790 --> 00:01:45,780
So, all right, Dort Phil and they.

22
00:01:47,920 --> 00:01:53,120
We'll first look at the parameters that we need using shift beb better.

23
00:01:55,990 --> 00:01:57,040
So he had our first.

24
00:01:57,300 --> 00:01:58,240
I mean, that is value.

25
00:01:59,450 --> 00:02:03,240
And the value we are going to assign is the mean of this variable.

26
00:02:03,340 --> 00:02:03,980
So, all right.

27
00:02:03,980 --> 00:02:04,940
Value equal to.

28
00:02:06,950 --> 00:02:09,610
And then we will copy paste this our mean formula.

29
00:02:15,690 --> 00:02:18,390
We will again look at all the parameters.

30
00:02:21,690 --> 00:02:24,990
Here there is another parameter that is in place.

31
00:02:25,890 --> 00:02:34,920
What this in place parameter will do is if this in place parameter is equal to falls, it is not going

32
00:02:34,920 --> 00:02:38,820
to store this information and Daud be a data frame.

33
00:02:40,410 --> 00:02:45,900
We can just use it to output this information, to store this information.

34
00:02:45,960 --> 00:02:47,490
And Tord, be a data frame.

35
00:02:47,850 --> 00:02:55,380
That is, we want to make permanent changes in door B of data frame that every blank should be replaced

36
00:02:55,380 --> 00:02:55,950
with the mean.

37
00:02:56,910 --> 00:02:59,980
Then we have to use the in place equally to grow.

38
00:03:00,900 --> 00:03:02,570
If we don't use in place Equador.

39
00:03:03,930 --> 00:03:05,610
It is not going to store.

40
00:03:06,180 --> 00:03:09,060
This changes as permanent changes.

41
00:03:15,950 --> 00:03:16,940
We can run this.

42
00:03:18,380 --> 00:03:21,920
Now, again, we will dig the info off or be of the name.

43
00:03:26,480 --> 00:03:30,260
You can see now our time taken variable.

44
00:03:30,650 --> 00:03:32,600
Have five hundred and six values.

45
00:03:33,380 --> 00:03:37,750
We have imputed our missing values with the mean of time taken.

46
00:03:37,780 --> 00:03:38,240
Very well.