pandas - Pandas 文件阅读器错误 FileNotFoundError: [WinError 3]

Question

我有以下

import os
import pandas as pd 
path = 'C:/PanelComplete/FileForPeter/'
for folder in os.listdir(path):
for file in os.listdir(folder):
    df = pd.read_csv(path+folder+'/'+file,engine='python')
    df1 = df.groupby('codprg').size().reset_index(name='counts')
    df1.to_csv(spath1+folder+'.csv', index=False,encoding='utf-8')

它会导致以下问题FileNotFoundError: [WinError 3] The system cannot find the path specified: '20180101' ，即使路径是正确的，如下面的截图

这个案子问得很快，但我的案子不同

标签： pandas

Answer 1

问题在于for您只放置folder名称而不是完整路径 ( path+folder)，因此您没有正确处理所需的目录。这应该有效：

import os
import pandas as pd 
path = 'C:/PanelComplete/FileForPeter/'
for folder in os.listdir(path):
for file in os.listdir(path+folder):
    df = pd.read_csv(path+folder+'/'+file,engine='python')
    df1 = df.groupby('codprg').size().reset_index(name='counts')
    df1.to_csv(spath1+folder+'.csv', index=False,encoding='utf-8')