1
00:00:01,860 --> 00:00:04,970
Now, let's start for missing value treatment in Python.

2
00:00:06,030 --> 00:00:08,850
So this what what observations from Oord EBD.

3
00:00:11,030 --> 00:00:14,500
We have discussed point three in our Outlander video.

4
00:00:15,110 --> 00:00:20,050
Now we will be discussing about this other missing, well, losing and Hause bets variable.

5
00:00:21,780 --> 00:00:31,380
The best way to identify missing value is just to take and full of data frames will be if not in full.

6
00:00:36,440 --> 00:00:42,080
Here you will see the total number of values for all the variables.

7
00:00:42,500 --> 00:00:44,600
There is only one way to even, which is.

8
00:00:44,660 --> 00:00:49,430
And Herzberg's where the total number of values is less than five zero six.

9
00:00:50,400 --> 00:00:56,100
Therefore, this confirms that and Horsburgh contain missing values.

10
00:00:57,810 --> 00:00:58,260
You can.

11
00:00:59,360 --> 00:01:03,010
Also, look at EDT to identify missing, let loose.

12
00:01:04,550 --> 00:01:06,500
But then a duty you only get.

13
00:01:06,740 --> 00:01:08,890
Values of numerical variables.

14
00:01:09,470 --> 00:01:12,390
This will give you details of what it calls variables as well.

15
00:01:16,420 --> 00:01:20,170
Greeting missing, well, it was fairly easy in Biton.

16
00:01:22,540 --> 00:01:24,930
To impute missing values, we will use.

17
00:01:26,040 --> 00:01:27,240
Fail and they function.

18
00:01:28,170 --> 00:01:31,280
So will they be, if not our column name, which is.

19
00:01:31,590 --> 00:01:33,000
And was birds.

20
00:01:37,810 --> 00:01:37,960
We.

21
00:01:38,260 --> 00:01:38,920
Equal to.

22
00:01:39,070 --> 00:01:46,120
Since we want our imputed data to again, Jane Doe is not the values in our data.

23
00:01:46,300 --> 00:01:46,450
So.

24
00:01:46,480 --> 00:01:50,200
All right, B.F. Dorte and Husbands.

25
00:01:53,130 --> 00:01:54,490
Don't feel any.

26
00:01:58,470 --> 00:02:04,170
And since we want to replace this value with the mean of our hospital beds.

27
00:02:04,500 --> 00:02:07,020
All right, B.F. Dorte and husbands.

28
00:02:11,230 --> 00:02:17,220
Not mean what this function is actually doing is.

29
00:02:18,900 --> 00:02:25,980
Plus, it is calculating the mean awful what really well, which is beef and Herzberg's.

30
00:02:27,560 --> 00:02:36,050
Then whenever I would be of dot and cause bags and there it is, filling those blanks with this mean

31
00:02:36,050 --> 00:02:36,560
value.

32
00:02:37,910 --> 00:02:44,500
And after filling all the missing values, we are again saving this day.

33
00:02:44,750 --> 00:02:46,340
And it or is not ordinarily to.

34
00:02:50,380 --> 00:02:51,280
If on this.

35
00:02:54,390 --> 00:02:56,160
Missing values are not imputed.

36
00:02:56,670 --> 00:03:01,140
If we take in full of our day Dufferin, I'd be if not in full.

37
00:03:09,270 --> 00:03:09,960
You can see.

38
00:03:12,170 --> 00:03:16,070
Now, the count is five 06 and set off for 98.

39
00:03:16,490 --> 00:03:21,980
So we have faith, all of it missing, we're loose with the meaning of that column.

40
00:03:26,580 --> 00:03:30,690
Now, if you want to do missing, well, you ambulation for all of the columns.

41
00:03:32,930 --> 00:03:34,180
You have to, right, B.F.?

42
00:03:34,640 --> 00:03:35,500
Don't feel any.

43
00:03:36,090 --> 00:03:37,410
And then record this right.

44
00:03:37,530 --> 00:03:38,540
B.F. Dorte Mean.

45
00:03:41,340 --> 00:03:45,880
And again, we have to save this data frame again and D'Oro reasonable little frame.

46
00:03:46,020 --> 00:03:48,390
So we'll read BFE to be if.

47
00:03:49,520 --> 00:03:57,460
Not in there this way, Lou, for all the columns, but since we want a specific solution for each of

48
00:03:57,460 --> 00:04:02,730
our columns, as we mentioned, in what to reelected, that for some variables, we won zero.

49
00:04:02,740 --> 00:04:06,490
For some variables we want me mean for some variables.

50
00:04:06,520 --> 00:04:07,300
We want more.

51
00:04:07,840 --> 00:04:08,840
That's why we have.

52
00:04:09,370 --> 00:04:11,650
We have used specific variables.

53
00:04:11,940 --> 00:04:13,360
They impute our missing value.

54
00:04:14,770 --> 00:04:20,860
This statement is not needed yet, as we have already imputed our missing values.

55
00:04:22,540 --> 00:04:25,390
Now we'll see what did you buy the notebook with?

56
00:04:25,600 --> 00:04:26,770
Go on.

57
00:04:26,910 --> 00:04:28,950
Change the title of your notebook.

58
00:04:38,140 --> 00:04:47,380
And click on say first and then say that so you do missing well, the amputation in Biton.

59
00:04:48,570 --> 00:04:49,050
Thanks.