批量转换CSV到XLSX保留python中的子文件夹结构

pip install pandas

import os
import pandas as pd

def convert_csv_to_xlsx(input_folder, output_folder):
    for root, dirs, files in os.walk(input_folder):
        for file in files:
            if file.endswith(".csv"):
                csv_path = os.path.join(root, file)
                xlsx_path = csv_path.replace(input_folder, output_folder).replace(".csv", ".xlsx")
                
                # 读取CSV文件
                df = pd.read_csv(csv_path)
                
                # 将数据写入XLSX文件
                df.to_excel(xlsx_path, index=False)
                
                print(f"转换成功：{csv_path} -> {xlsx_path}")

# 指定输入文件夹和输出文件夹的路径
input_folder = "输入文件夹路径"
output_folder = "输出文件夹路径"

# 调用函数进行批量转换
convert_csv_to_xlsx(input_folder, output_folder)