1 00:00:00,750 --> 00:00:09,390 In today's video, we will learn about some more functions of list, and for this, let's go to the 2 00:00:09,870 --> 00:00:11,010 barber Ed. 3 00:00:14,510 --> 00:00:19,280 So here you can see you already are familiar with this, David. 4 00:00:20,420 --> 00:00:27,890 So in today, we will learn about how we can get like top generals, right, cooptation. 5 00:00:30,720 --> 00:00:33,510 For this, what we need to do is. 6 00:00:36,260 --> 00:00:41,930 We will just create one list here, the list will be based on revenue. 7 00:00:43,860 --> 00:00:46,980 So how we can create a list, we just need to click. 8 00:00:49,740 --> 00:00:50,340 IPEX. 9 00:00:53,390 --> 00:01:01,220 And here we have to provide the column name Total Revenue decirte. 10 00:01:04,050 --> 00:01:08,220 And here you can see this is the list of total revenue. 11 00:01:10,280 --> 00:01:21,530 Before moving to this, let me delete this and we have to select this table sales, so again, we need 12 00:01:21,530 --> 00:01:22,610 to take effect 13 00:01:26,120 --> 00:01:27,470 total revenue. 14 00:01:27,500 --> 00:01:28,570 This is an emoticon. 15 00:01:29,570 --> 00:01:31,840 So we had this list, right? 16 00:01:33,740 --> 00:01:40,880 And now we need to know the top three records from this list, so what we have to do is first we need 17 00:01:40,880 --> 00:01:43,810 to do something in descending order. 18 00:01:45,050 --> 00:01:50,200 So because this is a list, this is returning as a list. 19 00:01:50,740 --> 00:01:52,970 So we need to write one function here. 20 00:01:52,970 --> 00:01:56,450 List, dot, sort. 21 00:02:04,510 --> 00:02:12,490 And the second parameter is order, we have to provide criteria, certain criteria to be ordered not 22 00:02:12,700 --> 00:02:13,330 descending. 23 00:02:16,800 --> 00:02:17,220 I said. 24 00:02:23,700 --> 00:02:26,820 It's a typo problem or descending this one. 25 00:02:27,330 --> 00:02:32,120 So here you can see we are getting the complete list in descending order. 26 00:02:33,890 --> 00:02:36,870 So now we need only top three records. 27 00:02:38,060 --> 00:02:42,650 So, again, we need to use the function in list that this list got. 28 00:02:45,840 --> 00:02:48,430 Um, let's talk French. 29 00:02:48,720 --> 00:02:55,400 This is a function and it's a subset of the list beginning again of that. 30 00:02:56,760 --> 00:02:59,640 So the first parameter will be list 31 00:03:02,280 --> 00:03:07,770 and then we have to provide the second parameter as an offset. 32 00:03:10,000 --> 00:03:21,250 So this list, the indexing for this list is started from from position zero zero, level zero, one, 33 00:03:21,250 --> 00:03:22,360 two, three and so on. 34 00:03:23,200 --> 00:03:25,910 So we have to start from the zero level. 35 00:03:26,350 --> 00:03:28,720 So for this one, you tried zero. 36 00:03:29,830 --> 00:03:37,400 And then we need to provide the third parameter that how many records are how many rules we need. 37 00:03:37,990 --> 00:03:39,370 So how many rows we need? 38 00:03:39,550 --> 00:03:42,970 We just need three rows, but just slide three. 39 00:03:44,090 --> 00:03:46,440 This is a complete expression. 40 00:03:47,350 --> 00:03:52,420 And when I will confirm this expression, I will get this. 41 00:03:53,020 --> 00:03:55,660 As you can see in the last point, six point six point eight. 42 00:03:55,830 --> 00:03:58,920 So I will get seven eight point five zero point it. 43 00:03:59,620 --> 00:04:00,840 So let me confirm it. 44 00:04:01,690 --> 00:04:04,210 And here you can see we are getting three rows. 45 00:04:04,390 --> 00:04:04,700 Right. 46 00:04:06,460 --> 00:04:17,890 So we know we need to know that this number this is the total revenue and we need to know that which 47 00:04:17,930 --> 00:04:20,260 generates these three rows below. 48 00:04:21,430 --> 00:04:30,910 So for this, we have to use much Gyuri and for joining two like datasets. 49 00:04:32,290 --> 00:04:35,960 The two datasets should be in a paper form. 50 00:04:36,190 --> 00:04:40,590 So this is a list we need to convert this list into a table. 51 00:04:40,930 --> 00:04:43,900 So we have to click convert to table. 52 00:04:47,310 --> 00:04:55,470 And then we just have to click, OK, and here you can see this is a table and. 53 00:04:57,900 --> 00:05:06,420 You can see this icon is being changed to tapin previously the icon was was a list. 54 00:05:07,550 --> 00:05:13,750 And now when you will convert to table this, I completely change to table icon, right? 55 00:05:14,450 --> 00:05:19,610 So now we have this table and let's try to click. 56 00:05:20,510 --> 00:05:30,470 Oh, no, we need to click much curious new because we don't need too much of a dessert within the same 57 00:05:30,470 --> 00:05:30,770 table. 58 00:05:30,770 --> 00:05:32,360 So we will make a new table. 59 00:05:32,490 --> 00:05:32,930 All right. 60 00:05:34,040 --> 00:05:44,510 So here we have to choose the other table sales and we have this column and we need to we need another 61 00:05:44,510 --> 00:05:44,900 table. 62 00:05:45,230 --> 00:05:47,750 The other table will be the center of our center. 63 00:05:49,310 --> 00:06:02,300 And we need to click this column header and then we need to make a left to join with Tokarev in this 64 00:06:02,300 --> 00:06:02,540 one. 65 00:06:03,700 --> 00:06:11,790 All right, so we will get all the arrows from this column and then we will get all the matching rows 66 00:06:12,180 --> 00:06:20,930 from the center, if we don't have any matching rule, then we will get all the rules from the from 67 00:06:20,930 --> 00:06:21,720 the same table. 68 00:06:22,170 --> 00:06:26,580 But only getting those rules from this is all that will have some match. 69 00:06:27,150 --> 00:06:27,460 Right. 70 00:06:28,530 --> 00:06:31,850 So in our case, it doesn't matter if you choose right. 71 00:06:32,110 --> 00:06:34,730 Inner join or left out, it doesn't matter. 72 00:06:34,740 --> 00:06:35,140 Right. 73 00:06:35,190 --> 00:06:39,750 Because our table, both table belong to the same date as it. 74 00:06:39,880 --> 00:06:40,240 Right. 75 00:06:40,890 --> 00:06:43,050 OK, so we will have to click. 76 00:06:43,050 --> 00:06:50,720 OK, and here you can see with every record we are getting one but. 77 00:06:51,090 --> 00:06:51,440 Right. 78 00:06:51,960 --> 00:07:02,280 And this table because seven, eight, seven one one point is because two rows belong to this tribunal 79 00:07:02,280 --> 00:07:09,060 and then we have a second record and third and third belong to only one rule I. 80 00:07:12,890 --> 00:07:26,120 So we need only channel, we have to click here and then we need to choose only this one and click, 81 00:07:26,120 --> 00:07:26,500 OK? 82 00:07:28,830 --> 00:07:36,330 And here you can see we are getting one of our data squirrel and we are getting. 83 00:07:38,570 --> 00:07:49,710 Forum for the whole wholesale, as these forums are saying, and we need to apply some grouping so that 84 00:07:49,710 --> 00:07:52,260 we can get only a unique record. 85 00:07:53,550 --> 00:07:58,210 So for this, let's go to the click click on the group. 86 00:08:00,030 --> 00:08:06,980 And here we have to choose which column on which column we need is the order channel. 87 00:08:07,800 --> 00:08:10,380 And this is the name Nambu. 88 00:08:10,380 --> 00:08:11,390 You can change. 89 00:08:11,470 --> 00:08:15,810 You can write any anything here and which operation we need. 90 00:08:17,140 --> 00:08:20,230 We need, like average. 91 00:08:22,300 --> 00:08:31,490 Right, you can choose anyone like I will show you, because Overexerted will be the same, you can 92 00:08:31,490 --> 00:08:38,760 apply any function like Min Max average and less like everyday, because the average of these seven 93 00:08:38,900 --> 00:08:47,120 seven one one point takes, this average will be the same, the same, the same for the decimal and 94 00:08:47,210 --> 00:08:50,250 on which call we need to apply this average function. 95 00:08:50,270 --> 00:08:51,700 This is the call one here. 96 00:08:52,070 --> 00:08:52,700 That's OK. 97 00:08:53,150 --> 00:08:55,760 OK, and here you can see. 98 00:08:56,770 --> 00:09:03,610 We are getting kudos to you, Negroes, minister, distributer, and the other one is also it. 99 00:09:04,390 --> 00:09:05,920 So this is how we can get. 100 00:09:08,050 --> 00:09:10,940 Our top recog per channel. 101 00:09:12,220 --> 00:09:13,810 So that's all about this video.