how to split a dataset based on values from one column

I have this dataset and want to split it into two data sets based on wether the values in the 7th column (etd) are >25 or <25. how would i go about doing this?

 Accepted Answer

column7 = datasets(:,7)
for i = 1:numel(column7)
if column7(i) > 25
above25(i) = column7(i)
elseif column7(i) < 25
below25(i) = column7(i)
end
end
above25(above25==0)=[]
below25(below25==0)=[]

4 Comments

I'm getting these 3 errors when i use that code, any idea why?
Error using dataset/subsrefParens (line 9) Dataset array subscripts must be two-dimensional.
Error in dataset/subsref (line 69) [varargout{1:nargout}] = subsrefParens(a,s);
Error in Code_new (line 58) if column7(i) > 25
Can you upload the file?
Upload the data file to test.
donn't worry, i figured it out. Thanks

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!