有人熟悉Comfirmit的数据格式吗？
我最近询问了有关从 SPSS 访问数据的问题，并在这里得到了一些非常好的帮助。我现在有几乎相同的需要，从Confirmit 数据文件中读取数据。在网络上找不到大量确认数据文件格式。看来Confirmit 可以导出到SPSS *.sav 文件。这对我来说可能是一种途径。确切的需求如下：
我需要能够从使用ConfirmIt完成的市场研究中提取两种不同但相关类型的信息：
我需要能够发现数据“模式”，例如正在提出什么问题询问（问题的文本）以及答案的类型是什么（多项选择、是/否、文本）以及与每个答案关联的文本标签。
我需要能够阅读受访者的答案并填充我的数据模型。因此，对于上述步骤 1 中发现的每个问题，我需要构建一个受访者答案表。
借助 SPSS，这一切变得很容易，这要归功于 IBM 免费提供的数据访问模块和 Albert-Jan Roskam 提供的漂亮的 Python 包装器。谷歌搜索我没有找到太多信息。对此的任何见解都会有所帮助。像 Python 或 Java 类这样的东西来读取确认数据将是完美的！
假设我的最佳选择最终是导出到 SPSS *.sav 文件，有谁知道它是否能满足我上面的两个用例（包含问题、答案架构并包含每个参与者的结果）？
I recently asked about accessing data from SPSS and got some absolutely wonderful help here. I now have an almost identical need to read data from a Confirmit data file. Not finding a ton of confirmit data file format on the web. It appears that Confirmit can export to SPSS *.sav files. This might be one avenue for me. Here's the exact needs:
I need to be able to extract two different but related types of info from a market research study done using ConfirmIt:
I need to be able to discover the data "schema", as in what questions are being asked (the text of the questions) and what the type of the answer is (multiple choice, yes/no, text) and what text labels are associated with each answer.
I need to be able to read respondents answers and populate my data model. So for each of the questions discovered as part of step 1 above, I need to build a table of respondent answers.
With SPSS this was easy thanks to a data access module available freely available by IBM and a nice Python wrapper by Albert-Jan Roskam. Googling I'm not finding much info. Any insight into this is helpful. Something like a Python or Java class to read the confirmit data would be perfect!
Assuming my best option ends up being to export to SPSS *.sav file, does anyone know if it will meet both of my use cases above (contain the questions, answers schema and also contain each participant's results)?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您可以从Confirmit的Excel定义导出中获取数据架构
You can get the data schema from Excel definition export from Confirmit
You can export from Confirmit txt file with the same template
最近我收到了一份来自confirmit的数据集。 Excel 文件中有近 4000 列。我想将它输入到 mysql 数据库中。他们不可能只从一张表中进行输出。您知道表模式如何用于确认吗？
I was recently given a data set from confirmit. There are almost 4000 columns in the excel file. I want to enter it into a mysql db. There is not way they are just doing that output from one table. Do you know how the table schema works for confirmit?