如何在Python中合并200个csv文件 [英] how to merge 200 csv files in Python

问题描述

伙计，我这里有从SH（1）到SH（200）命名的200个单独的csv文件。我想把它们合并成一个单一的csv文件。

Guys, I here have 200 separate csv files named from SH (1) to SH (200). I want to merge them into a single csv file. How can I do it?

推荐答案

正如ghostdog74说的，但是这次有标题：

As ghostdog74 said, but this time with headers:

fout=open("out.csv","a")
# first file:
for line in open("sh1.csv"):
    fout.write(line)
# now the rest:    
for num in range(2,201):
    f = open("sh"+str(num)+".csv")
    f.next() # skip the header
    for line in f:
         fout.write(line)
    f.close() # not really needed
fout.close()

这篇关于如何在Python中合并200个csv文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！