1
00:00:00,690 --> 00:00:12,300
And let's go ahead and load the XLS file XLSX actually, and an excel file.

2
00:00:12,300 --> 00:00:14,490
So pandas.read_excel and

3
00:00:18,970 --> 00:00:24,540
you pass a name of the excel file and normally you should also pass another parameter here for Excel

4
00:00:24,540 --> 00:00:30,210
files because you know Excel files might have multiple sheets inside them.

5
00:00:30,210 --> 00:00:34,860
So you want to specify the sheet name which start from zero.

6
00:00:34,890 --> 00:00:41,640
So you need to parse the index actually, if you want the first sheet you want to pass 0 if you want

7
00:00:41,640 --> 00:00:43,750
the second sheet you want the best one.

8
00:00:43,760 --> 00:00:44,400
And so on.

9
00:00:44,400 --> 00:00:46,040
So I'll pass zero there.

10
00:00:46,050 --> 00:00:52,280
I had one only one sheet in the Excel file, df3, execute.

11
00:00:52,730 --> 00:00:57,950
And yeah, we were able to successfully read the excel file as well so let's move on.