1 00:00:05,640 --> 00:00:06,300 Here everyone. 2 00:00:06,730 --> 00:00:12,710 So in this video we are going to analyze that how many subcategories out there like we have done the 3 00:00:12,720 --> 00:00:18,690 three categories now in their three categories how many total number of categories are they. 4 00:00:18,840 --> 00:00:23,950 And then we will find the sum of donations and protect. 5 00:00:23,970 --> 00:00:37,990 So first of all here we have data full and we will simply do project and we have a column that is subject 6 00:00:39,630 --> 00:00:50,010 Category 3 This one sea capital if you print that one you will find this one we have music sent the 7 00:00:50,010 --> 00:00:58,470 arts maths and science literacy and language and something like this and they are doing this one special 8 00:00:58,470 --> 00:01:05,760 ladies maths and science and if you need only the values that how many are there because simply do and 9 00:01:06,840 --> 00:01:15,930 unique to find the unique values then then pass defenses then we have fifty one number of subcategories. 10 00:01:15,930 --> 00:01:24,750 Now we will find the donation amount that these subcategories so we will use their variable asset and 11 00:01:24,750 --> 00:01:27,660 then data for first of all. 12 00:01:27,660 --> 00:01:34,650 Make this one group buy according to the subcategory that we need there. 13 00:01:35,700 --> 00:01:41,610 So simply you just need to group by the elements according to this one you need to find the donation 14 00:01:41,610 --> 00:01:42,440 amount. 15 00:01:42,480 --> 00:01:52,680 So here we have this one and then just like the previous one here we have donation space amount then 16 00:01:52,680 --> 00:01:55,320 find these some of these. 17 00:01:55,320 --> 00:02:01,000 Now here we have this one if you provide a seat here. 18 00:02:01,550 --> 00:02:02,320 Shifted on. 19 00:02:02,340 --> 00:02:14,610 We have all the 51 categories with the sum of donations in of E so make this one as type and then bus 20 00:02:14,660 --> 00:02:15,460 end. 21 00:02:15,630 --> 00:02:18,330 Now we have this sum in integer values. 22 00:02:18,780 --> 00:02:26,070 And now if we need only fuel values because we need to get autographs so we request the maximum buds. 23 00:02:26,070 --> 00:02:28,980 You can also plot the graph on the minimum one also. 24 00:02:28,980 --> 00:02:34,770 So just sold underscore values and their bus ascending 25 00:02:37,690 --> 00:02:40,280 equal to False. 26 00:02:40,600 --> 00:02:43,020 And how many values do we need. 27 00:02:43,240 --> 00:02:45,600 We just pass here. 28 00:02:45,880 --> 00:02:54,240 Let's say 15 values shifted on day we have only 15 values and that all sorted like we have maximum here 29 00:02:54,400 --> 00:02:58,990 minimum then they're decreasing and reaches a constant level. 30 00:02:58,990 --> 00:03:08,100 Now we just simply float this one by here we have first before that when these values are very large. 31 00:03:08,140 --> 00:03:11,020 So let me clear this value for ten millions. 32 00:03:11,020 --> 00:03:16,000 So here we have nine is equal to and divided by one million. 33 00:03:16,450 --> 00:03:22,260 So if we have one and then one two three four five six deals shifted on. 34 00:03:22,270 --> 00:03:27,370 And if you print s nine right now you will find this one in millions. 35 00:03:27,370 --> 00:03:29,590 Fifty nine point forty six point. 36 00:03:30,160 --> 00:03:34,180 These things now simply just blow this one s nine. 37 00:03:34,190 --> 00:03:48,850 Look I applaud kind equal to but and then pass the parameters like X data that will be project subcategory 38 00:03:49,360 --> 00:03:58,000 because they're using subcategories at x axis and then via title equal to donation 39 00:04:00,510 --> 00:04:04,580 amount in millions. 40 00:04:04,740 --> 00:04:08,310 Go to Dedmon after that. 41 00:04:08,610 --> 00:04:09,600 We had the title 42 00:04:12,210 --> 00:04:26,020 that will be something like donation amount by project subject you can add any title you want to and 43 00:04:26,020 --> 00:04:32,250 just color scale equal to be it there you go. 44 00:04:32,420 --> 00:04:37,210 Here we have this denoting the amount the donation amount in millions. 45 00:04:37,210 --> 00:04:45,290 And we have a spelling mistake in that one absence of an individual donation amounts in millions. 46 00:04:45,290 --> 00:04:51,410 Here we have a donation among our project and you can see him 59 46 and then decreasing to our constant 47 00:04:51,410 --> 00:04:52,360 value. 48 00:04:52,450 --> 00:04:54,020 Here we have maximum 59. 49 00:04:54,650 --> 00:05:01,430 So what we have analyzed this time just the subcategories their donations amount and which have the 50 00:05:01,430 --> 00:05:05,510 maximum donations amounts according to subcategories. 51 00:05:05,510 --> 00:05:08,110 So we have also classified one more parameter. 52 00:05:08,390 --> 00:05:09,550 So there is a thing here. 53 00:05:10,160 --> 00:05:16,020 This is the V by which you analyze different things under different categories that which is performing 54 00:05:16,020 --> 00:05:21,530 value which is not performing well which are the highest values which are the lowest values how you 55 00:05:21,530 --> 00:05:25,640 can increase your we can see profit or margins. 56 00:05:25,640 --> 00:05:36,700 So next the data analysis is now lasting required here is about Dick timings that which is donation 57 00:05:36,700 --> 00:05:40,710 fulfilled earlier which is fulfilled later these things. 58 00:05:40,750 --> 00:05:45,030 That is something different from these these are about the profits and values. 59 00:05:45,040 --> 00:05:51,660 Now we will move to time needs not how something is uglier than another one. 60 00:05:52,690 --> 00:05:55,200 So we will continue that one in the next video. 61 00:05:55,210 --> 00:05:58,290 Thanks for watching and I hope you are understanding everything here. 62 00:05:58,900 --> 00:05:59,530 So see you there.