Convert .csv file into .dbf using Python?

python csv python-3.x dbf
djq picture djq · Dec 14, 2010 · Viewed 10.6k times · Source

How can I convert a .csv file into .dbf file using a python script? I found this piece of code online but I'm not certain how reliable it is. Are there any modules out there that have this functionality?

Answer

Ethan Furman picture Ethan Furman · Jul 13, 2011

Using the dbf package you can get a basic csv file with code similar to this:

import dbf
some_table = dbf.from_csv(csvfile='/path/to/file.csv', to_disk=True)

This will create table with the same name and either Character or Memo fields and field names of f0, f1, f2, etc.

For a different filename use the filenameparameter, and if you know your field names you can also use the field_names parameter.

some_table = dbf.from_csv(csvfile='data.csv', filename='mytable',
        field_names='name age birth'.split())

Rather basic documentation is available here.

Disclosure: I am the author of this package.

Related questions

csv.Error: iterator should return strings, not bytes

Sample.csv contains the following: NAME Id No Dept Tom 1 12 CS Hendry 2 35 EC Bahamas 3 21 IT Frank 4 61 EE And the Python file contains the following code: import csv ifile = open('sample.csv', "rb") read = csv.reader(ifile) for row in read : …

Read More
How to add a new column to a CSV file?

I have several CSV files that look like this: Input Name Code blackberry 1 wineberry 2 rasberry 1 blueberry 1 mulberry 2 I would like to add a new column to all CSV files so that it would look like this: Output Name Code Berry …

Read More
TypeError: a bytes-like object is required, not 'str' in python and CSV

TypeError: a bytes-like object is required, not 'str' getting above error while Executing below python code to save the HTML table data in Csv file. don't know how to get rideup.pls help me. import csv import requests from bs4 …

Read More