topic Re: Convert dbf to numpy array in Python Questions

Convert dbf to numpy array

AlexanderKeyel — Thu, 15 Dec 2011 21:02:09 GMT

I need to use Python to convert a data table in .dbf format generated by ArcGIS 10 to a Numpy array.

Is there a simple way to do this? Forgive me if this is a naive question, but I was unable to find anything on the help pages.

Thanks!

Re: Convert dbf to numpy array

ChrisSnyder — Thu, 15 Dec 2011 22:04:38 GMT

I don't have an example, but basically you would have to use a search cursor to loop through the fields and records.

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002z0000001q000000

Re: Convert dbf to numpy array

AlexanderKeyel — Fri, 16 Dec 2011 14:08:02 GMT

Thanks! I'm still pretty new to Python, so never would have found that.
Below is the code that I came up with:

from numpy import *
import arcpy

rows = arcpy.SearchCursor("Z://Code//EX2_near.dbf","","","","")

currentIN_FID = ""
currentNear_FID = ""
currentNear_Dist = ""
newdata = []

# Iterate through the rows in the cursor
#
for row in rows:
rowN = [row.IN_FID, row.NEAR_FID, row.NEAR_DIST]
newdata.append (rowN)

print newdata
datatwo = array([newdata])

Re: Convert dbf to numpy array

ChrisSnyder — Sat, 11 Dec 2021 20:03:44 GMT

Yep -

Also, if you wanted to "variabalize" the field names (use the field names as varaibles) it would look like:

from numpy import *
import arcpy
rows = arcpy.SearchCursor("Z://Code//EX2_near.dbf","","","","")
currentIN_FID = "IN_FID" 
currentNear_FID = "NEAR_FID"
currentNear_Dist = "NEAR_DIST"
newdata = []
# Iterate through the rows in the cursor 
for row in rows: 
   rowN = [row.getValue(currentIN_FID), row.getValue(currentNear_FID), row.getValue(currentNear_Dist)]
   newdata.append (rowN)
del row, rows #be sure to delete the cursor objects, otherwise a lock on the table will persist!!!
print newdata
datatwo = array([newdata])