cancel
turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeSubscribe to RSS Feed

How to split a data table in two

May 28, 2015 9:58 AM (2218 views)
lauren_eggett

lauren_eggett

Community Trekker

Joined:

Mar 3, 2015

I'd like to randomly select 75% of my rows and save that to one data table and save the other random 25% of my rows to a second data table.  Can this be accomplished in JMP?

0 Kudos
Reply
1 ACCEPTED SOLUTION

Accepted Solutions
May 28, 2015 10:17 AM (4223 views)
ms

ms

Super User

Joined:

Jun 23, 2011

Solution

Here is one way to do it interactively:

1. Select 75% of rows by entering 0.75 in Rows -> Row Selection -> Select Randomly...

2. Make a subset of these 75% by selecting Tables -> Subset (check Selected rows and All columns in he Subset dialog)

3. Activate the original table (with the 75% still selected) and choose Rows -> Delete Rows to get rid of these rows and keep the remaining 25%.

Reply
2 REPLIES
May 28, 2015 10:17 AM (4224 views)
ms

ms

Super User

Joined:

Jun 23, 2011

Solution

Here is one way to do it interactively:

1. Select 75% of rows by entering 0.75 in Rows -> Row Selection -> Select Randomly...

2. Make a subset of these 75% by selecting Tables -> Subset (check Selected rows and All columns in he Subset dialog)

3. Activate the original table (with the 75% still selected) and choose Rows -> Delete Rows to get rid of these rows and keep the remaining 25%.

Reply
May 28, 2015 10:34 AM (2112 views)
lauren_eggett

lauren_eggett

Community Trekker

Joined:

Mar 3, 2015

Thank you!  That was very easy.

0 Kudos
Reply