How to exclude data points starting with a specific word from a PCA and followed by a graph builder?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.
Basic Data Analysis and ModelingData Exploration and VisualizationRe: How to exclude data points starting with a specific word from a PCA and followed by a graph builder?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?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?If you are looking for full matches, contains() is one option.
