Compare cell arrays and delete rows
1 view (last 30 days)
Show older comments
I have two cell arrays: JFM06avg(1x2) and JFM06D(88x3). I want to compare the value from the first cell in the first row from the array JFM06avg(9.3576) to the each cell in the second column of the array JFM06D. Then if the value in JFM06D is less than the value of JFM06avg then the row must be deleted.Attached are the two files.
1 Comment
the cyclist
on 5 Jul 2016
Note that JFM06avg is not a cell array. It is numeric. This will matter for the syntax, at least in my solution.
Accepted Answer
the cyclist
on 5 Jul 2016
Here is one way:
rowToDelete = [JFM06D{:,2}] < JFM06avg(1);
JFM06D(rowToDelete,:) = [];
0 Comments
More Answers (0)
See Also
Categories
Find more on Data Types 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!