Here everyone.
So in this video we are going to analyze that how many subcategories out there like we have done the
three categories now in their three categories how many total number of categories are they.
And then we will find the sum of donations and protect.
So first of all here we have data full and we will simply do project and we have a column that is subject
Category 3 This one sea capital if you print that one you will find this one we have music sent the
arts maths and science literacy and language and something like this and they are doing this one special
ladies maths and science and if you need only the values that how many are there because simply do and
unique to find the unique values then then pass defenses then we have fifty one number of subcategories.
Now we will find the donation amount that these subcategories so we will use their variable asset and
then data for first of all.
Make this one group buy according to the subcategory that we need there.
So simply you just need to group by the elements according to this one you need to find the donation
amount.
So here we have this one and then just like the previous one here we have donation space amount then
find these some of these.
Now here we have this one if you provide a seat here.
Shifted on.
We have all the 51 categories with the sum of donations in of E so make this one as type and then bus
end.
Now we have this sum in integer values.
And now if we need only fuel values because we need to get autographs so we request the maximum buds.
You can also plot the graph on the minimum one also.
So just sold underscore values and their bus ascending
equal to False.
And how many values do we need.
We just pass here.
Let's say 15 values shifted on day we have only 15 values and that all sorted like we have maximum here
minimum then they're decreasing and reaches a constant level.
Now we just simply float this one by here we have first before that when these values are very large.
So let me clear this value for ten millions.
So here we have nine is equal to and divided by one million.
So if we have one and then one two three four five six deals shifted on.
And if you print s nine right now you will find this one in millions.
Fifty nine point forty six point.
These things now simply just blow this one s nine.
Look I applaud kind equal to but and then pass the parameters like X data that will be project subcategory
because they're using subcategories at x axis and then via title equal to donation
amount in millions.
Go to Dedmon after that.
We had the title
that will be something like donation amount by project subject you can add any title you want to and
just color scale equal to be it there you go.
Here we have this denoting the amount the donation amount in millions.
And we have a spelling mistake in that one absence of an individual donation amounts in millions.
Here we have a donation among our project and you can see him 59 46 and then decreasing to our constant
value.
Here we have maximum 59.
So what we have analyzed this time just the subcategories their donations amount and which have the
maximum donations amounts according to subcategories.
So we have also classified one more parameter.
So there is a thing here.
This is the V by which you analyze different things under different categories that which is performing
value which is not performing well which are the highest values which are the lowest values how you
can increase your we can see profit or margins.
So next the data analysis is now lasting required here is about Dick timings that which is donation
fulfilled earlier which is fulfilled later these things.
That is something different from these these are about the profits and values.
Now we will move to time needs not how something is uglier than another one.
So we will continue that one in the next video.
Thanks for watching and I hope you are understanding everything here.
So see you there.