cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
mmcclusk0
Level II

How to select every other and third row?

Hello,

I am a new user, so please excuse me if this seems like an easy question to answer.

I have a data set (21k+ rows) where I want to select the 2nd and 3rd row, unselect the 4th, then select the 5th and 6th, unselect the 7th....so on...

After they are all selected, they can be deleted, as I don't need the data in those rows.

What would be the easiest way to do this?

Thank you very much.

-Matt

1 ACCEPTED SOLUTION

Accepted Solutions
Jeff_Perkinson
Community Manager Community Manager

Re: How to select every other and third row?

This is a fun question because there are probably lots of strategies for doing this. I'll look forward to seeing other suggestions.

Assuming you want to do this interactively (as opposed to automating with JSL to do it again later) here are a couple ways.

1) Add a new numeric column. Type 1, 2, and 3 in the first three rows of your table. Then select those cells and right click on them and choose Repeat sequence to end of table.

11989_JMPScreenSnapz021.png

This will create a column with a repeating 1, 2, 3. You now need to select the rows with a 2 or a 3 in them. This is easy. Select any "2" cell and any "3" cell (shift-click the second one if you need to or drag select two side by side). Right click on one of the selected cells and choose Select Matching Cells.

11990_JMPScreenSnapz022.png

This will select all of the "2" rows and all of the "3" rows. Now choose Rows -> Delete Rows.

2) You could create a Row State column with a formula using the Selected State function to select every 2nd and 3rd row.

11991_JMPScreenSnapz023.png

Notice that in the Rows to Delete column every 2nd and 3rd row is selected. I did this with the Modulo() function.

Now right click on the star next to the Rows to Delete column and choose Copy to Row States to select those rows in the active row state area. Now you can choose Rows -> Delete Rows.

11992_JMPScreenSnapz024.png

I'm sure the Community has other ways to do this. It'll be interesting to see them.

-Jeff

-Jeff

View solution in original post

6 REPLIES 6
ms
Super User (Alumni) ms
Super User (Alumni)

Re: How to select every other and third row?

One way to do it: Create a new numeric column and type 1, 2, 3 in the first three rows. Then select these rows and right click, select Fill -> Repeat Sequence to End of Table. Finally select both a "2" and a "3",  right click to select Select matching Cells. Now every other and third row should be selected and ready to be deleted.

ron_horne
Super User (Alumni)

Re: How to select every other and third row?

hi mmcclusk0​,

perhaps once basic way of doing this is:

Names Default To Here (1);

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

dt << new column ("selection", formula (sequence (1,3,1 )));

dt:selection << delete formula;

// select each second and  third row

selectedrows = dt << select where (:selection >1 );

dt << delete rows ();

Jeff_Perkinson
Community Manager Community Manager

Re: How to select every other and third row?

This is a fun question because there are probably lots of strategies for doing this. I'll look forward to seeing other suggestions.

Assuming you want to do this interactively (as opposed to automating with JSL to do it again later) here are a couple ways.

1) Add a new numeric column. Type 1, 2, and 3 in the first three rows of your table. Then select those cells and right click on them and choose Repeat sequence to end of table.

11989_JMPScreenSnapz021.png

This will create a column with a repeating 1, 2, 3. You now need to select the rows with a 2 or a 3 in them. This is easy. Select any "2" cell and any "3" cell (shift-click the second one if you need to or drag select two side by side). Right click on one of the selected cells and choose Select Matching Cells.

11990_JMPScreenSnapz022.png

This will select all of the "2" rows and all of the "3" rows. Now choose Rows -> Delete Rows.

2) You could create a Row State column with a formula using the Selected State function to select every 2nd and 3rd row.

11991_JMPScreenSnapz023.png

Notice that in the Rows to Delete column every 2nd and 3rd row is selected. I did this with the Modulo() function.

Now right click on the star next to the Rows to Delete column and choose Copy to Row States to select those rows in the active row state area. Now you can choose Rows -> Delete Rows.

11992_JMPScreenSnapz024.png

I'm sure the Community has other ways to do this. It'll be interesting to see them.

-Jeff

-Jeff
mmcclusk0
Level II

Re: How to select every other and third row?

Thanks everyone for the quick and easy answers.

I did end up using the added sequence numbers and selecting and deleting as needed.

-Matt

Re: How to select every other and third row?

Ha! ron_horne​ beat me to the "select where" strategy. This is one of my favorite things about JMP, though. You can solve problems like this in a way that your mind likes to work. If you are a scripting person, there is a good strategy here, and if you want to do it interactively, jeff.perkinson​'s ways are good too.

Connect with me on LinkedIn: https://bit.ly/3MWgiXt
ms
Super User (Alumni) ms
Super User (Alumni)

Re: How to select every other and third row?

Yet another way to do this. No requirements for adding an extra column or selecting rows:

dt = Current Data Table();

dt << delete rows(dt << get rows where(Mod(Row() + 2, 3)));