Skip to content

Instantly share code, notes, and snippets.

@vmanyushin
Created March 30, 2016 21:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save vmanyushin/57841023fb4cbe76ad922302d7007315 to your computer and use it in GitHub Desktop.
Save vmanyushin/57841023fb4cbe76ad922302d7007315 to your computer and use it in GitHub Desktop.
Convert dbf to csv
#!/usr/bin/python
import csv
from dbfpy import dbf
import os
import sys
filename = sys.argv[1]
if filename.endswith('.dbf'):
print "Converting %s to csv" % filename
csv_fn = filename[:-4]+ ".csv"
with open(csv_fn,'wb') as csvfile:
in_db = dbf.Dbf(filename)
out_csv = csv.writer(csvfile)
names = []
for field in in_db.header.fields:
names.append(field.name)
out_csv.writerow(names)
for rec in in_db:
out_csv.writerow(rec.fieldData)
in_db.close()
print "Done..."
else:
print "Filename does not end with .dbf"
@vmanyushin
Copy link
Author

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