如何从python列表中的CSV文件的单个单元格中写入一组单词? [英] How to write set of words in single cell of CSV file from python list?

问题描述

dataList = ['#cyclone', '#twister', '#thunderstorm', '#supercell', '#wind', '#weatherradar', '#storm', '#waterspout', '#tropicalcyclone', '#hurricane', '#typhoon', '#snowstorm']
    with open('test.csv', 'w', encoding='utf-8', newline='') as fp:
        writer = csv.writer(fp,delimiter=',')
        writer.writerow(dataList)

以上代码是将列表中的每个单词写入CSV文件中的新单元格，但是， 我想将此列表的数据写成一行中每个单元格5个单词.有人可以建议我解决方案还是可以编写一段代码或更正此代码?

Above code is writing each word of list to a new cell in CSV file but, I want to this list's data written as 5 words per cell in a single row. Can someone please suggest me solution or can write piece of code or correct this one?

推荐答案

我为此编写了一个简单的解决方案，您可以对其进行修改以更好地适合您的用途.内容如下:

I have written a naive solution for this, you could modify it to better fit your uses. It goes as follows:

import csv
dataList = ['#cyclone', '#twister', '#thunderstorm', '#supercell', '#wind', '#weatherradar', '#storm', '#waterspout', '#tropicalcyclone', '#hurricane', '#typhoon', '#snowstorm']
with open("Output.csv","w") as Output_csv:
    CSVWriter = csv.writer(Output_csv, delimiter = ' ')
    CSVWriter.writerow(dataList[:5])
    CSVWriter.writerow(dataList[5:10])
    CSVWriter.writerow(dataList[10:12])

希望有帮助.

这篇关于如何从python列表中的CSV文件的单个单元格中写入一组单词?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！