This is a collection of information on PostgreSQL and PostGIS for what I tend to use most often.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |