cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
0 Kudos

Python Dataframe to JMP Datatable without intermediate csv

It looks like the interface between a python dataframe and a jmp datatable goes through a csv file. Is that true?

For example:

 

Python Init(Path("C:\Program Files (x86)\Microsoft Visual Studio\Shared\Python37_64\python37.dll"));
Python Submit( "\[import pandas as pd
df = pd.read_parquet('c:/temp/tst.parquet')
]\" );
dt = Python Get(df); // this method is saving the df as csv and then opens it in jmp. Is there a way to do that in memory
dt << New Data View;
Python Term();

 

In the above code I see JMP opening a progress bar for reading a csv during the Python Get(df) call. This is taking a very long time in large files.

We would like a way to import the data-frame to data-table w/o the time to save as csv and reading it

2 Comments
Ryan_Gilmore
Community Manager
Status changed to: Archived
We are archiving this request. If this is still important please comment with additional details and we will reopen. Thank you!
hogi
Level XI

Thanks for implementing this Wish in Jmp 18