How to make my Excel file Random?

Hello! my excel file contains data set 3617*2 the data set should be divided in to 2 the first data should be 2/3 from the 3617 sets each one has to have random rows , then i should use every set in testing and training for error reports .. I'm confused and new, can somebody help me?

Answer 1

[KSSV]

data = rand(3617,2) ;
[m,n] = size(data) ;
idx = round(2/3*m) ;
train_data = data(1:idx,:) ;
test_data = data(idx+1:end,:) ;

[TABOUNI Khadidja]

Hello Sir! Thank you for you help! Can I ask you something else? Bout the traning?

[KSSV]

I am not expert in NN. Accept this answer and pose a different question for that. some other expert will answer your query.