在 csv 中,对于列,字符串中存在歧义。正因为如此,我得到6
列表中的值而不是5
值作为输出。
Code:
import csv
csv_data = csv.reader(file('test.csv'))
for row in csv_data:
print row
我尝试更换"
with space
至少获得不带任何引号的普通字符串,如下所示,
for row in csv_data:
print [r.replace('"',' ') for r in row] # This did't worked as expected.
Input:
csv 文件中的行看起来像这样,
1,2,"text1", "Sample text ""present" in csv, as this",5
"Sample text "present" in csv, as this" # Error due to this value.
Output:
['1', '2', 'text1', 'Sample text present" in csv', 'as this', 5]
预期输出:
['1', '2', 'text1', 'Sample text "present" in csv, as this', 5]