cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
TheSource
Level II

Writing a data table in Python

I perform extensive post-processing in Python and then move that data to jmp for analysis. Is the data table format standardized or documented somehow so that I can write jmp files directly? Right now I am writing to an intermediate CSV and then importing which is just another step to go wrong.

 

The answer to a similar question from last year suggested that the user write their data to a JSL script but I'm hoping that there is a better answer out there.

Reference: https://community.jmp.com/t5/Discussions/How-to-convert-Python-Pandas-dataFrame-to-jmp-format-withou...

2 REPLIES 2

Re: Writing a data table in Python

Hi,


I think there is no other solution for the moment.

Please add Kudo to my idea wish list :)

 

https://community.jmp.com/t5/JMP-Wish-List/API-to-convert-csv-to-jmp-format/idi-p/187194

Guillaume

Re: Writing a data table in Python

I don't know if this still works, but it used to be possible to use the win32com module in Python to connect to COM servers.  This means you could use the JMP Automation interface.  There is some documentation here: http://timgolden.me.uk/pywin32-docs/html/com/win32com/HTML/QuickStartClientCom.html .

 

Once you connect to JMP, you can ask it to create a data table and then populate the individual rows and columns.  The JMP Automation Reference is included with the JMP installation in the Documentation folder.

 

This is definitely more on the advanced side, but once you get a connection creating the table is not hard.

 

Brian Corcoran

JMP Development