1 00:00:00,780 --> 00:00:08,490 In the last video, we have seen that all we can get the value from the previous role, and I got one 2 00:00:08,490 --> 00:00:16,620 question regarding how we can repeat the same index for all the other countries. 3 00:00:16,920 --> 00:00:17,260 Right. 4 00:00:18,540 --> 00:00:26,970 Because in this in the last video, we just filter the country by us. 5 00:00:27,570 --> 00:00:32,340 So what happens if we have a lot of other countries? 6 00:00:32,550 --> 00:00:35,400 The index for every country should begin from zero. 7 00:00:35,610 --> 00:00:38,060 So here you can see another dataset. 8 00:00:38,730 --> 00:00:40,740 The name is it says groups. 9 00:00:41,670 --> 00:00:47,160 And here you can see we have different countries, data and Copernicus's. 10 00:00:47,850 --> 00:00:50,250 And now if I apply. 11 00:00:51,900 --> 00:00:55,020 Index column from 02 onward. 12 00:00:56,430 --> 00:01:03,330 So here you can see the indexes being started from zero and let me also make a little bit. 13 00:01:04,330 --> 00:01:06,060 And we have with Gordon. 14 00:01:07,110 --> 00:01:08,610 So here you can see. 15 00:01:10,210 --> 00:01:17,740 In the raw numbers, seventy eight, the number of cases or the number of cases are four hundred forty 16 00:01:17,740 --> 00:01:18,010 four. 17 00:01:18,990 --> 00:01:22,710 And then the end of the country, Albania. 18 00:01:23,760 --> 00:01:27,810 The index is I mean, it is just ongoing, right? 19 00:01:28,170 --> 00:01:30,750 77, 78, 79 and so on. 20 00:01:31,260 --> 00:01:32,820 And our requirement is. 21 00:01:33,980 --> 00:01:42,260 We need Albany to be started from zero and again, when the new country will come, the index will begin 22 00:01:42,260 --> 00:01:42,770 from zero. 23 00:01:43,070 --> 00:01:45,560 So how we can solve this problem? 24 00:01:46,980 --> 00:01:50,760 You need to understand one thing, if you go to the. 25 00:01:52,850 --> 00:01:54,260 Veal and. 26 00:01:57,290 --> 00:01:58,370 They advanced Ed. 27 00:01:59,560 --> 00:02:06,410 So here you can see the beauty ed has generated one function. 28 00:02:06,880 --> 00:02:10,480 So this is the quote that is generated by the power created. 29 00:02:11,290 --> 00:02:14,510 And here you can see one function at indexical. 30 00:02:15,630 --> 00:02:21,570 So an index, cholent requires one table like remove other columns. 31 00:02:21,770 --> 00:02:30,190 You can see this is the deck table that poverty has passed on an index card. 32 00:02:30,600 --> 00:02:32,580 So we need some kind of table. 33 00:02:33,530 --> 00:02:36,010 And let me cancel. 34 00:02:37,850 --> 00:02:40,830 So we have to apply grouping here. 35 00:02:40,950 --> 00:02:45,350 Here you can see group by click Gerbi. 36 00:02:47,420 --> 00:02:50,180 And then we had to select. 37 00:02:51,270 --> 00:02:54,060 On this column, we need a country column. 38 00:02:55,280 --> 00:03:06,200 And the name of the column you can write anything like a country works and you have to select Androes 39 00:03:06,200 --> 00:03:08,630 here because we need. 40 00:03:09,600 --> 00:03:16,740 Complete table against each country, for example, you can see Afghanistan and eventually we drop this 41 00:03:16,740 --> 00:03:24,340 column by country, then we should get one table you will see as we go farther. 42 00:03:24,480 --> 00:03:28,230 So it is better to learn while performing these steps. 43 00:03:28,560 --> 00:03:29,960 So let me click, OK? 44 00:03:32,590 --> 00:03:33,640 So here you can see. 45 00:03:34,710 --> 00:03:42,870 Against every country, we are getting one table, which content is what country their farmland index 46 00:03:42,870 --> 00:03:43,990 saw previously? 47 00:03:44,970 --> 00:03:45,720 If you look here. 48 00:03:46,820 --> 00:03:54,600 When we applied, I did index here the table that we have provided to the index was removed. 49 00:03:54,600 --> 00:03:57,980 The other column, every step is returning one table. 50 00:03:58,890 --> 00:04:08,820 And in the Capral, we are getting every win, every rule, we are getting one table, so we have to 51 00:04:09,540 --> 00:04:11,370 run the index column. 52 00:04:12,610 --> 00:04:22,000 Function against each rule and in every road, this function will get this stable as an input and then 53 00:04:22,000 --> 00:04:25,160 it will generate index structure from the zero. 54 00:04:25,300 --> 00:04:31,580 For this, we have to click the ADD column and then we have to like click on the custom column. 55 00:04:32,380 --> 00:04:37,070 And here you can write like a new index index group. 56 00:04:37,690 --> 00:04:44,110 Here we have to lose one function table, dot and index. 57 00:04:47,880 --> 00:04:57,360 This is the function name, and then we need to provide the first the the column on which we did this 58 00:04:57,600 --> 00:05:06,000 grouping, the this is the country groups that because we we need to provide one cable and the country 59 00:05:06,000 --> 00:05:10,770 groups is returning a particular religion is not predictable. 60 00:05:10,770 --> 00:05:18,570 It is written in one column and here it is returning regarding the column contributes that content. 61 00:05:20,270 --> 00:05:21,260 Good tables. 62 00:05:21,630 --> 00:05:25,550 Right, so we need to double click here. 63 00:05:26,030 --> 00:05:35,450 So we need to add quotations here because there is space inside and then in the start, we need to write 64 00:05:35,450 --> 00:05:36,160 a headline. 65 00:05:36,620 --> 00:05:39,010 OK, so this is the table. 66 00:05:39,170 --> 00:05:45,920 And then the second parameter will be is the name of the column, like the new index. 67 00:05:48,770 --> 00:05:54,460 And then we have to start the index will go from zero and the increment is one. 68 00:05:56,000 --> 00:05:57,170 So that's it. 69 00:05:58,970 --> 00:06:01,210 And we need to click, OK? 70 00:06:06,720 --> 00:06:13,770 So the table table, there is some type of problem here, just need to click a table. 71 00:06:13,800 --> 00:06:16,680 We just need to remove the this table. 72 00:06:17,700 --> 00:06:20,070 Oh, it's fine. 73 00:06:20,400 --> 00:06:20,750 OK. 74 00:06:22,590 --> 00:06:26,460 So here you can see we are again getting one deben. 75 00:06:28,030 --> 00:06:32,380 And of all the Afghanistan, the new index is starting from zero. 76 00:06:33,810 --> 00:06:34,350 You can see. 77 00:06:35,480 --> 00:06:38,750 Just sort of on the zero and in the same in Albania. 78 00:06:40,430 --> 00:06:42,480 It is again starting from zero. 79 00:06:43,280 --> 00:06:46,430 So what we need to do now. 80 00:06:48,140 --> 00:06:53,710 We just need the required columns, so which column we need, we need our date. 81 00:06:54,990 --> 00:06:58,780 And confirm the new index, right? 82 00:06:59,610 --> 00:07:00,940 So, OK. 83 00:07:05,180 --> 00:07:07,920 And we don't need this column. 84 00:07:08,300 --> 00:07:09,290 We just need to remove. 85 00:07:10,400 --> 00:07:11,750 And here we have country. 86 00:07:12,810 --> 00:07:16,920 A date, confirmed cases and the new index. 87 00:07:17,880 --> 00:07:19,710 So here you can see. 88 00:07:20,970 --> 00:07:24,120 In Afghanistan, the new index has started from zero. 89 00:07:24,960 --> 00:07:27,000 And if we go down. 90 00:07:28,100 --> 00:07:32,960 The Albania is again the new one that started from zero and so on. 91 00:07:33,890 --> 00:07:35,060 Let's check one more. 92 00:07:44,120 --> 00:07:52,220 So say the area is finished at 77 and the new index is starting from zero. 93 00:07:53,210 --> 00:07:55,520 For the enteropathy for this country. 94 00:07:56,510 --> 00:08:01,820 And so in this way, you have seen that how we can repeat. 95 00:08:03,460 --> 00:08:11,750 Values in different groups, and this approach is very useful for a lot of business problems. 96 00:08:12,700 --> 00:08:13,930 So here you can see. 97 00:08:16,100 --> 00:08:25,880 How important is to learn poverty and language, why we need poverty and language as we have here, 98 00:08:26,090 --> 00:08:28,870 you can see different poverty. 99 00:08:28,910 --> 00:08:36,490 Ed functions here like airdrome removal, and then we have Croppy and many more. 100 00:08:36,500 --> 00:08:36,770 Right. 101 00:08:37,580 --> 00:08:41,560 So we can use this a graphical interface as well. 102 00:08:41,570 --> 00:08:44,450 But this graphical user interface is not enough. 103 00:08:45,620 --> 00:08:53,010 Sometimes when news out of the box functionality, that is only possible if you are caught in poverty 104 00:08:53,330 --> 00:08:54,060 and language. 105 00:08:54,890 --> 00:09:03,800 So like, if we want to perform the same stuff that we did, the reputation that age groups with it, 106 00:09:03,950 --> 00:09:11,660 mainly because we know the functionality that that how we can get, how we can do the cooking and how 107 00:09:11,660 --> 00:09:14,540 we can do the index manually. 108 00:09:15,920 --> 00:09:22,250 And we will know the underlying theory and we know the the language, the function, and it is very 109 00:09:22,250 --> 00:09:29,270 easy for us to perform different operations on data and we we can get the data in the format. 110 00:09:29,660 --> 00:09:31,730 That is according to our requirement.