1
00:00:00,012 --> 00:00:04,949
And let's go ahead and load the xls file,

2
00:00:05,100 --> 00:00:08,295
xlsx actually, an Excel file.

3
00:00:08,319 --> 00:00:12,148
[No audio]

4
00:00:12,188 --> 00:00:14,536
So pandas.read_excel and

5
00:00:14,561 --> 00:00:18,791
[Author typing]

6
00:00:18,816 --> 00:00:20,010
you pass the name of the

7
00:00:20,010 --> 00:00:22,320
Excel file, and normally, you should also

8
00:00:22,320 --> 00:00:24,510
pass another parameter here for Excel

9
00:00:24,510 --> 00:00:26,760
files, because you know Excel files

10
00:00:26,760 --> 00:00:29,520
might have multiple sheets inside

11
00:00:29,520 --> 00:00:32,910
them. So you want to specify the sheet

12
00:00:32,910 --> 00:00:35,430
name, which start from zero, so you need

13
00:00:35,430 --> 00:00:38,040
to pass the index actually. If you want

14
00:00:38,040 --> 00:00:41,160
the first sheet, you want to pass 0,

15
00:00:41,160 --> 00:00:43,050
if you want second sheet, you want to

16
00:00:43,050 --> 00:00:45,600
pass 1, and so on. So I'll pass 0

17
00:00:45,600 --> 00:00:47,370
there. I had one other raw sheet in the

18
00:00:47,370 --> 00:00:53,940
Excel file. df3, execute. I am, we

19
00:00:53,940 --> 00:00:56,190
were able to successfully read the Excel

20
00:00:56,190 --> 00:00:58,333
file as well. So let's move on.