cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-615641%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Skript%20zum%20Abrufen%20eines%20globalen%20Anomalie-Scores%20(%20Screening%20von%20Ausrei%C3%9Fern%20)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-615641%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3ENormalerweise%20beginne%20ich%20mit%20der%20Suche%20nach%20denselben%20Namen%20im%20Scripting%20Index%20(und%20in%20diesem%20Fall%20k%C3%B6nnte%20es%20funktionieren).%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_0-1679519425252.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1679519425252.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1679519425252.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1679519425252.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1679519425252.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1679519425252.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1679519425252.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1679519425252.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F51423i2A39724C38A24FBF%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_0-1679519425252.png%22%20alt%3D%22jthi_0-1679519425252.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EDas%20einzige%2C%20bei%20dem%20ich%20mir%20nicht%20sicher%20bin%2C%20ist%20Impute%20Missing%20part%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_1-1679519529906.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1679519529906.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1679519529906.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1679519529906.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1679519529906.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1679519529906.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1679519529906.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1679519529906.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F51424iA40678643B36359A%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_1-1679519529906.png%22%20alt%3D%22jthi_1-1679519529906.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0AClear%20Log()%3B%0A%0Adt%20%3D%20Open(%20%22%24SAMPLE_DATA%2FBands%20Data.JMP%22%20)%3B%0A%0Aobj%20%3D%20dt%20%26lt%3B%26lt%3B%20Explore%20Outliers(%0A%20Y(%0A%20%20%3Aproof%20cut%2C%20%3Aviscosity%2C%20%3Acaliper%2C%20%3Aink%20temperature%2C%20%3Ahumidity%2C%20%3Aroughness%2C%0A%20%20%3Ablade%20pressure%2C%20%3Avarnish%20pct%2C%20%3Apress%20speed%2C%20%3Aink%20pct%2C%20%3Asolvent%20pct%2C%0A%20%20%3AESA%20Voltage%2C%20%3AESA%20Amperage%2C%20%3Awax%2C%20%3Ahardener%2C%20%3Aroller%20durometer%2C%0A%20%20%3Acurrent%20density%2C%20%3Aanode%20space%20ratio%2C%20%3Achrome%20content%0A%20)%0A)%3B%0Aobj%20%26lt%3B%26lt%3B%20k%20Nearest%20Neighbor%20Outliers(K(4))%3B%0Aobj%20%26lt%3B%26lt%3B%20Impute%20Missing(0)%3B%0Aobj%20%26lt%3B%26lt%3B%20Save%20NN%20Distances%3B%0A%2F%2Fobj%20%26lt%3B%26lt%3B%20Close%20Window%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-615630%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ESkript%20zum%20Abrufen%20eines%20globalen%20Anomalie-Scores%20(%20Screening%20von%20Ausrei%C3%9Fern%20)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-615630%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EJMP%20verf%C3%BCgt%20%C3%BCber%20mehrere%20Methoden%20zum%20Untersuchen%20von%20Ausrei%C3%9Fern%20(Analysieren%26gt%3BScreening%26gt%3BAusrei%C3%9Fer%20untersuchen).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EF%C3%BCr%20eine%20erste%20Datenexploration%20suche%20ich%20nach%20einer%20L%C3%B6sung%2C%20damit%20die%20Benutzer%20alle%20anomalen%20Zeilen%20interaktiv%20filtern%20k%C3%B6nnen.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEin%20einfacher%20Ansatz%20besteht%20darin%2C%20eine%20KNN-Ausrei%C3%9Feranalyse%20durchzuf%C3%BChren%20(die%20Option%20der%20Imputationen%20zu%20deaktivieren%20und%20die%20Standardzahl%20%C3%A4ndern%20zu%20k%C3%B6nnen).%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22FN_0-1679518219072.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22FN_0-1679518219072.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22FN_0-1679518219072.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F51421i185C8CAD30B6B87B%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22FN_0-1679518219072.png%22%20alt%3D%22FN_0-1679518219072.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnd%20speichern%20Sie%20die%20Entfernungen%20zu%20jedem%20NN%2C%20damit%20Sie%20eine%20Gesamtpunktzahl%20erhalten%20k%C3%B6nnen%20(z.%20B.%20durch%20Addieren%20aller%20Entfernungen%20in%20einer%20Spalte).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22FN_1-1679518708197.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22FN_1-1679518708197.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22FN_1-1679518708197.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F51422i97839FFC4045877E%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22FN_1-1679518708197.png%22%20alt%3D%22FN_1-1679518708197.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWie%20k%C3%B6nnen%20diese%20Schritte%20mit%20GUI-Aktionen%20in%20JMP%2016%20automatisiert%20werden%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0AClear%20Log()%3B%0A%0Adt%20%3D%20Open(%20%22%24SAMPLE_DATA%2FBands%20Data.JMP%22%20)%3B%0A%0A%2F%2F%20Launch%20platform%3A%20Explore%20Outliers%0AExplore%20Outliers(%0A%20Y(%0A%20%20%3Aproof%20cut%2C%20%3Aviscosity%2C%20%3Acaliper%2C%20%3Aink%20temperature%2C%20%3Ahumidity%2C%20%3Aroughness%2C%0A%20%20%3Ablade%20pressure%2C%20%3Avarnish%20pct%2C%20%3Apress%20speed%2C%20%3Aink%20pct%2C%20%3Asolvent%20pct%2C%0A%20%20%3AESA%20Voltage%2C%20%3AESA%20Amperage%2C%20%3Awax%2C%20%3Ahardener%2C%20%3Aroller%20durometer%2C%0A%20%20%3Acurrent%20density%2C%20%3Aanode%20space%20ratio%2C%20%3Achrome%20content%0A%20)%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-615630%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3EAnalytik%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESkripterstellung%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Choose Language Hide Translation Bar
FN
FN
Level VI

Script to obtain a global anomaly score ( screening outliers )

JMP has several methods to explore outliers (Analyze>Screening>Explore outliers).

 

For a first data exploration, I am looking for a solution so the users can interactively filter all anomalous rows.

 

One simple approach is to conduct a KNN outlier analysis (unchecking the option of imputations and being able to change the default number) 

FN_0-1679518219072.png

 

And save the distances to each NN, so a global score can be obtained (e.g., by adding all distances into one column).

 

FN_1-1679518708197.png

 

How can automate these steps that have GUI actions in JMP 16?

 

Names Default To Here( 1 );
Clear Log();

dt = Open( "$SAMPLE_DATA/Bands Data.JMP" );

// Launch platform: Explore Outliers
Explore Outliers(
	Y(
		:proof cut, :viscosity, :caliper, :ink temperature, :humidity, :roughness,
		:blade pressure, :varnish pct, :press speed, :ink pct, :solvent pct,
		:ESA Voltage, :ESA Amperage, :wax, :hardener, :roller durometer,
		:current density, :anode space ratio, :chrome content
	)
);

 

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: Script to obtain a global anomaly score ( screening outliers )

I usually start my looking for same names from Scripting Index (and in this case it might work)

jthi_0-1679519425252.png

Only thing I'm not sure about is Impute Missing part

jthi_1-1679519529906.png

 

Names Default To Here( 1 );
Clear Log();

dt = Open( "$SAMPLE_DATA/Bands Data.JMP" );

obj = dt << Explore Outliers(
	Y(
		:proof cut, :viscosity, :caliper, :ink temperature, :humidity, :roughness,
		:blade pressure, :varnish pct, :press speed, :ink pct, :solvent pct,
		:ESA Voltage, :ESA Amperage, :wax, :hardener, :roller durometer,
		:current density, :anode space ratio, :chrome content
	)
);
obj << k Nearest Neighbor Outliers(K(4));
obj << Impute Missing(0);
obj << Save NN Distances;
//obj << Close Window;
-Jarmo

View solution in original post

1 REPLY 1
jthi
Super User

Re: Script to obtain a global anomaly score ( screening outliers )

I usually start my looking for same names from Scripting Index (and in this case it might work)

jthi_0-1679519425252.png

Only thing I'm not sure about is Impute Missing part

jthi_1-1679519529906.png

 

Names Default To Here( 1 );
Clear Log();

dt = Open( "$SAMPLE_DATA/Bands Data.JMP" );

obj = dt << Explore Outliers(
	Y(
		:proof cut, :viscosity, :caliper, :ink temperature, :humidity, :roughness,
		:blade pressure, :varnish pct, :press speed, :ink pct, :solvent pct,
		:ESA Voltage, :ESA Amperage, :wax, :hardener, :roller durometer,
		:current density, :anode space ratio, :chrome content
	)
);
obj << k Nearest Neighbor Outliers(K(4));
obj << Impute Missing(0);
obj << Save NN Distances;
//obj << Close Window;
-Jarmo

Recommended Articles