有什么方法可以找到多个CSV头之间的多个文件名之间的交集吗?

你似乎想:

1. 识别.csv文件
2. 抓住标题

glob 是最好的。

import glob

csvs = glob.glob('PATH_TO_CSV_DIR' + '*.csv')

然后,我将创建一个主集,您可以将每个新.csv的标题与之进行比较:

import pandas as pd

master_set = set()

for file in csvs:
    this_df = pd.read_csv(file)
    cols = set(this_df.columns)
    master_set = master_set.intersection(cols)

是的,您可以这样做,但需要在文件列表上循环并存储结果。作为一个示例,下面是代码。

import pandas as pd
df1 = pd.read_csv("File1.csv")
df2 = pd.read_csv("File2.csv")
setA = set(df1.columns)
setB = set(df2.columns)
common = setA.intersection(setB)

我用下面的方法解决了这个问题。该代码适用于任意数量的CSV文件。

import pandas as pd
import csv
import glob

path = r'PATH_TO_CSV_DIR' # use your path
all_files = glob.glob(path + "/*.csv")
df1 = pd.read_csv('PATH_TO_CSV_DIR/c15.csv') # to initialize the master_set
master_set = set(df1.columns)

for file in all_files:
    this_df = pd.read_csv(file)
    cols = set(this_df.columns)
    master_set = master_set.intersection(cols)

w = csv.writer(open("CommonColumns.csv","w")) #it gives a CSV file of common header. The common header can be used later for other operations. 
w.writerow(master_set)
print(master_set)