我正在嘗試將一些數(shù)據(jù)寫入 csv 文件。我只希望中間列在 csv 文件中有引號(hào)。我從在數(shù)組上保存在數(shù)組中的數(shù)據(jù)開始。以下是打印出來的一些條目：['1', '"For Those About To Rock We Salute You"', 'Album']['2', '"Balls to the Wall"', 'Album']['3', '"Restless and Wild"', 'Album']['4', '"Let There Be Rock"', 'Album']['5', '"Big Ones"', 'Album']['6', '"Jagged Little Pill"', 'Album']...如您所見，唯一的中間列有引號(hào)。但是，當(dāng)我將其寫入 csv 文件時(shí)，這就是我得到的：1,""For Those About To Rock We Salute You"",Album2,""Balls to the Wall"",Album3,""Restless and Wild"",Album4,""Let There Be Rock"",Album5,""Big Ones"",Album6,""Jagged Little Pill"",Album...除了中間那一欄，一切都很好！我有雙引號(hào)！我有一個(gè)函數(shù)可以獲取數(shù)據(jù)（保存在數(shù)組數(shù)組中），并將其寫入 csv 文件。我研究了這個(gè)QUOTE_NONE方法，但這似乎不起作用......file_data = ...def write_node_csv(): with open("./csv_files/albums.csv", mode='w') as csv_file: writer = csv.writer(csv_file, delimiter=',', quoting=csv.QUOTE_NONE, escapechar="\"") for data in file_data: writer.writerow(data) csv_file.close()所以基本上我期待這個(gè)：1,"For Those About To Rock We Salute You",Album2,"Balls to the Wall",Album3,"Restless and Wild",Album4,"Let There Be Rock",Album5,"Big Ones",Album6,"Jagged Little Pill",Album...但我得到了這個(gè)：1,""For Those About To Rock We Salute You"",Album2,""Balls to the Wall"",Album3,""Restless and Wild"",Album4,""Let There Be Rock"",Album5,""Big Ones"",Album6,""Jagged Little Pill"",Album...
1 回答
胡說叔叔
TA貢獻(xiàn)1804條經(jīng)驗(yàn) 獲得超8個(gè)贊
這是獲取結(jié)果的演示：
In []:
data = """'1', '"For Those About To Rock We Salute You"', 'Album'
'2', '"Balls to the Wall"', 'Album'
'3', '"Restless and Wild"', 'Album'
'4', '"Let There Be Rock"', 'Album'
'5', '"Big Ones"', 'Album'
'6', '"Jagged Little Pill"', 'Album'"""
import csv
with StringIO(data) as fin:
reader = csv.reader(fin, quotechar="'", skipinitialspace=True)
for row in reader:
print(row)
Out[]:
['1', '"For Those About To Rock We Salute You"', 'Album']
['2', '"Balls to the Wall"', 'Album']
['3', '"Restless and Wild"', 'Album']
['4', '"Let There Be Rock"', 'Album']
['5', '"Big Ones"', 'Album']
['6', '"Jagged Little Pill"', 'Album']
In []:
with StringIO(data) as fin, StringIO() as fout:
reader = csv.reader(fin, quotechar="'", skipinitialspace=True)
writer = csv.writer(fout, quotechar='', quoting=csv.QUOTE_NONE)
writer.writerows(reader)
contents = fout.getvalue()
print(contents)
Out[]:
1,"For Those About To Rock We Salute You",Album
2,"Balls to the Wall",Album
3,"Restless and Wild",Album
4,"Let There Be Rock",Album
5,"Big Ones",Album
6,"Jagged Little Pill",Album
添加回答
舉報(bào)
0/150
提交
取消