在Python的字段中使用逗号读取CSV文件(Read CSV file with comma within fields in Python)

934 IT屋

I need to read a CSV file which has fields that have a comma, so I have double quoted the fields which contains commas, such as:

1, "text1,text2", "text3, text4", a, b, c

But when I try to read the file in Python I get the fields separated by the commas, as following:

row[0] = 1
row[1] = text1
row[2] = text2
row[3] = text3
row[4] = text4
row[5] = a
row[6] = b
row[7] = c

I am reading the CSV file with the following code:

info = csv.reader(open('./info.csv'))  
for row in info :
    print row[0] + " * " + row[1] ...

Is it possible to read double quoted fields which contains a comma?

解决方案

The Python csv module actually does support quoted fields, even by default. Your problem here is that Python by default does not skip the space, so you need to use skipinitialspace=True.

>>> s = StringIO.StringIO('1, "text1,text2", "text3, text4", a, b, c')
>>> list(csv.reader(s, skipinitialspace=True))
[['1', 'text1,text2', 'text3, text4', 'a', 'b', 'c']]

我需要读取一个包含逗号的字段的CSV文件,所以我用双引号引起了包含逗号的字段,例如:



  1,"text1,text2","text3,text4",a,b,c 

$ b b

但是当我尝试在Python中读取文件时,我得到用逗号分隔的字段,如下所示:



  row [0] = 1 
row [1] = text1
row [2] = text2
row [3] = text3
row [4] = text4
row [5] = a
row [6] = b
row [7] = c


我正在用以下代码读取CSV文件:



  info = csv.reader(open /info.csv'))
for row in info:
print row [0] +"*"+ row [1] ...
pre>

是否可以读取包含逗号的双引号字段?


解决方案

Python csv 模块实际上确实支持引用的字段,即使默认情况下。这里的问题是Python默认不会跳过这个空格,所以你需要使用 skipinitialspace = True

$



 >>> s = StringIO.StringIO('1,"text1,text2","text3,text4",a,b,c')
>> list(csv.reader(s,skipinitialspace = True))
[['1','text1,text2','text3,text4','a','b','c']]

本文地址:IT屋 » 在Python的字段中使用逗号读取CSV文件

相关文章: