1 00:00:00,150 --> 00:00:02,580 In this video, we will learn about list. 2 00:00:04,040 --> 00:00:08,690 So let's go to the power created this by clicking transformed into. 3 00:00:12,460 --> 00:00:18,360 And here you can see sort of data set, so. 4 00:00:19,650 --> 00:00:29,490 We can just make a copy control to control the updatable, and the name up to this table will be to 5 00:00:29,790 --> 00:00:30,390 sell to. 6 00:00:33,030 --> 00:00:39,530 So, for example, we have here Chenin that contain different channels here. 7 00:00:39,930 --> 00:00:46,390 Can consist of one column or more than one column, but lists contain the value from the single column. 8 00:00:47,820 --> 00:00:59,640 So let's go to the, uh, for example, we want to make a list, uh, for channel column. 9 00:01:00,300 --> 00:01:05,480 And when for this we have to click effects like we knew. 10 00:01:05,490 --> 00:01:07,230 We need to add one step. 11 00:01:08,310 --> 00:01:12,330 So either you can do here or you can do with the advanced editor. 12 00:01:12,510 --> 00:01:14,820 So if you click here effects. 13 00:01:17,730 --> 00:01:20,810 So the previous one was sorted of. 14 00:01:23,570 --> 00:01:34,550 So for the list, we have to, uh, write one ticket and the name of the column will be genuine. 15 00:01:36,500 --> 00:01:37,020 That's it. 16 00:01:40,370 --> 00:01:41,240 This is the list. 17 00:01:41,600 --> 00:01:46,630 No, we need to make as list have many functions. 18 00:01:47,950 --> 00:01:59,110 So let's apply one function, like we want to have distinct, listed, distinct items from this list. 19 00:02:00,450 --> 00:02:07,860 So for this, we have to click again effects the previous variable was on one, as you know, my in 20 00:02:07,860 --> 00:02:14,810 my previous belief that every time we have to use the previous the value from the previous video. 21 00:02:14,820 --> 00:02:21,720 But so as we know that this is a list, the name the name of the list is custom one. 22 00:02:22,980 --> 00:02:30,280 So what we have to do is we just need to use a list and list dot. 23 00:02:31,020 --> 00:02:32,550 So we need distinct. 24 00:02:33,720 --> 00:02:40,460 So this is a function for the list and then we need to start checking. 25 00:02:42,390 --> 00:02:51,660 So here you can see the first parameter that is required for the function is a list and custom one is 26 00:02:51,660 --> 00:02:54,430 a list and that's it. 27 00:02:55,350 --> 00:02:59,760 We don't have any equation criteria, so we just need to close. 28 00:03:00,680 --> 00:03:05,130 And here you can see we are getting a list of. 29 00:03:06,380 --> 00:03:17,630 Distinct channels, so we can do we can perform some more functions, for example, let's make the list, 30 00:03:18,080 --> 00:03:23,290 just delete this two and maybe we can also talk to the column. 31 00:03:23,300 --> 00:03:28,510 So we have the last step was renamed column. 32 00:03:29,660 --> 00:03:34,220 So we can do we can make a list of, uh, unit price. 33 00:03:36,480 --> 00:03:43,230 Or we can make the list of all the quantity so far, this we just need to click and fix. 34 00:03:44,850 --> 00:03:53,550 And to make a list for this column, we just need to click, we just click right wreckages and the name 35 00:03:53,550 --> 00:03:56,710 of the column, so it is out of quantity. 36 00:03:59,040 --> 00:03:59,530 That's it. 37 00:04:00,750 --> 00:04:03,890 So here you can see this is the list of the quantity. 38 00:04:04,800 --> 00:04:12,750 And as it is a list, so we can if we want to find the maximum value of the minimum value of the every 39 00:04:12,760 --> 00:04:13,080 value. 40 00:04:13,110 --> 00:04:15,000 So let's see what. 41 00:04:15,330 --> 00:04:17,370 Because there are many functions available. 42 00:04:17,380 --> 00:04:21,230 So let's play some for simple. 43 00:04:22,260 --> 00:04:31,320 Either I can make a new step or either I can work within the same step because I know this whole thing 44 00:04:31,320 --> 00:04:39,420 is is one list is this expression is there to name me one list. 45 00:04:40,560 --> 00:04:42,870 So I have it right here. 46 00:04:42,870 --> 00:04:47,000 List DOT, for example, next. 47 00:04:49,500 --> 00:04:53,610 And so makes one list as a parameter. 48 00:04:53,760 --> 00:04:58,460 So this list so you can close it here. 49 00:05:00,480 --> 00:05:06,690 So here you can see the maximum order quantity is 12. 50 00:05:08,750 --> 00:05:18,060 So if we go to rhenium column here and go to the other country, click here. 51 00:05:19,190 --> 00:05:25,850 So here you can see the maximum value is the maximum or the 12 and the minimum is five. 52 00:05:27,170 --> 00:05:29,290 So let's go to the custom column. 53 00:05:29,440 --> 00:05:35,300 And here we can write me and you can see the minimum value is five. 54 00:05:36,050 --> 00:05:40,670 And you would in this video, you can find a lot of this function. 55 00:05:40,670 --> 00:05:49,630 For example, here you can see list DOT and there are many functions available here. 56 00:05:50,040 --> 00:05:50,410 Right. 57 00:05:50,720 --> 00:05:54,310 So let's play fun blanko here. 58 00:05:57,410 --> 00:06:01,430 And we can make one list for Ssempa. 59 00:06:07,290 --> 00:06:08,880 One, two, three, four. 60 00:06:14,310 --> 00:06:19,380 So you can see this is a list one, two, three, four. 61 00:06:21,130 --> 00:06:27,070 And in the same way, we can write for them. 62 00:06:27,480 --> 00:06:32,650 We can write some cities name like a city one, 63 00:06:36,400 --> 00:06:37,360 32, 64 00:06:41,080 --> 00:06:41,910 33, 65 00:06:44,980 --> 00:06:48,220 and here you can say one more thing, like 66 00:06:51,280 --> 00:06:52,750 we can just delete it. 67 00:06:53,140 --> 00:06:58,150 And here can make one more list, for example, for the channel. 68 00:06:59,950 --> 00:07:02,140 So we just need to click effects. 69 00:07:03,520 --> 00:07:06,100 And here it is channel. 70 00:07:07,900 --> 00:07:11,110 This is one list and we need. 71 00:07:13,690 --> 00:07:16,870 For example, again, the distinct 72 00:07:19,660 --> 00:07:21,130 Lyster distinct. 73 00:07:25,460 --> 00:07:26,460 And, uh. 74 00:07:29,190 --> 00:07:35,460 Say, and if we want to apply some sorting here. 75 00:07:36,470 --> 00:07:42,470 So again, it is again, we can apply list and list, not 76 00:07:45,520 --> 00:07:53,540 the start thought, and let's not start again, need one list and here it is, a list. 77 00:07:54,350 --> 00:07:54,780 Right. 78 00:07:56,450 --> 00:08:02,060 So we have added to three list in one step. 79 00:08:02,270 --> 00:08:05,810 And here you can see this in ascending order. 80 00:08:06,150 --> 00:08:06,450 Right. 81 00:08:07,070 --> 00:08:10,040 So in this video, you have seen how we can work with the list. 82 00:08:10,460 --> 00:08:18,680 And in the next week we will see what are the usage, practical usage of list in real life.