how to split a dataset based on values from one column
5 views (last 30 days)
Show older comments
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?
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/194880/image.png)
0 Comments
Accepted Answer
madhan ravi
on 31 Aug 2018
Edited: madhan ravi
on 31 Aug 2018
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
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!