python将csv文件拆分_【中年阿姨python入门】CSV文件拆分（DictReader&DictWriter）

刚接触自动化办公~

---------------------------------分割线-----------------------------------

#这个模块常用知识点，取字典里的所有键

# info_dict = {'姓名': '徐小刚', '工号': '1005', '员工发展基金': '100', '员工签字': ''}

# headers=info_dict.keys()

# print(headers)

#-------------------------------------------------------------------------

import csv

# 设置员工发展基金确认表路径

source_path = './员工发展基金确认表.csv'

# 设置存放拆分结果文件的文件夹路径

result_path = './员工发展基金文件夹_demo/'

# 打开员工发展基金确认表

with open(source_path, 'r', encoding='utf-8', newline='') as source_file:

# 将文件对象转换为DictReader对象

source_csv = csv.DictReader(source_file)

# 将csv对象的表头读取出来

headers = source_csv.fieldnames

# 循环处理确认表中除表头外的每一行数据

for csv_row in source_csv:

# 根据获取的员工名字拼接新文件名

file_name = csv_row['姓名'] + '.csv'

# 拼接新文件路径

file_path = result_path + file_name

# 创建新文件并添加数据

with open(file_path, 'w', encoding='utf-8', newline='') as target_file:

# 将文件对象转换为DictWriter对象

target_writer = csv.DictWriter(target_file, fieldnames=headers)

# 写入表头

target_writer.writeheader()

# 写入数据

target_writer.writerow(csv_row)