CODEWITHSUNDEEP
pandascsvdataframesassas-jmp
Felix
Felix

Reputation: 1579

How to read JMP *.jmp file with Python Pandas into Pandas dataframe

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?

Upvotes: 3

Views: 8146

Answers (2)

user2558368
user2558368

Reputation: 41

One option is to use Julia language package JMPReader.jl. Assuming juliacall and pandas packages are installed

from juliacall import Main as jl
jl.seval("using JMPReader")
df = jl.readjmp("example1.jmp")
pt = jl.pytable(df, "pandas")

Upvotes: 0

arustictop
arustictop

Reputation: 86

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')

Upvotes: 7

Related Questions