python读取excel多个sheet_解决python pandas读取excel中多个不同sheet表格存在的问题

摘要：不同方法读取excel中的多个不同sheet表格性能比较

# 方法1

def read_excel(path):

df=pd.read_excel(path,None)

print(df.keys())

# for k,v in df.items():

# print(k)

# print(v)

# print(type(v))

return df

# 方法2

def read_excel1(path):

data_xls = pd.ExcelFile(path)

print(data_xls.sheet_names)

data={}

for name in data_xls.sheet_names:

df=data_xls.parse(sheetname=name,header=None)

data[name]=df

# print(df)

# print(name)

return data

# 方法3

def read_excel2(path):

data_xls = pd.io.excel.ExcelFile(path)

data={}

print(data_xls.sheet_names)

for name in data_xls.sheet_names:

df=pd.read_excel(data_xls,sheetname=name,header=None)

data[name]=df

return data

运行结果

<