cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
%3CLINGO-SUB%20id%3D%22lingo-sub-668394%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E7%A9%A9%E5%81%A5%E6%93%AC%E5%90%88%E9%9B%A2%E7%BE%A4%E5%80%BC%20-%20%E9%81%B8%E6%93%87%E4%B8%8D%E5%90%8C%E7%9A%84%E8%A1%8C%E9%9B%86%E4%B8%A6%E5%B0%87%E5%85%B6%E6%8E%92%E9%99%A4%E7%82%BA%E9%9B%A2%E7%BE%A4%E5%80%BC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-668394%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E8%A6%AA%E6%84%9B%E7%9A%84%E7%A4%BE%E5%8D%80%EF%BC%8C%3C%2FP%3E%3CP%3E%E6%88%91%E6%9C%89%E4%B8%80%E5%80%8B%E5%A0%86%E7%A9%8D%E7%9A%84%E6%95%B8%E6%93%9A%E8%A1%A8%EF%BC%8C%E4%B8%A6%E4%B8%94%E6%83%B3%E9%80%9A%E9%81%8E%E6%A8%99%E7%B1%A4%E6%8E%92%E9%99%A4%E7%95%B0%E5%B8%B8%E5%80%BC%EF%BC%88%E4%BE%8B%E5%A6%82%E7%94%A8%E6%96%BC%E6%9F%90%E4%BA%9B%E6%B8%AC%E9%87%8F%E7%9A%84%E5%85%83%E7%B4%A0%EF%BC%89%E3%80%82%3C%2FP%3E%3CP%3E%E5%9C%A8%E7%A9%A9%E5%81%A5%E7%9A%84%E6%93%AC%E5%90%88%E9%9B%A2%E7%BE%A4%E5%80%BC%E5%B9%B3%E5%8F%B0%E4%B8%AD%EF%BC%8C%E6%88%91%E5%8F%AF%E4%BB%A5%E6%AA%A2%E6%B8%AC%E9%9B%A2%E7%BE%A4%E5%80%BC%EF%BC%8C%E7%84%B6%E5%BE%8C%E9%81%B8%E6%93%87%E6%88%96%E6%8E%92%E9%99%A4%E7%9B%B8%E6%87%89%E7%9A%84%E8%A1%8C%E3%80%82%3C%2FP%3E%3CP%3E%E6%A0%B9%E6%93%9A%E6%88%91%E7%9A%84%E7%90%86%E8%A7%A3%EF%BC%8C%E9%81%B8%E6%93%87%E6%88%96%E6%8E%92%E9%99%A4%E7%9A%84%E8%A1%8C%E6%87%89%E8%A9%B2%E5%AE%8C%E5%85%A8%E7%9B%B8%E5%90%8C%E3%80%82%3C%2FP%3E%3CP%3E%E4%B8%8B%E9%9D%A2%E7%9A%84%20JSL%20%E4%B8%AD%E4%BD%BF%E7%94%A8%E7%9A%84%E7%A4%BA%E4%BE%8B%E6%95%B8%E6%93%9A%E8%A1%A8%E5%B0%B1%E6%98%AF%E9%80%99%E7%A8%AE%E6%83%85%E6%B3%81%E3%80%82%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%2F%2F%20from%20scripting%20index%0A%0ANames%20Default%20To%20Here(%201%20)%3B%0A%0Adt%20%3D%20Open(%20%22%24SAMPLE_DATA%2FWater%20Treatment.jmp%22%20)%3B%0A%0A%2F%2F%20similar%2C%20but%20stacked%20data%20and%20usage%20of%20by%20role%0A%0Adt_stack%20%3D%20dt%20%26lt%3B%26lt%3B%20Stack(%0A%20columns(%20Column%20Group(%20%22Sensor%20Measurements%22%20)%20)%2C%0A%20Source%20Label%20Column(%20%22Label%22%20)%2C%0A%20Stacked%20Data%20Column(%20%22Data%22%20)%2C%0A%20Output%20Table(%20%22Water%20Treatment%20stacked.jmp%22%20)%0A)%3B%0A%0Aobj_select%20%3D%20dt_stack%20%26lt%3B%26lt%3B%20Explore%20Outliers(%20Y(%20%3AData%20)%2C%20By(%20%3ALabel%20)%2C%20Robust%20fit%20outliers%2C%20select%20rows()%20)%3B%0Aobj_exclude%20%3D%20dt_stack%20%26lt%3B%26lt%3B%20Explore%20Outliers(%20Y(%20%3AData%20)%2C%20By(%20%3ALabel%20)%2C%20Robust%20fit%20outliers%2C%20exclude%20rows()%20)%3B%0AShow(%20N%20Items(%20dt_stack%20%26lt%3B%26lt%3B%20get%20selected%20rows()%20)%2C%20N%20Items(%20dt_stack%20%26lt%3B%26lt%3B%20get%20excluded%20rows()%20)%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%E4%BD%86%E5%9C%A8%E6%88%91%E4%BD%BF%E7%94%A8%E7%9C%9F%E5%AF%A6%E6%95%B8%E6%93%9A%E7%9A%84%E6%83%85%E6%B3%81%E4%B8%8B%EF%BC%8C%E6%88%91%E9%81%B8%E6%93%87%E4%B8%A6%E6%8E%92%E9%99%A4%E4%BA%86%E4%B8%8D%E5%90%8C%E7%9A%84%E8%A1%8C%EF%BC%8C%E5%9C%A8%E6%88%91%E7%9C%8B%E4%BE%86%EF%BC%8C%E8%A9%B2%E5%B9%B3%E5%8F%B0%E5%9C%A8%E8%AD%98%E5%88%A5%E9%9B%A2%E7%BE%A4%E5%80%BC%E6%96%B9%E9%9D%A2%E6%95%88%E6%9E%9C%E5%BE%88%E5%A5%BD%EF%BC%8C%E4%BD%86%E6%8E%92%E9%99%A4%E6%93%8D%E4%BD%9C%E7%84%A1%E6%B3%95%E6%8E%92%E9%99%A4%E4%B8%80%E8%A1%8C%EF%BC%88%E5%B7%B2%E8%A2%AB%E9%81%B8%E7%82%BA%E9%9B%A2%E7%BE%A4%E5%80%BC%EF%BC%89%20%E3%80%82%3C%2FP%3E%3CP%3E%E5%B0%8D%E9%80%99%E7%A8%AE%E8%A1%8C%E7%82%BA%E6%9C%89%E4%BB%80%E9%BA%BC%E6%83%B3%E6%B3%95%E5%97%8E%EF%BC%9F%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%22Georg_0-1692178566774.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Georg_0-1692178566774.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Georg_0-1692178566774.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F55790iECF6E83666F95BFA%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Georg_0-1692178566774.png%22%20alt%3D%22Georg_0-1692178566774.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-668394%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3E%E8%87%AA%E5%8B%95%E5%8C%96%E5%92%8C%E8%85%B3%E6%9C%AC%E7%B7%A8%E5%AF%AB%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%E6%95%B8%E6%93%9A%E6%B7%B7%E5%90%88%E5%92%8C%E6%B8%85%E7%90%86%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Choose Language Hide Translation Bar
Georg
Level VII

Robust Fit Outliers - different row set selected and excluded as outliers

Dear community,

I have a stacked data table, and want to exclude outliers by a Label (e.g. an element for some measurements).

In the robust fit outlier platform I can detect outliers and than can select or exclude corresponding rows.

For my understanding, rows that are selected than or excluded, should be exactly the same ones.

And that is the case for the below sample data table used in the JSL below.

 

// from scripting index

Names Default To Here( 1 );

dt = Open( "$SAMPLE_DATA/Water Treatment.jmp" );

// similar, but stacked data and usage of by role

dt_stack = dt << Stack(
	columns( Column Group( "Sensor Measurements" ) ),
	Source Label Column( "Label" ),
	Stacked Data Column( "Data" ),
	Output Table( "Water Treatment stacked.jmp" )
);

obj_select = dt_stack << Explore Outliers( Y( :Data ), By( :Label ), Robust fit outliers, select rows() );
obj_exclude = dt_stack << Explore Outliers( Y( :Data ), By( :Label ), Robust fit outliers, exclude rows() );
Show( N Items( dt_stack << get selected rows() ), N Items( dt_stack << get excluded rows() ) );

But in my case with real data, I get different rows selected and excluded, it looks to me that the platform works well in identifying the outliers, but the exclude operation fails to exclude one row (that has been selected as outlier).

Any idea on this behaviour?

 

Georg_0-1692178566774.png

 

Georg
0 REPLIES 0