First time here? We are a friendly community of Power Systems Engineers. Check out the FAQ!
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.read_excel('file_excel.xlsx', sheet_name = ['Hourly Market Data'])From the pandas.read_excel 'online' manual,
sheet_name str, int, list, or None, default 0
Strings are used for sheet names. Integers are used in zero-indexed sheet positions (chart sheets do not count as a sheet position). Lists of strings/integers are used to request multiple sheets. Specify None to get all worksheets.
Available cases:
Defaults to 0: 1st sheet as a DataFrame
1: 2nd sheet as a DataFrame
"Sheet1": Load sheet with name “Sheet1”
[0, 1, "Sheet5"]: Load first, second and sheet named “Sheet5” as a dict of DataFrame
None: All worksheets.To read a sheet into a dataframe, try the following:
import os
import pandas as pd
cwd = os.getcwd()
xlsfile = 'file_excel.xlsx'
df = pd.read_excel(os.path.join(cwd,xlsfile), sheet_name = 'Hourly Market Data')
print(df.head())To read all sheets into a dictionary of dataframe, try the following:
cwd = os.getcwd()
xlsfile = 'file_excel.xlsx'
dict_df = pd.read_excel(os.path.join(cwd,xlsfile), sheet_name = None)
for key in dict_df:
print(key)
print(dict_df[key].head())Check my updated ansawer.
hello I try the updated bus it's the same results, i use None, it's recover the sheet number 1 all time.
Did you test the code with another data excel file? is there any error messages during the run?
Asked: Mar 31 '2
Seen: 1,580 times
Last updated: Mar 31 '22
whit loves you. Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
