Batch ID Generation

varunm1

Hello,

Is there a simple way to generate batch id (Divide samples into 5 groups) based on ID column in a dataset. For example, I have a dataset with 400 samples related to 30 subjects (Multiple samples per subject). I would like to divide the data set into 5 (this can be any value) batches based on the Subject (not samples), so each batch will have 6 subjects related data.

I attached a sample dataset where "Subject ID" is the ID column.

sgenzer

嗨@varunm1ah ok took me a minute. Why not use Generate Attributes where you do something like mod([Subject_ID],5) ?
Scott

varunm1

Hello@sgenzer

Thanks for your response. Is this scalable to ID with characters like (A, B,C D,... etc)?

I just replaced Subject ID column values to characters (Instead of 1 now its A).

MartinLiebig

Hi@varunm1

Just do Nominal to numerical before to get unique integers?

Best,

Martin

lionelderkrikor

Hi Varun,

I'm not sure to understand, but is it what you are looking for ..?

Regards,

Lionel

varunm1

@mschmitzyep it works, I need to duplicate the column and then convert it to nominal to numerical. The reason for duplication is to trace back the ID's