为了解决该问题,我创建了一个函数,该函数读取文件的第一行(标题)并检测定界符。
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 ";"


