php 读csv跳过标题,python – 如何用csv.DictReader跳过预标题行？

我想要csv.DictReader从文件中推断字段名称.

The docs说“如果省略fieldnames参数,csvfile的第一行中的值将被用作字段名称”,但在我的情况下,第一行包含一个标题,第二行包含名称.

我不能按照Python 3.2 skip a line in csv.DictReader应用下一个(阅读器),因为在初始化读取器时会发生字段名称分配(或者我做错了).

csvfile(从Excel 2010,original source导出)：

CanVec v1.1.0,,,,,,,,,^M

Entity,Attributes combination,"Specification Code

Point","Specification Code

Line","Specification Code

Area",Generic Code,Theme,"GML - Entity name

Shape - File name

Point","GML - Entity name

Shape - File name

Line","GML - Entity name

Shape - File name

Area"^M

Amusement park,Amusement park,,,2260012,2260009,LX,,,LX_2260009_2^M

Auto wrecker,Auto wrecker,,,2360012,2360009,IC,,,IC_2360009_2^M

我的代码：

f = open(entities_table,'rb')

try:

dialect = csv.Sniffer().sniff(f.read(1024))

f.seek(0)

reader = csv.DictReader(f, dialect=dialect)

print 'I think the field names are:\n%s\n' % (reader.fieldnames)

i = 0

for row in reader:

if i < 20:

print row

i = i + 1

finally:

f.close()

当前结果：

I think the field names are:

['CanVec v1.1.0', '', '', '', '', '', '', '', '', '']

所期望的结果：

I think the field names are:

['Entity','Attributes combination','"Specification Code Point"',...snip]

我意识到简单地删除第一行并继续进行是有益的,但是我尽可能地尽可能靠近在原位读取数据,并尽量减少手动干预.