如何用python将dbf文件转成dataframe

如题。我现在知道pandas里有read_sql,不过不知道里面的参数怎么填。因为我就用到一个dbf,不涉及数据库,平时也是用vfp来打开。现在想将它读进Python,所以求教各位大神!

←如果以下回答对你有帮助,请点击右边的向上箭头及采纳下答案

需要外部库dbfread

import dbfread
def readDbfFile(filename):
    table = dbfread.DBF(filename, encoding='GBK')
    for field in table.fields:
        print(field)

https://www.cnblogs.com/zhugaopeng/p/9745800.html


#!/usr/bin/python3
# -*- coding:utf-8 -*-
__author__ = 'mayi'

#导入模块
from dbfread import DBF

#数据表文件名
table = DBF('test.dbf')

#遍历数据表中(没加删除标志)的记录
for record in table:
    for field in record:
        print(field, "=", record[field], end = ",")
    print()

print("*" * 40)

#遍历数据表中(加了删除标志)的记录
for record in table.deleted:
    for field in record:
        print(field, "=", record[field], end = ",")
    print()