python dbf转excel,使用Python将.csv文件转换为.dbf？

最新推荐文章于 2020-12-24 13:34:45 发布

要最好的

最新推荐文章于 2020-12-24 13:34:45 发布

阅读量341

点赞数

文章标签： python dbf转excel

在Python中将CSV文件转换为DBF文件需要指定字段类型、大小和小数位数。此任务没有现成的简单解决方案，因为每个DBF格式对应不同的软件版本。你需要了解目标DBF文件的格式要求，如dBaseIII、dBase4或VisualFoxPro等。对于简单的dBaseIII格式，不包含非ASCII文本且字段长度小于254字节的情况，可以使用找到的在线代码。确保你的Python版本符合要求。

摘要由CSDN通过智能技术生成

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?

解决方案

You won't find anything on the net that reads a CSV file and writes a DBF file such that you can just invoke it and supply 2 file-paths. For each DBF field you need to specify the type, size, and (if relevant) number of decimal places.

Some questions:

What software is going to consume the output DBF file?

There is no such thing as "the" (one and only) DBF file format. Do you need dBase III ? dBase 4? 7? Visual FoxPro? etc?

What is the maximum length of text field that you need to write? Do you have non-ASCII text?

Which version of Python?

If your requirements are minimal (dBase III format, no non-ASCII text, text <= 254 bytes long, Python 2.X), then the cookbook recipe that you quoted should do the job.