使用pandas是出现:No module named 'openpyxl'
在学习Python中pandas的过程中,打算将爬虫取到的数据保存到Excel文件中,使用
df=pandas.DataFrame(c) #print(df) df.to_excel('house.xlsx',sheet_name='sheet1') |
总是报错 Module Not Found Error: No module named 'openpyxl'
发现是有个库没有导入
问题:
Traceback (most recent call last):
File "E:/testPython/machine_learn/expmle_test1/Shells_Reptile.py", line 28, in <module>
df.to_excel('house.xlsx',sheet_name='sheet1')
File "E:\testPython\venv\lib\site-packages\pandas\core\generic.py", line 2256, in to_excel
engine=engine,
File "E:\testPython\venv\lib\site-packages\pandas\io\formats\excel.py", line 730, in write
writer = ExcelWriter(_stringify_path(writer), engine=engine)
File "E:\testPython\venv\lib\site-packages\pandas\io\excel\_openpyxl.py", line 19, in __init__
from openpyxl.workbook import Workbook
ModuleNotFoundError: No module named 'openpyxl'
解决办法:
使用:pip list查看是否有:openpyxl这个包;
没有导入:pip install openpyxl
import openpyxl
import requests
import pandas
import openpyxl
即可
更多推荐
所有评论(0)