[已解决]pandas出错.

fineconey

# coding:utf-8

import os
import pandas as pd
import time

t1 = time.time()
l = []
n = 0
for file in os.walk(r'E:\a'):
    for table in file[2]:
        path = file[0] + '/' + table
        data = pd.read_excel(path, header=0, encoding='utf-8', engine='python')
        n = n + 1
        l.append(data)
        print('第' + str(n) + '个表格已提取')
date_result = pd.concat(l)
date_result.to_excel(r'E:\a\result.excel', index=0)
t2 = time.time()
t2 = t2 - t1
t = round(t2, 2)
print('用时' + str(t) + '秒')
print('完成')

出错,

C:\Users\beluc\AppData\Local\Programs\Python\Python38\python.exe E:/_Python_/删除/鹰紫-合并excel-confired.py
Traceback (most recent call last):
  File "E:/_Python_/删除/鹰紫-合并excel-confired.py", line 13, in <module>
    data = pd.read_excel(path, header=0, encoding='utf-8', engine='python')
  File "C:\Users\beluc\AppData\Local\Programs\Python\Python38\lib\site-packages\pandas\io\excel\_base.py", line 304, in read_excel
    io = ExcelFile(io, engine=engine)
  File "C:\Users\beluc\AppData\Local\Programs\Python\Python38\lib\site-packages\pandas\io\excel\_base.py", line 813, in __init__
    raise ValueError(f"Unknown engine: {engine}")
ValueError: Unknown engine: python

最佳答案

月排行榜 / 总排行榜

MIke_python小小

2020-5-1 20:40:19

求最佳

跳转到最佳答案楼层

fineconey

附件里为excel表格文件.谢谢

永恒的蓝色梦想

pandas 文档里写的很清楚

    engine : str, default None
        If io is not a buffer or path, this must be set to identify io.
        Acceptable values are None, "xlrd", "openpyxl" or "odf".

engine 只能是 xlrd，openpyxl，odf，你传个 Python 啥意思？

永恒的蓝色梦想

fineconey 发表于 2020-5-1 20:30
附件里为excel表格文件.谢谢

噗……能看到吗

MIke_python小小

data = pd.read_excel(path, header=0, encoding='utf-8')

试试吧

MIke_python小小

求最佳

fineconey

MIke_python小小 发表于 2020-5-1 20:40
求最佳

然后提示这个错误

raise ImportError(msg) from None
ImportError: Missing optional dependency 'xlrd'. Install xlrd >= 1.0.0 for Excel support Use pip or conda to install xlrd.

fineconey

MIke_python小小 发表于 2020-5-1 20:40
求最佳

找到原因了,有个sheetname  没搞定.

data = pd.read_excel(path, sheet_name=0, header=None, encoding='utf-8')

MIke_python小小

你把求最佳设成最佳

不知道的人还以为刷分呢

fineconey

抱歉,抱歉,的确看走眼了,    感谢提供思路.