Hey everyone.
So in the last week we have calculated the mean for overall funding time in this video we are going
to analyze the average funding time for each state.
Now the first question arises here how can I get that money.
So that's very easy.
I will first group all the elements according to state so high I have the data of each state.
Then I will group the each of data according to their ideas.
Back then I have a good data according to project I.D. And then I will find the meaning of data in this
way.
I have the data of all the states.
So let me show you that one.
So I will take a variable state project under school funding under school time and that will be data
five dot group by post.
I will Group B element and here instead of passing one column this time I will pass a list of columns.
First there is school state so that I have data separated according to states not like a message system.
Then I've been separated data according to project I.D..
Maybe you have this one and after that I will pass the column.
That is our funding time.
The column we have added and simply calculate didn't hit enter and then to print this one.
Just add this one here shifted on and let it run.
There we go.
So here I have states the data is first grouped according to states.
If you notice them then the data is grouped according to project I.D..
And then there we have the funding time like 41 days 58 days 27 days.
This is the mean of each project.
I'd like the number of projects falling under this.
I'd have 41 average meantime.
Now this is a message system.
Hard to understand.
So convert this one is in a little understanding.
So here I have states
underscore.
Average I would just get the data according to average of states not with the I.D. because that is very
big.
So just copy this one instead of writing again.
This detail.
And an average day we had this one day we had this one and we will do this one by removing this from
here.
And add that variable.
We will use this variable again there and group the elements according to project I.D..
So these school states they we had this one and then group the elements.
So here that group by according to school state.
So here we have school space state a spacing between them.
And then just calculate the mean shift return we'll get at a state average project funding time not
defined.
There is a spelling mistake in this one.
There we go.
So here I have the data.
According to each state I have just printed this one this variable but I have just used these states
to group the elements.
So here Alabama.
This one Alabama.
Hey if you notice this thirty five this is the average or we said mean of all these values falling under
Alabama.
So I have removed just project I.T. sorted this one according to states here.
So here we had this one but this data is in point so wrong this one
note round.
And to remove the points around the values up to zero so that we do not have the point value so difficult
to determine.
So here we have Alabama 36 Alaska 34 and Arizona 35.
In this way we have all these and the mean of every state is here.
We have the 32.
And here we have these 31 34 32.
Are 29 also.
And as you know we have one in few schools or so in project.
So this is the average time per state.
Now we have done that one just one analyzes left that contains that which is performing best and which
is performing just so that we will continue in the next video.
Thanks for watching.
See you then.