|
写了如下代码:
import pandas as pd
data=pd.read_excel('自建练手数据.xlsx')
data1=data.loc[1,"一月20日"
data.to_excel('D:\Python\小象课程整理\自建练手数据.xlsx')
却不能导入文件,出现了下面的情况:
Traceback (most recent call last):
File "d:/Python/爬虫课课件/junior_spider-master/02-HTML/jichu/jichu12.py", line 2, in <module>
data=pd.read_excel('自建练手数据.xlsx')
File "C:\Users\ZH\Anaconda3\lib\site-packages\pandas\util\_decorators.py", line 118, in wrapper
return func(*args, **kwargs)
File "C:\Users\ZH\Anaconda3\lib\site-packages\pandas\io\excel.py", line 230, in read_excel
io = ExcelFile(io, engine=engine)
File "C:\Users\ZH\Anaconda3\lib\site-packages\pandas\io\excel.py", line 294, in __init__
self.book = xlrd.open_workbook(self._io)
File "C:\Users\ZH\Anaconda3\lib\site-packages\xlrd\__init__.py", line 116, in open_workbook
with open(filename, "rb") as f:
FileNotFoundError: [Errno 2] No such file or directory: '自建练手数据.xlsx'
PS D:\Python\爬虫课课件\junior_spider-master>
|
|