使用的话只需要更改输入和输出的文件夹路径,以及需要删除的是第几行,如果是第一列则为row[0],第二列则为row[1]...
import os
import csv
source_folder_path = "F:/Python_2/data"
target_folder_path = "F:/Python_2/result"
# 获取源文件夹下所有csv文件的路径
file_paths = [os.path.join(source_folder_path, file) for file in os.listdir(source_folder_path) if
file.endswith(".csv")]
for file_path in file_paths:
with open(file_path, "r") as file:
# 读取csv文件内容
reader = csv.reader(file)
rows = list(reader)
target_file_path = os.path.join(target_folder_path, os.path.basename(file_path))
with open(target_file_path, "w", newline="") as file:
writer = csv.writer(file)
for row in rows:
# 删除第一列数据
del row[0]
writer.writerow(row)
print("处理完成!数据已输出到目标文件夹。")