python excel csv帮助。如何进行格式化
python excel csv帮助。如何进行格式化
提问于 2013-07-03 03:46:35
我有个问题。如果我用文字来解释它，我会弄得一团糟，所以这里是图片。
我的代码：
import csv
def mytest():
s1 = 'post'
s2 = 'a_num'
s3 = ['personA','GenderA','personB','GenderB','personC','GenderC','personD','GenderD','personE','GenderE',]
s4 = ['comment by F','comm_F_gender','comment','ano_num','comment by G','comm_G_gender','comment','ano_num','comment by H','comm_H_gender','comment','ano_num']
with open('mytestfb.csv', 'a') as csvfile:
spamwriter = csv.writer(csvfile, delimiter=',',
quotechar='|', quoting=csv.QUOTE_MINIMAL)
spamwriter.writerow([s1.encode('utf-8'),s2.encode('utf-8')])
x = 0
while(x < len(s3)):
spamwriter.writerow(['','',s3[x].encode('utf-8'),s3[x+1].encode('utf-8')])
x += 2
x = 0
while(x < len(s4)):
spamwriter.writerow(['','','','',s4[x].encode('utf-8'),s4[x+1].encode('utf-8'),s4[x+2].encode('utf-8'),s4[x+3].encode('utf-8')])
x += 4这就是这段代码要做的事情：
这就是我需要代码做的事情：
回答 1
Stack Overflow用户
回答已采纳
发布于 2013-07-03 04:06:49
这不可能是整个代码，对吧？所以，如果我理解的话，s4中的四个项目和s3中的两个项目代表一行。
def mytest():
s1 = 'thing1'
s2 = 'a_number'
s3 = ['personA','GenderA','personB','GenderB','personC','GenderC','personD','GenderD','personE','GenderE',]
s4 = ['comment by F','comm_F_gender','comment','ano_num','comment by G','comm_G_gender','comment','ano_num','comment by H','comm_H_gender','comment','ano_num']
with open('mytestfb.csv', 'a') as csvfile:
spamwriter = csv.writer(csvfile, delimiter=',',
quotechar='|', quoting=csv.QUOTE_MINIMAL)
exportlist=[s1,s2]
for count in range(len(s3)/2):
exportlist+=s3[count*2-1:count*2]
try:
exportlist+=s4[count*4-1+count*4]
except IndexError:
pass
spamwriter.writerow(exportlist.encode('utf-8'))页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/17434507
复制相关文章
相似问题
腾讯云开发者
Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有
深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 
粤公网安备44030502008569号
腾讯云计算（北京）有限责任公司 京ICP证150476号 | 京ICP备11018762号