将dBase / Paradox数据读入R吗？ [英] Read dBase / Paradox data into R?

问题描述

我继承了大约一百个数据库文件，这些文件目前正在使用 Paradox dBase Access Reader进行读取，然后手动导出到以竖线分隔的文本文件。我很乐意使用某种访问库来做到这一点，它可以让我直接将这些文件读入R。

I have a hundred or so database files I inherited that I'm currently reading with "Paradox dBase Access Reader", and exporting manually to pipe-delimited text files. I'd LOVE to do this with some kind of access library that would let me read these files directly into R.

阅读器工具指出，这些文件是 Paradox 5.0 Windows，并且在它们上有 .db 扩展名。

The reader tool states that these files are "Paradox 5.0 for Windows", and they have a .db extension on them.

我希望我可以使用外国包可以读取它们，因为它在文档中指出了 read.dbf（）函数：

I was hopeful that I could use the foreign package to read them, because it states in the docs for the read.dbf() function:

DBF是文件的扩展名为
数据库语言的 XBASE系列编写，涵盖了dBase，Clipper，FoxPro及其与Windows NT等效的
Visual dBase，Visual Objects和Visual FoxPro，
以及一些较旧的产品

DBF is the extension used for files written for the ‘XBASE’ family of database languages, covering the dBase, Clipper, FoxPro, and their Windows equivalents Visual dBase, Visual Objects, and Visual FoxPro, plus some older products’

不幸的是，它在 DBFOpen C函数中失败，位于425行附近：

Unfortunately, it fails in the DBFOpen C function, at around line 425:

if( fread( pabyBuf, nHeadLen-32, 1, psDBF->fp ) != 1 )
{
  fclose( psDBF->fp );
  free( pabyBuf );
  free( psDBF );
  return NULL;
}

任何人都有其他解决方案，或者了解 read是否.dbf（）在这里是好是坏？

Anyone have other solutions, or insight into whether read.dbf() is a good or bad match here?

推荐答案

搜索 paradox db 在rseek.org 上产生 gnumeric软件包，表示它可以读取Paradox文件。我没有任何方法可以测试该功能，但它可能会起作用...

A search for "paradox db" on rseek.org yields the gnumeric package, which says it can read Paradox files. I don't have any way to test that functionality, but it just might work...

这篇关于将dBase / Paradox数据读入R吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！