1
00:00:06,390 --> 00:00:07,890
Hi, welcome back.

2
00:00:08,010 --> 00:00:17,400
And this lecture, we will learn new things using Banda's python module to analyze data frame that we

3
00:00:17,400 --> 00:00:19,410
created in the last section.

4
00:00:19,680 --> 00:00:24,330
Data frame is as spreadsheet as you see in the law section.

5
00:00:24,780 --> 00:00:34,500
When we try to open and read the airline's data, both see as we file it, return it as data, frame

6
00:00:34,890 --> 00:00:42,990
the first binders comment we will use in this lecture as the F dot columns as the following.

7
00:00:50,330 --> 00:01:00,590
So we will tie the DOT columns and run the sun, it returns the names of the columns in the data frame

8
00:01:00,810 --> 00:01:04,140
if we want to get the values of one column.

9
00:01:04,550 --> 00:01:08,120
So we will use the name of the column as the volume.

10
00:01:08,300 --> 00:01:18,290
For example, we will use passenger name in our next example, G.F., Dot Messenger and the school name

11
00:01:18,680 --> 00:01:22,640
and run the cell by using Scheft and enter to run the cell.

12
00:01:22,640 --> 00:01:31,220
And we get the first five values or the first five rows of the passenger name column.

13
00:01:31,380 --> 00:01:39,620
If we want to grant all the data and the data frame, we will type D.F. It will print all the data in

14
00:01:39,620 --> 00:01:46,250
the data frame and the following, as you see, it brings all the data in the data frame and all the

15
00:01:46,250 --> 00:01:48,740
columns we have now.

16
00:01:48,740 --> 00:01:54,770
We want to get many columns, but not all the columns from our data frame.

17
00:01:55,070 --> 00:01:57,830
So our good will be at the following.

18
00:01:58,100 --> 00:02:07,220
The F one equals the F between two square brackets and inside the two square brackets, passenger name

19
00:02:07,220 --> 00:02:14,600
column, the column and the right column, each column between two parentheses and separated by commas

20
00:02:14,780 --> 00:02:16,040
and run the cell.

21
00:02:16,040 --> 00:02:26,300
It will return all the data from the three specified columns so we can return many columns without returning

22
00:02:26,300 --> 00:02:32,110
all the column by using the comment, by using the last data frame comment.

23
00:02:32,180 --> 00:02:41,330
Now we want to return the last five rows of our data frame and the following using the F dot tail or

24
00:02:41,330 --> 00:02:50,090
the tail method to return the last five rows and we can specify numbers of last rows we want to return.

25
00:02:50,210 --> 00:02:57,620
And between the two brackets of the tail method, we can also display specific role in our data frame

26
00:02:57,620 --> 00:03:03,190
by using Eilert method as the following display between two brackets the f dot.

27
00:03:03,230 --> 00:03:09,080
I log into square brackets the position of the row that we want to return as the following.

28
00:03:09,080 --> 00:03:11,480
We choose the tickets through.

29
00:03:11,600 --> 00:03:17,560
So after run cell, it returns the value of the second row and our data frame.

30
00:03:17,570 --> 00:03:22,130
If we want to know the rank of every row in our data frame.

31
00:03:22,140 --> 00:03:26,180
So we will use dot rank method as the following.

32
00:03:26,210 --> 00:03:28,340
So they have that rank.

33
00:03:29,320 --> 00:03:35,630
And runs the cell at Returnee's, the rank for every role in our data frame.

34
00:03:35,650 --> 00:03:44,350
And if we want to retain all the information about our data frame, we will tie D.F. Dot info and run

35
00:03:44,830 --> 00:03:45,430
the cell.

36
00:03:45,850 --> 00:03:49,860
It will return all the information about our data frame.

37
00:03:50,320 --> 00:03:59,590
Now we will use Biton Web browser module as the following to run to run the Banda's data frame website

38
00:03:59,590 --> 00:04:00,710
as the following.

39
00:04:01,000 --> 00:04:05,440
So import web browser and run the cell.

40
00:04:05,740 --> 00:04:14,060
Then in the next cell declared the website that we want to open to a variable called website.

41
00:04:14,170 --> 00:04:22,990
So website equal between two entities, entity B as a column, then slash Spender's dot org.

42
00:04:22,990 --> 00:04:24,910
Slash Banda's dot docs.

43
00:04:24,910 --> 00:04:35,110
Slash slash reference, slash api, slash Vandersloot data frame dot com and then end new line web browser

44
00:04:35,110 --> 00:04:38,980
dot orbin between two brackets website variable.

45
00:04:40,590 --> 00:04:48,720
So in the website of that Afrim Banda's, all the muscles and function can be used and you can learn

46
00:04:48,720 --> 00:04:49,350
about it.

47
00:04:49,710 --> 00:04:50,640
That's that a frame.

48
00:04:50,790 --> 00:05:00,840
Please don't skip this process and keep learning and check all these functions to learn more about bandas

49
00:05:00,840 --> 00:05:01,530
that a frame.

50
00:05:01,680 --> 00:05:05,540
At this point, we reach the end of this lecture hall.

51
00:05:05,550 --> 00:05:08,620
We enjoyed this lecture and get all of that.

52
00:05:09,150 --> 00:05:10,760
Thanks for being here.

53
00:05:12,250 --> 00:05:13,450
Thanks for watching.

54
00:05:13,570 --> 00:05:15,390
See you next week, you.