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

python excel python-3.x pandas xlsx
Meghdeep Ray picture Meghdeep Ray · May 27, 2015 · Viewed 12.9k times · Source

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 ?

Answer

Meghdeep Ray picture Meghdeep Ray · May 27, 2015

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

Related questions

How can I see the formulas of an excel spreadsheet in pandas / python?

I would like to read in an excel spreadsheet to python / pandas, but have the formulae instead of the cell results. For example, if cell A1 is 25, and cell B1 is =A1, I would like my dataframe to show: 25 =A1 …

Read More
append dataframe to excel with pandas

I desire to append dataframe to excel This code works nearly as desire. Though it does not append each time. I run it and it puts data-frame in excel. But each time I run it it does not append. I …

Read More
How do I get started with PyWin32

I am looking for good resources to get started with pywin32. I haven’t found much in the way of tutorials, books or blogs that talk about it. I’d like to be able to use python to automate some …

Read More