无法拾取列表元素并将其附加到现有cs中

Question

我有以下格式的列表

Mylist = [['5AEEP1','0','1','LAP1'],['5XXEP1','0','1','LAP2'],['5AXAP1','0','1','LAP3']]

我试图获取第一个和最后一个元素，并将它们附加到现有的csv中

5AEEP1,LAP1
5XXEP1,LAP2
5AXAP1,LAP3

有以下几点

with open(old_pcodes,"a",encoding='utf-8', newline="") as infile:         
    writer = csv.writer(infile, delimiter=';',quoting=csv.QUOTE_NONE)
    towrite =[]
    for ritem in Mylist:
        if ritem:
            pno = ritem[0]
            thepcode = ritem[3]
            finalout = pno+';'+thepcode
            finalout.strip('"')
        writer.writerow([finalout])

我犯了一个逃逸错误

如果我加上

writer = csv.writer(infile, delimiter=';',quoting=csv.QUOTE_NONE, escapechar=' ')

然后我在csv中有一个空间

5AEEP1 ,LAP1
5XXEP1 ,LAP2
5AXAP1 ,LAP3

我还能怎么做呢

Answer 1

您可以一次将它们全部写入with ^{}：

import csv

Mylist = [['5AEEP1','0','1','LAP1'],['5XXEP1','0','1','LAP2'],['5AXAP1','0','1','LAP3']]

with open("t.txt","a",encoding='utf-8', newline="") as infile:         
    writer = csv.writer(infile, delimiter=';',quoting=csv.QUOTE_NONE)
    writer.writerows( (i[0],i[3]) for i in Mylist )

with open("t.txt") as f:
    print(f.read())

输出：

5AEEP1;LAP1
5XXEP1;LAP2
5AXAP1;LAP3