我可以导入CSV文件并自动推断定界符吗？

Question

我想导入两种CSV文件，有些使用“;” 对于定界符，其他使用“，”。到目前为止，我一直在接下来的两行之间切换：

reader=csv.reader(f,delimiter=';')

要么

reader=csv.reader(f,delimiter=',')

是否可以不指定分隔符，而让程序检查正确的分隔符？

下面的解决方案（Blender和sharth）对于用逗号分隔的文件（由Libroffice生成）似乎效果很好，但对于以分号分隔的文件（由MS
Office生成）却不起作用。这是一个用分号分隔的文件的第一行：

ReleveAnnee;ReleveMois;NoOrdre;TitreRMC;AdopCSRegleVote;AdopCSAbs;AdoptCSContre;NoCELEX;ProposAnnee;ProposChrono;ProposOrigine;NoUniqueAnnee;NoUniqueType;NoUniqueChrono;PropoSplittee;Suite2LecturePE;Council PATH;Notes
1999;1;1;1999/83/EC: Council Decision of 18 January 1999 authorising the Kingdom of Denmark to apply or to continue to apply reductions in, or exemptions from, excise duties on certain mineral oils used for specific purposes, in accordance with the procedure provided for in Article 8(4) of Directive 92/81/EEC;U;;;31999D0083;1998;577;COM;NULL;CS;NULL;;;;Propos* are missing on Celex document
1999;1;2;1999/81/EC: Council Decision of 18 January 1999 authorising the Kingdom of Spain to apply a measure derogating from Articles 2 and 28a(1) of the Sixth Directive (77/388/EEC) on the harmonisation of the laws of the Member States relating to turnover taxes;U;;;31999D0081;1998;184;COM;NULL;CS;NULL;;;;Propos* are missing on Celex document

Answer 1

为了解决该问题，我创建了一个函数，该函数读取文件的第一行（标题）并检测定界符。

def detectDelimiter(csvFile):
    with open(csvFile, 'r') as myCsvfile:
        header=myCsvfile.readline()
        if header.find(";")!=-1:
            return ";"
        if header.find(",")!=-1:
            return ","
    #default delimiter (MS Office export)
    return ";"