如何使用python读取csv文件中包含逗号的单个值

问题描述：

我有一个包含以下值的csv文件

I have a csv file that contains the following values

"Spam2,pank",Spam3,Spam6,Spam7
Spam1,Spam5,Spam0,Spam9

我正在使用以下python代码读取特定列

And i am using the following python code to read a particular column

for line in open('D:\eggs2.csv','rb'):
    columns = line.split(",")
    print columns[0]

它提供的输出是:-

"Spam2
Spam1

在我期待的时候:

Spam2,pank
Spam1

请帮助我解决这个问题.

Please Help me out on this.

答

您不必重新发明轮子，python csv模块可以完美地完成工作.

You don't have to reinvent the wheel, the python csv module does a perfect job.

import csv

csv_file = open('D:\eggs2.csv','rb')
csv_reader = csv.reader(csv_file)
for row in csv_reader:
    print row[0]

csv_file.close()

@请参见 Python csv