1 00:00:05,110 --> 00:00:06,180 Hey everyone. 2 00:00:06,370 --> 00:00:11,060 So in the last week we have calculated the mean for overall funding time in this video we are going 3 00:00:11,060 --> 00:00:14,030 to analyze the average funding time for each state. 4 00:00:14,090 --> 00:00:17,030 Now the first question arises here how can I get that money. 5 00:00:17,240 --> 00:00:18,670 So that's very easy. 6 00:00:18,680 --> 00:00:24,510 I will first group all the elements according to state so high I have the data of each state. 7 00:00:24,710 --> 00:00:28,400 Then I will group the each of data according to their ideas. 8 00:00:28,480 --> 00:00:34,220 Back then I have a good data according to project I.D. And then I will find the meaning of data in this 9 00:00:34,220 --> 00:00:35,090 way. 10 00:00:35,090 --> 00:00:37,290 I have the data of all the states. 11 00:00:38,300 --> 00:00:41,230 So let me show you that one. 12 00:00:41,510 --> 00:00:54,520 So I will take a variable state project under school funding under school time and that will be data 13 00:00:54,530 --> 00:00:58,840 five dot group by post. 14 00:00:58,850 --> 00:01:08,510 I will Group B element and here instead of passing one column this time I will pass a list of columns. 15 00:01:08,600 --> 00:01:16,190 First there is school state so that I have data separated according to states not like a message system. 16 00:01:16,310 --> 00:01:20,990 Then I've been separated data according to project I.D.. 17 00:01:20,990 --> 00:01:25,100 Maybe you have this one and after that I will pass the column. 18 00:01:25,100 --> 00:01:27,080 That is our funding time. 19 00:01:27,170 --> 00:01:37,100 The column we have added and simply calculate didn't hit enter and then to print this one. 20 00:01:37,100 --> 00:01:44,510 Just add this one here shifted on and let it run. 21 00:01:44,520 --> 00:01:45,420 There we go. 22 00:01:45,420 --> 00:01:49,150 So here I have states the data is first grouped according to states. 23 00:01:49,170 --> 00:01:54,120 If you notice them then the data is grouped according to project I.D.. 24 00:01:54,690 --> 00:02:00,370 And then there we have the funding time like 41 days 58 days 27 days. 25 00:02:00,390 --> 00:02:02,270 This is the mean of each project. 26 00:02:02,290 --> 00:02:06,030 I'd like the number of projects falling under this. 27 00:02:06,050 --> 00:02:09,350 I'd have 41 average meantime. 28 00:02:09,660 --> 00:02:11,730 Now this is a message system. 29 00:02:11,790 --> 00:02:12,720 Hard to understand. 30 00:02:13,020 --> 00:02:16,470 So convert this one is in a little understanding. 31 00:02:17,160 --> 00:02:18,870 So here I have states 32 00:02:21,250 --> 00:02:22,050 underscore. 33 00:02:22,260 --> 00:02:31,440 Average I would just get the data according to average of states not with the I.D. because that is very 34 00:02:31,440 --> 00:02:31,790 big. 35 00:02:32,430 --> 00:02:34,660 So just copy this one instead of writing again. 36 00:02:36,840 --> 00:02:37,630 This detail. 37 00:02:39,390 --> 00:02:51,720 And an average day we had this one day we had this one and we will do this one by removing this from 38 00:02:51,720 --> 00:02:52,100 here. 39 00:02:56,150 --> 00:02:58,420 And add that variable. 40 00:02:58,970 --> 00:03:04,490 We will use this variable again there and group the elements according to project I.D.. 41 00:03:05,090 --> 00:03:10,610 So these school states they we had this one and then group the elements. 42 00:03:10,770 --> 00:03:15,420 So here that group by according to school state. 43 00:03:15,440 --> 00:03:23,100 So here we have school space state a spacing between them. 44 00:03:24,970 --> 00:03:32,950 And then just calculate the mean shift return we'll get at a state average project funding time not 45 00:03:32,950 --> 00:03:34,590 defined. 46 00:03:34,590 --> 00:03:38,520 There is a spelling mistake in this one. 47 00:03:38,540 --> 00:03:39,500 There we go. 48 00:03:39,500 --> 00:03:40,840 So here I have the data. 49 00:03:41,600 --> 00:03:50,150 According to each state I have just printed this one this variable but I have just used these states 50 00:03:50,240 --> 00:03:51,270 to group the elements. 51 00:03:51,270 --> 00:03:53,670 So here Alabama. 52 00:03:53,840 --> 00:03:55,000 This one Alabama. 53 00:03:55,190 --> 00:04:02,290 Hey if you notice this thirty five this is the average or we said mean of all these values falling under 54 00:04:02,350 --> 00:04:03,530 Alabama. 55 00:04:03,820 --> 00:04:10,550 So I have removed just project I.T. sorted this one according to states here. 56 00:04:11,350 --> 00:04:15,970 So here we had this one but this data is in point so wrong this one 57 00:04:18,690 --> 00:04:21,390 note round. 58 00:04:21,520 --> 00:04:28,260 And to remove the points around the values up to zero so that we do not have the point value so difficult 59 00:04:28,260 --> 00:04:28,780 to determine. 60 00:04:29,950 --> 00:04:35,350 So here we have Alabama 36 Alaska 34 and Arizona 35. 61 00:04:35,440 --> 00:04:40,450 In this way we have all these and the mean of every state is here. 62 00:04:40,450 --> 00:04:42,250 We have the 32. 63 00:04:42,340 --> 00:04:45,610 And here we have these 31 34 32. 64 00:04:45,960 --> 00:04:47,560 Are 29 also. 65 00:04:48,370 --> 00:04:52,880 And as you know we have one in few schools or so in project. 66 00:04:53,470 --> 00:04:56,380 So this is the average time per state. 67 00:04:56,380 --> 00:05:01,930 Now we have done that one just one analyzes left that contains that which is performing best and which 68 00:05:01,930 --> 00:05:06,160 is performing just so that we will continue in the next video. 69 00:05:06,280 --> 00:05:07,120 Thanks for watching. 70 00:05:07,120 --> 00:05:07,700 See you then.