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?

 Respuesta aceptada

madhan ravi
madhan ravi el 31 de Ag. de 2018
Editada: madhan ravi el 31 de Ag. de 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 comentarios

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
madhan ravi
madhan ravi el 31 de Ag. de 2018
Editada: madhan ravi el 31 de Ag. de 2018
Can you upload the file?
madhan ravi
madhan ravi el 31 de Ag. de 2018
Editada: madhan ravi el 31 de Ag. de 2018
Upload the data file to test.
donn't worry, i figured it out. Thanks

Iniciar sesión para comentar.

Más respuestas (0)

Etiquetas

Preguntada:

el 31 de Ag. de 2018

Editada:

el 31 de Ag. de 2018

Community Treasure Hunt

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

Start Hunting!

Translated by