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

Question

本来是想把所有的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)

Answer 1

每个csv取不同的命名

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)