Python integration get column properties

[#1]

Hi,

Is there a way to get column properties from JMP data table (such as "Design role" and "Factor changes") in python, if I use df = jmp.current() as a reference to the opened JMP data table?
I am aware of df[0].dtype and df[0].mtype to get data type and modeling type properties, but I would like to list the factors and responses in python from a DoE generated table.

Thanks!

[#2]

You can always fallback to run_jsl if some feature hasn't yet been implemented

[#3]

Sure, however the following code:

df = jmp.current()
sc = jmp.run_jsl('df << Get Column Names();')
print(sc)

returns the following error: Name Unresolved: df in access or evaluation of 'df' , df/*###*/

Any ideas? 

[#4]

JMP side doesn't know about your df python variables unless you "share" them. No idea what is preferred method, but you can for example use jmp.here

import jmp

dt = jmp.open(jmp.SAMPLE_DATA + 'Big Class.jmp')

jmp.here["dt"] = dt

jmp.run_jsl('''
	Names Default To Here(1);
	p = Column(dt, "name") << Get Property("Notes");	
'''
);

print(jmp.here.get('p'))

Or you could use Python Get from JMP side of things

import jmp

dt = jmp.open(jmp.SAMPLE_DATA + 'Big Class.jmp')

jmp.run_jsl('''
	dtref = Python Get(dt);
	p1 = Column(dtref, "name") << Get Property("Notes");	
'''
);

print(jmp.here.get('p1'))

[#5]

Very useful, thanks. Although when running:

df = jmp.current()
jmp.run_jsl('''
dt = Python Get( df );
cname = dt << Get Column Names();
''')
print(jmp.here.get('cname'))

I get "None" as output, despite obviously having some columns in my table.

Also, if using the script with "Names Default To Here(1)", my JMP crashes...

[#6 · Accepted solution]

You get None because you don't have access to here namespace. You can use Python Send

import jmp

jmp.open(jmp.SAMPLE_DATA + 'Big Class.jmp')

df = jmp.current()
jmp.run_jsl('''
dt = Python Get(df);
cname = dt << Get Column Names("string");
Python Send(cname);
''')

print(cname) # ['name', 'age', 'sex', 'height', 'weight']

[#7]

Many thanks jthi!
This works, not only due to using Python Send (because I tried that before), but also due to specifying "string" type for cname.

[#8]

Another question/wish: how would one scroll through all columns and check whether they have a "Design Role" or "Factor Changes" property, and list only those columns? 

[#9]

Do you want the result in Python list if one of those properties is found for the columns?

[#10]

Yes