find and save the rows where condition is met

4 次查看(过去 30 天)
I have a 1x3001 cell, 'y', and I want matlab to loop through all the cells and save all the rows where the value in column 2 is <-0.13.
I have the following code but i get the error below. Please could somebody help me fix this?
%for all the csv files (3001)
for b = 1:length(data)
%get the ID number (:,1) and coordinates (:,6) and save them in an array
y{b} = table2array(data{b}(:,[1 6]));
%find and save all the rows in each csv file where column 2 is <-0.13
g{b} = y{b}(y(:,2) <= -0.13, :);
end
Undefined operator '<=' for input arguments of type 'cell'.

采纳的回答

David Hill
David Hill 2021-1-28
for b = 1:length(data)
%get the ID number (:,1) and coordinates (:,6) and save them in an array
y{b} = table2array(data{b}(:,[1 6]));
%find and save all the rows in each csv file where column 2 is <-0.13
g{b} = y{b}(y{b}(:,2) <= -0.13, :);
end

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Multidimensional Arrays 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by