1
00:00:00,180 --> 00:00:05,490
Halaal, in the previous session, what we have done, we have performed lots of little preparation

2
00:00:05,490 --> 00:00:12,900
on our data and we have basically defined this very amazing function and using this function, we had

3
00:00:12,900 --> 00:00:18,450
just read our data by just writing a single block of code over here in this session.

4
00:00:18,450 --> 00:00:21,350
What we have to do, we have to analyze the data.

5
00:00:21,660 --> 00:00:30,090
So the very first problem statement is exactly which country has maximum total cases, total debts,

6
00:00:30,510 --> 00:00:33,940
total recovered cases and total active cases.

7
00:00:33,950 --> 00:00:38,830
So this is exactly the very first analysis that you have to deal with that.

8
00:00:39,180 --> 00:00:47,160
So let's see what I'm going to do over here very first and just going to check how exactly my data looks

9
00:00:47,160 --> 00:00:47,390
like.

10
00:00:47,410 --> 00:00:53,430
So for this, I'm just going to call ahead and you will see this is exactly a data set on which you

11
00:00:53,430 --> 00:00:55,160
have to do this analysis.

12
00:00:55,740 --> 00:00:57,180
So you will figure it out over here.

13
00:00:57,210 --> 00:00:59,480
Here you have multiple features over here.

14
00:00:59,700 --> 00:01:03,450
This total case is this total debt and all these features.

15
00:01:03,780 --> 00:01:08,670
But you need some certain features so that you can go ahead with your analysis.

16
00:01:08,670 --> 00:01:13,410
So aive on this word, underscore data, data frame.

17
00:01:13,410 --> 00:01:18,360
I just want to call these columns or you will get all the column names over here.

18
00:01:18,750 --> 00:01:27,000
So that column data exactly need for my analysis on nothing but which are exactly the total cases.

19
00:01:27,010 --> 00:01:33,540
So I'm just going to copy from here and Lexan would define a list over here, let's say list his column.

20
00:01:33,540 --> 00:01:37,970
The very first is exactly my total cases after eight.

21
00:01:37,980 --> 00:01:42,300
I just need this total debt, so I just need this one.

22
00:01:42,660 --> 00:01:47,320
After that, I need basically this total recovery, this one.

23
00:01:47,670 --> 00:01:52,290
So either you can do this manually or you can copy paste.

24
00:01:52,290 --> 00:01:54,300
It's it's nothing fancy.

25
00:01:54,300 --> 00:02:00,930
After what I have to do, I have to say I just need this active cases, which is exactly this one.

26
00:02:00,930 --> 00:02:05,110
So I'm just going to say these are exactly my active cases.

27
00:02:05,130 --> 00:02:09,420
Now, what I have to do, I can I trade on each and every feature.

28
00:02:09,420 --> 00:02:17,790
So for this, I'm going to say for I n this list, which is exactly my columns list now on each and

29
00:02:17,790 --> 00:02:21,540
every feature you have to do certain kind of.

30
00:02:22,260 --> 00:02:24,930
Now it's all up to you what kind of resolution you want.

31
00:02:25,260 --> 00:02:32,510
Let's say for here you can definitely go ahead with your three map, your pie chart, your bar plot.

32
00:02:32,520 --> 00:02:33,450
It's all up to you.

33
00:02:33,780 --> 00:02:36,900
So let's say here I'm going to use my map.

34
00:02:37,050 --> 00:02:44,070
So if you're not that much of it about what exactly is a tree map visual that just like a tree like

35
00:02:44,490 --> 00:02:52,770
structure and wherever, if a particular block has a bigger size, it means that particular block has

36
00:02:52,770 --> 00:02:53,660
a higher account.

37
00:02:53,910 --> 00:02:59,970
So for this this tree map, we have this tree map inside of our block leaves the very first I have to

38
00:02:59,970 --> 00:03:08,220
import my part, which I'm going to say import this plot, DOT Xpress, and I'm going to create its

39
00:03:08,220 --> 00:03:09,630
allies as Peerce.

40
00:03:09,900 --> 00:03:15,150
And now using this, I have my function, which is exactly my map.

41
00:03:15,390 --> 00:03:21,540
And if I'm going to pass shift BASTABLE, you will get all the custom barometer's that you can play

42
00:03:21,540 --> 00:03:21,960
with that.

43
00:03:21,960 --> 00:03:26,700
If you really want your tree map a little bit, user-friendly, that's all up to you.

44
00:03:26,970 --> 00:03:30,890
And after what I have to do, we have to set some custom parameters over here.

45
00:03:31,170 --> 00:03:37,830
Let's say I just need 20 countries that get was effected by this coronavirus.

46
00:03:38,100 --> 00:03:45,060
So it means I just need these top 20 rules from this data frame for this what I'm going through.

47
00:03:45,060 --> 00:03:51,360
I'm just going to say what Alesco data dot I know, which is exactly my index location.

48
00:03:51,630 --> 00:03:56,400
And in this index location, I'm going to say I just need my first twenty two.

49
00:03:56,460 --> 00:03:57,030
That's it.

50
00:03:57,450 --> 00:04:01,260
After what I have to do, I have some parameters as well if you will.

51
00:04:01,290 --> 00:04:05,190
Best shiftless tab, you will get a parameter which is exactly your values.

52
00:04:05,520 --> 00:04:09,300
So this is exactly the parameter that you have to take care of it.

53
00:04:09,510 --> 00:04:16,950
So values is equal to because on each and every feature on the basis of this value, your block size

54
00:04:16,950 --> 00:04:17,920
will be assigned.

55
00:04:18,210 --> 00:04:23,210
So after it, what I'm going to do in this spot that you have to reflect on your block.

56
00:04:23,610 --> 00:04:31,590
So in this part you have to mention a column name, which is exactly this country slash region.

57
00:04:31,590 --> 00:04:36,300
So here I am going to say this is exactly my path of doing all this stuff.

58
00:04:36,450 --> 00:04:39,840
Here you have certain parameters still here.

59
00:04:39,840 --> 00:04:44,790
You have templates or data, multiple parameters over here.

60
00:04:45,220 --> 00:04:47,700
Let's say I have to assign some titles as well.

61
00:04:48,060 --> 00:04:56,550
So my title is nothing, but let's say my title is three map representation, three map representation

62
00:04:56,790 --> 00:04:59,810
of different countries.

63
00:05:00,810 --> 00:05:08,790
With respect to their future, so I'm going to say with respect to there and here, I'm going to add

64
00:05:08,790 --> 00:05:16,110
a placeholder and this placeholder, I'm going to set its value by using my formal function.

65
00:05:16,410 --> 00:05:24,450
So here I am going to say DOT format of AI and whatever placeholder over here, it will receive this

66
00:05:24,450 --> 00:05:27,330
value from this format, from this I.

67
00:05:27,630 --> 00:05:30,990
So this is what my placeholder will do over here.

68
00:05:31,410 --> 00:05:33,360
So this is exactly my code.

69
00:05:33,360 --> 00:05:38,850
And still, if you have to do some modifications, you can install it in some good.

70
00:05:38,850 --> 00:05:46,050
And after what you guys can do, you guys can call simply dot show over here.

71
00:05:46,140 --> 00:05:53,040
And if I'm going to execute this well now, you will get this amazing tree map, the very first one

72
00:05:53,040 --> 00:05:54,600
with respect to total cases.

73
00:05:54,600 --> 00:06:00,080
And you can simply visualize over here, you see has a bigger block after it.

74
00:06:00,090 --> 00:06:02,070
We have a block after it.

75
00:06:02,070 --> 00:06:03,120
We have an entire block.

76
00:06:03,450 --> 00:06:12,000
It means these are the three top notch countries with respect to my higher number of total cases, because

77
00:06:12,000 --> 00:06:18,410
what I have told you with respect to tree map, because the block will be higher, the council, it

78
00:06:18,420 --> 00:06:20,610
meets us, it has a higher number of count.

79
00:06:20,700 --> 00:06:22,380
It has a highest priority.

80
00:06:22,650 --> 00:06:29,710
And what tree map will do, Trimark will basically assign some kind of hierarchy, some kind of priority.

81
00:06:29,790 --> 00:06:35,740
That's what my team will do in a similar way if I'm going to scroll with respect to total that.

82
00:06:35,880 --> 00:06:39,540
So this is exactly tree map with respect to total debt.

83
00:06:39,660 --> 00:06:43,530
And you will see what hear you say is still opinion over here.

84
00:06:43,560 --> 00:06:50,180
And with respect to your total record, is still USA and Brazil and India again over here.

85
00:06:50,520 --> 00:06:55,770
But with respect to active number of cases, the very first is exactly.

86
00:06:55,770 --> 00:06:59,370
You can see almost 50 percent of total number of cases.

87
00:06:59,370 --> 00:07:04,950
If you are going to hover your mouse over here, you can simply visualize how much active number of

88
00:07:04,950 --> 00:07:07,530
cases with respect to you as you have.

89
00:07:07,950 --> 00:07:13,830
Whereas with respect to Brazil, you have that much number of cases with respect to India, which is

90
00:07:13,830 --> 00:07:18,770
right now the third country, which has the highest number of active number of cases.

91
00:07:18,780 --> 00:07:20,140
So that's basically it.

92
00:07:20,140 --> 00:07:23,000
And France, your conclusion from your visa.

93
00:07:23,430 --> 00:07:32,970
So let's go ahead with our next statement, which is exactly what is the trend of confirmed that and

94
00:07:32,970 --> 00:07:36,060
recovered as well as your active cases.

95
00:07:36,270 --> 00:07:40,680
So whenever someone is asking what is the trend going in your data?

96
00:07:40,680 --> 00:07:47,040
Or you can say, Alexian, time to this data, what is a trend ongoing over here in a stock market anywhere

97
00:07:47,040 --> 00:07:47,330
else?

98
00:07:47,670 --> 00:07:50,520
So then someone will ask you, what is a trend?

99
00:07:50,530 --> 00:07:55,260
It means you can definitely go ahead with your plot over here.

100
00:07:55,500 --> 00:07:58,500
So it means you have to considered line item here.

101
00:07:58,830 --> 00:08:02,550
So far, this what we guys can do, we guys can use properly.

102
00:08:02,550 --> 00:08:04,950
And here we have a function which is exactly line.

103
00:08:05,370 --> 00:08:11,640
So price shift postop to get the documentation and all the custom parameters, the data frame and all

104
00:08:11,640 --> 00:08:12,240
these things.

105
00:08:12,570 --> 00:08:18,450
So my data frame is nothing but my device, which is exactly this one.

106
00:08:18,720 --> 00:08:24,900
And if I'm going to call, let's say DNS conveys DOT had over here to get a preview.

107
00:08:25,170 --> 00:08:28,140
You will see these are all the columns over here.

108
00:08:28,140 --> 00:08:29,940
These are all my column names.

109
00:08:30,180 --> 00:08:36,570
So on X axis, I definitely need this state because with this back to date, I have to plot all these

110
00:08:36,570 --> 00:08:36,960
things.

111
00:08:37,260 --> 00:08:45,270
So I'm going to say on X axis, I just need this date and after it on Y axis, I need this.

112
00:08:45,270 --> 00:08:47,820
Confirmed that and Rickover.

113
00:08:48,150 --> 00:08:53,910
So let's say I'm going to say the underscore y dot columns over here.

114
00:08:54,180 --> 00:09:02,520
And these are all those stats that I exactly need to plot on my landlord.

115
00:09:02,700 --> 00:09:06,630
So I'm going to say I have to define all these stuffs in my list.

116
00:09:06,960 --> 00:09:07,560
That's it.

117
00:09:07,830 --> 00:09:10,800
And after that you have to assign some titles.

118
00:09:10,800 --> 00:09:18,810
You guys can definitely say here I'm going to say my title is nothing, but let's say my title is COGAT

119
00:09:18,810 --> 00:09:20,430
Cases with respect to date.

120
00:09:20,790 --> 00:09:29,880
So here I'm going to say covid cases with respect to date, this is exactly my title.

121
00:09:30,120 --> 00:09:37,950
And if you are going to pass shiftless tab over here, you guys will get all the defined custom parameters

122
00:09:37,950 --> 00:09:38,490
over here.

123
00:09:38,670 --> 00:09:41,670
How do you have a barometer, which is exactly your template?

124
00:09:42,060 --> 00:09:43,770
So let's say ahead of time it is not.

125
00:09:43,770 --> 00:09:47,610
Let's say I have to assign some my own custom templates for this.

126
00:09:47,610 --> 00:09:51,770
I'm going to say my template, which is exactly this one.

127
00:09:51,780 --> 00:09:55,120
Let's say I just need some user friendly template.

128
00:09:55,120 --> 00:09:59,790
So for this week, I can pass my block only underscore.

129
00:09:59,990 --> 00:10:00,980
Dark over there.

130
00:10:01,190 --> 00:10:01,860
That's it.

131
00:10:01,880 --> 00:10:07,970
And if I'm going to execute it, it will definitely return this amazing visual over here.

132
00:10:07,970 --> 00:10:14,810
And you can definitely conclude from this visual, this is exactly what exponential trend with respect

133
00:10:14,810 --> 00:10:21,710
to your confirmed number of cases, whereas with respect to this record number of cases, it is not

134
00:10:21,710 --> 00:10:28,850
that much explanation and with respect to this number of deaths, so it is almost in a linear fashion.

135
00:10:28,850 --> 00:10:37,220
Whereas with respect to this active so you will see this has that much fashion which somehow moves in

136
00:10:37,220 --> 00:10:38,240
up to some extent.

137
00:10:38,240 --> 00:10:43,070
You can see it is somehow very approx to your zigzag fashion.

138
00:10:43,280 --> 00:10:46,640
So that's all about this session of the session very much.

139
00:10:46,910 --> 00:10:47,550
Thank you.

140
00:10:47,600 --> 00:10:48,510
Have a nice day.

141
00:10:48,680 --> 00:10:49,510
Keep learning.

142
00:10:49,520 --> 00:10:50,360
Keep growing.

143
00:10:50,600 --> 00:10:51,410
Keep practicing.