See sheet n in .read_excel

27 views
Skip to first unread message

Julius Hamilton

unread,
Nov 22, 2021, 11:08:17 AM11/22/21
to PyData
I have loaded an Excel file with pandas.read_excel(). How do I view sheet 1, 2, 3, etc. of that dataframe? The default is to display Sheet 1.

Thanks,
Julius

Graham Duncan

unread,
Nov 22, 2021, 11:10:46 AM11/22/21
to pyd...@googlegroups.com
Use the sheet_name argument. pd.read_excel(filename, sheet_name="Name of worksheet"). 

--
You received this message because you are subscribed to the Google Groups "PyData" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pydata+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/pydata/6bb8453f-d68b-47b7-a13f-ff6d60261e6cn%40googlegroups.com.
--
. . . . . . . . . . . . . . . . . . . . . . . . . . . .
Graham H. Duncan
Reply all
Reply to author
Forward
0 new messages