import os
import pandas as pd
print(os.listdir(r'C:\Users\666\Desktop\新建文件夹'))
file_name = r'C:\Users\666\Desktop\新建文件夹\ces.xls'
wb = pd.ExcelFile(file_name)
sheet_names = wb.sheet_names
print(sheet_names)
shet_list = []
for sheet_name in sheet_names:
sheet = wb.parse(sheet_names)
shet_list.append(sheet)
wb_all = pd.concat(shet_list)
print(wb_all)
run后提示如下错误:TypeError: cannot concatenate object of type '<class 'dict'>'; only Series and DataFrame objs are valid
麻烦大神们帮看下,什么原因!
import pandas as pd
print(os.listdir(r'C:\Users\666\Desktop\新建文件夹'))
file_name = r'C:\Users\666\Desktop\新建文件夹\ces.xls'
wb = pd.ExcelFile(file_name)
sheet_names = wb.sheet_names
print(sheet_names)
shet_list = []
for sheet_name in sheet_names:
sheet = wb.parse(sheet_names)
shet_list.append(sheet)
wb_all = pd.concat(shet_list)
print(wb_all)
run后提示如下错误:TypeError: cannot concatenate object of type '<class 'dict'>'; only Series and DataFrame objs are valid
麻烦大神们帮看下,什么原因!