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
Choose Language Hide Translation Bar
joaquimgui
Level II

Plot 3D Diagram

Hello,

I am trying to plot a 3D diagram but unsuccessful. I have the data in Excel like this:

 Y4,1581575710,5410784
X Z1Z2
0,00038225 0,047405620,09242527
0,00032384 0,13448339

0,34250103

But I have a lot of rows and columns. This is just an example. I would appreciate any help.

Thanks.

 

11 REPLIES 11
joaquimgui
Level II

Re: Plot 3D Diagram

The code works pretty good. I found out that I don't have enough memory available to run all the rows 104,284,944, that's why it didn't run.

 

I am using JMP 12.

 

Thank you very much.

ian_jmp
Level X

Re: Plot 3D Diagram

'Daten.xlsx' has 23 Y values, 444 X values a Z value for each (10212 values in all). So shouldn't 'dtFinal' be:

dtFinal = New Table( "Converted", New Column( "X" ), New Column( "Y" ), New Column( "Z" ) );
dtFinal << add rows( N Rows( Xmat ) * N Rows( Ymat ) );

rowcnt = 0;

For( Xcnt = 1, Xcnt <= N Rows( Xmat ), Xcnt++,
	For( Ycnt = 1, Ycnt <= N Rows( Ymat ), Ycnt++,
		rowcnt++;
		dtFinal:X[rowcnt] = Xmat[Xcnt];
		dtFinal:Y[rowcnt] = Ymat[Ycnt];
		dtFinal:Z[rowcnt] = Zmat[Xcnt, Ycnt];
	)
);

givinhg somethkng like?

Screen Shot 2017-11-27 at 10.35.09.png

Without knowing anything about the data context and what you are attempting, I imagine that more informative visualisations are possible.