Here.
Even so in this video we are going to find some relations.
And here if you notice on the caution is there a relation between number of projects offers and number
of donations made by donor.
So we have to find a relationship between projects offered and the donations made by donor.
Then with state performing battering case and how many of responding projects request below average
and states are performing best and best in terms of donations per project.
So after that we need to find that the state is performing that best and which is performing lowest.
And then I have a hint here for you.
In order to answer this question we just need to get the number of projects per state.
That is we have already done before.
And then the number of donations made per state.
That is also we have done in the last video then we should most these two and proto skateboard to solicit.
So first of all we're required that the number of projects posted if you remember we have done that
one in the case we have schools in the previous one.
And we have used schools state that is maybe the first one that we have done here.
School straight goes this one and is this one.
And then we will count the values that how many of that type out of eleven.
So here just count.
And then the second one is the one that we have done in the last video that is we have data for and
we first group all the data by donor state so that we have these states according to the donors and
then we will count the number of items available there which will be equal to the number of donations
because I decided presenting the donations.
So instead of counting them we can just count the ibis.
So hey we have these two datasets and discern is s now build most of them by using couldn't coordination.
Here I have RDF and I will do PD dot com get they began to discern and provide the values that need
to be concatenated like I have s full and S5 after that positive barometers like X is I need to 1 instead
of zeros then I have keys and keys are the projects and donations
maybe Edison
and David go the data.
Now if you print death first that we've been ahead Dave we have this one we have states then we have
projects and we have donation we have conquered needed this one only that these two keys projects and
donations and we have the does this for an S5 that is first one the school states and we have counted
all the values and then we have beautiful group donor state and counted the donations I despairs and
then so get the decision and if you print this one simply you will find we have all these states the
deep project and donations made but in the last we have a debt that is an empty value men but if it
has donations so do you not have any projects but it has donation maybe something Blechman but we need
to drop that well.
So here we will just do deserve equal to be f don't drop any so we will drop that null value now if
you print this one you will find that you do not have that particular value now and that is where they
drop a name though I have not shown that bonanza before.
Now here we had the head they legal the Denver now we will visualize this one by just simply D after
a plot and we need a scatter probe there if you remember biased get to produce lays it.
So here we have this one scatter There we go and then we have X titan
that is the projects this time invite title is the donations.
So here we have donations then we have the title of this float that is simply projects was is donations
to go after that the wide symbol equal to x and color scale equal to be it shifted on David go the debt.
So here we have this one but this one is form of Inform of line we need to add one more Bama to them
so find a space and then decode and just write
Ma ko so it is more equal to Marcus.
So here we had the son Marcus will shift Britain and then we had this when I started plotting form of
this cross team bus.
So now we have plotted despite now we need to combine the data to visualize that.
So in order to enter a discussion we must get the number of projects posted and the number of tuition.
Then we should must this data.
This too.
And plotters get to visualize it.
So here we have done this one.
But now we also require to much upload with that one.
Here we have now done is the relationship between number of projects offered and the donations made
by donor.
This is what we have done here and now fit a linear model which would basically indicate a relationship
between projects and donations.
So we need to create some particular relation in between the projects and donations so that there will
be a linear linear go is something a straight line we can see.
If I have discovered in a straight line going down in which X and Y values are equal.
So for that we define two way above the slope and intercept
and they will be defined by using a method that is known as poly fit.
This is a method that simply return a polynomial of a particular degree it requires three parameters
generated by mode but the basic one of three that is X flight and then degree of what degree we require
the polynomial.
So in X we just two days after the projects
in case of value we just simply do D F for donations.
So here we have donations and we require a degree.
1 This is something you can do search for qualified a home book for you.
After that we have X and Y No we required to define the excesses so X is something and B don't every
and in that one the bus B after projects and we will go for the minimum and maximum values.
So first minimum and after that one will pass the F not projects
and then the maximum because we need to figure it out here on the cushion visited performing better
in this case.
How many of responding projects request below average.
And which states are performing best in terms of donations per project.
So we simply need to find a minimum and maximum values so that we can visualize that one that real are
the maximum values and we're at the minimum values that which states are denoting the maximum one and
which are denoting the minimum.
So for that when we require this x variable in which we have minimum and maximum values of project so
there is word here X is I hope you get the idea of what the X is more you will understand this one while
we complete the other remaining problems here.
Then we have the right that will be equal to that slope and multiply by x plus intercept.
Now if you plot this one you will get a straight line X comma white shift written day we have a straight
line.
I hope you go that what I have done here.
If your mental math is mathematics student then this one is very easy for you just.
I have created a slope and intercept that is of these two which is a polynomial of degree.
It provides me slope of that particular location and the intercept of that one.
And if you remember the general equation for any go is Vi's equal to emacs plus C the M is the slope
X is the variable C is any constant C the intercept of these two lines.
And then we have divide.
So I have defined a variable X that is denoting an area of the minimum and maximum values of the project.
And then I have defined a variable VI which is the general equation slope plus intercept then I have
P BLT dot plot and simply I have plotted to discuss.
I hope you got this one now and if you get any problem then please ask me the cushions.
After that we need to combine these plots so combining the plots is very simple.
We just have first.
Do you have good plot not shatter.
The first one this time not by using the plot because we required to combine these two.
I have X is equal to projects the same this one but in form of a simple plot.
So here I have projects and then I have Y equal to donations.
Then we had this one.
If you plot that one you will have this simple curve.
So a simple plot of scatter plots.
Then after this we will add this whole currency.
Here in this set come on 3.
So here we had this slope and intercept.
We have defined and qualified poly fit with projects and donations with the group 1.
Then I have the maximum and minimum value.
Edit That is the x and then I have VI that is the slope into x plus intercept.
Here I have plotted these two.
No.
Just simply provide BLT or type underscored layout for a proper view and also provide a margin there
that is BLT.
Note margin
and this one zero point zero five shift return day.
We have a combined plot here if you notice this go the values that are about this one showing the states
in which we have better donations and the values below this one representing that is not performing
good.
So this is the visualization by design of this particular problem that which states which projects request
below average and which states are performing best in terms of donations.
So this goes on about this straight line representing districts which are better donations according
to the number of projects they can cannot just simply conclude.
This one like this one has the maximum number of donations so this is best if you notice this one is
also the maximum number of projects and the best means that according to the number of projects we have
a better number of donations.
So this call there is this simple line dividing the plane into two halves is just simply representing
we can see a boundary line below which the plots are not performing well.
They have met more number of projects but let's number of donations about this one.
We have the plots which are generally presenting lower number of projects.
So we can see the number of projects fulfilled by the number of donations.
So it means these states like when we have this one two thousand and the about this line this dude is
performing well.
So I hope you get this and lies that.
What do I need to show you here that this girl is just a special light.
I need to plot as straight go so that we can have the idea of maximum and minimum values about this.
We have the better one below this.
We have the one that under performing well.
So and then analyzes them.
Now we will move that.
How many different projects type sexist.
So try.
If you are feeling comfortable with this one and see in the next video.