1
00:00:05,640 --> 00:00:07,910
Hey everyone welcome to this video.

2
00:00:07,920 --> 00:00:14,280
In this video we are going to learn about a legal concept that is known as cities gently before learning

3
00:00:14,280 --> 00:00:15,020
anything.

4
00:00:15,040 --> 00:00:21,930
I'm going to play you that band that is not something like any hard thing or any library that is very

5
00:00:21,930 --> 00:00:28,980
hard to learn and that's functioning is very hard and complex bondage something a tool that makes us

6
00:00:28,980 --> 00:00:33,190
to show the data like this table.

7
00:00:33,660 --> 00:00:40,320
You have seen data in so many forms and pundits is just generally used to make the data look like these

8
00:00:40,320 --> 00:00:44,180
forms so that we can easily look at these things.

9
00:00:44,190 --> 00:00:45,960
This is like the Excel files.

10
00:00:46,110 --> 00:00:50,240
And here you can see the growth things of movies worldwide do things.

11
00:00:50,250 --> 00:00:55,860
So here you see the names the dollars they earn the E delivery list.

12
00:00:55,950 --> 00:01:02,620
This is how we also use these funds to make the data in tablet form.

13
00:01:03,220 --> 00:01:04,920
And that is the only thing.

14
00:01:05,110 --> 00:01:11,200
And for doing the data in these tabling things like these tables we have two things.

15
00:01:11,260 --> 00:01:12,870
One is known as this series.

16
00:01:12,910 --> 00:01:15,020
Second is known as the data frames.

17
00:01:15,190 --> 00:01:17,100
This thing is known as the data.

18
00:01:17,200 --> 00:01:22,420
That how you are going to represent the data and just they are in form of proper tables.

19
00:01:22,420 --> 00:01:25,740
This is just missing one like this one here.

20
00:01:25,750 --> 00:01:32,380
This is the frame in which you have rows and columns and series is also something similar to that one

21
00:01:32,680 --> 00:01:34,090
but less used.

22
00:01:34,540 --> 00:01:35,920
And that we are going to cover here.

23
00:01:35,920 --> 00:01:40,840
You will get to know that what the series is and what the data frames are in the next video.

24
00:01:41,290 --> 00:01:45,150
So let's begin jumping on Jupiter notebooks.

25
00:01:45,240 --> 00:01:53,960
So here launched the Jupiter notebooks also to install the pandas on your computer here.

26
00:01:55,610 --> 00:02:04,910
In terminal you just need to write beep install bond us

27
00:02:07,850 --> 00:02:13,530
and here this one I feel the one there.

28
00:02:14,270 --> 00:02:17,070
And then it got installed in your computer.

29
00:02:17,660 --> 00:02:25,590
And if you have Anaconda then it's already installed and you can also use the command Condor install.

30
00:02:25,640 --> 00:02:31,840
Does it seem more efficient for this Anaconda.

31
00:02:33,920 --> 00:02:37,010
Now after it got installed and even before it got here.

32
00:02:37,010 --> 00:02:45,610
Don't go to the Jupiter notebooks and that installation in the terminal is for when you're using some

33
00:02:45,750 --> 00:02:48,190
next top editor like the atom as atom.

34
00:02:48,490 --> 00:02:50,220
Or just a command prompt.

35
00:02:50,350 --> 00:02:55,580
Here I am using Jupiter notebook so if you even did not install Dedmon by using these commands of their

36
00:02:55,580 --> 00:02:58,960
own determinant then still it will work.

37
00:02:59,020 --> 00:03:07,670
So here first let me import the name by so import name pi as MP.

38
00:03:08,140 --> 00:03:12,880
Then import bind us.

39
00:03:13,050 --> 00:03:14,290
So this is all you can import.

40
00:03:14,320 --> 00:03:20,040
The does just import Bond does as beauty.

41
00:03:20,250 --> 00:03:24,240
That is the form that is generally used for bond us.

42
00:03:24,300 --> 00:03:33,120
The nickname you can see now here I'm going to declare some data types that is first a list that is

43
00:03:33,120 --> 00:03:36,420
with the name L. of let we have X more common.

44
00:03:37,350 --> 00:03:53,040
And this one is going to be a character that is a b c b and c and then I'm going to have an in the list

45
00:03:53,100 --> 00:03:59,950
that is in form of numbers so same do that one.

46
00:04:00,260 --> 00:04:01,700
Then we have a dictionary

47
00:04:04,970 --> 00:04:16,280
and dictionary something like index will be a and not the index a just one is the index and the data

48
00:04:16,280 --> 00:04:34,200
will be a then similarly to natively B B then three data will be C then for later will be D.

49
00:04:35,030 --> 00:04:46,070
And 5 last and they don't because the value will be E and then shift into or shifted on Mac.

50
00:04:46,260 --> 00:04:50,090
Now here how we use depends.

51
00:04:50,100 --> 00:04:57,650
We just you use this spend us to create this series and series can be created just using Billy note

52
00:04:57,680 --> 00:05:00,490
series method and in series method.

53
00:05:00,570 --> 00:05:09,120
Make sure s is capitalized then dependencies and if you use shift tab here you will get the parameters

54
00:05:09,120 --> 00:05:13,270
that how many parameters are used there.

55
00:05:13,400 --> 00:05:16,960
Like this one it is.

56
00:05:17,490 --> 00:05:25,660
So here listen now you can see here there are a number of barometers here.

57
00:05:25,660 --> 00:05:30,900
That is the data index type name because this is a form of table vacancy.

58
00:05:31,170 --> 00:05:38,260
So a table not only just required the values it also required some indexes like many who have made tables

59
00:05:38,260 --> 00:05:44,860
on paper you also write something like serial number then name then marks age or whatever you need.

60
00:05:44,890 --> 00:05:47,950
That's all we also need indexing this one.

61
00:05:47,950 --> 00:05:52,820
Then we have data type also name copy of the face.

62
00:05:52,970 --> 00:05:59,670
But and we are just going to need these two now all these are not much of an input as there.

63
00:06:00,700 --> 00:06:09,220
So this is work something like if I want to make a series of x i just use exhale then I will assign

64
00:06:10,450 --> 00:06:22,480
this X the named data and that is if you haven't noticed there this data then should be redone or chipped

65
00:06:22,490 --> 00:06:23,260
into and Mac.

66
00:06:23,350 --> 00:06:29,170
You will see you get this table without any modal boundaries or partition.

67
00:06:29,170 --> 00:06:32,190
So that's why this is known as a series.

68
00:06:32,620 --> 00:06:36,400
If you assign this one to a variable like.

69
00:06:37,270 --> 00:06:39,810
And here a you will get this one.

70
00:06:39,820 --> 00:06:46,670
And if you check the type of a that is the type A you will get a series object.

71
00:06:46,750 --> 00:06:48,700
Here we have series.

72
00:06:49,360 --> 00:06:50,620
So that's the disease.

73
00:06:50,620 --> 00:06:59,050
And that's how you can create this if you use something like this one and make this one a then it will

74
00:06:59,140 --> 00:06:59,700
also work.

75
00:07:00,400 --> 00:07:02,500
But why the data use there.

76
00:07:02,500 --> 00:07:07,940
It just you can use to show the like someone who is going to check the program.

77
00:07:09,010 --> 00:07:11,010
And then there is one more thing here.

78
00:07:11,050 --> 00:07:17,080
Like we have X this thing and when I have done this here I get predefined indexes that is zero one two

79
00:07:17,080 --> 00:07:17,650
three four.

80
00:07:18,190 --> 00:07:22,980
But if you have noticed again in this one you have index options also.

81
00:07:23,170 --> 00:07:24,980
That is after the data.

82
00:07:25,090 --> 00:07:28,380
So one more thing here for one parameter.

83
00:07:28,390 --> 00:07:33,100
You can just write X because the parameter must be data first parameter because without it all you're

84
00:07:33,100 --> 00:07:33,900
going to do anything.

85
00:07:34,450 --> 00:07:41,590
So that's why you can normally write the X instead of data is equal to x but if you're using more than

86
00:07:41,590 --> 00:07:47,080
one parameters without any order then you have to use these things like if you are using index and the

87
00:07:47,080 --> 00:07:48,510
next will be Vi.

88
00:07:48,640 --> 00:07:52,130
So here this is how it will [REMOVED].

89
00:07:52,230 --> 00:07:53,440
One two three four five.

90
00:07:53,500 --> 00:07:54,820
That is the index by then.

91
00:07:55,300 --> 00:08:04,690
If you change this one like if I convert all these into one and then hey I have all this one.

92
00:08:06,070 --> 00:08:10,460
So let me change that again.

93
00:08:10,820 --> 00:08:12,260
There it is.

94
00:08:12,450 --> 00:08:20,650
Now if you are not using these things then there must be a thing that like if you do this thing now

95
00:08:20,830 --> 00:08:22,550
you will get the same result.

96
00:08:22,600 --> 00:08:25,330
Let me update this one also.

97
00:08:25,420 --> 00:08:33,670
Now let's look at the thing here is you have to use them in the order that is same here like First Data

98
00:08:33,790 --> 00:08:35,060
then index.

99
00:08:35,380 --> 00:08:43,480
Then you have to use the data type the name like this one if you use something improper like VI here

100
00:08:44,530 --> 00:08:50,000
and X there then you will get the opposite one day down the next an index will need data.

101
00:08:50,200 --> 00:08:58,780
So that's why these data and index are also given not just to someone country but positioning is much

102
00:08:58,780 --> 00:08:59,470
important.

103
00:08:59,590 --> 00:09:03,700
Instead of writing those and much more efficient you can just write.

104
00:09:03,880 --> 00:09:05,410
And this one is very easy.

105
00:09:05,410 --> 00:09:11,200
You can remember this thing that first day that second engine X and I know this one is opposite to the

106
00:09:11,200 --> 00:09:13,840
normal conditions like first we write the indexes.

107
00:09:13,840 --> 00:09:15,330
So there must be index first.

108
00:09:15,790 --> 00:09:20,920
But in here barometer first will be data because data is the first thing that we require in any table

109
00:09:21,250 --> 00:09:21,900
without data.

110
00:09:21,910 --> 00:09:23,440
There will be no table.

111
00:09:23,560 --> 00:09:31,600
So this is about declaring the cities by using the data types here and bind us.

112
00:09:31,780 --> 00:09:37,300
And if you want to convert a dictionary into series and you just write her dictionary then you will

113
00:09:37,300 --> 00:09:44,140
get already the index is in dictionary and the values in dictionary that mission more make you more

114
00:09:44,140 --> 00:09:45,100
clear about this one here.

115
00:09:45,100 --> 00:09:48,890
If I have nine and I do that thing here I got nine.

116
00:09:48,970 --> 00:09:55,660
So the indexes of dictionaries will be already get here instead of the default indexes default indexes

117
00:09:55,660 --> 00:10:02,500
will begin to begin from 0 1 to 3 like that one and I will use it define indexes will be like this one.

118
00:10:03,910 --> 00:10:06,590
So that's the series here.

119
00:10:06,610 --> 00:10:22,170
Now one more thing like if you have something like ABC and then x is equal X two is equal to copy all

120
00:10:22,190 --> 00:10:25,070
these.

121
00:10:25,210 --> 00:10:25,680
Come on.

122
00:10:25,670 --> 00:10:26,350
See.

123
00:10:26,350 --> 00:10:28,960
And come on be here now.

124
00:10:30,820 --> 00:10:40,680
If I have an endless series that is this one first bid and now I'm going to use ABC as in next and by

125
00:10:40,680 --> 00:10:46,920
yes value Miguel's operations can be done on values not on these things.

126
00:10:46,920 --> 00:10:49,310
They will be concatenated but numbers will be added.

127
00:10:49,510 --> 00:10:55,240
So here I have VI X and if I take this on I go display.

128
00:10:55,550 --> 00:11:04,900
Now another series that is B equal to copy this whole command C and command V here instead of this one

129
00:11:04,900 --> 00:11:06,310
just right x2.

130
00:11:06,760 --> 00:11:09,050
And if you check x to here.

131
00:11:09,360 --> 00:11:13,750
Read Ruby here you will get reason or define x2 is not defined here.

132
00:11:13,750 --> 00:11:15,930
This one is X I believe.

133
00:11:16,420 --> 00:11:19,500
I have not just run this cell.

134
00:11:19,510 --> 00:11:20,580
I have just moved there.

135
00:11:21,040 --> 00:11:27,100
So here you get this one and this one whenever you make a change you have also load this thing like

136
00:11:27,100 --> 00:11:30,240
shift returns so that this thing will be saved there.

137
00:11:30,310 --> 00:11:34,320
So here this one this one and here this is now.

138
00:11:34,660 --> 00:11:40,050
Here I have B and you have also seen it that is this one both same.

139
00:11:40,120 --> 00:11:48,940
If you do something like c is equal to a plus b or just generally like a plus b and you hit enter then

140
00:11:48,940 --> 00:11:58,210
you will get this thing that all the values with the same index like a BBC d e all will be added if

141
00:11:58,210 --> 00:12:03,190
you notice that 1 1 2 2 2 4 3 3 6 4 4 8 5 5 10.

142
00:12:03,730 --> 00:12:09,760
So is the automatic on cities negative values with the same indexes will be added.

143
00:12:09,760 --> 00:12:16,830
Others like if you have this one f then there will be no added.

144
00:12:16,870 --> 00:12:23,700
You just get this thing the values with the same indexes will be added others values will get men not

145
00:12:23,890 --> 00:12:32,770
stand for line and one more thing all the values while get patients on operations form of cities with

146
00:12:32,770 --> 00:12:38,350
genes in do floating point values I hope you get this thing that only same index will be added that

147
00:12:38,410 --> 00:12:47,290
will get none if all of these values will be something like this one I also said this one also G and

148
00:12:47,290 --> 00:12:50,630
this on Q You will get something like this where

149
00:12:53,540 --> 00:13:00,860
so that's what the automatic on C D is and you can do any type of operation

150
00:13:03,650 --> 00:13:15,470
so here you get again Dedmon so there about the values here and one more thing like if you want to access

151
00:13:15,470 --> 00:13:23,270
any value in this series and if you do something like a and then pass the index like this series I have

152
00:13:23,270 --> 00:13:32,990
c c there in this form then you will get the value so this is just like the last part of the index and

153
00:13:32,990 --> 00:13:38,630
you will get this one one more thing if you pass this one here you will get added because C is not a

154
00:13:38,630 --> 00:13:46,340
variable it is just an index and that index is also element of that list so you just need to pass this

155
00:13:46,340 --> 00:13:50,250
one with the court and he will get three.

156
00:13:50,840 --> 00:13:57,950
So there is the indexing is if you do something like this one for slicing you can also do just see index

157
00:13:58,040 --> 00:14:05,140
and then these dots that means that every value after C and after c v have three four and five.

158
00:14:05,140 --> 00:14:14,200
Here we have three four five and if you will pass here E then you will get again these values.

159
00:14:14,960 --> 00:14:16,120
So here it is.

160
00:14:16,250 --> 00:14:23,360
And if you have noticed there the last value is also included in these and if you do something like

161
00:14:23,390 --> 00:14:28,370
this one you get a complete list because that one is begin from zero.

162
00:14:28,730 --> 00:14:32,460
So here the slicing also.

163
00:14:32,520 --> 00:14:38,720
Now most of the concepts are now done about this series and I hope you get all these and this is very

164
00:14:38,720 --> 00:14:39,940
easy.

165
00:14:40,040 --> 00:14:45,590
So there is this series is but we are going to use them less in the course and even practically they

166
00:14:45,590 --> 00:14:51,050
are not used much the data points are more efficient than these things.

167
00:14:51,470 --> 00:14:54,950
So we will learn about the data frames in the next video.

168
00:14:55,310 --> 00:14:58,060
Thanks for watching and we will continue in the next video.