python抽取某个时间段的数据_python 批量提取excel 指定时间段的数据

[Python] 纯文本查看 复制代码import pandas as pd

import os

import datetime

path = r'C:\Users\plm\Desktop\text1'

files = os.listdir(path)

for file in files:

df =pd.read_excel(file)

Traceback (most recent call last):

File "", line 12, in

df =pd.read_excel(file)

File "D:\ProgramData\Anaconda3\lib\site-packages\pandas\util\_decorators.py", line 296, in wrapper

return func(*args, **kwargs)

File "D:\ProgramData\Anaconda3\lib\site-packages\pandas\io\excel\_base.py", line 304, in read_excel

io = ExcelFile(io, engine=engine)

File "D:\ProgramData\Anaconda3\lib\site-packages\pandas\io\excel\_base.py", line 867, in __init__

self._reader = self._engines[engine](self._io)

File "D:\ProgramData\Anaconda3\lib\site-packages\pandas\io\excel\_xlrd.py", line 22, in