Here everyone.
So in the last few days we have find the main period and more in this video we are going to do two smaller
analyses.
First in which percent is the data sports greater or smaller than the value shown excesses.
And second is in which states they are more donations than by donor clustering is very easy one that
is the one depends on the mean minute and more.
If you have noticed we have mean sixty one and median quantified it means there's a great difference
in between them.
Also the 25 percent values fifteen and seventy five is 50 that denotes that we have some outliers causing
men to rise and that is something shown here that on some values we have the values what we can see
points greater or smaller than the values on x axis.
So this is a little graph easy to understand after that that we move to a proper analysis.
That is again based on the data in which states that are more donations than by donors.
So we need to find here than that what are the states in this day donations are more that is judged
by the donors.
So how we get so different so lesbian just by creating a data and using data for.
So what we require for disclosure look at the cushion in which states that are more donations than by
the donor.
So we require donors with states and then their donations that how many donations to have.
So we will first group by the elements by donor states.
If you look at the columns then we have a column here that is to donor state status of donor and we
will group the elements according to Declan who will find particular state donors as in there.
So we have here donor state and then they will use
this buy up and sees because this is not the particular column of data for we just need to group by
decision.
So here very glad now the packets for the main column Vidic platform.
So here we require donation I column that was offensive I that features the idea of donation and then
we will count net how many are present state.
So just count.
And then so devalues according to their
amplitude.
So here we have salt values and ascending equal to False and we will print tier 15 values this time
shifted on that region.
David go and now been devalues as three so here we have 15 states in which we have these numbers of
donors here we have sixty nine thousand six left ninety three thousand.
Now we will just blow this data by using as three I bloat and then provide kind equal to bar.
We had the sun ex title state
then we have white title.
This will be number of donations area design.
Then we have titan that is donations count because we are counting the donations state and also polite
gala scaled
equal to be a
shift return.
David go with that.
So here we have these 50 states with the number of donations in them.
This one six up to 700.
Kate just a few million is less than we had this one and then of course 10 values.
So this is the number of donations by the state.
We have also analyzed that plan and now we will move to some more advanced solutions that is in the
next video.
These are defining the relations between these values.
So thanks for watching.
See you then.