读取带有两个或多个分隔符的csv文件时出现分析错误

2024-10-03 17:23:23 发布

您现在位置:Python中文网/ 问答频道 /正文

样本数据

354;monojet_Zp2000.0_DM_50.0;2.44336e-05;832841;-1.22431;b,947383,824498,-0.523103,1.64421;j,258722,243675,0.328962,2.25014;j,520092,108590,-2.2473,-1.85679;j,383024,88405.6,2.14516,-1.95635;j,39507.6,35365.1,0.47046,-1.16445;j,225430,26878.2,-2.81608,-2.25938;
354;monojet_Zp2000.0_DM_50.0;2.44336e-05;

这是我的测试代码:

df=pd.read_csv('monojet_Zp2000.0_DM_50.0_chan3.csv',
              sep=';|,',
              engine='python',
              header=None)

运行时,我会遇到以下错误:

ParserError: Expected 262 fields in line 6, saw 273. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.

Tags: csv数据nonedfreaddmenginesep