topic Re: How do I save the eigenvalues from PCA into dataset? in Discussions

How do I save the eigenvalues from PCA into dataset?

gemmahodgson — Wed, 01 Feb 2017 15:05:06 GMT

I am using JMP Pro 13 doing PCA and although I can see all the output I need on the screen, I want to be able to extrct the eigenvalues and use them as weights for another anlaysis, so I need them in a dataset, but there doens't appear to be any option to get them out. The only thing I can save is the principal components...does anyone know how you can save the other parts of the output? Either via scripting or interactive is fine.

Thanks in advance

Gemma

Re: How do I save the eigenvalues from PCA into dataset?

Dan_Obermiller — Wed, 01 Feb 2017 16:02:09 GMT

Try right-clicking on the table and choose Make into Data Table.

Re: How do I save the eigenvalues from PCA into dataset?

gemmahodgson — Wed, 01 Feb 2017 17:35:26 GMT

Thanks for your quick answer Dan, I found that, however I need to do it lots of times (as I have to do 12 PCAs) so I wanted to run it in JSL as a script, where the PCA is done (by consumer) and the eigenvalues exported each time...any ideas on that?

Re: How do I save the eigenvalues from PCA into dataset?

txnelson — Wed, 01 Feb 2017 20:10:11 GMT

Here is a simple example of a script creating the Eigenvalue data table

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

pc=dt << Principal Components(
	Y( :NPN1, :PNP1, :PNP2, :NPN2, :PNP3 ),
	Estimation Method( "Default" ),
	"on Correlations",
	Eigenvalues( 1 ),
	SendToReport(
		Dispatch(
			{"Summary Plots"},
			"PCA Summary Plots",
			FrameBox,
			{Frame Size( 43, 40 )}
		),
		Dispatch(
			{"Summary Plots"},
			"PCA Summary Plots",
			FrameBox( 2 ),
			{Frame Size( 53, 40 )}
		)
	)
);
report(pc)["Eigenvalues"][1][1]<<make into data table;

Re: How do I save the eigenvalues from PCA into dataset?

jules — Wed, 01 Feb 2017 23:15:06 GMT

Hi Gemma,

If I'm understanding your question correctly you want to save the table of eigenvalues shown in the JMP PCA report for all the extracted components. If that's right, a simple way to do this is to right-click the table in the report and select "Make into Data Table."

I hope this helps!

Julian

Re: How do I save the eigenvalues from PCA into dataset?

jules — Wed, 01 Feb 2017 23:16:43 GMT

Oops, I see now that Jim already responded with a great method for handling this across many reports!

Re: How do I save the eigenvalues from PCA into dataset?

gemmahodgson — Thu, 02 Feb 2017 10:17:26 GMT

That's great thank you so much - I will try it now! Can't believe all the v quick replies - I was expecting to wait weeks!

Re: How do I save the eigenvalues from PCA into dataset?

louv — Thu, 02 Feb 2017 15:17:54 GMT