如何在python中为csv使用分隔符
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/16823695/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to use delimiter for csv in python
提问by hydi
I'm having trouble with figuring out how to use the delimiter for csv.writer in Python. I have a csv file in which the strings separated by commas are in single cell and I need to have each word in each individual cell. For ex:
我在弄清楚如何在 Python 中为 csv.writer 使用分隔符时遇到了麻烦。我有一个 csv 文件，其中用逗号分隔的字符串在单个单元格中，我需要在每个单独的单元格中包含每个单词。例如：
100 , 2559 ,,Main, St,LEOMA,LEOMA,498,498, AK,AK
140 , 425 ,,Main, St,LEOMA,LEOMA,498,498, AK,AK
100 , 599 ,,Main, St,LEOMA,LEOMA,498,498, AK,AK
should be
应该
100 2559 Main St LEOMA LEOMA 498 498 AK AK
140 425 Main St LEOMA LEOMA 498 498 AK AK
100 599 Main St LEOMA LEOMA 498 498 AK AK
(each word in individual cell).
（单个单元格中的每个单词）。
I tried:
我试过：
import csv
workingdir = "C:\Mer\Ven\sample"
csvfile = workingdir+"\test3.csv"
f=open(csvfile,'wb')
csv.writer(f, delimiter =' ',quotechar =',',quoting=csv.QUOTE_MINIMAL)
采纳答案by underrun
Your code is blanking out your file:
您的代码正在清空您的文件：
import csv
workingdir = "C:\Mer\Ven\sample"
csvfile = workingdir+"\test3.csv"
f=open(csvfile,'wb') # opens file for writing (erases contents)
csv.writer(f, delimiter =' ',quotechar =',',quoting=csv.QUOTE_MINIMAL)
if you want to read the file in, you will need to use csv.reader and open the file for reading.
如果要读取文件，则需要使用 csv.reader 并打开文件进行读取。
import csv
workingdir = "C:\Mer\Ven\sample"
csvfile = workingdir+"\test3.csv"
f=open(csvfile,'rb') # opens file for reading
reader = csv.reader(f)
for line in reader:
print line
If you want to write that back out to a new file with different delimiters, you can create a new file and specify those delimiters and write out each line (instead of printing the tuple).
如果要将其写回具有不同分隔符的新文件，您可以创建一个新文件并指定这些分隔符并写出每一行（而不是打印元组）。
回答by abhishekgarg
ok, here is what i understood from your question. You are writing a csv file from python but when you are opening that file into some other application like excel or open office they are showing the complete row in one cell rather than each word in individual cell. I am right??
好的，这是我从你的问题中了解到的。您正在从 python 编写 csv 文件，但是当您将该文件打开到其他应用程序（如 excel 或 open office）时，它们会在一个单元格中显示完整行，而不是单个单元格中的每个单词。我是对的？？
if i am then please try this,
如果我是那么请试试这个，
import csv
with open(r"C:\test.csv", "wb") as csv_file:
writer = csv.writer(csv_file, delimiter =",",quoting=csv.QUOTE_MINIMAL)
writer.writerow(["a","b"])
you have to set the delimiter = ","
你必须设置 delimiter = ","
