topic Re: How to change the variables name in PCA loading scatter plot? in Discussions

How to change the variables name in PCA loading scatter plot?

sofiasousa24 — Mon, 29 May 2023 16:46:40 GMT

Hello,

I'm trying to change the variables name in loading scatter plot but I can't. The variables included in PCA analysis are from two linked data tables. I'd like to change the columns name to new abbreviation names.

Thank you very much in advance.

Re: How to change the variables name in PCA loading scatter plot?

Mark_Bailey — Tue, 30 May 2023 16:06:06 GMT

The names of the variables in the loadings plot are the names of the data columns. Change the column names before the PCA.

Re: How to change the variables name in PCA loading scatter plot?

ih — Tue, 30 May 2023 20:51:24 GMT

If for whatever reason you don't want to rename the columns, you could make calculated columns when launching the platform. Here is one table with a PCA showing the original names and one with shorter names:

Names Default To Here( 1 );

dt = Open( "$Sample_data/Quality Control/Chemical Reactor Process.jmp" );

New window("PCA Compare",
	h list box(
		dt << Principal Components(
			Y( :A.Feed.S1, :D.Feed.S2, :E.Feed.S3, :Total.Feed.S4 ),
			Estimation Method( "Row-wise" ),
			Standardize( "Standardized" ),
			Loading Plot( 2 )
		),

		dt << Principal Components(
			Transform Column( "S1", Formula( :A.Feed.S1 ) ),
			Transform Column( "S2", Formula( :D.Feed.S2 ) ),
			Transform Column( "S3", Formula( :E.Feed.S3 ) ),
			Transform Column( "S4", Formula( :Total.Feed.S4 ) ),
			Y( :S1, :S2, :S3, :S4 ),
			Estimation Method( "Row-wise" ),
			Standardize( "Standardized" ),
			Loading Plot( 2 )
		);
	)
);