topic Re: Neglect hide and exclude in Discussions

Neglect hide and exclude

JulieSAppel — Tue, 10 Dec 2019 12:04:21 GMT

Hi,

Is there anyway to do a summary table or similar based on data that is excluded?

I´ve excluded certain rows of data based on requirements in my analysis but I just need to extract a few numbers which have been excluded. Is that possible or do I have to remove the exclude statements (and add them again afterwards)?

Br Julie

Re: Neglect hide and exclude

ron_horne — Tue, 10 Dec 2019 12:15:05 GMT

Hi @JulieSAppel

My low-tech solution is to introduce a new binary column and use the BY option in the platform for the analysis. this way you get results with and without the rows of interest.

would love to know if there is another solution.

Ron

Re: Neglect hide and exclude

JulieSAppel — Tue, 10 Dec 2019 12:47:41 GMT

I was trying something like:

column(data table("my data set"), "column where I need to include data") << unexclude(1);

but that just excluded the entire column.

What do you mean by "a new binary column and use the BY option"?

Re: Neglect hide and exclude

HadleyMyers — Tue, 10 Dec 2019 12:50:19 GMT

Hi,

Would selecting the rows in question and creating a subset table using Tables-->Subset work?

Re: Neglect hide and exclude

Mark_Bailey — Tue, 10 Dec 2019 13:35:25 GMT

What about a data filter with Tabulate?

Re: Neglect hide and exclude

ron_horne — Tue, 10 Dec 2019 14:13:19 GMT

Hi @JulieSAppel

try the following script.

most likely you can do it faster with clicking out of menus but it will give you my general way of thinking.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

r = dt << Select Rows( [5, 7, 8, 10] );
r << Exclude;
dt << clear select;

// now we start

dt << Select Excluded;
dt << Name Selection in Column( Column Name( "Subset" ), Selected( "excluded" ), Unselected( "all others" ) );
dt << clear row states;

// do some analysis
New Window( "Analysis",
	H List Box(
		Distribution( Continuous Distribution( Column( :height ) ) ), // whole table (excluded and not excluded)
		Distribution( Continuous Distribution( Column( :height ) ), where( :subset == "excluded" ) ), // only excluded
		Distribution( Continuous Distribution( Column( :height ) ), where( :subset == "all others" ), ), // non excluded

	)

);

Re: Neglect hide and exclude

txnelson — Tue, 10 Dec 2019 15:00:05 GMT

Since we are all playing the "I would" game :-), I would take the data table with the excluded rows, create a new Row State column, save the row states to that column, remove all of the row states in the row states column, perform the additional analysis, then simply copy the row states back from the new Row State column, back to the row states.

Re: Neglect hide and exclude

JulieSAppel — Wed, 11 Dec 2019 12:03:25 GMT

Wow that´s a lot of different solutions. I´ll keep those in mind for future challenges

Thanks a lot :)

Re: Neglect hide and exclude

jules — Wed, 11 Dec 2019 14:36:20 GMT

Hi @JulieSAppel,

It sounds like you have a lot of solutions! I like @HadleyMyers's idea of a subset, and wanted to point out, in case you or another don't know, you can right-click in the row information panel on any of the indicators, and select "Data View" to see just those rows. In this case, you could right-click on Excluded, and select Data View to make that subset without selecting the rows or invoking Tables > Subset. I find the "Data View" to be a great tool for focusing your attention on the various subsets (selected, excluded, etc) that you might want to see (or analyze).

I hope this is helpful!

@jules

Re: Neglect hide and exclude

P_Bartell — Wed, 11 Dec 2019 16:30:14 GMT

JulieSAppel: To me that's one of the beautiful characteristics of JMP...there are often more than one way to get JMP to 'do something'...especially if that 'something' isn't capable 'out of the box'. This way JMP is very accomodating to the diverse ways in which people think, approach problems, and process data.