cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
%3CLINGO-SUB%20id%3D%22lingo-sub-712901%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ECopie%20y%20pegue%20la%20tabla%20de%20medias%20y%20desviaci%C3%B3n%20est%C3%A1ndar%20de%20un%20an%C3%A1lisis%20unidireccional.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-712901%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%C2%A1Hola%20a%20todos!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEs%20la%20primera%20vez%20que%20publico%20aqu%C3%AD%2C%20as%C3%AD%20que%20me%20disculpo%20si%20me%20pierdo%20algo.%20Escrib%C3%AD%20un%20script%20que%20esencialmente%20crea%20un%20an%C3%A1lisis%20unidireccional%20para%20los%20datos%20importados%20por%20el%20usuario.%20Me%20preguntaba%20si%20era%20posible%20extraer%20(copiar%20y%20pegar)%20la%20tabla%20%22Medias%20y%20desviaciones%20est%C3%A1ndar%22%20en%20una%20tabla%20diferente%20en%20JSL.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEx%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20style%3D%22width%3A%20266px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20style%3D%22width%3A%20266px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20style%3D%22width%3A%20266px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20style%3D%22width%3A%20266px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20style%3D%22width%3A%20266px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20style%3D%22width%3A%20266px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20style%3D%22width%3A%20266px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20style%3D%22width%3A%20266px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20style%3D%22width%3A%20266px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20style%3D%22width%3A%20266px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F60127i4B2D68594D2AE9DA%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22OhThatArabGuy_1-1703880407651.png%22%20alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-712901%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3EAutomatizaci%C3%B3n%20y%20secuencias%20de%20comandos%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAn%C3%A1lisis%20y%20modelado%20de%20datos%20b%C3%A1sicos%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eventanas%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-712908%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Copiar%20y%20pegar%20la%20tabla%20de%20medias%20y%20desviaci%C3%B3n%20est%C3%A1ndar%20de%20un%20an%C3%A1lisis%20unidireccional.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-712908%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EAqu%C3%AD%20hay%20un%20ejemplo%20que%20muestra%20c%C3%B3mo%20tomar%20la%20tabla%20de%20Medias%20y%20Est%C3%A1ndares%20completa%20y%20crear%20una%20nueva%20tabla%20de%20datos%20a%20partir%20de%20ella%20y%20tambi%C3%A9n%20un%20ejemplo%20de%20c%C3%B3mo%20tomar%20una%20columna%20espec%C3%ADfica%20de%20la%20tabla%20de%20estad%C3%ADsticas%20y%20agregarla%20a%20la%20tabla%20de%20datos%20actual.%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Enames%20default%20to%20here(1)%3B%0Adt%3Dopen(%22%24SAMPLE_DATA%2Fbig%20class.jmp%22)%3B%0A%0AOneway(%0A%20Y(%20%3Aheight%20)%2C%0A%20X(%20%3Asex%20)%2C%0A%20Quantiles(%201%20)%2C%0A%20Means%20and%20Std%20Dev(%201%20)%2C%0A%20t%20Test(%201%20)%2C%0A%20Box%20Plots(%201%20)%2C%0A%20Mean%20Error%20Bars(%201%20)%2C%0A%20Std%20Dev%20Lines(%201%20)%0A)%3B%0A%0AtheReport%20%3D%20current%20report()%3B%0A%0A%2F%2F%20Create%20it%20own%20new%20table%0AtheReport%5B%22Means%20and%20Std%20Deviations%22%2C%20TableBox(1)%5D%20%26lt%3B%26lt%3B%20make%20into%20data%20table%3B%0A%0A%2F%2F%20and%2For%20add%20the%20data%20to%20the%20current%20data%20table%0Adt%20%26lt%3B%26lt%3B%20new%20column(%20%22Mean%22%20)%3B%0AtheMeans%20%3D%20theReport%5B%22Means%20and%20Std%20Deviations%22%2C%20NumberColBox(2)%5D%20%26lt%3B%26lt%3B%20get%3B%0Adt%3AMean%20%26lt%3B%26lt%3B%20set%20values(%20theMeans%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar

Copy pasting means and std deviation table from a Oneway analysis.

Hello all!

 

First time posting here so I apologize if I miss anything. I wrote script which essentially creates a oneway analysis for user imported data. I was wondering if it was possible to extract (copy paste) the "Means and Std Deviations" table to a different table in JSL.

 

Ex:

OhThatArabGuy_1-1703880407651.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Copy pasting means and std deviation table from a Oneway analysis.

Here is an example that shows how to take the complete Means and Std table and create a new data table from it and also and example of how to take a specific column of the stat table and add it to the current data table.

names default to here(1);
dt=open("$SAMPLE_DATA/big class.jmp");

Oneway(
	Y( :height ),
	X( :sex ),
	Quantiles( 1 ),
	Means and Std Dev( 1 ),
	t Test( 1 ),
	Box Plots( 1 ),
	Mean Error Bars( 1 ),
	Std Dev Lines( 1 )
);

theReport = current report();

// Create it own new table
theReport["Means and Std Deviations", TableBox(1)] << make into data table;

// and/or add the data to the current data table
dt << new column( "Mean" );
theMeans = theReport["Means and Std Deviations", NumberColBox(2)] << get;
dt:Mean << set values( theMeans );
Jim

View solution in original post

1 REPLY 1
txnelson
Super User

Re: Copy pasting means and std deviation table from a Oneway analysis.

Here is an example that shows how to take the complete Means and Std table and create a new data table from it and also and example of how to take a specific column of the stat table and add it to the current data table.

names default to here(1);
dt=open("$SAMPLE_DATA/big class.jmp");

Oneway(
	Y( :height ),
	X( :sex ),
	Quantiles( 1 ),
	Means and Std Dev( 1 ),
	t Test( 1 ),
	Box Plots( 1 ),
	Mean Error Bars( 1 ),
	Std Dev Lines( 1 )
);

theReport = current report();

// Create it own new table
theReport["Means and Std Deviations", TableBox(1)] << make into data table;

// and/or add the data to the current data table
dt << new column( "Mean" );
theMeans = theReport["Means and Std Deviations", NumberColBox(2)] << get;
dt:Mean << set values( theMeans );
Jim