In today's video, we will learn about some more functions of list, and for this, let's go to the
barber Ed.
So here you can see you already are familiar with this, David.
So in today, we will learn about how we can get like top generals, right, cooptation.
For this, what we need to do is.
We will just create one list here, the list will be based on revenue.
So how we can create a list, we just need to click.
IPEX.
And here we have to provide the column name Total Revenue decirte.
And here you can see this is the list of total revenue.
Before moving to this, let me delete this and we have to select this table sales, so again, we need
to take effect
total revenue.
This is an emoticon.
So we had this list, right?
And now we need to know the top three records from this list, so what we have to do is first we need
to do something in descending order.
So because this is a list, this is returning as a list.
So we need to write one function here.
List, dot, sort.
And the second parameter is order, we have to provide criteria, certain criteria to be ordered not
descending.
I said.
It's a typo problem or descending this one.
So here you can see we are getting the complete list in descending order.
So now we need only top three records.
So, again, we need to use the function in list that this list got.
Um, let's talk French.
This is a function and it's a subset of the list beginning again of that.
So the first parameter will be list
and then we have to provide the second parameter as an offset.
So this list, the indexing for this list is started from from position zero zero, level zero, one,
two, three and so on.
So we have to start from the zero level.
So for this one, you tried zero.
And then we need to provide the third parameter that how many records are how many rules we need.
So how many rows we need?
We just need three rows, but just slide three.
This is a complete expression.
And when I will confirm this expression, I will get this.
As you can see in the last point, six point six point eight.
So I will get seven eight point five zero point it.
So let me confirm it.
And here you can see we are getting three rows.
Right.
So we know we need to know that this number this is the total revenue and we need to know that which
generates these three rows below.
So for this, we have to use much Gyuri and for joining two like datasets.
The two datasets should be in a paper form.
So this is a list we need to convert this list into a table.
So we have to click convert to table.
And then we just have to click, OK, and here you can see this is a table and.
You can see this icon is being changed to tapin previously the icon was was a list.
And now when you will convert to table this, I completely change to table icon, right?
So now we have this table and let's try to click.
Oh, no, we need to click much curious new because we don't need too much of a dessert within the same
table.
So we will make a new table.
All right.
So here we have to choose the other table sales and we have this column and we need to we need another
table.
The other table will be the center of our center.
And we need to click this column header and then we need to make a left to join with Tokarev in this
one.
All right, so we will get all the arrows from this column and then we will get all the matching rows
from the center, if we don't have any matching rule, then we will get all the rules from the from
the same table.
But only getting those rules from this is all that will have some match.
Right.
So in our case, it doesn't matter if you choose right.
Inner join or left out, it doesn't matter.
Right.
Because our table, both table belong to the same date as it.
Right.
OK, so we will have to click.
OK, and here you can see with every record we are getting one but.
Right.
And this table because seven, eight, seven one one point is because two rows belong to this tribunal
and then we have a second record and third and third belong to only one rule I.
So we need only channel, we have to click here and then we need to choose only this one and click,
OK?
And here you can see we are getting one of our data squirrel and we are getting.
Forum for the whole wholesale, as these forums are saying, and we need to apply some grouping so that
we can get only a unique record.
So for this, let's go to the click click on the group.
And here we have to choose which column on which column we need is the order channel.
And this is the name Nambu.
You can change.
You can write any anything here and which operation we need.
We need, like average.
Right, you can choose anyone like I will show you, because Overexerted will be the same, you can
apply any function like Min Max average and less like everyday, because the average of these seven
seven one one point takes, this average will be the same, the same, the same for the decimal and
on which call we need to apply this average function.
This is the call one here.
That's OK.
OK, and here you can see.
We are getting kudos to you, Negroes, minister, distributer, and the other one is also it.
So this is how we can get.
Our top recog per channel.
So that's all about this video.