Python读取DBF文件并保存为CSV文件的几种方法

1. 直接按列表读取DBF

input=f"H:/1.dbf"
table = DBF(input, encoding='utf-8')
   #writer.writerow(table.field_names)#写入表头
for record in table:
     print(record)

2.以Pands读取DBF，然后读取列表数据保存

with open(out, 'w', encoding='utf-8', newline="") as f:
           data = DBF(InitailData_path, encoding='utf-8')
           df = pd.DataFrame(iter(data))
           # print(df[0])
           for i in range(len(df)):
               row = df.iloc[i].values.tolist()
               # print(row)
               csv_writer = csv.writer(f)
               csv_writer.writerow([row[3]])
               flag+=1
               print(flag)

3.以Datafame形式读取直接用to_csv方法直接保存

import pandas as pd
from dbfread import DBF
path = r'C:/Users/pc/Desktop/有向图数据/正式代码处理/成都点邻接.dbf' # 文件目录
table = DBF(path)
df = pd.DataFrame(iter(table))
df.to_csv("C:/Users/pc/Desktop/有向图数据/正式代码处理文件/成都点邻接.csv",index_label="FID")