如题。我现在知道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()