CODEWITHSUNDEEP
pythonexcelpython-3.xpandasxlsx
Meghdeep Ray
Meghdeep Ray

Reputation: 5537

Pandas: Always selecting the first sheet/tab in an Excel Sheet

I know how to get the list of sheet names. The excel file I am using has multiple sheets. How do I select the first one sequentially ? I don't know the name of the sheet but I need to select the first one. How would I go about this ?

Upvotes: 19

Views: 35634

Answers (3)

Meghdeep Ray
Meghdeep Ray

Reputation: 5537

The first sheet is automatically selected when the Excel table is read into a dataframe.

To be explicit however, the command is :

import pandas as pd
fd = 'file path'
data = pd.read_excel( fd, sheet_name=0 )

Use of 'sheetname' is deprecated. Please use sheet_name

Upvotes: 32

StinkySocks
StinkySocks

Reputation: 934

Also this bug at the time of writing: https://github.com/pandas-dev/pandas/issues/17107

Use 'sheetname', not 'sheet_name'.

Upvotes: 2

alec_djinn
alec_djinn

Reputation: 10819

Following the official documentation and as already suggested by EdChum, it's enough to use read_excell passing sheetname=N as argument. N=0 for the first sheet, N=1 for the second, N=2 for the third and so on..

Upvotes: 0

Related Questions