python如何读取dbf文件_python读写dbf文件

读取遍历dBASE或Xbase文件中的记录。从Python的序列创建DBF文件。

import struct, datetime, decimal, itertools

def dbfreader(f):

"""Returns an iterator over records in a Xbase DBF file.

The first row returned contains the field names.

The second row contains field specs: (type, size, decimal places).

Subsequent rows contain the data records.

If a record is marked as deleted, it is skipped.

File should be opened for binary reads.

"""

# See DBF format spec at:

# http://www.pgts.com.au/download/public/xbase.htm#DBF_STRUCT

numrec, lenheader = struct.unpack('

numfields = (lenheader - 33) // 32

fields = []

for fieldno in xrange(numfields):

name, typ, size, deci = struct.unpack('<11sc4xBB14x', f.read(32))

name = name.replace('\0', '') # eliminate NULs from string

fields.append((name, typ, size, deci))

yield [field[0] for field in fields]

yield [tuple(field[1:]) for field in fields]

terminator = f.read(1)

assert terminator == '\r'

fields.insert(0, ('DeletionFlag', 'C', 1, 0))

fmt = ''.join(['%ds' % fieldinfo[2] for fieldinfo in fields])

fmtsiz = struct.calcsize(fmt)

for i in xrange(numrec):

record = struct.unpack(fmt, f.read(fmtsiz))

if record[0] != ' ':

continue # deleted record

result = []

for (name, typ, size, deci), value in itertools.izip(fields, record):

if name == 'DeletionFlag':

continue

if typ == "N":

value = value.replace('\0', '').lstrip()

if value == '':

value = 0

elif deci:

value = decimal.Decimal(value)

else:

value = int(value)

elif