Hey everyone.
So just a few more places to go.
Now the next problem we have is how many different projects type sexist.
What is the total donation amount for each of them.
So here we need to get that the how many project types out there.
Then what is the total amount of donation for them.
So first of all here I have data for the head and being just 2 there and such for column name as project
types.
There is not here.
Let me show you that one in the columns name.
So here we have a column that is project type here.
This one not represented in here at this one but that one is better and.
You can check in the data types so see the difference.
So there is something containing that project type that how many people.
Which category.
All we can say that which type of project that particular is.
So we need that column and we need to count that how many particular project types out there.
Then after getting the project types we get this some of the donations for these but project types.
So here we need to very well first one six that is data for and then we pass the column project type
there we have this one and then we just count the values there that how many values out there.
And if you've been six you will get this one.
These three and then they have particular values like this one and this one for the three thousand forty
five flag 32000.
So here we have only three types of categories that is teacher led student led and professional development.
So only triple digit types out there.
Now what will we do.
We will first find this some of the donations with each of these Category Four that we have a variable
seven and how we will do that one we will first group by all the elements according to project type
fit this one you will also understand it how group by works.
So here we have project for group by.
And then we have project type.
So first I will group the data according to the project type.
It means that this thing that first it will group all the projects according to their project type that
how many ties are there then it will group all the projects according to that plan.
So in that case we have only three groups.
These three which containing these numbers of values and now I will access this column of donations.
Like here we have only the number then base their donation amount.
So there must be a donation amount also.
That is the this column donation amount.
I will accept that donation amount.
He is simply donation amount.
And then I will make this sum of all the values there.
But if you pass this thing this is okay but if you pass this fund you will find the sum in exponential
forms the 80s.
This is like the one that is when we have applauded the values like here this one then we have described
this in form of explanation values.
So what to do now because this is something non understandable.
So for that just pass him as type that in this type you need to find the sum in then you will find the
donation amount in it.
Here we have this one.
So this is how you can have this project types and the amount of donations related to these project
types.
Now we will simply float us by Jack with this one and this one plus 20 showing that how many projects
are there and how many numbers of project type t to do that but then we will blow it up by a judge for
their donation.
So we will have BLT and value supplement.
And if you remember in support we have us the number of frauds number of columns and the number of one
that day number at which we are currently working.
So hey I'm going to use two rows one column so that I have to buy charts I'm not using one two and two
column because that will be a little mess there because this victim's little smaller no blowed debated
just BLT by and they passed the value that is close to an Essex and and a parameter that is start angle
this one just 90 after that when we have a second thought BLT dot subplot this one two one two and simply
BLT or by their past seven comma and this trading.
Come on see that one.
Come on V here.
Here we have this one.
If you shifted on that one you will have a small pie charts.
So let me change their sizes so that they can be visualize easily.
So here we will first away a tight label so BLT tight underscore layout also provide margins so that
it will be mode good looking.
So here we have zero point zero five and then about this size.
So here we will first create a fake variable that is BLT and use the metric GCF for size declaration
and then we will use this matter to set the size.
So fig don't set underscores size and in which amount we needed inches.
So these are the tools you cannot get everyone at now but whenever you are working just get to the problem
that what is your problem.
You need to change the size and Google out deck that shifted on there.
We have this one.
This one is the teacher led I believe and these two are these student led and daredevil because if you
notice this is in LAX and this one is only 1 percent of that flat you can also provide the D denoting
colors that what they are denoting just by simply adding for this one BLT note legend
and provide this one a location like this that we go for a boat lift shifted on there we have this one
baseball but not visible.
You can also do that one that's for you a homework again to add diligence in both these graphs.
So we are not done with debt financing.
We have not analyzed that how many projects types in that particular data frame is and what is the donation
amount for these types.
And here I am just doing these things like I have already says the columns but whenever you are working
you need to find the columns there so you first need to completely analyze the columns that what they
are denoting their donation ideas amount school I.D. teacher I.D. and then you need to work on that
one.
So don't be stupid like me because I just need to teach you here.
I am not performing my project so this is about this one in the next video we will work on subcategories.
So thanks for watching.
See in the next video.