1
00:00:00,180 --> 00:00:06,850
Halaal, before going ahead in the session, let's have a quick recap of what we have done in this project.

2
00:00:06,870 --> 00:00:14,880
In so doing, lots of preparation and we have analyzed using this heat map what exactly is a crude map

3
00:00:14,880 --> 00:00:20,020
representation of different countries with respect to the activity of these recovered cases and all

4
00:00:20,020 --> 00:00:20,610
of these things.

5
00:00:20,910 --> 00:00:23,790
Then we have found this amazing trend over here.

6
00:00:24,000 --> 00:00:27,870
After that, we have concluded with respect to all different, different county.

7
00:00:28,320 --> 00:00:34,770
We have to the which country has Baghdad population to test the ratio that we have.

8
00:00:34,770 --> 00:00:43,650
Something can do almost to Western countries have battered population to pastern ratio comparative to

9
00:00:43,650 --> 00:00:45,030
the Asian countries.

10
00:00:45,250 --> 00:00:48,200
After what we have done, we have performed.

11
00:00:48,200 --> 00:00:53,350
This is tech bossart analysis with respect to all these features.

12
00:00:53,700 --> 00:00:59,040
So in this session, we had this assignment, the very first of a statement we have to analyze what

13
00:00:59,040 --> 00:01:06,810
exactly are our worst 20 countries having a maximum number of confirmed cases, four days, what I am

14
00:01:06,810 --> 00:01:07,970
going to do over here.

15
00:01:08,130 --> 00:01:11,610
So I'm just going to use simple bar chart over here.

16
00:01:11,790 --> 00:01:13,770
I'm going to say start bar.

17
00:01:14,010 --> 00:01:19,590
And the very first I have to mention what exactly my name is so that I'm going to say my data for this

18
00:01:19,590 --> 00:01:21,190
one, I just need to know.

19
00:01:21,400 --> 00:01:23,880
So I log of zero to twenty.

20
00:01:23,880 --> 00:01:27,630
That's what we have done in a previous session after it on Y-axis.

21
00:01:27,630 --> 00:01:32,250
Let's say I just want my horizontal pad chart.

22
00:01:32,430 --> 00:01:39,110
It means on y axis I have to assign this country reason, which is exactly this one.

23
00:01:39,120 --> 00:01:42,000
So on y axis, I have to assign this much.

24
00:01:42,360 --> 00:01:50,040
And basically on X axis I have to assign what exactly is my total cases where I'm going to say on x

25
00:01:50,040 --> 00:01:50,940
axis I am nothing.

26
00:01:50,940 --> 00:01:54,450
But my total case is feature after eight.

27
00:01:54,450 --> 00:02:00,750
What I have to do, let's say if I'm going to press shift plus tabular here, you will get all your

28
00:02:00,750 --> 00:02:07,380
custom parameters over here and here you have a barometer, which is exactly your text parameter.

29
00:02:07,390 --> 00:02:14,580
So in this text parameter, what I have to pass, I have to basically pass, say, my total kasit.

30
00:02:14,760 --> 00:02:20,760
It means I have to assign that bar on the basis of this total number of Kasit.

31
00:02:21,000 --> 00:02:27,640
So here, I would say on the basis of this total cases, I have to assign this color bar as well.

32
00:02:28,020 --> 00:02:31,950
So let's say I'm going to say this is exactly my figure.

33
00:02:32,250 --> 00:02:40,290
And if you have to assign some title, you guys can simply say fig dot of date on this score.

34
00:02:40,770 --> 00:02:44,840
It means I'm just going to update my by default layout over here.

35
00:02:45,120 --> 00:02:50,730
So the very first parameter, I have to say, I'm also going to modify my template like my top at this

36
00:02:50,730 --> 00:02:55,010
time is exactly my floridly on score dark.

37
00:02:55,620 --> 00:02:57,510
And I forget what I have to say.

38
00:02:57,510 --> 00:02:59,130
I have to assign some title as well.

39
00:02:59,130 --> 00:03:05,880
So here I'm going to say, let's say a title and a score text is nothing, but let's say top 20 countries

40
00:03:05,880 --> 00:03:07,950
of total confirmed cases.

41
00:03:07,950 --> 00:03:11,490
Whatever title you want to assign, it's all up to you.

42
00:03:11,760 --> 00:03:23,190
So what I would say top 20 countries of total confirmed cases, I'm going to say total confirmed cases.

43
00:03:23,310 --> 00:03:26,790
And this is exactly my title after it.

44
00:03:26,790 --> 00:03:32,850
What I have to do, I have to just call show on my finger, which is exactly the object of Barcott.

45
00:03:32,850 --> 00:03:34,490
So just execute this.

46
00:03:34,500 --> 00:03:38,780
But before executing, let me assign some parameter, which is exactly monocular.

47
00:03:38,790 --> 00:03:44,910
It means on the basis of what feature I have to assign this color bar on the basis of this country reason.

48
00:03:44,930 --> 00:03:51,720
So here in this color bar, let's say I have to assign color to the bar on a basis of this total cases

49
00:03:51,720 --> 00:03:56,340
where I'm going to say in this color, I have all these stuff.

50
00:03:56,490 --> 00:04:03,480
And this text exactly means whenever you are going to go on your bar, so whatever data that will get

51
00:04:03,480 --> 00:04:05,520
displayed is exactly your text.

52
00:04:05,790 --> 00:04:13,110
So if you are going to execute this, you will get this amazing bar chart would look at it how user-friendly

53
00:04:13,110 --> 00:04:13,530
it is.

54
00:04:13,830 --> 00:04:16,390
You can definitely download it as well.

55
00:04:16,410 --> 00:04:18,270
Let's say here you have a multiple feature.

56
00:04:18,270 --> 00:04:24,510
So let's say you have to zoom in, you have to zoom out, you have to select some particular boundary,

57
00:04:24,510 --> 00:04:25,840
whatever you want here.

58
00:04:25,840 --> 00:04:28,980
Do you have all the stuffs available here and here?

59
00:04:28,980 --> 00:04:35,880
You can conclude here this USA, Brazil, India, the top three countries having the highest number

60
00:04:35,880 --> 00:04:43,590
of confirmed cases for as of today, we have Russia, Africa, Mexico, Pelote and Colombia, lots of

61
00:04:43,590 --> 00:04:44,680
other countries as well.

62
00:04:45,060 --> 00:04:52,410
Similarly, the next statement, we have to analyze the top 20 countries having max total that.

63
00:04:52,410 --> 00:04:57,210
So I'm just going to copy all these stuffs and just going to paste.

64
00:04:57,210 --> 00:04:59,940
Just I have to do some modifications over here.

65
00:05:00,420 --> 00:05:07,170
This time, I have to say here, my all these stuffs are OK, but in the place of this data frame,

66
00:05:07,380 --> 00:05:08,810
I need something else.

67
00:05:09,000 --> 00:05:17,700
So let's say I'm going to say a word on this called data dot short underscore values, which is exactly

68
00:05:17,700 --> 00:05:18,220
this one.

69
00:05:18,420 --> 00:05:21,780
And here I have to say on what basis I have to short it.

70
00:05:22,020 --> 00:05:27,230
So I have to short it on the basically on the basis of this total debt.

71
00:05:27,240 --> 00:05:31,040
And after it, I have to assign a parameter, which is exactly my standing.

72
00:05:31,290 --> 00:05:34,920
So here I'm going to say ascending equals to false.

73
00:05:34,920 --> 00:05:41,280
And if I'm going to execute it, you will get all your amazing is taxed over here and you will see this

74
00:05:41,280 --> 00:05:42,020
total.

75
00:05:42,020 --> 00:05:48,160
Is that right now in sorted order, it means you need this data frame to visualize.

76
00:05:48,420 --> 00:05:53,970
So here I'm going to say I'm just going to copy all these stats over here.

77
00:05:54,300 --> 00:05:57,990
And the very first one I have to just paste over here.

78
00:05:58,290 --> 00:06:01,640
And on y axis, I just need country citizen.

79
00:06:02,070 --> 00:06:12,060
And on X axis, I definitely need something else which is exactly total that total deaths, which is

80
00:06:12,060 --> 00:06:19,240
exactly this one, because I have to say, I have to assign discolor on the basis of this total debt,

81
00:06:19,260 --> 00:06:21,820
whereas on X axis I also need the steps.

82
00:06:22,110 --> 00:06:28,620
So here I am going to say on X axis, I have just this total that's after it.

83
00:06:28,680 --> 00:06:34,290
This text is also my total debt.

84
00:06:34,560 --> 00:06:41,730
And after having all these tests, what I'm going to do, I have to some modification in this title

85
00:06:41,760 --> 00:06:42,470
text as well.

86
00:06:42,810 --> 00:06:46,190
So I'm going to say this is nothing but my daughter.

87
00:06:46,290 --> 00:06:47,180
That's it.

88
00:06:47,190 --> 00:06:47,790
That's it.

89
00:06:47,790 --> 00:06:53,160
Just execute it and you will get some amazing bosshard over here.

90
00:06:53,250 --> 00:06:55,550
So you will see this is right, very complex.

91
00:06:55,560 --> 00:06:58,470
So definitely you need some top 20 countries.

92
00:06:58,470 --> 00:07:02,840
It means here you guys can say I just need top 20 countries.

93
00:07:03,060 --> 00:07:07,890
So here you can see from zero to top 20.

94
00:07:07,890 --> 00:07:15,540
Here you have to assign this one and twenty over here say just execute and it will take a while and

95
00:07:15,540 --> 00:07:18,350
it will give us this amazing result over here.

96
00:07:18,570 --> 00:07:23,630
And if you see or hear here, you have a text assigned to each of the bodies as well.

97
00:07:23,940 --> 00:07:25,400
And with respect to us.

98
00:07:25,400 --> 00:07:32,340
So you will see how much bigger this body is, because definitely in us we have a highest number of

99
00:07:32,340 --> 00:07:32,640
deaths.

100
00:07:32,640 --> 00:07:39,450
We all know this after we have Brazil, then we have Mexico, then we have UK and operate on this number.

101
00:07:39,450 --> 00:07:45,930
We have India because India has not that much number of deaths comparatively to the all other countries

102
00:07:45,930 --> 00:07:46,500
of the world.

103
00:07:46,680 --> 00:07:53,100
After what we have to do, we have to analyse a third problem, a statement in which we have to find

104
00:07:53,320 --> 00:07:58,140
was 20 countries having maximum active cases.

105
00:07:58,140 --> 00:08:03,030
It means this time what I have to do, I have to short this data.

106
00:08:03,240 --> 00:08:10,380
I have to short this data on the basis of active cases, because in this statement I had to analyse

107
00:08:10,680 --> 00:08:12,870
having a maximum number of active cases.

108
00:08:12,870 --> 00:08:21,450
It means here I have to just say, let me say a word on this call data columns over here to cross-check

109
00:08:21,450 --> 00:08:22,920
what exactly the column name.

110
00:08:23,280 --> 00:08:28,240
So here my column name is this one, which is exactly my active cases.

111
00:08:28,240 --> 00:08:33,060
So here I have to just do some modification as active cases.

112
00:08:33,300 --> 00:08:38,820
After eight on X-axis, I just need these active cases.

113
00:08:39,240 --> 00:08:44,700
Then I have to assign color to the bar on the basis of these active cases.

114
00:08:45,060 --> 00:08:49,080
Then definitely I have to show my active cases as well on my bar.

115
00:08:49,530 --> 00:08:50,250
That's it.

116
00:08:50,250 --> 00:08:54,020
And definitely you have to update your title as well.

117
00:08:54,420 --> 00:09:03,290
So I have to say top 20 countries of active cases and all aristos are okay now.

118
00:09:03,300 --> 00:09:09,930
And if I'm going to execute this one now, you will get this amazing start over here with respect to

119
00:09:09,930 --> 00:09:11,530
your active number of cases.

120
00:09:11,630 --> 00:09:15,480
Still us, it has maximum number of active cases.

121
00:09:15,840 --> 00:09:21,480
So let's go ahead with our next following statement in which we have to analyze what are my first 20

122
00:09:21,480 --> 00:09:24,150
countries having a maximum number of legal cases.

123
00:09:24,510 --> 00:09:28,250
It means you have to just short listed on the basis of record cases.

124
00:09:28,290 --> 00:09:35,640
That said, or if you want to do this task in a much more smarter way, then I will suggest to just

125
00:09:35,640 --> 00:09:42,450
go ahead and create a function of that and just call this number of different features as a parameter

126
00:09:42,450 --> 00:09:48,840
and just gather with that what we have done in the very first session using this one, we have just

127
00:09:48,840 --> 00:09:54,520
created a function and just call this function passing different different files and we get our duffing

128
00:09:54,870 --> 00:09:55,800
in a similar way.

129
00:09:55,800 --> 00:09:57,180
You can perform this tax.

130
00:09:57,450 --> 00:09:59,870
So definitely this is your assignment.

131
00:09:59,980 --> 00:10:06,250
And that you have to do because you have to apply a lot of efforts over here to do your analysis in

132
00:10:06,250 --> 00:10:10,660
a much more better way by writing some good quality, of course.

133
00:10:10,990 --> 00:10:16,930
So here I am going to say I have to share this data basically on the basis of this record.

134
00:10:17,830 --> 00:10:23,470
So here I have a column, which is exactly my total recovered.

135
00:10:23,620 --> 00:10:30,490
So I'm going to say I have two very first shot to my data frame on the basis of this total recovered

136
00:10:30,820 --> 00:10:36,130
after I'm going to say on X-axis, I just need this column.

137
00:10:36,370 --> 00:10:42,150
And definitely on the basis of these recovered cases, I have to assign my color.

138
00:10:42,160 --> 00:10:45,300
Then I have to assign this record cases and text as well.

139
00:10:45,310 --> 00:10:45,780
That's it.

140
00:10:46,300 --> 00:10:51,090
After doing all this stuff, I have to manipulate my title as well.

141
00:10:51,400 --> 00:11:01,660
So I'm going to say top 20 countries in terms of recovery cases or you can say total recovered cases

142
00:11:01,660 --> 00:11:03,280
or you can say cases.

143
00:11:03,460 --> 00:11:05,770
So just execute this over here.

144
00:11:05,770 --> 00:11:12,130
And this is an amazing result that you will see us has the highest number of recovery cases.

145
00:11:12,400 --> 00:11:15,080
After we have Brazil, we have India.

146
00:11:15,370 --> 00:11:19,830
So from these four results, you can definitely come up with some conclusion.

147
00:11:19,840 --> 00:11:27,010
Yeah, almost in each and every visa we have something like hierarchy that very first we have Usted

148
00:11:27,010 --> 00:11:30,870
and we have Brazil and then we have India, then probably we have Russia.

149
00:11:31,030 --> 00:11:36,610
So this is exactly a trend for each of the features, what we have analyzed over here.

150
00:11:36,880 --> 00:11:42,940
So you can showcase that conclusion in your report, in your PowerPoint, and you can represent it to

151
00:11:42,970 --> 00:11:45,920
stakeholder, to your client, whatever you want.

152
00:11:45,940 --> 00:11:47,710
So that's all about the session.

153
00:11:47,720 --> 00:11:49,630
I hope you love this session very much.

154
00:11:49,960 --> 00:11:50,630
Thank you.

155
00:11:50,650 --> 00:11:51,560
Have a nice day.

156
00:11:51,730 --> 00:11:52,500
Keep learning.

157
00:11:52,510 --> 00:11:53,260
Keep growing.

158
00:11:53,260 --> 00:11:54,130
Keep practicing.