合并多个不含头的CSV文件（使用Python） [英] Merging multiple CSV files without headers being repeated (using Python)

问题描述

我是Python的初学者。我有多个CSV文件（超过10），并且它们都有相同的列数。我想将它们合并成一个CSV文件，其中我不会重复头。

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.

所以本质上，我需要只有第一行与所有头，然后我需要所有CSV文件合并的所有行。

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?

感谢！

b

推荐答案

虽然我认为最好的答案是来自@valentin的一个，你可以不使用 csv module at all：

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)

这篇关于合并多个不含头的CSV文件（使用Python）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！