[已解决]pandas出错.

fineconey

1. # coding:utf-8
   
2. 
   
3. import os
   
4. import pandas as pd
   
5. import time
   
6. 
   
7. t1 = time.time()
   
8. l = []
   
9. n = 0
   
10. for file in os.walk(r'E:\a'):
    
11.     for table in file[2]:
    
12.         path = file[0] + '/' + table
    
13.         data = pd.read_excel(path, header=0, encoding='utf-8', engine='python')
    
14.         n = n + 1
    
15.         l.append(data)
    
16.         print('第' + str(n) + '个表格已提取')
    
17. date_result = pd.concat(l)
    
18. date_result.to_excel(r'E:\a\result.excel', index=0)
    
19. t2 = time.time()
    
20. t2 = t2 - t1
    
21. t = round(t2, 2)
    
22. print('用时' + str(t) + '秒')
    
23. print('完成')

复制代码

出错,

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

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