将列表写入csv文件，而不是按需要写入

Question

当我运行此代码时，每个列表项都被分隔成单独的字母，并通过逗号分隔

例如，如果我将持有stockName的列表'amazon'和持有'amzn'的tickerName作为每个受尊重列表中的第一项，则运行下面的代码将其存储为：

a,m,a,z,o,n
a,m,z,n

实际上，我想把它放在一行：

amazon,amzn

代码：

with open('/Users/reubenmcqueen/Desktop/csvStoreFile.csv', 'w',) as myFile:
    writer = csv.writer(myFile)
    for a in range(0, len(stockName)):
        i = [stockName[a], tickerName[a]]
        writer.writerows(i)

Answer 1

像这样使用writer.writerow(a,b)：

data = ['amazon','amzn']
with open('art_ton_prices.csv','a') as test:
    writer = csv.writer(test)
    writer.writerow(data[0], data[1])

Answer 2

你应该使用writer.writerow(...)

stockName = ['amazon', 'apple']
tickerName = ['amzn', 'aapl']

with open('test.csv', 'w',) as myFile:
    writer = csv.writer(myFile)
    for stock, ticker in zip(stockName, tickerName):
        writer.writerow([stock, ticker])