由于我的数据本身并没有列名,第一行就是数据,为了不占用第一行的数据而对每一列进行命名,采用了以下代码:
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)
# 写入新的列名
writer.writerow(["num","lat", "lon", "E", "time"])
# 写入原始数据
for row in rows:
writer.writerow(row)
print("处理完成!数据已输出到目标文件夹。")
使用时将source_folder_path修改为自己的原始文件夹,target_folder_path为输出文件夹,列名也按需修改