dbf轉excel - swuxyj

dbf轉excel

學校的成績是dbf格式的，要轉excel

首先pip安裝兩個要用到包pandas和dbfread

pip install pandas dbfread      

然後直接代碼：

import dbfread
import pandas as pd
file_name = "xscj (2).dbf"
table = dbfread.DBF(file_name, encoding=\'GBK\')
data = {}
for record in table:
    for field in record:
        if field not in data:
            data[field] = [record[field]]
        else:
            data[field].append(record[field])

df = pd.DataFrame(data)
df.to_excel(file_name[:-4] + ".xlsx", index=False)