您可以首先将CSV读取为文本，修改标题行以使每个列名唯一，然后将其读入DataFrame。

with open('data.csv', 'r') as f:
    lines = f.readlines()

header = lines[0].strip().split(',')

col_count = {}
new_header = []

for col in header:
    if col in col_count:
        col_count[col] += 1
        new_col = f"{col}_{col_count[col]}"
    else:
        col_count[col] = 1
        new_col = col
    new_header.append(new_col)

lines[0] = ','.join(new_header) + '\n'

with open('modified_data.csv', 'w') as f:
    f.writelines(lines)

df = pd.read_csv('modified_data.csv')

column2 = df['Row B'] column3 = df['Row B.1']

非常感谢.我学到了很多，也发现了另一种可能性，我在我的程序中实现了：我导入了除“B”列以外的所有列。然后我使用lambda函数导入所有“B”列，最后我合并了两者：

df = pd.read_csv('new.csv', header = 0, usecols = ["A", "C"], sep = ',')
df_1 = pd.read_csv('new.csv', header = 0, usecols = lambda x: x.startswith("B") | x.startswith("A"), sep = ',')
df = df.merge(left_on = "A", right_on = "A", right = df_1, how = "left")