topic Cut dataset in Discussions

Cut dataset

Emma1 — Sat, 10 Jun 2023 23:35:26 GMT

Hello,
I would like to cut my 70% vs 30% dataset to have a learning dataset and a test dataset for my statistical models
I use this method:

And I change the 0.7 in 0.3 to have 30%
However when I do that, the dataset does not separate into two parts: 70% vs 30%, it takes 70% then 30%
This means that in the dataset 30% there may be data from the dataset containing 70%

Is there a way to cut into two parts the dataset: 70 vs 30% without having the same type of data in both parts?

Thank you

Re: Cut dataset

txnelson — Fri, 13 Aug 2021 15:11:51 GMT

You need to use the "Make Validation Column"

Analyze=>Predictive Modeling=>Make Validation Column

This will give you a new column that if you need to, you can subset the data table into 2 different tables.

Re: Cut dataset

ZF — Fri, 13 Aug 2021 21:21:07 GMT

Create a new column using formula:

Random Binomial(1, 0.3), it will give you 30% "1' and 70% "0".

Re: Cut dataset

Emma1 — Mon, 16 Aug 2021 07:48:33 GMT

Hello,

I use the JMP version 16.1.0 and I can't find in the "Analyze" menu the "make validation column"

Thank you

Re: Cut dataset

Emma1 — Mon, 16 Aug 2021 07:49:13 GMT

It works very well !!

Thank you