First time here? We are a friendly community of Power Systems Engineers. Check out the FAQ!

Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

asked Mar 31 '2

Moha jbr gravatar image

How to Read Multiple Sheets to Pandas Dataframe

HELLO evreyone i'm traying to create a dataframe from un excel with multiple sheets, i want to use one sheets from excel file in some analysis, i try everthings that i know but it does'n work.

sheets = pd.readexcel('fileexcel.xlsx', sheet_name = ['Hourly Market Data'])

click to hide/show revision 2
No.2 Revision

updated Mar 31 '2

jconto gravatar image

How to Read Multiple Sheets to Pandas Dataframe

HELLO evreyone i'm traying to create a dataframe from un excel with multiple sheets, i want to use one sheets from excel file in some analysis, i try everthings that i know but it does'n work.

sheets
##sheets = pd.readexcel('fileexcel.xlsx', pd.read_excel('file_excel.xlsx', sheet_name = ['Hourly Market Data'])

Data'])