WEBVTT 00:02.080 --> 00:08.380 Hello and welcome to this patented Odean here we will understand how to deal with missing data. 00:08.620 --> 00:13.910 Let us begin first import these two liabilities numpty and pend. 00:19.010 --> 00:19.640 Great. 00:20.450 --> 00:22.220 Now define a dictionary. 00:22.580 --> 00:23.120 The. 00:25.420 --> 00:36.690 He as a den value, as a least one to the null value and P doc and a n. 00:40.140 --> 00:44.610 Then key B and value as a list. 00:45.180 --> 00:45.760 Three. 00:47.130 --> 00:47.880 And B dot. 00:48.060 --> 00:50.370 And A N again. 00:50.460 --> 00:51.760 And B dot and a.. 00:51.890 --> 00:54.870 And these two are the NL values. 00:56.430 --> 01:01.800 Then one more key that it c and value as a list. 01:02.360 --> 01:04.440 Four for you and six. 01:05.550 --> 01:06.720 No execute. 01:10.610 --> 01:11.660 Take this dictionary. 01:15.280 --> 01:15.910 Great. 01:16.600 --> 01:19.810 So there are three key value pairs in this dictionary. 01:19.920 --> 01:20.350 The. 01:24.250 --> 01:29.160 Now, using this dictionary to define A data frame B F. 01:31.760 --> 01:40.040 PD dot data frame specified dictionary be executed. 01:43.780 --> 01:45.610 Take this data from D.F.. 01:48.160 --> 01:49.750 So this is the data frame. 01:49.990 --> 01:55.750 There are three columns and three rows, column A, column B and column C. 01:55.990 --> 02:00.040 And these three are the rows zero, one and two. 02:00.160 --> 02:01.630 These are the indexes. 02:02.620 --> 02:03.520 Let us understand. 02:03.520 --> 02:04.810 Drop and then method. 02:16.540 --> 02:17.590 A, b, f. 02:18.140 --> 02:20.860 Dot drop and a. 02:27.010 --> 02:28.420 So this is the output. 02:28.690 --> 02:33.770 Let us understand this out to the drop in a meter drops Dinello values. 02:34.090 --> 02:39.460 As you can see here, all the roads with null values are dropped by default. 02:39.550 --> 02:41.290 Access is equal to zero. 02:41.500 --> 02:45.670 Hayne's ordinal values are dropped on the basis of rudes. 02:46.510 --> 02:49.540 We can drop the null values on the basis of columns. 02:49.670 --> 02:50.320 Also. 02:52.210 --> 02:58.150 To do that, a, b, f didn't drop and a method. 03:01.780 --> 03:04.360 Specify access is equal to one. 03:07.230 --> 03:09.840 By default, access is equal to zero. 03:13.300 --> 03:18.640 So this is the output Nele values are dropped on the basis of columns. 03:19.510 --> 03:23.110 Let us understand one more parameter in drop and a method. 03:26.630 --> 03:30.210 The F dot drop. 03:30.310 --> 03:35.260 And they know putting place is equal to two. 03:40.740 --> 03:41.320 Dequeue. 03:44.690 --> 03:46.340 Let us understand this output. 03:46.940 --> 03:51.220 Place is equal to two means, at least two non and they valued. 03:51.740 --> 03:55.870 So there are at least two non in their values in a row. 03:57.090 --> 03:59.340 We can make access is equal to one. 03:59.510 --> 04:00.120 Also. 04:02.280 --> 04:05.580 At the barometer, axis is equal to one. 04:09.740 --> 04:13.490 Great to not in their values in a column. 04:14.070 --> 04:16.540 And when access is equal to zero. 04:20.220 --> 04:20.770 Do none. 04:20.860 --> 04:22.630 And their values in OTRO. 04:24.800 --> 04:26.620 Let us see one more example. 04:30.040 --> 04:31.380 Drop and then nematode. 04:37.300 --> 04:39.910 Specified three showed it equal to one. 04:44.940 --> 04:47.910 At least one nun and a value in Uru. 04:51.430 --> 04:55.630 Similarly, when access is equal to one. 05:00.770 --> 05:03.860 At least one nun in a value in a column. 05:04.850 --> 05:07.460 So this is all about the drop in a method. 05:10.920 --> 05:12.910 Let us understand one more method. 05:14.760 --> 05:16.170 Fill in a method. 05:22.070 --> 05:23.790 Jack dee dee, dee dee dee f. 05:29.200 --> 05:34.070 No, use the Method B F don't feel any. 05:36.860 --> 05:41.480 In parentheses, value is equal to. 05:44.390 --> 05:47.870 New value executed. 05:49.720 --> 05:51.130 So this is the output. 05:51.700 --> 05:56.290 You can see here all the Nele values are replaced by new value. 05:57.730 --> 06:00.370 Previously, there were three NL values. 06:00.910 --> 06:02.830 Now there are three new valued. 06:04.090 --> 06:08.500 So using this method to fill in, they we can replace the null values. 06:11.810 --> 06:13.910 We can add a mean of a column. 06:14.000 --> 06:23.880 Also, let us see how type data from the F select the column A, this one column A. 06:24.380 --> 06:29.450 There are three values in column A, one, two and new value. 06:29.540 --> 06:30.920 This is the null value. 06:31.520 --> 06:32.510 Now you fill. 06:32.730 --> 06:33.530 Their method 06:36.080 --> 06:36.450 enter. 06:36.470 --> 06:41.330 Parameter value is equal to column A. 06:43.930 --> 06:45.400 Does it mean. 06:47.970 --> 06:51.570 So here we are replacing the value by means of this column. 06:55.370 --> 07:00.080 So this he did, he told the metal value is replaced by me enough column. 07:00.620 --> 07:01.700 That is one point five. 07:01.700 --> 07:05.170 You mean off these two values is one point for you. 07:05.990 --> 07:08.570 So this is all about Dicle and a method. 07:09.740 --> 07:16.720 Using the film and a method we can replace the values as well as we can replace the null values with 07:16.790 --> 07:18.010 mean of the column. 07:18.530 --> 07:23.210 There are other methods also that which we can replace the null values. 07:25.830 --> 07:28.700 Let us divide what we have learned in this Teito deal. 07:29.820 --> 07:33.540 In this tutorial, if we help understood how to deal with missing data. 07:34.780 --> 07:37.090 First, we have created a dictionary. 07:37.300 --> 07:45.220 B, then we have created a data frame, B, F, and we have created this data frame using this dictionary. 07:45.470 --> 07:51.670 B, then we help understood drop a method using the drop and then method. 07:51.730 --> 07:56.800 We can drop null values on the basis of rows or on the basis of columns. 08:00.000 --> 08:04.380 And after that, we help understood, fill and then method with this method. 08:04.420 --> 08:06.240 We can replace the values. 08:07.710 --> 08:10.920 So this patented odille on missing data ends here. 08:11.310 --> 08:13.230 I will see you in the next one. 08:13.560 --> 08:15.410 buildOn, happy learning.