我已经写了识别和解析所要查找的值所需的内容,我需要帮助将具有已解析的值的列写入csv文件(或新的csv文件).这是我想要做的一些伪代码/有些逼真的Python代码:
# Given a CSV file, this function creates a new CSV file with all values parsed
def handleCSVfile(csvfile):
with open(csvfile, 'rb') as file:
reader = csv.reader(file, delimiter=',', lineterminator='\n')
for row in reader:
for field in row:
if isWhatIWant(field):
parsedValue = parse(field)
# write new column to row containing parsed value
我已经编写了isWhatIWant和parse函数.如果我需要编写一个全新的csv文件,那么我不确定如何同时打开这两个文件以及如何从一个文件读取另一个文件.
解决方法:
我会这样我猜想isWhatIWant()应该替换掉原位字段.
import csv
def handleCSVfile(infilename, outfilename):
with open(infilename, 'rb') as infile:
with open(outfilename, 'wb') as outfile:
reader = csv.reader(infile, lineterminator='\n')