写csv文件用双引号为特定列不工作 [英] write csv file with double quotes for particular column not working
本文介绍了写csv文件用双引号为特定列不工作的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我试图使用python csv writer写一个csv文件。
其中一个列值被包含在[双引号] :'col1''col2'test,当我在wordpad中打开文件时,单词test预期为test,但实际结果是test
$ b $
有人可以指导这个问题。
我试用的示例代码片段:
csvReader = csv.reader(iInputFile)
writer = csv.writer(open('one_1.csv','wb'),delimiter =',',lineterminator ='\r \\\
')
csvReader中的行:
rawRow = []
rawRow.append('31 -7-2014')#Appending Date
rawRow .append(row [0])#附加数据
rawRow.append('\'+'test'+'\')
writer.writerow(rawRow)
解决方案试试这个
f_writ = open('one_4.csv','wb')
csvReader = csv.reader(iInputFile)
writer = csv.writer(f_writ, delimiter =',',
lineterminator ='\r\\\
',
quotechar ='
)
for csvReader:
writer.writerow(['31-7-2014',row [0],'\text\'])
f_writ.close()
我也觉得这个链接非常有用
http://pymotw.com/2/csv/ ,有很多例子I'm trying to write a csv file using python csv writer.
In which one of the column value is enclosed in "" [double quotes] e.g. : 'col1' 'col2' "test", when I open the file in wordpad, the word test is expected as "test" but actual result is """test"""
can someone guide for this issue.
Sample snippet of my try out:
csvReader = csv.reader(iInputFile) writer = csv.writer(open('one_1.csv', 'wb'), delimiter=',', lineterminator='\r\n') for row in csvReader: rawRow = [] rawRow.append('31-7-2014') #Appending Date rawRow.append(row[0]) #Appending data rawRow.append('\"'+'test'+'\"') writer.writerow(rawRow)
解决方案try with this one
f_writ = open('one_4.csv', 'wb') csvReader = csv.reader(iInputFile) writer = csv.writer(f_writ, delimiter=',', lineterminator='\r\n', quotechar = "'" ) for row in csvReader: writer.writerow(['31-7-2014',row[0],'\"text\"']) f_writ.close()
also i find very useful this link http://pymotw.com/2/csv/, there are a lot of exemples
这篇关于写csv文件用双引号为特定列不工作的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文