topic Re: Delete all fields except those specified in Python Questions

Delete dbf fields

StefaniGermanotta — Mon, 01 Apr 2013 21:48:28 GMT

I have a dbf table with four fields: OID,TYPE,FREQUENCY,COUNT.

I only want to keep TYPE. I got this script off this forum and modified it to fit my data but it is not working. Is that because it is a dbf file? It returns the correct fields for the "print field" command. Any other suggesestions?

test_dbf = "C:\\TempData\\testdata.dbf"

data_description = arcpy.Describe(test_dbf)
fields = [f.name for f in data_description.fields if f.type not in ["Geometry", "Raster", "Blob"]]

#fields = [f.name for f in arcpy.ListFields(test_dbf)  <> 'Geometry'] # This didn't work either
print fields

for i,f in enumerate(fields):
    if f == 'OID' or f == 'FREQUENCY' or f == 'COUNT':
        del fields

Thank you in advance

Re: Delete all fields except those specified

curtvprice — Sat, 11 Dec 2021 07:28:29 GMT

I have a dbf table with four fields: OID,TYPE,FREQUENCY,COUNT.

I only want to keep TYPE.

This should do what you want (except you can't delete the object ID field):

test_dbf = "C:\\TempData\\testdata.dbf"
# one of more fields to keep in a list
keepers = ["TYPE"]
# list all field delete candidates
fields  = [f.name for f in arcpy.Describe(test_dbf).Fields \
    if f.type not in ["Geometry, "Raster", "BLOB", "OID"]]
# remove  TYPE field from delete list
fields  = [f for f in fields if f.upper() not in keepers]
arcpy.DeleteFields_management(test_dbf, fields)

Re: Delete all fields except those specified

StefaniGermanotta — Sat, 11 Dec 2021 07:28:32 GMT

This should do what you want (except you can't delete the object ID field):

test_dbf = "C:\\TempData\\testdata.dbf"
# one of more fields to keep in a list
keepers = ["TYPE"]
# list all field delete candidates
fields  = [f.name for f in arcpy.Describe(test_dbf).Fields \
    if f.type not in ["Geometry, "Raster", "BLOB", "OID"]]
# remove  TYPE field from delete list
fields  = [f for f in fields if f.upper() not in keepers]
arcpy.DeleteFields_management(test_dbf, fields)

Pesky OID. I don't want this field either. I will eventually be exporting to csv file but it doesn't seem any easier to get rid of it as a csv either.

Re: Delete dbf fields

RDHarles — Tue, 02 Apr 2013 11:43:54 GMT

In a bind, I've used this program (CSVed), can do just about anything to a csv file...

http://csved.sjfrancke.nl/#csved