Pandas: Always selecting the first sheet/tab in an Excel Sheet
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 pdfd = 'file path'data = pd.read_excel( fd, sheet_name=0 )
Use of 'sheetname' is deprecated. Please use sheet_name
Also this bug at the time of writing:https://github.com/pandas-dev/pandas/issues/17107
Use 'sheetname', not 'sheet_name'.
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..