Skip to content

Instantly share code, notes, and snippets.

@ryan-hill
Last active July 3, 2023 16:09
Show Gist options
  • Save ryan-hill/f90b1c68f60d12baea81 to your computer and use it in GitHub Desktop.
Save ryan-hill/f90b1c68f60d12baea81 to your computer and use it in GitHub Desktop.
Import DBF file to Pandas data frame in Python
import pysal as ps
import pandas as pd
'''
Arguments
---------
dbfile : DBF file - Input to be imported
upper : Condition - If true, make column heads upper case
'''
def dbf2DF(dbfile, upper=True): #Reads in DBF files and returns Pandas DF
db = ps.open(dbfile) #Pysal to open DBF
d = {col: db.by_col(col) for col in db.header} #Convert dbf to dictionary
#pandasDF = pd.DataFrame(db[:]) #Convert to Pandas DF
pandasDF = pd.DataFrame(d) #Convert to Pandas DF
if upper == True: #Make columns uppercase if wanted
pandasDF.columns = map(str.upper, db.header)
db.close()
return pandasDF
@rutgerhofste
Copy link

Is pysal still a supported library. Fails to install in virtualenv

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment