cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Get the free JMP Student Edition for qualified students and instructors at degree granting institutions.
Choose Language Hide Translation Bar
View Original Published Thread

How to convert Python Pandas dataFrame to jmp format without saving it as files?

Kwangki
Level III

I know JMP support "Python Interface" function within JMP script envirornment. But somtimes it will be better to do co-work independently Python engineer and JMP one.

 

In our case, Python engineer read database files with DB interface, and makes pre-process with Pandas library, and wants to convert JMP format because JMP enginner need only JMP format data in order to do data analysis and post-process with JSL.

 

As you imagine, the bottleneck is how to convert Python Pandas dataFrame without saving it as files. The easiest way is to save files and read it as jmp format but it takes many times to save and read them. I'd like to know where there is any library to convert Python Pandas dataFrame to jmp format directly in memory or not.

11 REPLIES 11
lwx228
Level VIII


Re: How to convert Python Pandas dataFrame to jmp format without saving it as files?

JSON formats are too many to handle.

GoodwinJMP
Level I


Re: How to convert Python Pandas dataFrame to jmp format without saving it as files?

Thanks for the post back.   Would love to be able to simply open a .parquet file directly with JMP. 

 

We already use DB connections to fetch data,  but there are so many inefficiencies in using .csv in a full data pipelines (extraction writing,  storing,  reading),  we'd love to start using parquet.