批量导入数据报错了怎么解决萌新刚学python 求大佬指点

报错：Traceback (most recent call last):
File "F:/coin_quant_class/program/class6/1_如何批量导入数据.py", line 38, in <module>
df = pd.read_csv('F:\coin_quant_class\data\class6\BITFINEX\EOSUSD\.' + file,
File "F:\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 610, in read_csv
return _read(filepath_or_buffer, kwds)
File "F:\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 462, in _read
parser = TextFileReader(filepath_or_buffer, **kwds)
File "F:\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 819, in __init__
self._engine = self._make_engine(self.engine)
File "F:\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 1050, in _make_engine
return mapping[engine](self.f, **self.options) # type: ignore[call-arg]
File "F:\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 1867, in __init__
self._open_handles(src, kwds)
File "F:\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 1362, in _open_handles
self.handles = get_handle(
File "F:\Anaconda3\lib\site-packages\pandas\io\common.py", line 642, in get_handle
handle = open(
FileNotFoundError: [Errno 2] No such file or directory: 'F:\\coin_quant_class\\data\\class6\\BITFINEX\\EOSUSD\\.BITFINEX_EOSUSD_20170701_1T.csv'

代码：

# 批量读取文件名称
file_list = []
for root, dirs, files in os.walk('F:\coin_quant_class\data\class6'):

if files:

for f in files:

if f.endswith('.csv'):

file_list.append(f)

# 遍历文件名，批量导入数据

all_data = pd.DataFrame()
for file in sorted(file_list):
    print(file)

# 导入数据
df = pd.read_csv('F:\coin_quant_class\data\class6\BITFINEX\EOSUSD\' + file,
skiprows = 1,  # 跳过第一行
           parse_dates = ['candle_begin_time'])  #  将'candle_begin_time'转换为日期格式

print(df)
exit()

导入数据那里应该是写在for循环里面的吧，你可以打印你拼接的路径看看是不是存在这个file

all_data = pd.DataFrame()
for file in sorted(file_list):
    df = pd.read_csv('F:\coin_quant_class\data\class6\BITFINEX\EOSUSD\' + file,
           skiprows = 1,  # 跳过第一行
           parse_dates = ['candle_begin_time'])  #  将'candle_begin_time'转换为日期格式

    print(df)
exit()

您好，我是有问必答小助手，您的问题已经有小伙伴解答了，您看下是否解决，可以追评进行沟通哦~

如果有您比较满意的答案 / 帮您提供解决思路的答案，可以点击【采纳】按钮，给回答的小伙伴一些鼓励哦～～

ps:问答VIP仅需29元，即可享受5次/月有问必答服务，了解详情>>>https://vip.csdn.net/askvip?utm_source=1146287632

批量导入数据报错了 怎么解决 萌新刚学python 求大佬指点

批量导入数据报错了怎么解决萌新刚学python 求大佬指点