如何使用 Python Pandas 将 JMP *.jmp 文件读入 Pandas 数据帧

作者: wangkx1990
来源: 51数据库
2022-10-20

问题描述

我很难用 Pandas read_csv<阅读 SAS JMP 文件/code> 函数到 Pandas 数据帧中.有人对这种类型的数据文件有经验吗?什么是最有效的方法?

I am struggling to read SAS JMP files with Pandas read_csv function into Pandas dataframe. Does anyone have experience with this type of data file? What is the most efficient way?

推荐答案

这对我有用.它的结果有时有点出乎意料(例如，有时我得到没有标题的 CSV，即使在 JMP 中有它们).不幸的是，您需要安装 SAS JMP，而且此解决方案仅适用于 Windows.

This has worked for me. Its results are sometimes a bit unexpected (for example, sometimes I get CSVs without headers, even though in JMP they have them). Unfortunately, you need to have SAS JMP installed and this solution only works on Windows.

import pandas as pd
from win32com.client import Dispatch

jmp = Dispatch("JMP.Application")
doc = jmp.OpenDocument('sasjmpfile.jmp')
doc.SaveAs('sasjmpfile.csv')

df = pd.read_csv('sasjmpfile.csv')

推荐阅读