python问题。运行的时候只输出了一个csv文件

本来是想把所有的excel文件都转成csv文件,然后保存到当前工作目录,但是运行后发现只会输出一个csv文件,这应该怎么改?


for root, dirs, files in os.walk(operate_path):
    n = 1
    for i in range(0,len(files),n) :
        file = files[i : i + n]
        # print(file)
        str_file = ','.join(file)
        # print(str_file)
        filepath = os.path.join(root, str_file)
        # print(filepath)
        csv_file = pd.read_excel(filepath, index_col=0)
        csv_file.to_csv('csv_file.csv',encoding='utf-8')
        print(csv_file)

每个csv取不同的命名
img


count = 0
for root, dirs, files in os.walk(operate_path):
    n = 1
    for i in range(0,len(files),n) :
        file = files[i : i + n]
        # print(file)
        str_file = ','.join(file)
        # print(str_file)
        filepath = os.path.join(root, str_file)
        # print(filepath)
        csv_file = pd.read_excel(filepath, index_col=0)
        count= count+1
        csv_file.to_csv('csv_file'+str(count)+'.csv',encoding='utf-8')
        print(csv_file)