topic Re: How to exclude data points starting with a specific word from a PCA and followed by a graph builder? in Discussions

How to exclude data points starting with a specific word from a PCA and followed by a graph builder?

WhiteCow2000 — Tue, 04 Mar 2025 09:48:06 GMT

Hi,

I have a dataset where the sample name for some data points start with "Bad...". I want to exclude these data points starting with "Bad" from a PCA but they should still be visible in the plot.

After PCA I plot the PC1 and PC2 in graph builder and here I also want the same datapoints to be excluded but visible in the graph.

Is there a way to script this in JSL? So I don't need to manually exclude the data point from the data table.

I'm using JMP18.

Hope you can help.

Re: How to exclude data points starting with a specific word from a PCA and followed by a graph builder?

jthi — Tue, 04 Mar 2025 16:06:24 GMT

You can use Select Where with Starts With to select those rows and then exclude them

Current Data Table() << Select Where(Starts With(:sample, "Bad")) << Exclude(1);

Then in graph builder, hold shift and click on red triangle to select show excluded rows

If you wish to show the values in Principal Components platform I think you would have to write a script for that using graphic script

Re: How to exclude data points starting with a specific word from a PCA and followed by a graph builder?

WhiteCow2000 — Mon, 10 Mar 2025 13:28:42 GMT

Hi, thank you for your reply!

Could you help me how the script would look if I want to exclude multiple files with specific sample names instead?

Thanks in advance

Re: How to exclude data points starting with a specific word from a PCA and followed by a graph builder?

jthi — Mon, 10 Mar 2025 13:44:15 GMT

If you are looking for full matches, contains() is one option.