python将输出结果写入csv_将for循环的输出写入python中的csv

我正在打开一个名为Remarks_Drug.csv的csv,其中包含产品名称并映射

连续列中的文件名.我正在对产品栏进行一些操作

删除字符后的所有字符串内容.从中剥离字符串后

字符,我将结果存储在一个名为product_patterns的变量中.

现在我打开一个新的csv,我想将for循环的输出写入

两列,第一列包含product_patterns,第二列包含

相应的文件名.

我现在得到的输出只是我要寻找的输出csv的最后一行.

我想我没有正确地循环,以至于product_patterns和filename的每一行都得到

附加在输出的csv文件中.

有人可以帮我吗

下面的代码：

import csv

with open('Remarks_Drug.csv', newline='', encoding ='utf-8') as myFile:

reader = csv.reader(myFile)

for row in reader:

product = row[0].lower()

#print('K---'+ product)

filename = row[1]

product_patterns = ', '.join([i.split("+")[0].strip() for i in product.split(",")])

#print(product_patterns, filename)

with open ('drug_output100.csv', 'a') as csvfile:

fieldnames = ['product_patterns', 'filename']

print(fieldnames)

writer = csv.DictWriter(csvfile, fieldnames=fieldnames)

print(writer)

#writer.writeheader()

writer.writerow({'product_patterns':product_patterns, 'filename':filename})

输入样例：

Film-coated tablet + TERIFLUNOMIDE, 2011-07-18 - Received approval letter_EN.txt

Film-coated tablet + VANDETANIB, 2013-12-14 RECD Eudralink_Caprelsa II-28 - RSI - 14.12.2017.txt

Solution for injection + MenQuadTT, 395_EU001930-PIP01-16_2016-02-22.txt

Solution for injection + INSULIN GLARGINE, 2017-11-4 Updated PR.txt

Solution for injection + INSULIN GLARGINE + LIXISENATIDE, 2017 12 12 Email Approval Texts - SA1006-.txt