python之如何从 CSV 文件中获取输入并使用 Python 编写特定输出

我有一个包含如下数据的 CSV 文件:

a,b,c,d,e,f 
0,0,AER,0,DME,0 
0,0,ASF,0,LED,0 

我如何从 C 列和 E 列获取输入，并将它们输出到如下内容:

I like [column C] and [column E] 
I like [column C] and [column E] 

例子:

I like AER and DME 
I like ASF and LED 

现在我有以下代码:

import csv 
 
header1 =['c'] 
header2 =['e'] 
 
with open('routes2.csv', 'rb') as csvfilein, open('out.csv', 'wb') as csvfileout: 
    reader = csv.DictReader(csvfilein) 
    writer1 = csv.DictWriter(csvfileout, header1, extrasaction='ignore') 
    writer2 = csv.DictWriter(csvfileout, header2, extrasaction='ignore') 
    for line in reader: 
        writer1.writerow(line), writer2.writerow(line) 

我一直在尝试弄清楚如何将文本附加到 C 列和 E 列的数据中。我该怎么做？

请您参考如下方法:

您可以使用字符串格式化并提供csv.DictReader返回的row对象，例如:

with open('routes2.csv', 'rb') as csvfilein: 
    reader = csv.DictReader(csvfilein) 
    for row in reader: 
        print 'I love {c} and {e}'.format(**row)