python 合并多个csv 只保留一个表头_合并多个不含头的CSV文件（使用Python）

I am a beginner with Python. I have multiple CSV files (more than 10), and all of them have same number of columns. I would like to merge all of them into a single CSV file, where I will not have headers repeated.

So essentially I need to have just the first row with all the headers and from then I need all the rows from all CSV files merged. How do I do this?

Any help is appreciated.

Thanks!

解决方案

While I think that the best answer is the one from @valentin, you can do this without using csv module at all:

import glob

interesting_files = glob.glob("*.csv")

header_saved = False

with open('output.csv','wb') as fout:

for filename in interesting_files:

with open(filename) as fin:

header = next(fin)

if not header_saved:

fout.write(header)

header_saved = True

for line in fin:

fout.write(line)