使用Python的csv库进行读取和处理

示例代码：

import csv

with open('poorly_organized.csv', 'r') as file: reader = csv.reader(file) for row in reader: # 处理每行数据的操作 pass

也可以使用csv.DictReader，将每行数据存储为字典

with open('poorly_organized.csv', 'r') as file: reader = csv.DictReader(file) for row in reader: # 处理每行数据的操作 pass

如果需要写入处理后的数据，可以使用csv.writer或csv.DictWriter

with open('cleaned_up.csv', 'w', newline='') as file: writer = csv.writer(file) writer.writerow(['Column 1', 'Column 2']) # 写入表头 # 写入处理后的数据 writer.writerow(['Value 1', 'Value 2'])

with open('cleaned_up.csv', 'w', newline='') as file: fieldnames = ['Column 1', 'Column 2'] # 字段名 writer = csv.DictWriter(file, fieldnames=fieldnames) writer.writeheader() # 写入表头 # 写入处理后的数据 writer.writerow({'Column 1': 'Value 1', 'Column 2': 'Value 2'})