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)

Categories

Community Treasure Hunt

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

Start Hunting!