topic Re: Writing a data table in Python in Discussions

Writing a data table in Python

TheSource — Mon, 11 Mar 2019 21:26:11 GMT

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-without/m-p/58173#M32298

Re: Writing a data table in Python

guillaumebugnon — Thu, 21 Mar 2019 09:33:54 GMT

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

Re: Writing a data table in Python

briancorcoran — Thu, 21 Mar 2019 12:01:59 GMT

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