Csv Writer-尝试在每个列中写入变量

Question

我试图在csv文件中写入一些数据，但我无法选择不同的列。。

car=["car 11"]
finish=["Landhaus , Nord"]
time=["['05:36']", "['06:06']", "['06:36']", "['07:06']", "['07:36']", "['08:06']", "['08:36']", "['09:06']", "['09:36']", "['10:06']", "['10:36']", "['11:06']", "['11:36']", "['12:06']", "['12:36']", "['13:06']", "['13:36']", "['14:06']", "['14:36']", "['15:06']", "['15:36']", "['16:06']", "['16:36']", "['17:06']", "['17:36']", "['18:06']", "['18:36']", "['19:06']", "['19:36']", "['20:06']", "['20:36']"]<br/>
myfile = open("Informationen.csv", "wb")
writer = csv.writer(myfile,dialect='excel',delimiter=' ')
bla =[car,finish,time]
writer.writerow(bla)

输出：

car 11 Landhaus , Nord "['05:36']", "['06:06']", [..]

一行一列

但我要这样

car 11 (in row 1 Colum 1) | "Landhaus , Nord" (in row 1 Column 2) | ['05:36'] (in Line 1 Column 3 ) | ['06:06'] (in row 1 Column 4 ) till Column n

谢谢你的帮助！

编辑
1更详细的示例 1号线：11号车厢（第1栏）北兰德豪斯（第2栏）['05:36'（第3栏）['05:36'（第4栏）[…] 示例http://img13.imageshack.us/img13/4964/unbenanntvilw.png

目前的解决方案： 但时间清单还有问题

car=["car 11"]
trenn=[';']
finish=['Landhaus , Nord']
time=["['05:36']", "['06:06']", "['06:36']", "['07:06']", "['07:36']", "['08:06']", "['08:36']", "['09:06']", "['09:36']", "['10:06']", "['10:36']", "['11:06']", "['11:36']", "['12:06']", "['12:36']", "['13:06']", "['13:36']", "['14:06']", "['14:36']", "['15:06']", "['15:36']", "['16:06']", "['16:36']", "['17:06']", "['17:36']", "['18:06']", "['18:36']", "['19:06']", "['19:36']", "['20:06']", "['20:36']"]
myfile = open("Informationen2.csv", "wb")
writer = csv.writer(myfile,delimiter=' ')
bla = car + trenn + finish + trenn + time
writer.writerow(bla)
myfile.close()

Answer 1

Python documentation声明对于csv.writer()函数。。。

"optional dialect parameter can be given which is used to define a set of parameters specific to a particular CSV dialect".

。。。还有。。。

"the other optional fmtparams keyword arguments can be given to override individual formatting parameters in the current dialect".

您遇到的问题是将time列表的字符串表示形式写入文件，并使用空格分隔符写入文件的结果。如果您将Informationen.csv作为纯文本文件查看，则问题变得显而易见。

首先，对在csv.writer(myfile, dialect='excel', delimiter=' ')中作为参数传递了空格分隔符的文件的写入操作将重写在Excel方言中定义的默认分隔符，并导致列表bla的元素以element1 element2 element3格式（而不是element1,element2,element3）写入文件。

其次，尽管time列表中的大多数元素按需要在电子表格中分配了它们自己的列，但将列表作为自身的字符串表示形式写入文件会导致整体格式不受欢迎。

当您将用脚本创建的文件作为Excel文件打开时，Excel会根据它发现的前两个逗号读入两个初始值，这两个逗号恰好位于字符串'Landhaus , Nord'的中心和time列表的字符串表示形式中。

通过将time列表的元素附加到bla列表，而不是将前者嵌套到后者中，可以首先实现所需的列分隔。然后需要在csv.writer(myfile, dialect='excel', delimiter=' ')中省略delimiter=' '，从而避免在写入文件时使用分隔符覆盖效果：

import csv

car = ['car 11']
finish = ['Landhaus , Nord']
time = ["['05:36']", "['06:06']", "['06:36']", "['07:06']", "['07:36']"]
try:
    with open('Informationen.csv', 'w') as myfile:
        writer = csv.writer(myfile, dialect='excel')
        bla = [car, finish]
        for each_time in time:
            bla.append(each_time)
        writer.writerow(bla)
except IOError as ioe:
    print('Error: ' + str(ioe))

在Excel中生成以下输出：

http://imageshack.us/a/img839/8061/screenshotkn.png

Answer 2

import csv

car=["car 11"]
finish=['Landhaus , Nord']
time=["['05:36']", "['06:06']", "['06:36']", "['07:06']", "['07:36']", "['08:06']", "['08:36']", "['09:06']", "['09:36']", "['10:06']", "['10:36']", "['11:06']", "['11:36']", "['12:06']", "['12:36']", "['13:06']", "['13:36']", "['14:06']", "['14:36']", "['15:06']", "['15:36']", "['16:06']", "['16:36']", "['17:06']", "['17:36']", "['18:06']", "['18:36']", "['19:06']", "['19:36']", "['20:06']", "['20:36']"]
myfile = open("derp.csv", "wb")
writer = csv.writer(myfile)
bla = car + finish + time
writer.writerow(bla)
myfile.close()

这是我从excel中得到的输出