我有两个csv文件:
- output.csv
- output1.csv
output.csv有5列标题。
output1.csv有大约40列不同类型的数据。
我需要将output1.csv的所有内容附加到output.csv中。如何做到这一点?
有人可以给我一个提示吗?
我有以下代码:
reader=csv.DictReader(open("test.csv","r"))
allrows = list(reader)
keepcols = [c for c in allrows[0] if all(r[c] != '0' for r in allrows)]
print keepcols
writer=csv.DictWriter(open("output.csv","w"),fieldnames='keepcols',extrasaction='ignore')
writer.writerows(allrows)
with open("test1.csv","r") as f:
fields=next(f).split()
# print(fields)
allrows=[]
for line in f:
line=line.split()
row=dict(zip(fields,line))
allrows.append(row)
# print(row)
keepcols = [c for c in fields if any(row[c] != '0' for row in allrows)]
print keepcols
writer=csv.DictWriter(open("output1.csv","w"),fieldnames=keepcols,extrasaction='ignore')
writer.writerows(allrows)
test.csv 生成 output.csv
test1.csv 生成 output1.csv
我试图看看是否可以使两个文件将输出合并到同一个文件中...