In the last video, we have seen that all we can get the value from the previous role, and I got one
question regarding how we can repeat the same index for all the other countries.
Right.
Because in this in the last video, we just filter the country by us.
So what happens if we have a lot of other countries?
The index for every country should begin from zero.
So here you can see another dataset.
The name is it says groups.
And here you can see we have different countries, data and Copernicus's.
And now if I apply.
Index column from 02 onward.
So here you can see the indexes being started from zero and let me also make a little bit.
And we have with Gordon.
So here you can see.
In the raw numbers, seventy eight, the number of cases or the number of cases are four hundred forty
four.
And then the end of the country, Albania.
The index is I mean, it is just ongoing, right?
77, 78, 79 and so on.
And our requirement is.
We need Albany to be started from zero and again, when the new country will come, the index will begin
from zero.
So how we can solve this problem?
You need to understand one thing, if you go to the.
Veal and.
They advanced Ed.
So here you can see the beauty ed has generated one function.
So this is the quote that is generated by the power created.
And here you can see one function at indexical.
So an index, cholent requires one table like remove other columns.
You can see this is the deck table that poverty has passed on an index card.
So we need some kind of table.
And let me cancel.
So we have to apply grouping here.
Here you can see group by click Gerbi.
And then we had to select.
On this column, we need a country column.
And the name of the column you can write anything like a country works and you have to select Androes
here because we need.
Complete table against each country, for example, you can see Afghanistan and eventually we drop this
column by country, then we should get one table you will see as we go farther.
So it is better to learn while performing these steps.
So let me click, OK?
So here you can see.
Against every country, we are getting one table, which content is what country their farmland index
saw previously?
If you look here.
When we applied, I did index here the table that we have provided to the index was removed.
The other column, every step is returning one table.
And in the Capral, we are getting every win, every rule, we are getting one table, so we have to
run the index column.
Function against each rule and in every road, this function will get this stable as an input and then
it will generate index structure from the zero.
For this, we have to click the ADD column and then we have to like click on the custom column.
And here you can write like a new index index group.
Here we have to lose one function table, dot and index.
This is the function name, and then we need to provide the first the the column on which we did this
grouping, the this is the country groups that because we we need to provide one cable and the country
groups is returning a particular religion is not predictable.
It is written in one column and here it is returning regarding the column contributes that content.
Good tables.
Right, so we need to double click here.
So we need to add quotations here because there is space inside and then in the start, we need to write
a headline.
OK, so this is the table.
And then the second parameter will be is the name of the column, like the new index.
And then we have to start the index will go from zero and the increment is one.
So that's it.
And we need to click, OK?
So the table table, there is some type of problem here, just need to click a table.
We just need to remove the this table.
Oh, it's fine.
OK.
So here you can see we are again getting one deben.
And of all the Afghanistan, the new index is starting from zero.
You can see.
Just sort of on the zero and in the same in Albania.
It is again starting from zero.
So what we need to do now.
We just need the required columns, so which column we need, we need our date.
And confirm the new index, right?
So, OK.
And we don't need this column.
We just need to remove.
And here we have country.
A date, confirmed cases and the new index.
So here you can see.
In Afghanistan, the new index has started from zero.
And if we go down.
The Albania is again the new one that started from zero and so on.
Let's check one more.
So say the area is finished at 77 and the new index is starting from zero.
For the enteropathy for this country.
And so in this way, you have seen that how we can repeat.
Values in different groups, and this approach is very useful for a lot of business problems.
So here you can see.
How important is to learn poverty and language, why we need poverty and language as we have here,
you can see different poverty.
Ed functions here like airdrome removal, and then we have Croppy and many more.
Right.
So we can use this a graphical interface as well.
But this graphical user interface is not enough.
Sometimes when news out of the box functionality, that is only possible if you are caught in poverty
and language.
So like, if we want to perform the same stuff that we did, the reputation that age groups with it,
mainly because we know the functionality that that how we can get, how we can do the cooking and how
we can do the index manually.
And we will know the underlying theory and we know the the language, the function, and it is very
easy for us to perform different operations on data and we we can get the data in the format.
That is according to our requirement.