python - Pandas 解析 csv 错误 - 预期 1 个字段找到 9

Question

我正在尝试从 .csv 文件中解析:

planets = pd.read_csv("planets.csv", sep=',')

但我总是以这个错误结束:

ParserError: Error tokenizing data. C error: Expected 1 fields in line 13, saw 9

我的 csv 文件的前几行是这样的:

# This file was produced by the test
# Tue Apr  3 06:03:27 2018
#
# COLUMN pl_hostname:    Host Name
# COLUMN pl_discmethod:  Discovery Method
# COLUMN pl_pnum:        Number of Planets in System
# COLUMN pl_orbper:      Orbital Period [days]
# COLUMN pl_orbsmax:     Orbit Semi-Major Axis [AU])
# COLUMN st_dist:        Distance [pc]
# COLUMN st_teff:        Effective Temperature [K]
# COLUMN st_mass:        Stellar Mass [Solar mass] 
#
loc_rowid,pl_hostname,pl_discmethod,pl_pnum,pl_orbper,pl_orbsmax,st_dist,st_teff,st_mass
1,11 Com,Radial Velocity,1,326.03000000,1.290000,110.62,4742.00,2.70
2,11 UMi,Radial Velocity,1,516.22000000,1.540000,119.47,4340.00,1.80
3,14 And,Radial Velocity,1,185.84000000,0.830000,76.39,4813.00,2.20
4,14 Her,Radial Velocity,1,1773.40000000,2.770000,18.15,5311.00,0.90
5,16 Cyg B,Radial Velocity,1,798.50000000,1.681000,21.41,5674.00,0.99
6,18 Del,Radial Velocity,1,993.30000000,2.600000,73.10,4979.00,2.30
7,1RXS J160929.1-210524,Imaging,1,,330.000000,145.00,4060.00,0.85

编辑:这是第 13 行:

loc_rowid,pl_hostname,pl_discmethod,pl_pnum,pl_orbper,pl_orbsmax,st_dist,st_teff,st_mass

编辑:感谢@Rakesh，跳过前 12 行解决了问题

行星 = pd.read_csv("行星.csv", sep=',', skiprows=12)

Answer 1

函数pandas.read_csv()从第一行获取列数及其名称。默认情况下，它不考虑第一行作为注释的选项。

发生的事情是 pandas 读取第一行，将其拆分并发现只有一列，插入拆分到第 13 行，第一个未注释的行。要解决这个问题，可以使用参数 comment。

planets = pd.read_csv("planets.csv", comment='#')

与使用 skiprows 相比，这允许相同的代码加载 planets.csv 文件，即使注释行的数量不同也是如此。