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

问题描述

我需要读取包含逗号的字段的 CSV 文件，因此我对包含逗号的字段进行了双引号，例如:

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

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

row[0] = 1行 [1] = 文本 1行 [2] = 文本 2行 [3] = 文本 3行[4] = text4行[5] = a行[6] = b行[7] = c

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

info = csv.reader(open('./info.csv'))对于信息行:打印行[0] + " * " + 行[1] ...

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

解决方案

Python csv 模块实际上确实支持带引号的字段，即使在默认情况下也是如此.这里的问题是 Python 默认不跳过空格，因此您需要使用 skipinitialspace=True.

<预><代码>>>>s = StringIO.StringIO('1, "text1,text2", "text3, text4", a, b, c')>>>列表(csv.reader(s，skipinitialspace=True))[['1', 'text1,text2', 'text3, text4', 'a', 'b', 'c']]

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']]

这篇关于在Python中的字段中使用逗号读取CSV文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！