python - 将数据写入 CSV 文件

Question

我有一个基本上是这样做的代码：

row1 = []
count = 0
writer = csv.writer(myFile)
row = []
for j in range(0, 2):
    for i in range(0, 4):
        row1.append(i+count)
    count = count + 1
    print(row1)
    writer.writerows(row1)
    row1[:] = []

我正在创建一些列表，我想将每个值映射到一列，就像这样

这个错误出现了iterable expected。我怎样才能做到这一点？

标签： pythonpython-3.xcsv

Answer 1

@roganjosh 是对的，你需要一次写一行是writerow：

import csv

myFile = open("aaa.csv", "w", newline="")

row1 = []
count = 0
writer = csv.writer(myFile)
row = []
for j in range(0, 2):
    for i in range(0, 4):
        row1.append(i+count)
    count = count + 1
    print(row1)
    writer.writerow(row1)
    row1[:] = []

myFile.close() # Don't forget to close your file