我需要打印头和数据行到一个CSV文件。这是我的密码:
import csv
import sys
with open(r'C:\Users\testuser\Desktop\raw_inpuy.csv','rb') as csvfile:
reader=csv.reader(csvfile,delimiter=',')
first=True
data={}
for row in reader:
if first:
first= False
continue
if not int(row[1]) in data:
data[int(row[1])]=[]
data[int(row[1])].append(float(row[3]))
with open (r'C:\Users\testuser\Desktop\outcome.csv','wb') as f_out:
outwriter=csv.writer(f_out,delimiter=',')
f_out.write(";".join(['Size','S1','S2','S3','S4']))
for item in data:
row=[item]
row.extend(data[item])
f_out.write(";".join(map(str,row)))
我得到这个错误:
**ERROR Expected a character buffer obj**
应该用
str
而不是list
来填充writer.write
:此外:
与其尝试构建自己的CSV记录,不如让
csv
模块来处理它。像这样:相关问题 更多 >
编程相关推荐